Newbie:Can't append value into field

[AndyB]

I am trying to create a query that once it is satisfied will send a value
I select into a field.
ie.,

SELECT 3 AS platoon, [Crime Table].Time1
FROM [Crime Table]
WHERE ((([Crime Table].Time1)>=#12/30/1899 15:35:0# And ([Crime
Table].Time1)<#12/30/1899 23:35:0#));

essentially I am not doing this in SQL but in the design view of the query.
I am trying to get an update query to place the number 3 in all occurances
of above.

Andy B

 

[Van T. Dinh]

What you posted is a SELECT Query / SQL String which only select Fields of
Records to be displayed or to create Recordset in memory.

Check Access Help on Update Query or Append Query since I am not sure
whether you want to Update the Field values of existing Records or adding
new Records.