Search results for query: *

I need to update one field based on the entry in one or more other fields. The scenario is that we have an incident "state" field, which will be a value between 1 and 4. The value for "state" corresponds to a series of date fields on the form. Right now, "state&quot...

Our database has an autonumber field as a key field. I need to append records into the database and then adjust the autonumber so that the next added record assumes the correct id number. I've tried following the instructions in the help files, which are basically to create a new table with...

I have created a report that prompts the user to enter a starting and ending date so the query can select records in that range. The header of the report includes the date range in the title. If there no records in the range, the report is blank (correct) but the header prints out for the...

I am trying to create a report with several sections. Each section selects the same fields from the main table, but using slightly different criteria based on one or more date fields. After much trial and error, I stumbled on using subreports. After even more trial and error, I now have a...

I am trying to create a report based on some date fields in our database. We have "Fixed", "Verified", "Delivered", and "Closed" (all date fields). Selection for the report needs to be based on if ANY of those fields have a date in them (but at least one...

I'm real beginner on creating Access forms. I've fumbled my way through most of it, but am stuck on how to get a calculated value to display onto the screen and also update into a field in the database. Example: Priority, Rank, and Status are all numeric fields entered by user...