Search results

Nector Perhaps you just need to change the "Data Entry" property of the main form from Yes to No

Glad to help if I can. Be sure to test well wit more data.

Try: SELECT Max(YourTableName.SeatimeID) AS MaxOfSeatimeID, YourTableName.CrewID, Last(YourTableName.JoinDate) AS LastOfJoinDate, Last(YourTableName.LeaveDate) AS LastOfLeaveDate FROM YourTableName GROUP BY YourTableName.CrewID ORDER BY Max(YourTableName.SeatimeID);

I've certainly not offered any solution. All I've offered is some advice on cross-posting.

You may be correct about "new posters", I can't remember that far back anymore :ROFLMAO: Not so sure about the need for new glasses though. In post #12 at: https://www.accessforums.net/showthread.php?t=88955 he said, "Okay thank you, you are awesome. You saved me lol, what did you change so I...

I never realized that you were such an optimist ;)

I notice that Minty managed it. I always use copy/paste to show a link here. It's never let me down.

Why would he?

I wonder if the OP ever did read the link that Minty offered regarding cross-posting :unsure: 👋👋

The url for what and where did you try to post it?

If you could be bothered to read the links that Minty supplied, you might have more success.

Sounds like a job for DateDiff() function: https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/datediff-function To be of more help we'll need to know something of your table.

I shall remember the name "bmaccess".

I think everybody should be able to see now. Remember the saying, "Abandon hope all ye who enter here".

Post a copy of the db

You're missing two commas: DoCmd.GoToRecord , , acNewRecord

Can you post a copy of the db

Try <> instead

Does the report open ok if you use: DoCmd.OpenReport "rpt3", acViewPreview in the Immediate Window

can you open other reports in Preview