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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

creating an expression to find largest vaule in access 1

Status
Not open for further replies.
noahaz

noahaz

Technical User
Aug 15, 2005
30
US
I need to create an expression that will allow me to pull largest value from field in a table. Can someone help me
The field name is site_program_year and the table is tblsss.
Thanks!
 
Sort by date Sort by votes
I did this and it is giving me the max number for all my sites. I have another field site_number I want to pull the highest program year for each site. They are both in the same table. Is this possible??
 
Upvote 0 Downvote
dmax("site_program_year","tblsss","site_number=" & xxxx)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

lgvalencia
  • Locked
  • Question
ACCESS VBA
Replies
0
Views
125
lgvalencia
lgvalencia
Loanpro
  • Locked
  • Question
Passing + sign to .csv file
Replies
0
Views
83
Loanpro
Loanpro
sa0309
  • Locked
  • Question
Passing an Oracle SP error message to Informatica Email Task
Replies
0
Views
94
sa0309
sa0309
newbie1314
  • Locked
  • Question
New to informatica, need help with expression transformations
Replies
0
Views
72
newbie1314
newbie1314
yimitz
  • Locked
  • Question
InstRev function in SQL for HIR
Replies
0
Views
91
yimitz
yimitz

Part and Inventory Search

Sponsor

Back
Top