Re: I use the same parameter in 2 queries - how do I only enter once?

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

Enter it in a control of a form? Even if the form is hidden, that is ok, as
long as it is open. Then, use the syntax FORMS!formNameHere!ControlNameHere
for each query.

Note that if the queries are cascaded (one inside the other) there is no
need to supply the parameter twice.


Hoping it may help,
Vanderghast, Access MVP



"Pogue" <joemullanynospam@xxxxxxxxxxx> wrote in message
news:C82438EC-45D7-41EE-A75D-0D96B4EC94F2@xxxxxxxxxxxxxxxx
I have a report that uses a subreport. Same company/same date range.
Currently each query asks for the company name and the beginning and
ending
date so I have to enter each twice when I run the report.
Ideally, I would only have to enter this once.

How do I do this?

Thanks for your help,
Joe


.

Relevant Pages

  • Re: add a query in a texte field in a form...
    ... clause in your query. ... Now, on the Syntax: ... Not sure I understand the reference to the control on ... > i cannot save my macro, or quit this window, with thatparametters.. ...
    (microsoft.public.access.queries)
  • Re: "sum" syntax for four fields
    ... What would be the syntax to create a sum of three fields in one record in a ... query table (NOTE: I prefer an SQL syntax, ... In its control source, ...
    (microsoft.public.access.forms)
  • Re: Calendar using between dates
    ... The calendar "control" has to be in a form, and once there, the syntax to ... query it is as with any control in an open form: ... and you have to do it BEFORE execution of the query ...
    (microsoft.public.access.queries)
  • Re: Using Query Results in Macros
    ... I have never before seen the type of syntax you are using in your ... you can't really refer to the value in a query ... an unbound control. ... If it is an unbound control, you may be best to directly refer ...
    (microsoft.public.access.reports)
  • Re: Formula Problem
    ... You can alternatively create an expression in your query with the same ... you can create the report. ... The syntax you have used is ... > Given the following expression attached to a control named Surviving ...
    (microsoft.public.access.reports)