Search results

I'm running a query to find records over one year old. When I use Date()-"365" or DateAdd (365 days, 12 months, 4 quarters, or 1 year) the records from one year ago today come up just like they are suppose to. The problem comes in when I put the comparison operator out front. If I put < in...

Not even sure where to start so if this isn't a query question, please point me in the right direction. I work in a plant that has a number of cranes. Each crane should be inspected each shift (three shifts per day), each day (less Sunday). I have exactly what I need to capture the...

I have a form with a pop up calendar that fills cboDate1 and it works great. When I click the Save button, I run a query checking to see if a record was added yesterday Date()-"1". The query works great. If a record is not found for yesterday, I display a message box saying a record was not...

My table has a date field. I would like my form to search for a record with yesterday's date and if it is not found display a msgbox. How do I get it to look for records that aren't there? Thanks

Can I put yesterday's date in a msgbox message? If so, how? Thanks.

I have a form in which the user inputs crane inspection results (a series of check boxes). When the user clicks the save button, I would like to run a query (I guess a query is how to do this) that searches records for the past seven days (less weekends and holidays) and alerts the user to days...

Help. I know just enough about Access to get myself into trouble. What I want to do is have a form where I enter a low work order # and a high work order # with a series of yes/no questions and then have that autofill a table with work order #s incrementally from the low value to the high...