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.
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.