VBA query syntax error

[Guest]

Hi, I am getting the following syntax error when I try to execute the query,
SELECT MAX(Master_Suppliers.supplier_id) AS s_id FROM Master_Suppliers.

Syntax error . in query expression 'SELECT MAX(Master_Suppliers.supplier_id)
AS s_id FROM Master_Suppliers'.

Any idea why this error is displayed ?

 

[Jason Lepack]

Try this, but if it doesn't work then actually post the code that you
are using.

SELECT MAX(supplier_id) AS s_id FROM Master_Suppliers

 

[Guest]

The code snippet is as follows.
DLast("s_id", "Master_Suppliers", "SELECT MAX(supplier_id) AS s_id FROM
Master_Suppliers")
Even now I am getting the same error.

 

[Jason Lepack]

The code snippet is as follows.
DLast("s_id", "Master_Suppliers", "SELECT MAX(supplier_id) AS s_id FROM
Master_Suppliers")
Even now I am getting the same error.

Instead of all that just use:
DMax("supplier_id", "Master_Suppliers")

Cheers,
Jason Lepack