I have a Query the i need to update a table. Now my one table has the following fields:
Now i need the date and return to update from another table with these fields:
Year (I know year is an important word in access)
I need to group the Month and year into one field from this past table. I have been trying to use a query but i cant get them to group to give the month end date. I am able to get it to group like this, for example. May, 2004.
Is there a way to get the year, and month to group in this format dd/mm/yyyy? It needs to be the last day of the every month. any ideas, thanks!
So i have figure out that i need to use the DateSerial formula. I currently have this:
the reason i have plus one is to tell access to go to the beginning of next month, then i have the day set as zero to go to the last day of the previous month. This helps avoid confusion with how many days are in a month etc. does anyone have an idea why i keep getting #error? I have been tried linking it to the table its self ie. ([Monthly_Performance].[Year],[Monthly_Performance].[Month]+1,0)
However it is still not working. I have data that doesnt equal zero at all? so how is it giving me a div/o error? thanks,