Append query with criteria?

[Guest]

Good Day,

I have an Append Query that I have set up to update a tblinventory. how can
I set up the append query with critiera? So if tblinvoicedetails field
serialnumber matches tblinventory field serialnumber then update that
particular record with the update query information? How would I go about
doing this?

Thanks,

Brook

 

[John Vinson]

Good Day,

I have an Append Query that I have set up to update a tblinventory. how can
I set up the append query with critiera? So if tblinvoicedetails field
serialnumber matches tblinventory field serialnumber then update that
particular record with the update query information? How would I go about
doing this?

Thanks,

Brook

I'm not clear what you're asking, Brook. It sounds like you're mixing
an Append query (which appends new records where none existed before)
with an Update query (which updates existing records).

You can, of course, use criteria for an append query: just put them on
the Criteria line of the query grid. This will limit which records are
appended to the target table to those records which match. I'm not
sure that's what you need though, especially if you mean that you want
to update existing records; if you do, an Update query joining
tblinvoicedetails to tblinventory by SerialNumber would be the ticket.

John W. Vinson[MVP]

 

[Guest]

Good Day John,

I guess you are correct, I do need to perform an update query. what would
I need to do to set up my criteria?

If I want to update based on serialnumber, how would I do that? I have
tried many options but cannot get it to work.

thanks for your help!

Brook

 

[John Vinson]

Good Day John,

I guess you are correct, I do need to perform an update query. what would
I need to do to set up my criteria?

If I want to update based on serialnumber, how would I do that? I have
tried many options but cannot get it to work.

Brook...

Please remember: you can see your database. I cannot. My telepathy has
been on the blink for a while too... <g>

Please post the relevant portions of the table definitions
(fieldnames, datatypes, table relationships) and indicate just what it
is that you want to update, and what criteria you want to apply.

John W. Vinson[MVP]

 

[Guest]

Good Day John,

I appologize for that... I was able to get the updatequery working properly.

Thanks for your help!

Brook