Recent content by Skotor

Ahah, not exactly what I needed. But I think it pointed me in the proper direction to correct that error. I'll force the place holder dates to null in the source query. I do need it tied into the location # AND sub location though. I will be running this on anywhere from 20-200 locations...

See attached DB for 2000 copy.

Still stuck. Sample DB attached. Apparently I don't understand how to get the bracket syntax correctly as I'm getting a different error now. Thanks for the help.

I get a syntax error when I try to run what is listed below... prev: (SELECT Actual Date FROM Sales Data AS Alias WHERE Actual Date = (Select MAX(Actual Date) FROM Sales Data AS Alias2 WHERE Alias2.Actual Date < Sales Data.Actual Date AND Alias2.Location # = Sales Data.Location #) AND...

I found that on a previous search and was unable to make it work for my query. Kept getting an error. I'll attempt it again and post what I used. Might can point out where I screwed up. Thanks!

I'm no expert, but try using the Dateadd function... Dateadd ("d",30,[date field])

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

Perfect! Thanks for the help.

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

ehhh thats kinda what I was looking for. What that gave me was only locations entered on 8/31/03. Which is the last keyed in date. I have no problem getting that another way. What I'm looking for is a listing of all active locations, the last service date, and the prior service date. I can...

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

That did exactly what I needed it to do. Was making it harder on my self than I should of. Thanks!

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