where to put criteria?

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

Guest

For a given report I want to either print all or a single batch. I can create 2 queries with the appropriate criteria, but since the report is always the same except for record source being qryAll or qryBatch, isn't there a better way to do this than creating the same report twice with the only difference being the record source. PS. I don't know VB at all.
 
For a given report I want to either print all or a single batch. I can create 2 queries with the appropriate criteria, but since the report is always the same except for record source being qryAll or qryBatch, isn't there a better way to do this than creating the same report twice with the only difference being the record source. PS. I don't know VB at all.
Click to expand...

What's the difference between the criteria? Could you use a single
Parameter query, in which one parameter (or set of parameters) gives
you All and the other parameter value gives you Batch?
 
couldn't you copy the report with a 2nd name: Report .... Single, Report
.... All Base each report on its appropriate query/ Your users can then
just select the report that gives the output they want.

--
-Larry-
--

create 2 queries with the appropriate criteria, but since the report is
always the same except for record source being qryAll or qryBatch, isn't
there a better way to do this than creating the same report twice with the
only difference being the record source. PS. I don't know VB at all.
 
----- Larry Daugherty wrote: ----

couldn't you copy the report with a 2nd name: Report .... Single, Repor
.... All Base each report on its appropriate query/ Your users can the
just select the report that gives the output they want

--
-Larry
-

John Vinson said:
On Thu, 22 Apr 2004 07:21:05 -0700, "jk
Click to expand...
create 2 queries with the appropriate criteria, but since the report i
always the same except for record source being qryAll or qryBatch, isn'
there a better way to do this than creating the same report twice with th
only difference being the record source. PS. I don't know VB at all
What's the difference between the criteria? Could you use a singl
Click to expand...
Parameter query, in which one parameter (or set of parameters) give
you All and the other parameter value gives you Batch
John W. Vinson[MVP
Click to expand...
Come for live chats every Tuesday and Thursda
http://go.compuserve.com/msdevapps?loc=us&access=publi
Click to expand...

Yes, both of those would work, but... I am trying to not junk up my reports list with 2 reports that are practically identical. Use the criteria determine which query to run. Then 1 report generated based on query results
 
Back
Top