By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,148 Members | 774 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,148 IT Pros & Developers. It's quick & easy.

setting up a query for a report

P: 1
Hello. I am new to MS Access and am trying to set up a simple data base for my martial arts company. I have only one table (a listing of student information) and seem to be okay at setting up queries.

There are times I want to be able to pull specific students on a report I have created or on my mailing label report. I can't seem to find how to do this.

I am formerly a Lotus Approach user and when you do a 'find' in Approach, any reports you bring up are filtered until you clear it and go back to 'all records'. It seems to work differently in Access.

How can I do a query on a report?

Mike
Sep 14 '07 #1
Share this Question
Share on Google+
1 Reply


Scott Price
Expert 100+
P: 1,384
Hello. I am new to MS Access and am trying to set up a simple data base for my martial arts company. I have only one table (a listing of student information) and seem to be okay at setting up queries.

There are times I want to be able to pull specific students on a report I have created or on my mailing label report. I can't seem to find how to do this.

I am formerly a Lotus Approach user and when you do a 'find' in Approach, any reports you bring up are filtered until you clear it and go back to 'all records'. It seems to work differently in Access.

How can I do a query on a report?

Mike
Have a look at this tutorial first: http://www.thescripts.com/forum/thread585228.html, as I suspect you may have a design issue from using only one table.

Then after you read and understand that! What you are looking for may be found in this tutorial: http://www.thescripts.com/forum/thread590551.html

You are basically trying to filter a group of records based on a name of a student, with the ability to then remove the filter later.

Ask any questions you need until you understand the concepts involved...

Regards,
Scott
Sep 15 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.