trying to create a report but wizard creates a new form

gillbates21

Registered User.
Local time
Today, 18:16
Joined
Apr 8, 2006
Messages
15
query has 4 columns, first 3 from 1 table, last from a second table.
the query works fine.

when using the report wizard, i select to make a report from that query, but after selecting all needed field, the wizard askes "how do you want to view your data" and options "by table1" and "by table2"...

choosing one and finishing the wizard's last steps, it creates a new form instead of a report.

Am I doing something wrong?
As I understand, the report gets created from a query, not from a table...
 
Are you sure you are in the correct place? With your DB window open... On the left under "Objects" is "Reports" highlighted? Are you choosing "Create Report using wizard"????
Make sure your in the right place and trying to create a report, not a form.
 
21,
Suppose your table1 has
name
address
city
your table2 has
purchases
When you create a report and the relationships are set on a PK Access creates a form to use as a Sumform to display the results.
The Table 1 will display on the report as a list of the three txtboxes.
The sub form will display below in a "Datasheet view" the Purchases related to each Name.

Jones
123 4th st
NewYork
---------------------
grapes
oranges
apples
onions
Click on the "RecordSelector" at the bottom of the form and the next "Name" record will display with it's related purchases.

Smith
456 7th Ave
Newark
-----------------------
Peanut butter
cereal
juice
 

Users who are viewing this thread

Back
Top Bottom