dmax #error syntax

[cpampas]

hello,
I would like to retrieve a value with the DMax function , from a form, a cant figure out the right syntax

=DMáx("[plaganha]";" tblPlacardTodosAvg ";"[bookieID]=" & [Forms]![frmApostas]![bookerID] & " AND [jogopla]= """ & [jogo] & """")

the field [bookieID] is an integer
the field jogopla is a string

Any thoughts about this ?

 

[bob fitz]

assuming this is being called from the form frmApostas

=DMáx("[plaganha]";" tblPlacardTodosAvg ";"[bookieID]=" & Me.[bookerID] & " AND [jogopla]= '" & [jogo] & "'")

 

[Dreamweaver]

Not Sure if it matter but you have a space before and after tblPlacardTodosAvg I.E. " tblPlacardTodosAvg "

 

[bob fitz]

Not Sure if it matter but you have a space before and after tblPlacardTodosAvg I.E. " tblPlacardTodosAvg "

Good spot. Well done Mick.

 

[arnelgp]

also the Dmax word, correct or no?

 

[Dreamweaver]

Think you might be right @arnelgp compiling should have picked that up if uing Option Explicit

 

[cpampas]

the DMáx is correct, wich is automaticaly corrected by Access according to the portuguese version of Ms Access I am working with
the issue was realy what Mickjav mentioned, wich were the spaces before and after tblPlacardTodosAvg I.E. " tblPlacardTodosAvg "
that is what happens when I choose copy/paste the name of a table instead of typing it. I am sure I would spend the whole day looking at this and not be able to see it

thanks a lot for your kind help