update query problem

  • Thread starter SJJ via AccessMonster.com
  • Start date
S

SJJ via AccessMonster.com

i have a table called tblBookings, i have 50 records, field ID is the primary
key

i have a field called Date. i used a query to pick up some dates which wanted
to update to this table on the Date field. how can i update to certain fields.


for example i need to update these dates to the records which are like "*GH*"
(this is from the Primary key fied) on them. not for all the 50 records. how
can i do that please.

any ideas

thanks in advance
 
W

Wolfgang Kais

Hello SJJ.

SJJ said:
i have a table called tblBookings, i have 50 records, field ID is the
primary key

i have a field called Date. i used a query to pick up some dates which
wanted to update to this table on the Date field. how can i update to
certain fields.

for example i need to update these dates to the records which are
like "*GH*" (this is from the Primary key fied) on them.
not for all the 50 records. how can i do that please.
Click to expand...

Create a query that is based on your table.
Add the ID and Date fields to the query.
In the criteria row for the ID field, enter this: Like "*GH*"
In the query menu, select the query type "Update query"
For the Date field, in the update row, enter the desired expression (the
value that is written to the field).
Save the query.
 
Top