SQL

M

Missy

I'm currently running Access Database, I've succesfully created the tables
that I need. I've placed a form on my web page so that my customers will
insert all the data I need to fill their orders. My objective is once the
customer inserts the data they've entered they can preview their personnal
entry before finalizing their order. But, I'm having difficulty somewhere in
my SQL statement which permits the user to see only the entry that they have
made. Each time I set what I think is the correct SQL it allows for every
entry made prior including the last, or only the very first entry made.
Again, please help me to have the user insert and see only what they've
entered?

Thanks,
Missy
 
L

Larry Linson

Determine what fields define "this order for this customer" and use them as
criteria in a WHERE clause. If that is not sufficiently specific, please
clarify what information you have, how you are keeping it, and perhaps
someone can offer a more focused suggestion.

Larry Linson
Microsoft Access MVP
 
Top