Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Using SQL to change table values
I tried that but it dooesn't seem to work. It keeps throwing up the error that the docmd.RunSQL statement needs to have an SQL statement to work properly. I have figured out how to do this another way now within access itself so I think I am okay for the moment but it would still be interesting...- Quaterno
- Post #7
- Forum: Microsoft: Access Queries and JET SQL
-
Using SQL to change table values
I am unsure about how to make this work. Every time I try even simple bits of SQL statements it seems to come up with the error "characters found after end of SQL statement". The first SELECT statement needs a semi-colon at the end, correct? I really just don't know the syntax for SQL. If I try...- Quaterno
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
Using SQL to change table values
I am trying to create a database for my dad's business and I need a button on a form that creates a query from a table of customers with just one record in (the customer that is currently selected on the form). It then needs to check the value of a field called numberofcalls and change the value...- Quaterno
- Thread
- Replies: 7
- Forum: Microsoft: Access Queries and JET SQL
