View Full Version : Analyst Name Search


establishd
11-05-2009, 03:29 AM
Hi I want to run a report, where I search for a user name and then the dates the data was recorded, I have these fields within a table and have created a query where I have the following:

Analyst Name, Date Logged as the fields, in Date Logged criteria I have >=[Enter Start Date] And <=[Enter End Date] so that I enter a start date and an end date to search on when the query is ran. However how do I do this for Analyst name's...so that I can search for the user and then the date that their scores were recorded. They are in the format Surname, Forename, but only as one field...

If this doesn't make sense I apologise, I'm pretty new to this.

namliam
11-05-2009, 03:41 AM
enter [enter analyst name] as a criteria?

establishd
11-05-2009, 03:44 AM
Sorry yea, forgot to mention I've tried that, and it returns no data. Even though I know the data is there...

DCrake
11-05-2009, 03:53 AM
Have you tried use Between [Enter Start Date] And [Enter End Date] instead of <= >=.

Also have you tried filter on the analyst only to check that it works independantly?

David