2 questions

  • Thread starter Thread starter GSealey
  • Start date Start date
G

GSealey

Please answer the following:

1. You want to allow the user to enter the Last Name used
as selection criteria for a Query. What would you enter
in the criteria row of the Last Name?

2.You want to allow the user to select the range of dates
to be used as selection criteria for a query. What would
you enter in the criteria row of the Payment Due field?
 
Please answer the following:

1. You want to allow the user to enter the Last Name used
as selection criteria for a Query. What would you enter
in the criteria row of the Last Name?
Click to expand...

[Enter last name:]

but see below...
2.You want to allow the user to select the range of dates
to be used as selection criteria for a query. What would
you enter in the criteria row of the Payment Due field?
Click to expand...
= CDate([Enter start date:]) AND < DateAdd("d", 1, CDate([Enter end date:]))
Click to expand...

It's often convenient to give the user a drop-down list (a "Combo
Box") for names so they don't have to be so precise with the spelling:
searching for "Seely" will of course not find Sealy but it's the kind
of thing that a user might do. One alternative is to create a small
unbound Form, frmCrit let's call it, with a combo box listing all the
last names in alphabetical order (perhaps with first name and some
additional info so you can distinguish Fred Jones the cafeteria busboy
from Fred Jones the head of Marketing); call this combo cboLastName.
You can then use a criterion of

=[Forms]![frmCrit]![cboLastName]

If the combo's bound column returns the unique personID (if you have
one!) then that's all the better. You'ld use similar form references
in place of the [Enter start date:] and [Enter end date:] criteria
above.
 
Back
Top