Date Stamp

[Lyndseyd]

Hi all,

Im just wondering about a date stamp which is in one of my queries. The database which i am working on is for a fuels company, one of the tables they have is a runout table, obviously for when fuel runs out at a station and also contains sales history. They have used a date stamp, so they can see how many runout were recorded each day.

My user now wants to be able to see what the previous 'date stamps' sales were, which is DATE_STAMP-1. I was just wondering if this was actually possible, i have tried several different ways of adding the criteria to the DATE_STAMP fields but it doesnt work and have got no where. I would be grateful of any help.

Thanks

 

[reclusivemonkey]

As long as the previous date stamps are recorded in the table, you can do this. If the field is simply overwritten without an audit trail being created, you are out of luck.

 

[Lyndseyd]

Thanks for your reply, no there isnt an audit trail currently in place. I didn't think i could do it the way it was, it just didn't seem to be logical, thanks again