ms access help

[zhuanli]

I am having some trouble with a database I am trying to build, the problem is that students purchase a card with a quantity of lessons on it lets say 20, when they enter the office thier card is scanned via barcode scanner, the scanner writes directly to the field, I need the field to record the date of entry ,the data and then deduct 1 lesson form the 20 lessons. There are 2 tables one is employees and one students, students are the only ones making purchases but would like to record the entry date of the employee as well. even if it could open the form with the matching record which could have a button on it to 'enter class' which would deduct the 1 lesson or in the case of the employees form a ' clock in' button. any help would be much appreciated

[bwcc]

You can add a 'date(now)' in an expression builder to auto add the current date (grabbed by the computer's cmos date) into the field. This way when new data is entered into a new row, the date(now) expression would be auto-filled.