Auto fill data to query results

[accessuser via AccessMonster.com]

I'm trying to create a Reconciliation database. My database has a field
called status. 2 queries, 1st called Matched Query, 2nd UnMatched. User
will import two different files. One from the bank, and other accounting
software. I want the Match query to return and auto fill the status field to
"Matched" or "UnMatched". Currently, status field is blank. I tried to do
the update query, but it doesn't update anything, still blank and it removes
all my other fields leaves me with only Status field. Any suggestions? Is
there modules?

Thanks in advance.

 

[Ken Snell \(MVP\)]

Very difficult to troubleshoot without seeing the actual queries that you're
trying to run. Post the SQL statements of both queries.

 

[accessuser via AccessMonster.com]

Thanks for the reply. i know what i did wrong, i didn't "Run" the update
query, i did the datasheetview. Thats why nothing was updated. Thanks.

Very difficult to troubleshoot without seeing the actual queries that you're
trying to run. Post the SQL statements of both queries.

I'm trying to create a Reconciliation database. My database has a field
called status. 2 queries, 1st called Matched Query, 2nd UnMatched. User

[quoted text clipped - 10 lines]

Thanks in advance.