You typically can't create an updateable query that contains an aggregate like Max(). You could use DMax() like:
UPDATE [Table 2] SET Job_Number = DMax("Job_Number","[Table 1]");
Duane Hookom MVP
MS Access
----------------------------------------
> From: tsherven@mcd.net
> 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.
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar