Search results

How would I create a query which the user fills in the surname of the customer he is searching the database for, the query finds the record? Also does anybody know why the help files in Access are written in klingon?:D

How can I set up a query to show the most recent entries in a database? These could typically be a week back from whatever the current date is when the query is run. Hope that makes sense! Thanks:confused:

I want to have fields in an Access tables behave like they would in an Excel spreadsheet. i.e. if someone enters the number 42 into a field called 'units' I would like the next field (called stock) to multiply it by 2 and display 84 automatically. This is needed for approximately 3/4 fields...