Parameter Query ABC

  • Thread starter Thread starter AH
  • Start date Start date
A

AH

Hi,

I have this query that lists firstname, lastname and
orders.

All I am trying to do is when you launch the query, it
will prompt you for the firstname. If firstname is
enterd, you will only get the "orders" records with that
firstname.

I have entered: "<[First Name:]" in the firstname column
in the criteria cell, but I get other firstname records
when I enter one person's name!

For example, if I enter "user1" in the prompt (ofcoarse
user1 exists in the underlaying table), I will get
entries for user1, user2 and user3!!

Thanks for the help
 
Back
Top