Show Criteria When No Data in results

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When running a report that has no records in the results I am unable to show
the Start Date and End Date (criteria) from the query. If there is data
present the dates will show. The control source for each is as follows:

[Enter Start Date:] and [Enter End Date]

I need to print the report showing the Start and End Date criteria even if
no data is present. I have figured out how to show zeros in my calculated
fields and return the message "No Systems Tested" if there is no data, but
the criteria dates have got me stumped. Any ideas?
 
rwitosky said:
When running a report that has no records in the results I am unable
to show the Start Date and End Date (criteria) from the query. If
there is data present the dates will show. The control source for
each is as follows:

[Enter Start Date:] and [Enter End Date]

I need to print the report showing the Start and End Date criteria
even if no data is present. I have figured out how to show zeros in
my calculated fields and return the message "No Systems Tested" if
there is no data, but the criteria dates have got me stumped. Any
ideas?
Click to expand...

Instead of to present an input box that ask the date,
create a form with to control
e in the query poit to the
between form!tuaform!tuotxtbox1 and form!tuaform!tuotxtbox2
obviously use it also for report

--
_ _
Ciao
MAssimiliano Amendola www.accessgroup.it
Cisa1 - I° Conferenza Italiana per Sviluppatori Access Arezzo 4+5
Giugno 2005 Sono aperte le iscrizioni Info: www.donkarl.com/it
 
Abandon all parameter prompts in queries. Use references to values in
controls on forms. These values would be available even if there are no
records returned by the query:
="Between Dates " & Forms!frmDates!txtStart & " And " &
Forms!frmDates!txtEnd
 
Back
Top