Search results

Once again thank you arnelgp. The tempvars worked fine. I have finally made the bd workable....still need a lot of fine tunining but for now it doing its job ;)

Can i use a vba pop up in the report to inset the dates i need? As I do not want to record these dates? This is going to be used just for the report generated.

Hi again, I mainly finished the table and forms in my project and seems all is working...so far :) i am now compiling the reports. and have a question........i am creating a report with the data in my tables and queries, so far all is set, however my question is, I need to insert a text box...

@arnelgp thanks a lot for the sample, was very instructive.....worked like a charm in my project.

Hi All. Sorry for the late response but was a bit busy on work. both version work like a charm, the total Mondays per month are correct. @arnelgp: as mentioned I need the total mondays per month as the tax is worked each monday.....so yes it is easy to make the total monday multiply by 2...

Hi All, thank you for your replies. Will try it out later and let you now how if i manage to do it. I did this calendar as i included the holidays of the coming 10 years in it.....but at this point seeing that i can use the date anyway i think i could simply used the holiday dates in a table...

Hello, I've been searching all evening on how to use a sumproductif function, like the one in excel in access. I have a table containing the calendar dates for ten ten years. so i have column 1 - date, column 2 i extracted the year, column 2 the month and column 3 the mondays. so it would...

Hi All, I am new to access and trying to learn some basics.