complicated query

[RobTuby]

Hi

I have a table call ed Archive.
i need a query that would produce the following results
Must be within one query.

I'm after a distinct list of names
To look within the field Hashtag to find if there is text "#LEFT"
If there is i need the first Calendar date it appears against their name.
If there isnt a "#Left" then null

It need to have parameters in Calendar date to between Parameter1 and Parameter2 and also UploadDate = ?

The exact field names are
NAME (Text)
CalendarDate (Stored as DD/MM/YYYY)
HashTag (Text)
UploadDate (Stored as DD/MM/YYYY)
I also need to bring in
FUNCT (Text)
TeamNAME (Text)
Skill (Text)

Thanks

Rob

 

[CJ_London]

First, NAME is a reserved word, using it will cause problems at some point, I recommend you change it.

Second, It looks like a simple group by query will do what you want but
your description is not clear so I suggest you post some sample data and what you actually want as a result