Recent content by rs197290

No, I'm not sure where that code would go. Could you explain a little more in detail. If I should do this, could you explain how I would do it and if I dont need to do this could you explain how to take it off?

Thanks Bob, this worked great for one exception. When I open the form it goes to the last record that I need it to. However, when I go back a couple of records and hit my Refresh button which I have set up as a Macro for GoTo Record "Last", it does not go to the record that I need. I tried to...

Here's my situation. I have a table that is sorted by Date and then Time. Let's say that I add a record at 7:00am that has a time stamp as 3:00pm. At 8:00am I have to add another record that has a time stamp of 7:30am. In my table the records show up in the correct order by time stamp...

Almost there Thank you for your reply. I have never worked with SQL before but I am figuring it out little by little. However, I am only needing to select one Type of Event but I need to query on the most recent three records by date and time and only 1 type of event. Thank you in advance...

I have 4 fields that I am doing a query on. Date Time Comments Type of Event I am trying to query and display only the 3 most recent records based on the Type of Event. I am having a problem where I am either receiving the records from today's date or yesterday's date. We do a turnover log...