Search results

After the fact, I was asked to create a selection box for a field "Posting Type" rather than have the user check a box to indicate a "Posting" is to take place. I would like to run a query that would the check the "Posting" checkboxes and if the box is checked, autopopulate the selection box...

Thanks Jack, that helps also. Chris

Thx Thank you Fornation, that did exactly what I needed. Chris

When generating a report, how can I get a total on the number of times a certain checkbox was checked? Thanks, Chris

When generating a report, how can I get a total on the number of times a certain checkbox was checked? Thanks, Chris

Here is the SQL: Thanks again: SELECT [WMAG Work Requests].Status, [WMAG Work Requests].WorkRequestNumber, [WMAG Work Requests].DateSubmitted, [WMAG Work Requests].DesiredDueDate, [WMAG Work Requests].ProductOrService, [WMAG Work Requests].ShortDescriptionOfWork, [WMAG Work...

:rolleyes: Well, Pat, I don't really think I'm on the edge in this case. It isn't always necessary or desireable to enforce referential integrity. But discussing theory is not what I'm here for. How do I post the query? Chris

I have a form I want to use to update records in my database. I don't want to use the same form as I do to enter new records. The form is based on a query where some fields have a criteria. I have found that I cannot update the fields that have a criteria. I am using four tables. Three of...