Recent content by Fstetson

I am trying to make a simple database structure to allow me to store monthly mileage readings. I am using a subquery to develop two fields "PriorValue" and "Mileage". PriorValue being the last updated odometer reading and Mileage is calculated from current reading and prior value. The query...

Try Udemy online courses....Bruce Myron provides some really great courses

Hope your New Year is better than last one. Has to be, right? Of course. Hi I am novice database builder with limited Access and VBA experience. Not a professional but a hobbyist of sorts. I created, what I think is a cool database for homeowners to use to manage their home tasks...you...

I'll post a link here when completed, as it will be free to the general public anyway.

Eureka, your solution worked, I put your suggest statement into the criteria row iof the intended field and it works. corrected the SQL itself to show as; WHERE (((IIf(tblEquipEventException.EventID Is Null,IIf(([qryEquipEventCartesian].PeriodTypeID Is Null) Or...

Okay, getting a syntax error.... here is the where statement WHERE (Between CDate([Enter Start Date]) And CDate([Enter End Date]))

Should that be in the SELECT, FROM, WHERE portion of the statement of the SQL?

Good Day all, I have a unique situation where I have set up a series of reports for different areas to show data between user input dates. The uniqueness comes with the field (in the report query). I am applying the parameter criteria of Between [Enter the Start Date] And [Enter the End Date]...