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
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.