calculated field to VBA

[SmallTime]

Hi All,

Anyone know how I could write the following in VBA, perhaps using something like DCount. (can DCount have more then one veriable?)

=Sum(IIf([TDIsTarget]=True And IsNull([TDCompleted]),1,0))

The Table name I want to extarct the data from is tdAppointments and the date field names are as above [TDIsTarget] and [TDCompleted]

Many thanks
SamllTime

 

[hbrems]

I'm guessing this:

dim count as integer

count = DCount("tdAppointmentID", "tdAppointments", "TDIsTarget = true AND TDCompleted IS NULL")

 

[SmallTime]

Many many thanks

I'll give it a go in a while

 

[SmallTime]

MsgBox "Brilliant",vbOK,"Many Thanks"