Insert Into Table Field

  • Thread starter Thread starter Traveler
  • Start date Start date
T

Traveler

Hi,

I have a table named GrandPrix with field named RaceTrack. When a condition
is met I want to insert a text string in RaceTrack field. How can I do that
using DoCmd.runSQL.
 
On Tue, 26 May 2009 21:05:01 -0700, Traveler

I'm not following. Does tblGrandPrix only have a single field?
Also, what kind of condition are you thinking of?

-Tom.
Microsoft Access MVP
 
Hi,

I have a table named GrandPrix with field named RaceTrack. When a condition
is met I want to insert a text string in RaceTrack field. How can I do that
using DoCmd.runSQL.
Click to expand...

With an Update Query (if you mean to update one or more existing records in
the table):

UPDATE GrandPrix SET Racetrack = "Saline Speedway" WHERE <some condition>

Create a new query based on the table and use the Query Type menu option to
select Update.
 
Back
Top