By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,841 Members | 1,675 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,841 IT Pros & Developers. It's quick & easy.

Update Query - Finding and Updating Maximum Order Number

P: n/a
I am trying to pass the maximum order number from a table
of orders into one record only in another table. I created
an update query and created the following:

Field: next_fpo_no
Table: OrdersTable
Update To: Max([ord_no])

It tells me, "You tried to execute a query that does not
include the specified experssion 'next_fpo_no" as part of
the aggregate function." I understand what is telling me
yet I don't know how to get around the problem.

Any help would be appreciated.

Gregg Horwitz
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.