Insert field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table called named tblTemp. One of the fields is named TransDate. What I'd like to do is take the date from a field on a form and insert it into the TransDate field in every record in tblTemp. Any suggestions

Ken
 
An "update" action query will solve your problem..
I have a table called named tblTemp. One of the fields is named
Click to expand...
TransDate. What I'd like to do is take the date from a field on a form and
insert it into the TransDate field in every record in tblTemp. Any
suggestions?
 
I have a table called named tblTemp. One of the fields is named TransDate. What I'd like to do is take the date from a field on a form and insert it into the TransDate field in every record in tblTemp. Any suggestions?

Ken
Click to expand...

An Update query will do this:

UPDATE tblTemp
SET TransDate = [Forms]![NameOfForm]![NameOfField];
 
Back
Top