Listing Fields in Report

[NashTrump]

I am trying to create a report from two tables in a database.

The two tables i have are sales and purchases.

The fields im taking from each are Suppliers, Model, Date, and Qty

I want to create a report that groups the results per suppiler, but when i do i get a report of numbers!!

IE:

Supplier Model Date Qty
1 Nokia 01/01/01 2
2 Nokia 01/01/01 2
3 Nokia 01/01/01 2

Etc etc

Does anyone have any ideas??

Very grateful if you can help me!

Thanks

 

[dhookom]

Did you include the supplier table in your report's record source? I expect you might have used lookup fields in your tables. My opinion is this should never have been included as a "feature" in Access.

Consider reviewing this page

http://www.mvps.org/access/lookupfields.htm.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]