Getting Value from a query onto form

[Ethereal]

in my table i have id column and idsequence column, the id column can have multiples, while the idsequence can't have multiples withing the same ID multiple IE, 5-1,5-2,5-3,6-1,6-2,7-1 etc
anyways i have created a query that gets the max idsequence value for a certain ID so that i can append with the ID and IDseqmax + 1, But how do i access that ONE field from the ONE record in my query ?

 

[FoFa]

DMAX("idsequence","table/queryname","ID = 6")
would return the max idsequence where the ID value is 6 given that the idsequence is a numeric datatype, not a string datatype.
Of course you would ahve to replace the 6 in the statement with what ever value you are looking for.

 

[Ethereal]

I thank you FoFa.... That is a HELL of a lot less work than what i was trying to do!