I have several filtered queries that I want to place in a report. However, when I combine these queries on the report, the filter gets applied accross each query leaving me a blank report.
Anyone know how to show the data from each query on the same report
They should when you are comparing 2003 vs 2002. This year, those stores will be open the entire year but only 6 months and 3 months respectively last year. Therefore, on my report I want store 12&13 to show 0's until they have a comparible month (month against where there are sales to compare -...
Thanks guys. I think I will make some improvements to my table. You see, the table was created by importing all the data from excel spreadsheet.
But the real problem I can't get is this:
List on 1 report or query every store that was open for the same months as prior years. For example, Store...
Thanks for the response. Let me answer your first question.
I have a table called Sales. In this table I have fields named
Store #
Region
Comparible Month Y/N
Jan'03
Jan'02
Comparible Month Y/N
Feb'03
Feb'02
Comparible Month Y/N
Mar'03
Mar'02
etc through Dec.
My form simply is the vehicle to...
I am trying to set up a query that compares sales from different stores that opened in different months. Therefore, when I sort in my query to include only those units that were open in say January, when I use the same filter in Feb, it reduces the unit again if the store opened in Feb because...
I need to be able to update different tables with same data inputed through a form. Can anyone help solve this. I have spent 3 long days trying to figure out.
(You may notice that I am new to Access)
Thanks,
Montygee
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.