DCount problems

[warnett]

I need some help debugging this DCount field which has been created within a
query:

Turkey count: DCount("Turkey 1 ID","Order","[Turkey 1 ID] <>
'0'")+DCount("Turkey 2 ID","Order","[Turkey 2 ID] <> '0'")+DCount("Turkey 3
ID","Order","[Turkey 3 ID] <> '0'")+DCount("Turkey 4 ID","Order","[Turkey 4
ID] <> '0'")+DCount("Turkey 5 ID","Order","[Turkey 5 ID] <> '0'")

Where turkey count is the new field made within the query.

Thanks

Jason

 

[Wayne Morgan]

There are a couple of syntax errors.

1) >DCount("Turkey 1 ID"<, This should be DCount("[Turkey 1 ID]" because
there are spaces in the field name.

2) >"[Turkey 1 ID] <> '0'"<, This would indicate that the [Turkey 1 ID]
field is a text field. If it is a number field, remove the single quotes
from around the 0.

Do this for all of the DCount uses in the equation.

 

[warnett]

k this has solved all my syntax errors. thanks.

still got problems though. this field always equals 3.

this is true for the total of turkeys of customer 1 and 2. but i was wanted
it for each customer. in this case the turkey count field for customer 1
should be 1 and the turkey count field for customer 2 should be 2.

any ideas? am i using the wrong function or sumthing?

Jason

 

[Wayne Morgan]

Right off-hand, I don't know. I would need to know more about your table and
field structure.

 

[Big Terry]

You cheating little scumbag! This sounds very similar to the A-level
coursework I am teaching my students. cheers.

Big Terry (founder of Terrys Turkeys Ltd)