Search results

If CertificationDate is the date that the Cert was issued then it might be better to NOT have an ExpiresOn field in a table but have that date calculated in the query. It is usually considered to be better to do the calculation whenever and wherever it is required than to store it in a table.

I think that would work but you might need to check the length of Cert Validity AS WELL as the checking for Null in CourseID2. Perhaps a 3rd conditional rule. Post back if you need more help :)

I've just had an afterthought. Won't you need to take into consideration the length of time that a certificate is valid for? I noticed a field called "ValidFor". Would I be correct in assuming that this holds the number of days that the certificate is valid for? Do you need to indicate in the...

Always pleased to help if I can ;)

Not sure that I've understood the requirement but see attached:

So how many products are in the list and how large will it need to become before you decide to structure things properly by creating a "ProductType" related to the "Products" table

Perhaps your criteria should be in a different column

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