Possible DCount?

[Sgt Bilkp]

Hi again. Just dragged out an old DB that ended up on the bottom of the pile.

I need to do a simple count up in a different form of values in "frmFaults", but only for records with a start date within the last 12 months.

Eg in "frmFaults"

Date_down = 1/2/06 Days_Lost 12
Date_down = 20/8/07 Days_Lost 5
Date_down = 1/2/08 Days_Lost 22

I need the count up to only add 20/8 and 1/2 = 27

Anyone?

 

[WayneRyan]

Sarge,

Paste something like this in the query grid:

Select Sum(Days_Lost)
From   YourTable
Where  DateDiff("d", Date(), Date_Down) < 365

It should get you started,
Wayne

 

[Sgt Bilkp]

Sarge,

Paste something like this in the query grid:

Select Sum(Days_Lost)
From   YourTable
Where  DateDiff("d", Date(), Date_Down) < 365

It should get you started,
Wayne

I only want the value to appear in a text box. How do i get to the query builder from a text box?

 

[WayneRyan]

Sarge,

Me.txtBox = Dsum([Days_Lost], "YourTable", "DateDiff("d", Date(), Date_Down) < 365")

Wayne

 

[Sgt Bilkp]

Sarge,

Me.txtBox = Dsum([Days_Lost], "YourTable", "DateDiff("d", Date(), Date_Down) < 365")

Wayne

Spot on. Cheers Wayne (apologies for being so dense).