Query that seperates the date?

[patchesohouli]

Hi,


Every week a file will be imported into a table which breaks out into three separate queries, depending on the pay frequency. Within that, I know one of the pay frequencies will have two calendar dates associated, another will have two dates, and a third will have four dates. These dates will be changing each week, so it’s not like I can set the criteria for a specific date.

I need to further break these down so I have a separate query for each pay frequency with only one pay date. Therefore, I essentially need 8 separate queries. Is there any way for access to do that? It will need to recognize that a pay frequency has two distinct calendar dates associated, and separate it out by the different dates.

There should be separate queries for:

Biweek 26 – 1/1/2016
Biweek 26 – 1/15/2016
Weekly – 1/1/2016
Weekly – 1/8/2016
Weekly – 1/15/2016
Weekly – 1/22/2016
Ect.

But again, those calendar dates will change constantly. The number per pay frequency however will remain constant.

[davegri]

Attachment 24430 will show you how VBA can create queries with dates taken from form textboxes. The main form, frmQueries, is unbound, while the subform is bound to the queries created.
This should get you started.