How do I create the query criteria and what are the steps for creating a popup message on a form that states "vehicle exceeded permitted number of days" based on the calculated field?
I hope this isn't too complicated. I have no idea.
My database is used to track the number of days that a car is parked in a garage and make sure that it doesn't exceed 50 days per year.
I use three forms on my main entry screen all based on their applicable table.
On one of the forms, I use a field listed in the table to calculate the total...
I would like to create a report that looks like a letter inserting multiple fields from a query. The problem is the body of the letter will not fit into a textbox. Can I create a memo field in a report without modifying query or tables?