DMAX Criteria is the Field name

[dhen21dx]

I create a access query where i need to check for max number from table but using the field from another table, but however Table1 cannot be read.
NewID:DMAX("[NumberID]","Table2]","[Country] = [Table1]![Country]??")+1

Table 1		Table 2
Country		Country
Product		NumberID
SampleLot

 

[Joe4]

Please post a small sample of the data from each table, and show us exactly what you are trying to return.

 

[welshgasman]

I would expect you would need to concatenate the field value anyway?

 

[dhen21dx]

Hi All, i got the solution now, i enclose it to '" and & to refer to other parameters.

NewID:DMAX("[NumberID]","Table2]","[Country] ='" & [Table1]![Country] &"'")+1