Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pass max of quey value into variable

Status
Not open for further replies.
Frank72

Frank72

Technical User
Nov 13, 2001
57
IE
Hows it going

I'm trying to pass the result of a max of query into a variable i have tried using.. variable = [queryName]![MaxOfFieldName]
but this isnt working
any ideas?
much appreciated

frank
 
Sort by date Sort by votes
Try using the DMax function...

variable = DMax("[FieldName]", "[QueryName]")
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Bubba002
  • Locked
  • Question
Pass a subform fieldname-ID as a string variable in CF expression
2 3
Replies
50
Views
2K
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Spurious Change of Fonts
Replies
3
Views
312
dhookom
dhookom
caykamanj1966
  • Locked
  • Question
Hyperlink Text of a field
Replies
1
Views
189
caykamanj1966
caykamanj1966
PLCBeetle
  • Locked
  • Question
Passing a form value to query...
Replies
6
Views
211
Andrzejek
Andrzejek
iamchemist
  • Locked
  • Question
Getting Into Break Mode?
Replies
7
Views
443
iamchemist
iamchemist

Part and Inventory Search

Sponsor

Back
Top