Are all of those date parts from a single date?

Post #151,830 by FuManChu 4/19/04 4:40:43 PM Reply	Are all of those date parts from a single date? That is, if you can derive qDOM, qMonth, qAPDay, qDOW, and qJDate from a single inputted date, then you're left with requesting only three params: qDate, qSystem, and qExcept. The string-to-date coercion in Access is actually not too bad. qDOM = Int(Format(CDate([Enter the report date]), 'd')) etc. It's doable. Personally, I'd move this kind of logic out of the database entirely and into a middle tier. ;)
Post #151,831 by jbrabeck 4/19/04 4:55:09 PM Reply	More qDOM = Calendar day of month 1-31 qMonth = The month qDOW = Alpha day of week (Sun ... Sat) qJDate = Julian day qAP = Day of the accounting period, based on a 28 day month. No correlation to actual calendar date. Yes, I can generate the first three variable from a single date, and maybe the julian date, but I still need to pass to the query. Other information that will be provided in number of days to run. That means that the query would be run x times to produce x schedules. I've been doing it manually, but my co-workers are tech writers and I don't want to risk them missing a variable and not getting the schedules correct. All for Disaster Recovery. FWIW, I'm learning Access on the fly. All pointer are appreciated. I'm trying Jay's VB suggestions and getting an error "Object Required" on the Set Query1 = line
Post #151,838 by JayMehaffey 4/19/04 5:19:22 PM Reply	Sorry To use the example code I gave you need to do this first. It's one of those things that is so standard I skipped by it. I should also point out that I don't have a copy of Access handy, so there could be typos and other things I've overlooked. Set db = CurrentDb() Despite the fact that all Access code exists in the context of a database, Access does not give you a reference to the database by default. Thus the above is usually the first line of non-declare code in any significant Access VB routine. I believe the reason for that has to do with the fact that you can create multiple database variable and access multiple databases through them. But Access really should give you access to the database the code is in through some default keyword. Jay

Welcome to IWETHEY!