Question Microsoft Access report with query with some data duplicate

snigapoe

New member
Local time
Today, 16:51
Joined
May 6, 2014
Messages
4
so i had created query using query design wizard for which i i needed to enter year of the data everytime the query is being made
all my data are correct when just using the query
however when i turning it into report where the query will still be runing and with adding in another field from my original table to get on the montly rearrangement that's where the some record are shown duplicate on the report
how should i go with it?
 

Attachments

  • query 1.png
    query 1.png
    4.3 KB · Views: 123
  • query.png
    query.png
    11 KB · Views: 122
  • report 1.png
    report 1.png
    4.9 KB · Views: 114
Are you going to add Total d later?
 
Are you going to add Total d later?

yes at the end of report i will add subtotal for each month then grand total for that particular year

i was trying to create monthly report query but could not success to run the query by just entering (mm/yyyy) eg: 01/2014 without the date part

is there any non too technical method on creating them?
 

Users who are viewing this thread

Back
Top Bottom