I
ihatecomputers
Hi,
Can someone kindly post some example code for a SQL query?
I have a table named Foo, with text fields foo and bar, and a numeric
field named type. At the moment, Access will display all of the data
in my table in my three field form. I would like to be able to press a
button, and perform a SQL query on the table. Something like: "SELECT
* FROM Foo WHERE type = 2;"
I've written some VB code to cause a button to do this, and while it
apparently runs without error, it also runs without changing the record
data.
I've been searching the web to no avail, trying to find out how to get
this to work. It should be simple enough, right?
Thanks,
Mike
Can someone kindly post some example code for a SQL query?
I have a table named Foo, with text fields foo and bar, and a numeric
field named type. At the moment, Access will display all of the data
in my table in my three field form. I would like to be able to press a
button, and perform a SQL query on the table. Something like: "SELECT
* FROM Foo WHERE type = 2;"
I've written some VB code to cause a button to do this, and while it
apparently runs without error, it also runs without changing the record
data.
I've been searching the web to no avail, trying to find out how to get
this to work. It should be simple enough, right?
Thanks,
Mike