Criteria

[pungigi]

I have a table with 52 Trip Status' I want a query that pulls anything that begins with a D, It keeps telling me it is too complex, can anyone help??

 

[SkipVought]

Hi,

Please post your SQL.

Skip,

_{[red]Be advised:[/red] It's been reported that a wee psychic is roaming the countryside.
Small Medium @ Large!}

 

[pungigi]

SELECT Lisa.[Appt Date], Lisa.[Plan Id], Lisa.[Trip Status], Count(Lisa.[Trip Status]) AS [CountOfTrip Status]
FROM Lisa
GROUP BY Lisa.[Appt Date], Lisa.[Plan Id], Lisa.[Trip Status]
HAVING (((Lisa.[Appt Date]) Between [Begin Date] And [End Date]) AND ((Lisa.[Plan Id])=[Enter Plan Id]) AND ((Count(Lisa.[Trip Status]))="begins with D"));

 

[PHV]

Try this:
SELECT Lisa.[Appt Date], Lisa.[Plan Id], Lisa.[Trip Status], Count(Lisa.[Trip Status]) AS [CountOfTrip Status]
FROM Lisa
WHERE [Appt Date] Between [Begin Date] And [End Date]
AND [Plan Id]=[Enter Plan Id]
AND [Trip Status] Like 'D*'
GROUP BY Lisa.[Appt Date], Lisa.[Plan Id], Lisa.[Trip Status]
;


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[SkipVought]

How can a COUNT, be a string?


Skip,

_{[red]Be advised:[/red] It's been reported that a wee psychic is roaming the countryside.
Small Medium @ Large!}