Link to home
Create AccountLog in
Avatar of CalebP
CalebPFlag for United States of America

asked on

Select Statement Pull Data from Field based on Last Posting Date

I have the following Select Statement and was wondering what syntax to use to make it only get the last applied forecast amount associated with the last posting date (1 per job).

For example:
Job No_ = 0100001-01
Applied Forecast = $-45439.00
Based on Posting Date 03/31/2009 (Previous Posting Dates were 12/31/2008, 1/31/2009, 2/28/2009.
SELECT     [Job No_], [Posting Date], [Applied Forecast]
FROM         dbo.[NAV Corporate - Setup$Job Applied Forecast]

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of arilani
arilani

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of CalebP

ASKER

That was amazingly fast.  Worked like a charm!  Thanks so much!!!
Avatar of arilani
arilani

I'm glad to helped you
Avatar of CalebP

ASKER

Worked great!