MS-ACCESS-2003 VBA:   Make-Table-Query:  How can I code the Query-SQL or a VBA Module to fill in....

In MS Access 2003:

I need for the Make-Table-Query to every time it is run:  change the destination database name to fill-in/change to the current month-name at the very end of the db-name.  I also want the "end" date parameter to pick-up the "latest" pay-period-end-date by referencing a list that is a table within the same generation mdb.   The actual data will be pulling per the date specs from Sybase linked table that will be a make-table going to it's new destination - and will pull data YTD thru to the latest pay-period-end.

The person running this does not want any parameter boxes popping up.   There are other items that are run along with this in a Macro.  This 'open query' is one item in this Macro.    As soon as the query is opened,  I need for the query itself to reference the latest pay-period-end and fill it in - and - for it to reference the the month - and insert the month-name at the end of the destination-db-name.  Please see below.  

Can you please assist me with this?  It's really urgent........

The SQL Coding within the Make-Table Query is like this:

SELECT [_dbo_ncv_aud_allocs].* INTO [Output - Allocations] IN 'P:\Prod\Fy2008\AUD\RAJ_AUD_FY2008_MAY.mdb'
FROM _dbo_ncv_audit_val_allocs
WHERE ((([_dbo_ncv_aud_allocs].PPEndDate) Between [start] And [end]));

Thanking you for your time & help, sincerely, R.

Start Free Trial