Search results for query: *

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

Thanks

Field:Store# |Region|Open/Close|JanSales|O/C |FebSales| Table: Sales | Sales|Sales | Sales |Sales|Sales | Sort: Show: yes | Yes | NO | Yes | NO |Yes | Criteria: | | "Y" | | "Y" | |

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...

It's the only table I have

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