Seperate records by Date?

[k12hugh]

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. The pay dates will be on the Thursday of each month.

I need to 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 give me separate results by the different dates. Each record will only have one date associated with it.

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.

 

[Joe4]

Cross-posted: Query that seperates the date?

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule #13 here: Forum Rules).

This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

For a more complete explanation on cross-posting, see here: Excelguru Help Site - A message to forum cross posters).

I think that we will need to know your exact table structure and see some sample data to try to come up with a solution.