Report... help needed urgently

[asiandoll]

Urgent help needed..

I have a report which is called Physical Stock... The values in the fields are based on the date they enter.. I have a between date criteria in the Query.

My problem is that I want the Opening field to take the first day of the month data while the Physical stock will be the last day of the month data. but the rest is calculated through out the month..

I have gotten the firsat data to work for the Opening field but I cannot seem to get the data for the last day of the month field only to be placed in the physical stock.

HELP ASAP.... Any help is appreciated.. Thanx in advance..

 

[TrojanRabbit]

One way would be to check the month and use if statements to determine the day. (If Month(...) = ...) Maybe you can get the first day of the following month and subtract one day. Not sure if this helps, but it's something.