Hi Frank,
You'll need to create a query and a report first, if you have not already
done so. The query will serve as the recordsource (source of records) for the
report. Select the tables that include the data you want to include in your
report when presented with the Select Table dialog. Then select the
appropriate fields. Run the query and verify that it is returning the desired
results. Note: you will likely see customers listed more than once in the
query, in fact, there should be a record for each movie rental. This is
normal.
Once you have the proper query, use the Report wizard to create a report.
You should see a New Object toolbar button, with a small black arrow to the
right. Click on this arrow. Select Report to start the report wizard. You
will likely want to include a grouping option, to group records by customer.
If your switchboard was created using the switchboard wizard (the answer is
yes if you have a table named "Switchboard Items") then after you get your
report working properly, you can use the switchboard wizard to add this
report to an existing switchboard.
Tom
__________________________________
:
I need to print reciepts, about customers, that rent movies on a access
database. I have all the tables, and forms. I need to have it done from the
switchboard.
