Search results

Guys, I have a mainreport, that has subreports and when the subreport does not return a value, nothing appears. I would like to keep the header the same and under it say " There were no issues to report" So after research, i found that i must be using the hasdata function. However after...

omg dude.. I've been messing with this for DAYS!!! Thanks for your help.. It now pulls to the report

Appears the database was too big to upload.. No Data, I can't get the form to come up when i hit the ! button to run the query.. I assume that a with this setup a form should pop up

i've attached the the database if that will aid

tried to copy and paste getting popup The expression you entered has an invalid date value. By the way i appreciate all your help with this

SQL Data . . . So not confused im trying to query the data between 2 start dates... SELECT [Daily Tracking Issues].Status, [Daily Tracking Issues].[GWIM Severity], [Daily Tracking Issues].MGMTSum, [Daily Tracking Issues].[Issue Tracked], [Daily Tracking Issues].[Start Date], [Daily...

ok I made a new form.. went through the builder and below is what i have now.. Nothing pops up just comes to runs basically a blank query Between [Forms]![Form1]![StartDate] And [Forms]![Form1]![EndDate]

in_StartDate... Something wrong with the naming convention?

Thanks for replying.. Forms!Dates!in_StartDate .. comes up in the parameter box

Hello guys, Im new to access and obviously having a rough time :) Basically what im trying to accomplish here Is a report that can use a form as a parameter to pull a query of dates. I've created, Form, Report, Query However, I am unable to make the query open up the form to gather the...