Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report Criteria

Status
Not open for further replies.
zrobinso

zrobinso

MIS
Apr 22, 2001
27
US
I have a report that uses 5 sub reports and is based on 5 seperate querys. Each query is linked to a query [qryDates] that asks [startdate] and [enddate]. When I run the main report it asks for start and end date 5 times before report is displayed.

How can I get it to ask only once without editing query each time. I am using a switchbord to keep uses from seeing database.
 
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Question
Excel Match / Index on multiple values and criteria
Replies
6
Views
181
remeng
remeng
MM1963
  • Locked
  • Question
Excel - Unique count using a criteria 2
Replies
19
Views
354
SkipVought
S
Rick_Stanich
  • Locked
  • Question
Find the nth occurrence of a string and report value to the left. 1
Replies
5
Views
120
Rick_Stanich
Rick_Stanich
LinsayPatterson
  • Locked
  • Question
MSQuery date criteria using 'today's' date
Replies
2
Views
47
LinsayPatterson
LinsayPatterson
RRinTetons
  • Locked
  • Question
Excel pivot table refresh says Invalid Pivot Table report
Replies
2
Views
162
RRinTetons
RRinTetons

Part and Inventory Search

Sponsor

Back
Top