Search results

Bob, I made a rookie mistake. I had my date formatted as text in my table instead of short date. When I made that change, funny, everything started working correctly. I figured I was doing something not so bright and as it turns out, I was. Thanks for the help. Forrest

CD, Sorry for the late reply. Crazy week, but here they are all crazy. I did normalize the table. Thanks for the reminder. It has been about a million years since my DB class. I haven't gotten to the other stuff yet but will try to make time this week. Thanks for all your help. Forrest

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

CraigDolphin, Thanks so much for the quick response and sorry I wasn't more specific but now that I know I have a guru helping... Attached are snapshots of my DB, the form where crane inspection results are entered, the table, and a second form for recalling the results. What I would like to...

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

Thanks very much for all your help. I did everything you told me to, even running a deep search and got rid of everything that, as far as I could tell, caused a problem with Date. Still got the same result. Ended up rebuilding the form, copying the controls and code from the old to the new...

I had cboDate1 feed a table column titled Date. Whether I used DateAdd or Date - 1, Date returned a value of whatever was in cboDate1. Thinking that the table column Date may be confusing the issue, I renamed it as Date Inspected, made the appropriate adjustments and now Access is telling me...

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

Exactly what I needed. Thank you.

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

KeithG, Thanks for the suggestion. I kinda sorta know how to use DateDiff and Weekdays by themselves. How do I use them together to count back 7 days?

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