One more Dcount Question
On Thu, 11 Dec 2008 04:07:01 -0800, Tom wrote:
One more Think Ken
First of all I get so confused in access as to when I use quotations and
when to use exclamation points and in general how to refer to fields that are
not in the form or table that I am using at the moment. Do you know a good
reference that could explain these for me so I can get a handle on them?
second of all in the same table I would like a dcount of all vendors where I
spent more than 20 but less than 200.00 I tried this
=dcount('[Vendor]","Expenses","([Cost]'20' AND [Cost]'200')) and it keeps
giving me an error. It is very frustrating and I hate to bother you with this
but I just need some guidence. Thanks again
Lose the single quotes around the Cost criteria.
Text field criteria must be delimited with either ' or " quotemarks.
Date field criteria must be delimited with #.
Number or Currency field criteria get no delimiters at all.
--
John W. Vinson [MVP]
|