complicated query

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

complicated query