Making a daily list of people from a database...

[greentiger]

I have created a database of club members in Access 2010. Each day I need to generate a report of who comes to the club. Up to this point I have been using an Excel spread sheet of members that I copy and paste to new daily spreadsheets each day. I am new to Access and would appreciate any ideas on how to do this.

[alansidman]

In a query, run a listing setting the criteria in the date field to the date you want.

If you have not run queries, here is a link on how to do that.

http://www.databasedev.co.uk/parameter_queries.html

[orange]

http://www.databaseanswers.org/data_...bers/index.htm this data model deals with club members

[orange]

http://www.databaseanswers.org/data_...bers/index.htm This data model deals with club members

[greentiger]

Thanks for the reply! I'm investigating the query solution and I'm having trouble understanding how to implement it in what I need to do. I'll be more specific as to what it is I need to do. I have a member list with a couple thousand members in it. The club is open every day (like a gym). Each day any number of members will visit the club. Each day I would like to generate a report of what members visited the club. It would be ideal if the dates a member visits are linked to his/her record. Let me know if I'm just not seeing the solution in the links provided, I am a novice and still getting my sea legs in Access

http://www.databaseanswers.org/data_...bers/index.htm this data model deals with club members

[orange]

Do you tables and relationships look anything like the the picture at the link I recommended?
If you moved from Excel to Access, did you design your tables? Did you set up relationships?
Did you Normalize your tables?