Report getting data from table.

  • Thread starter Thread starter randall.phillips
  • Start date Start date
R

randall.phillips

I don't know how to explain this so here goes. I have a report
(Customer Report) when I open the report I want to pull the information
from a customer table such as Name, Address, etc.
I would imagime this would be a heading. I also want the customer
product data which is in the customer product table. Can anyone give me
an Idea on this one. Thanks
 
The easiest way is to open your report in 'Design View.'
Then open the 'View' menu at the top of the screen.
Select 'Field List' from the menu.

This will give a list of all the available field in the Table that the
report is referenced to.

Your report may not be referenced to a table. To check this, press
'Alt+Enter' or from the 'View' Menu select 'Properties.'

Select the the 'Data' Tab and look at your 'Record Sorce.'

Clicking on the arrow to the right of 'Record Source' will allow you to
change the Table or Query from which your data originates.

If no table was selected, select the appropriate table and see above.


good luck.


Field List
 
Randall

You should create a query (qryCustReport) which pulls together the data from
the two tables and base your report on this query. It may depend on your
existing relationships, but you can always create a query join.

Regards
D Dawson


The easiest way is to open your report in 'Design View.'
Then open the 'View' menu at the top of the screen.
Select 'Field List' from the menu.

This will give a list of all the available field in the Table that the
report is referenced to.

Your report may not be referenced to a table. To check this, press
'Alt+Enter' or from the 'View' Menu select 'Properties.'

Select the the 'Data' Tab and look at your 'Record Sorce.'

Clicking on the arrow to the right of 'Record Source' will allow you to
change the Table or Query from which your data originates.

If no table was selected, select the appropriate table and see above.


good luck.


Field List
 
Back
Top