Queries for a report

A

Ana

I have a form which stores weekly appointment information on reps. I need to create a report but I have no idea how to do it.
1) I want to print a report for a particular rep listing all the appointments info for a particular week. So I would like to be able to select a rep name from a list and then type the week-ending date and then have the report print all appointment data for the selected rep for that particular week.

FYI - my form has a combobox repnamebox that list all rep names and a short-date field called week ending date.

Thank you
 
S

SF

First create a query from the table on this particular
form. Frm that query enter in criteria under the repname:
[Enter Rep name:] Then, over under criteria on your
weekending date type: [Enter week ending date:] SAVE AND
RUN the query to see if this is what you want. Then you
can create your report from the query. HTH.
-----Original Message-----
I have a form which stores weekly appointment information
on reps. I need to create a report but I have no idea how
to do it.
1) I want to print a report for a particular rep listing
all the appointments info for a particular week. So I
would like to be able to select a rep name from a list and
then type the week-ending date and then have the report
print all appointment data for the selected rep for that
particular week.
FYI - my form has a combobox repnamebox that list all rep
names and a short-date field called week ending date.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top