Search results
-
S
Multiple LEFT JOIN from two tables causing migrane
I have multiple tables I'm going to be putting into a query, but I'm getting stuck on one thing. I have a main table called 'tblEvent' with data similar to the following: eventID | eventCheck1 | eventCheck2 123 | 0 | 0 124 | 1 | 0 125 | 0 | 1 126 | 1 | 1 ...which is related to a table called... -
S
Expression builder: for newest date and for newest time, then dmax number +1
I've got a form that is used to enter specific data. The first box is a number associated with the total record. I already have an autonumber formatted ID column that is unique per record, but the record number is formatted as a number and allows duplicates. The validation range for it is...