G
GTOHerder1958
I'm fishing for some ideas to accomplish a task. I have transactional data
that is imported into access based on posting dates throughout the month. I
summarize this data by office, by date each month, the result of which is
imported to a web platform. Tagged onto each record by Office, by Date is the
beginning of the month Balance. The problem is that I need to add in a dummy
record for non-process days in the month. Example 3/1 and 3/2 (Saturday and
Sunday). Data looks like this coming in.
Office Post Date Debits Credits Beginning balance
001 03/03/2008 100.00 100.00 1000.00
002 03/03/2008 200.00 200.00 1500.00
I need to find an automated way to insert non-process days by office using
the beginning balance for each office and zeroes for the amount fields.
Thanks in advance for any ideas
that is imported into access based on posting dates throughout the month. I
summarize this data by office, by date each month, the result of which is
imported to a web platform. Tagged onto each record by Office, by Date is the
beginning of the month Balance. The problem is that I need to add in a dummy
record for non-process days in the month. Example 3/1 and 3/2 (Saturday and
Sunday). Data looks like this coming in.
Office Post Date Debits Credits Beginning balance
001 03/03/2008 100.00 100.00 1000.00
002 03/03/2008 200.00 200.00 1500.00
I need to find an automated way to insert non-process days by office using
the beginning balance for each office and zeroes for the amount fields.
Thanks in advance for any ideas