Hi,
I'm using Access 2010 and am trying to write an update query, but am
struggling. The source table (Table 1) has many records ordered by job
number. The destination table (Table 2) has 1 record with a field
called Job_Number. Every day, I want to capture the highest job number
and store it in Table 2. Is this possible through an update query? I
seem to be struggling with the concept of using MAX(Table1.jobno) in an
update query. Any advice?
Thanks,
Troy Sherven
MCD, Inc.
[Non-text portions of this message have been removed]
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar