Re: Multiple queries-Want only 1 report

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hey Jeff!

Thanks bunches for the quick reply. I like the unbound controls usage.
Deinitely have a use for your advice.

I appreciate your time!
--
Bonnie W. Anderson
Cincinnati, OH


"Jeff Boyce" wrote:

Bonnie

Another approach might be to start with a form...

If you have a form from which the billings are "ordered", you could add
three controls corresponding to your "billed", "rebilled", "final" values.
Don't bind them to the underlying fields, just use them as containers.

Add a <Send Bill> command button that opens the report.

Now go to a single query and modify the Selection Criterion "cells" under
these three fields in your query. Point each at its respective
setting/container on the form, using something like:

Forms![YourOrderFormName]![YourBilledControlName]
and
Forms![YourOrderFormName]![YourReBilledControlName]
and
...

Use the query as the source for your report.

This will only work if the form is open. Open the form, set the Billed,
ReBilled and Final controls the way you want them. Click the button.

JOPO (just one person's opinion)

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/


"Bonnie A" <bonnielynnw@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:990A3B02-0138-4600-9452-1E1F40E1FBA2@xxxxxxxxxxxxxxxx
Hi everyone! I'm using A02 on XP. Not a programmer but can work a little
VB
in event procedures.

I have a report that is a bill for services rendered. We bill, rebill,
and
then final bill.

My queries all have the same fields BUT I want to use just one report.
I've
researched it here and found a few items but only saw one that said "do it
programmatically" and the reply was "ok" and one other that said to create
a
form with the query list and create a union query for the report.

My logic path is this:...when I bill, the criteria includes [Billed] is No
and [ReBill] and [FinalBill] are Null (then [Billed] is updated to Yes);
when
I rebill, the criteria includes [Billed] is Yes and [ReBill] and
[FinalBill]
are Null (then [Rebilled] is updated to Yes); and lastly, [Billed] and
[Rebilled] are Yes and [FinalBill] is Null. In each case after the
initial
billing I also filter out those where [Paid] is Yes.

Would a list box with the queries be best utilized with the
"programmically"
or "union query" approach? Is there a better way for my example? I'm
pretty
sure I understand the union query one but wanted some advice first.

Thank you all in advance for all the time you put into helping folks on
the
newsgroups!
--
Bonnie W. Anderson
Cincinnati, OH


.

Relevant Pages

  • QFTCICR Game 4 Rounds 4,6 answers: migrations, presidents
    ... for Marc, Pete, Jeff, Boot, Peter, Joshua, ... Stephen, Dan, and Bill. ...
    (rec.games.trivia)
  • QFTCI 02-05 R9-10 answers: sports trades, challenge round
    ... for Marc, Bill, Stephen, Joshua, Dan, and Jeff. ...
    (rec.games.trivia)
  • Re: Safespeeds fake coppers.
    ... You really haven't got the hang of this quoting thing have you? ... in order to prove with peer-reviewed data that speed cameras save ... So far Jeff you've screamed "HYPOCRITE" at me because you hadn't read ... "Appendix H" of the 4th year report? ...
    (uk.rec.cycling)
  • QFTCI answers 01-22 R7-8: NFL logos, river confluences
    ... Stephen, Jeff, Joshua, and Dan got all ten for 4 points each. ... New England Patriots...Keith, Marc, Bill, Peter. ... Marc, Stephen, Jeff, Bill, Erland, Dan, Peter, and Rob. ...
    (rec.games.trivia)
  • Re: Access query performance
    ... Thanks for the advice, subreports did the trick. ... troubleshooting advice on whether these types of problems are query or report ... "Jeff Boyce" wrote: ... > The first thing to check on slow queries is that fields used for selection ...
    (microsoft.public.access.queries)