Is there a way to select in a form which address to use

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

Guest

I am trying to create a database for expense reports. Sometimes the employee
has the check mailed to their homes or sometimes to their business. I would
like to have both addresses in the form and select one for that particular
expense report. Can anyone tell me if this is a viable option?
 
However you distinguish which is the default mailing address, is the way
that you proceed. Use a Where clause (the criteria box in a query) to
determine which one to use. Something like:

Select Street, City. State, Zip From tblEmployees Where Mailing address =
True;

If that doesn't work, report back with your table design so we can help you
further.
 
Back
Top