Where to place the parameter?

  • Thread starter Thread starter Hallgeir
  • Start date Start date
H

Hallgeir

This is an example. I have one query with customer id and amount this
period. A second query with customer id and amount this year. And a third
query based on the two previous ones showing me customer id with amount this
period and this year. I in a case like this where should I place a customer
id parameter when the goal is to make the query most effective. Should I put
it in the first query, the last query, maybe in all three or does it not
matter? I have never figured out of access workes when it comes to queries
based on other queries. I hope someone can give me some hints.

regards
hallgeir
 
Hallgeir said:
This is an example. I have one query with customer id and amount this
period. A second query with customer id and amount this year. And a third
query based on the two previous ones showing me customer id with amount this
period and this year. I in a case like this where should I place a customer
id parameter when the goal is to make the query most effective. Should I put
it in the first query, the last query, maybe in all three or does it not
matter? I have never figured out of access workes when it comes to queries
based on other queries. I hope someone can give me some hints.
Click to expand...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Do you mean the PARAMETERS ...; clause?

I'd put that in the base queries (per period & per year). When you run
the "final" query you will be prompted for the parameter. Make sure you
use the same wording in the PARAMETERS clause for both queries. I
believe that will make the prompt run only once instead of once for each
query that has the parameter.

If you combine queries into one "final" query, and just one of those
queries has a PARAMETERS clause, you'll be prompted for that parameter,
or the parameter data will be retrieved from the referenced form/report.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQIQlCoechKqOuFEgEQLDBwCglQzcEDG3TBaQsq27wEYjUEUS8v8AoIPy
BQ3Wo5qcONVyJVdqjX+J+Th+
=1bQo
-----END PGP SIGNATURE-----
 
Back
Top