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
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