how to put dmax and dateadd together in one column in query (1 Viewer)

[sspreyer]

hi,

all

I just wondered is it possible to add my dateadd calculation to my findlast calculation using dmax in one column in my query

here's what I hoping to put in one column as at the moment it takes 2

findlast: DMax("[ServiceDate]","[PlantServiceTbl]","([ImpPlantItemID]= " & [PlantItemID] & ")")

this is what I want to add without a separate column

DateAdd("m",[Months],[findlast])

hope this is possible thanks in advance


any help much appreciated


shane

 

[plog]

Its simple algebraic replacement:

x + y = 7
2y + 3 = x

How do you solve for y? You take what x is equal to in 1 equation and replace it in the other:

(2y + 3) + y = 7

 

[sspreyer]

Its simple algebraic replacement:

x + y = 7
2y + 3 = x

How do you solve for y? You take what x is equal to in 1 equation and replace it in the other:

(2y + 3) + y = 7

thank plog penny has dropped finally bit of dumb moment
for everyone else it is

find next DateAdd("m",[Months],DMax("[ServiceDate]","[PlantServiceTbl]","([ImpPlantItemID]= " & [PlantItemID] & ")"))

cheers again plog

shane