Auto fill data to query results

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

accessuser - 03 Mar 2007 17:47 GMT

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.

Reply to this Message

Ken Snell (MVP) - 03 Mar 2007 18:34 GMT

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

Signature

Ken Snell
<MS ACCESS MVP>

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

Reply to this Message

accessuser - 04 Mar 2007 04:43 GMT

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.
[quoted text clipped - 4 lines]
>>
>> Thanks in advance.

Reply to this Message