Search results
-
N
Not all records from my query appear in my report
Great idea! I would like to assume, and maybe that's my mistake, that the date starts at 00:00 and ends at 23:59. There were two records on the last day of the month that do show on the report while the other two 'missing' records were created mid-afternoon on the same day. I have been... -
N
Not all records from my query appear in my report
I tried replacing BETWEEN with >= and <= but it didn't like it. I also checked other records in the DB against the 'missing' records to see if I could determine if anything was wrong with those records but I could not. Thoughts? Ideas? Thanks again! -
N
Not all records from my query appear in my report
I have an Access 2003 database with a report that does not display all of the records in the query that populates it. The query for the report looks like this: SELECT Incidents.[Incident number], Incidents.DateTimeCaseOpened, Incidents.CurrentStatus, Incidents.IncidentClassification...