Report showing abnormal information

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

Guest

Hi, everyone,
I got a problem in the report.
I created two queries both linked to same table including ProductID,
SalesDate, SalesAmount. Query A is set for the period from Nov04 to Dec04 but
Query B for Nov04 to Jan05. I did so by insert one new column in query with
SalesDate1 in Query A and SalesDate2 in Query B. After this, I make a report
selecting these two queries as sources. As a result, the result is not
correct becasuse the information are greatly duplicated or even triplicated.
Who can advise me my error here.

Thanks, Roy
 
aggregate said:
Hi, everyone,
I got a problem in the report.
I created two queries both linked to same table including ProductID,
SalesDate, SalesAmount. Query A is set for the period from Nov04 to
Dec04 but Query B for Nov04 to Jan05. I did so by insert one new
column in query with SalesDate1 in Query A and SalesDate2 in Query B.
After this, I make a report selecting these two queries as sources.
As a result, the result is not correct becasuse the information are
greatly duplicated or even triplicated. Who can advise me my error
here.

Thanks, Roy
Click to expand...

Take a really careful look at the links. I suspect that is were your
problem is.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Access Date/Time Calculation After Midnight 1
Count of Duplicates 3
Printing a report with a chart 15
Print a report from another database 7
A report design question 3
Access Access Report Works on One Machine but not Another 3
report after parameter form 3
How Can I join Two Queries? 3

Back
Top