Search results

Thank you Minty, i have to store in a table an estimate of car lease payment. I have a table Estimations, a table Clients. In a data entry form called "Estimate form", i put all the estimate data: client, payment, lease data, date of estimate. After i stored the record i can generate a .pdf...

I am trying on VBA with your code, but there is something not working: In DMAX method: Year(Date()) This take the TODAY YEAR. I need to put the date of the data entry form (that could be different from "today year"). Right?

Ok, the only thing is that the date of the record come from a data entry mask. ...but i can't it in a query.... How can i do in VBA?

Sorry, just to better understand: From the first expression: DMAX(...) -> find the record with the latter-day of the year that i want. If founded, take the code and add 1. Nz(...) -> if null, the code is YEAR01. If not null is year+(last code+1) format(...) -> The code is composed by "000000"...

Hi and thank for all the Help/suggestions: I have a table records with a "data creation" field and a "sequential number" field. On the same table, I need to generate a "sequential number" and a "code number" like: YYYY+"0"+(sequential number starting from "1", EVERY YEAR). For example: RECORD...