Update query, cant get it to work

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
 
J

John Vinson

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

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.
 
K

Kerman

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top