By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,203 Members | 1,341 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,203 IT Pros & Developers. It's quick & easy.

What's the syntax for this SQL statement

P: n/a
I'm trying to write a SQL statement to find all rows in a query that have
the last name = (a last name entered into a text box in a form)

"Select * from query where lastname=" textboxname
Feb 24 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Sat, 24 Feb 2007 16:34:16 -0600, "Robbie Russell"
<ro**************@insightbb.comwrote:
>I'm trying to write a SQL statement to find all rows in a query that have
the last name = (a last name entered into a text box in a form)

"Select * from query where lastname=" textboxname
SELECT * FROM query WHERE LastName = " & Chr(34) & me.Textbox & Chr(34) & ";"
Wayne Gillespie
Gosford NSW Australia
Feb 24 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.