Search results

Sorry, that is not possible.

Iam trying to navigate my way through the maze in the northwind db modules and totally lost. I was hoping to make a much simpler process. And yes, I always create a system administrator form for various system operations and information keeping. I was hoping there would be some simpler...

Hello and Greetings All, I am trying to set my database solution for deployment in order to provide company/owner personalization during FIRST startup, and then prevent that form from showing again in future openings of the DB. I have seen several examples and unsuccessfully finding them now...

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]...