Parameter Query ABC

[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

 

[Ashby]

The parameter you have should work find, just lose the
less than symbol (<).