Update query, cant get it to work

  • Thread starter Thread starter Kerman
  • Start date Start date
K

Kerman

I posted earlier about an update query, but I cant seem to get it to work
the way I want. I have a field[DateIssued] and a field [CertNumber]
I could have up to 200 records before i know what the date issued will be.
I know how to run a query to gather all the records with [CertNumber]. I
use: Like[CertNumber] and enter the appropriate Cert Number. Now I need to
updat all the [DateIssued] fields with the appropriate date. I was hoping
the same way I get the [CertNumber]. Such as: Like[DateIssued] and then
enter the date. But this doesn't wrok...Any Ideas...RANDY
 
I posted earlier about an update query, but I cant seem to get it to work
the way I want. I have a field[DateIssued] and a field [CertNumber]
I could have up to 200 records before i know what the date issued will be.
I know how to run a query to gather all the records with [CertNumber]. I
use: Like[CertNumber] and enter the appropriate Cert Number. Now I need to
updat all the [DateIssued] fields with the appropriate date. I was hoping
the same way I get the [CertNumber]. Such as: Like[DateIssued] and then
enter the date. But this doesn't wrok...Any Ideas...RANDY
Click to expand...

Create a new Query based on your table.

On the Criteria line under [CertNumber] type

[Enter CertNumber to update:]

Don't use LIKE - you don't need the LIKE operator unless you will be
using wildcards; if you just want to type a number and find that
record, you won't be doing so.

Change the query to an Update query and type on the Update To line
under [DateIssued]

[Enter Date Issued, mm/dd/yyyy:]

If this isn't working, please open the query in SQL view and post the
SQL text to a message here.
 
Thank you very much, that works great...Randy
John Vinson said:
I posted earlier about an update query, but I cant seem to get it to work
the way I want. I have a field[DateIssued] and a field [CertNumber]
I could have up to 200 records before i know what the date issued will be.
I know how to run a query to gather all the records with [CertNumber]. I
use: Like[CertNumber] and enter the appropriate Cert Number. Now I need to
updat all the [DateIssued] fields with the appropriate date. I was hoping
the same way I get the [CertNumber]. Such as: Like[DateIssued] and then
enter the date. But this doesn't wrok...Any Ideas...RANDY
Click to expand...

Create a new Query based on your table.

On the Criteria line under [CertNumber] type

[Enter CertNumber to update:]

Don't use LIKE - you don't need the LIKE operator unless you will be
using wildcards; if you just want to type a number and find that
record, you won't be doing so.

Change the query to an Update query and type on the Update To line
under [DateIssued]

[Enter Date Issued, mm/dd/yyyy:]

If this isn't working, please open the query in SQL view and post the
SQL text to a message here.
Click to expand...
 
Back
Top