Dmax

A

Art Vandaley

Can somebody please give me an idea about following?

Y = DMax("[field1]", "table1")

What can it be the syntax if "table1" is in an external database? Regards.
 
D

Douglas J. Steele

Simplest would be to create a linked table (through File | Get External Data
| Link Tables) and go from there.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Dmax at an external table 5
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Access Command button to look up and copy data from a query to a table 0
Query 1
Replace text with related number 1
validation rule (for a record in a table) with dlookup 7
add variable table name to query results 4
Exclude query advise 4

Top