Search results

Hello all, I'm looking for a way to pull the previous date in a query. The table data is structured in the same way listed below minus the red text. The red dates below are my goal. I am using Access 2003. I've done some searching and tried a few things I found, but no luck so far. What...

I have a query that looks at a closed date of a location and gives me a date 11 months prior or the open date, which ever is larger. My problem is from this point I want to find any sales from the first day of the 11th month back up until december 03. So say if a location closed on 3/20/04 it...

Hello, I am trying to make a report based off a table that contains sales data broken down by month and year. I've got everything working well and it's grouping by route and location number. Listing the 2003 and 2004 sales for aug like I designed it to. Now in the location group footer I...

Hello all. I'm looking for a way to make it where a person can not launch an update macro (launches a update-query) if X date is = to Y date (meaning that it was already updated so it will not allow them to do it twice and tell them so. I tried launching an IIF() in a query and launching a...

Have a database table containing sales collected per location. [month] / [year] / [date] / [location #] / [sales] When locations are collected the date of collection is keyed in. If that location is NOT collected it gets a date of 1/1/1901. [Month] and [Year] are always correct. I have no...

I've used the search function on the forum and couldn't find what I needed so I'll give this a shot at explaining what I'm trying to do and if there is a way I'm over looking... I have a database with various location data keyed on a location number. There is one field that is a yes/no check...

Ok I hate working with dates as I can never seem to get queries to do what I need with them. I have sales collection records and I'm trying to get a per day sales equation to work. The sales records are entered like so... Month / Year / Collect Date / Location# / Sales$ So each month there...

Hello, I am making a query that is using several fields from differant tables. In one of the tables I'm using there is a date field. In this query I need to list the last 2 dates closest to the current date. I'm needing the last 2 dates for a report I will be generating from this query...

Hello all, I'm working on developing a minor database. I have 1 table with locations and all set location data in that file. I have several tables with sales data sorted by year and month and so on. I have several queries that sort the data how I want it for easier usage and reporting...