Hi
I have a query Union based on two simple queries.
I have to set a command button on a form which print previous month entries of all records based on ID.
My question is:
1) should I have to set previous month criteria on each query for to have union query to work?
2) I have set on one query the following previous month criteria but it does not run:
I have a query Union based on two simple queries.
I have to set a command button on a form which print previous month entries of all records based on ID.
My question is:
1) should I have to set previous month criteria on each query for to have union query to work?
2) I have set on one query the following previous month criteria but it does not run:
Code:
Year([DataPIP])* 12 + DatePart("m", [DataPIP]) = Year(Date())* 12 + DatePart("m", Date()) - 1