G
gawilkes
Using the following SQL query below truncates the field
Dataset.AvailabilityGapNotes to 255 characters in the output. This field
originates in memo format which I obviously want to keep.
This statement was generated using query by example window in MS access 2003.
Any reworking of the statement below to keep Dataset.AvailabilityGapNotes as
memo would be appreciated.
Thanks.
SELECT Data_Requirement.DataRequirementGroup,
Data_Requirement.DataRequirement, Data_Requirement.DataPlanType,
Data_Requirement.CoverageRequired, Data_Requirement.SpatialScaleRequired,
Dataset.CoverageExisting, Dataset.DatasetName, Dataset.ScaleRangeExisting,
Dataset.AvailabilityStatus, Dataset.LicenseStatus,
Dataset.AccessRelationship, Dataset.Province, Dataset.AvailabilityGapNotes,
Min(AppsPriorities21Oct04.Phase) AS MinOfPhase,
Min(AppsPriorities21Oct04.PhasedRank) AS MinOfPhasedRank
FROM (Data_Requirement LEFT JOIN (Data_To_Application LEFT JOIN
AppsPriorities21Oct04 ON Data_To_Application.AppTitle =
AppsPriorities21Oct04.AppTitle) ON Data_Requirement.DataRequirement =
Data_To_Application.Data) INNER JOIN (Data_Requirement_To_Dataset INNER JOIN
Dataset ON Data_Requirement_To_Dataset.DatasetName = Dataset.DatasetName) ON
Data_Requirement.DataRequirement = Data_Requirement_To_Dataset.DataRequirement
GROUP BY Data_Requirement.DataRequirementGroup,
Data_Requirement.DataRequirement, Data_Requirement.DataPlanType,
Data_Requirement.CoverageRequired, Data_Requirement.SpatialScaleRequired,
Dataset.CoverageExisting, Dataset.DatasetName, Dataset.ScaleRangeExisting,
Dataset.AvailabilityStatus, Dataset.LicenseStatus,
Dataset.AccessRelationship, Dataset.Province, Dataset.AvailabilityGapNotes
HAVING (((Data_Requirement.DataPlanType)="Land Use") AND
((Min(AppsPriorities21Oct04.Phase)) Is Not Null))
ORDER BY Data_Requirement.DataRequirementGroup,
Data_Requirement.DataRequirement, Data_Requirement.DataPlanType,
Data_Requirement.SpatialScaleRequired, Dataset.CoverageExisting DESC;
Dataset.AvailabilityGapNotes to 255 characters in the output. This field
originates in memo format which I obviously want to keep.
This statement was generated using query by example window in MS access 2003.
Any reworking of the statement below to keep Dataset.AvailabilityGapNotes as
memo would be appreciated.
Thanks.
SELECT Data_Requirement.DataRequirementGroup,
Data_Requirement.DataRequirement, Data_Requirement.DataPlanType,
Data_Requirement.CoverageRequired, Data_Requirement.SpatialScaleRequired,
Dataset.CoverageExisting, Dataset.DatasetName, Dataset.ScaleRangeExisting,
Dataset.AvailabilityStatus, Dataset.LicenseStatus,
Dataset.AccessRelationship, Dataset.Province, Dataset.AvailabilityGapNotes,
Min(AppsPriorities21Oct04.Phase) AS MinOfPhase,
Min(AppsPriorities21Oct04.PhasedRank) AS MinOfPhasedRank
FROM (Data_Requirement LEFT JOIN (Data_To_Application LEFT JOIN
AppsPriorities21Oct04 ON Data_To_Application.AppTitle =
AppsPriorities21Oct04.AppTitle) ON Data_Requirement.DataRequirement =
Data_To_Application.Data) INNER JOIN (Data_Requirement_To_Dataset INNER JOIN
Dataset ON Data_Requirement_To_Dataset.DatasetName = Dataset.DatasetName) ON
Data_Requirement.DataRequirement = Data_Requirement_To_Dataset.DataRequirement
GROUP BY Data_Requirement.DataRequirementGroup,
Data_Requirement.DataRequirement, Data_Requirement.DataPlanType,
Data_Requirement.CoverageRequired, Data_Requirement.SpatialScaleRequired,
Dataset.CoverageExisting, Dataset.DatasetName, Dataset.ScaleRangeExisting,
Dataset.AvailabilityStatus, Dataset.LicenseStatus,
Dataset.AccessRelationship, Dataset.Province, Dataset.AvailabilityGapNotes
HAVING (((Data_Requirement.DataPlanType)="Land Use") AND
((Min(AppsPriorities21Oct04.Phase)) Is Not Null))
ORDER BY Data_Requirement.DataRequirementGroup,
Data_Requirement.DataRequirement, Data_Requirement.DataPlanType,
Data_Requirement.SpatialScaleRequired, Dataset.CoverageExisting DESC;