This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Last Record from a table of records

Posted on 04-01-2020 07:55 AM
ABBA
Silver 1
Silver 1
Reply posted on --/--/---- --:-- AM

I have a table-Tbl1 with Multiple Rows of data by [Date] for a Column Item
I would like to make a Report or Newtable-Tbl2 with the last know data for that Column Item

I am adding new records every day to this table

Thanks for your help

Solved Solved
0 24 5,084
Topic Labels
Jump to Solution
0 Likes
1 ACCEPTED SOLUTION

Posted on --/--/---- --:-- AM
ABBA
Silver 1
Silver 1
In response to Steve
Reply posted on --/--/---- --:-- AM

Thanks Steve.
I changed _ROWNUMBER to โ€œDateโ€โ€ฆThanks to @Marc_Dillon

SOLVED

([_THISROW] = MAXROW(โ€œWell Testsโ€, โ€œDateโ€, ([_THISROW].[Well Name] = [Well Name])))

View solution in original post

Jump to Solution
24 REPLIES 24
Top Labels in this Space