How do I create this form

[hmho]

I have table I have been changing but this is how the table is and I keep track Phobe cards sales that come in books of 50 0r 100 or 200 per pack. and each book has uniqoe serial number and number of each card for example book serial will be X123 and if it has 50 in pack each phone card will have the serial number and 01, 02, 03 to 50. I designed the table this way

SaleDate BookSerNo EndingNo
01/01/09 X12345 00
01/02/09 X12345 05
01/03/09 X12345 20
01/04/09 X12345 30

I want to enter these information every day so then I can run quesry that will give me each day's sales, but how do i design form that will show me yesterday's data so i can see which books are open so I can update the EndingNO. I hope I'm clear enough.

 

[speakers_86]

Query the data where

Date is now()-1

and

EndingNo Is Null


I could be off with Now(), but it is something like that. Perhaps Date(), or Today(), I'm not sure, use trial and error, or Google.

 

[WIS]

Query the data where

Date is now()-1

and

EndingNo Is Null


I could be off with Now(), but it is something like that. Perhaps Date(), or Today(), I'm not sure, use trial and error, or Google.

Use Date()-1 as Now() incorporates the time as well. I had a problem some time ago where some records from the last day filter in my qry were left out.

eg Date() the number was 31
Now() the number was 31.5 because it was 12:00 noon.

 

[speakers_86]

Thats what I thought, that is why I gave that little disclaimer!

 

[hmho]

When I set up the query I got yesterday's numbers but when I set up form with this query to update the table it overrides the yesterday's numbers. I want to keep yesterday's numbers and enter today's ending number aswell..