User Query

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

Guest

I have a Query with two Criteria’s
1- Between [Begin Date ?] And [Ending Date ?
2- User
But after the operator input the dates I want the second criteria open a windo
with the “ user value †for the operator can choice one value in the User field
Any advic
Thank

Fernand
 
Fernando said:
I have a Query with two Criteria’s
1- Between [Begin Date ?] And [Ending Date ?]
2- User
But after the operator input the dates I want the second criteria open a window
with the “ user value †for the operator can choice one value in the User field.
Click to expand...

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

Perhaps:

PARAMETERS [Begin Date?] Date, [End Date?] Date, [User?] Text;
SELECT ...
FROM ...
WHERE UserColumn = [User?]
AND DateColumn Between [Begin Date?] And [End Date?]

If the [User?] is a different data type change the Text to that data
type.

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

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

iQA/AwUBQICKqoechKqOuFEgEQJj+QCfd3sfzREwtg7ykonYGxt3pfU32BEAoODE
H8Wc2Vgif5Jl89gGiEldR80e
=uJ5D
-----END PGP SIGNATURE-----
 
Doesn't work
I have only one table
Date - Date/Tim
Time - Date/Tim
User - Tex
Systolic - Text
Diatolic - Tex
Pulse/Min - Tex
and my Query is for when I ask for a report by, I be able to select the user Me or my wife without have to right down the name
Can you help, me
One more time thanks
 
You can't get a dropdown/combo box in a parameter prompt query like this.
The solution is to use controls on forms for your criteria. Your criteria
would then be something like:
1 Between Forms!frmA!txtBegin and Forms!frmA!txtEnd
2 Forms!frmA!cboUser
 
Back
Top