Queries for a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...
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
Click to expand...
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
Click to expand...
names and a short-date field called week ending date.
 
Back
Top