Why isn't this working?

[srburk]

MED1: DateDiff("n",[MEDIN1],[MEDOUT1])
MED2: DateDiff("n",[MEDIN2],[MEDOUT2])
MED3: DateDiff("n",[MEDIN3],[MEDOUT3])
MED4: DateDiff("n",[MEDIN4],[MEDOUT4])
MED5: DateDiff("n",[MEDIN5],[MEDOUT5])

Each gives me the number of minutes a patient is seen by five separate doctors based on information entered into MEDIN1, MEDOUT1, MEDIN2, MEDOUT2, etc.

I then want to total the MED calculations to arrive at a total duration in minutes.

MEDT: Sum([MED1]+[MED2]+[MED3]+[MED4]+[MED5])

I get the error:
"You tried to execute a query that does not include the specified expression "ID" as part of an aggregate function.

How can I revise MEDT?

 

[Andrew Fergus]

Hi, I tried doing exactly what you did and got the identical error when using a select query. I got rid of the error by changing this line

MEDT: Sum([MED1]+[MED2]+[MED3]+[MED4]+[MED5])

to this :

MEDT: [MED1]+[MED2]+[MED3]+[MED4]+[MED5]

HTH, Andrew.

 

[srburk]

Hi, I tried doing exactly what you did and got the identical error when using a select query. I got rid of the error by changing this line

MEDT: Sum([MED1]+[MED2]+[MED3]+[MED4]+[MED5])

to this :

MEDT: [MED1]+[MED2]+[MED3]+[MED4]+[MED5]

HTH, Andrew.

YOU are awesome! Thank you! That worked.
Scott