count function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to create a query I think using the count function to count multiple
text fields for each record in the db. How do I build it? I have put Count
[field1] + [field2] + [field3]
and I get a syntex error.
 
I want to create a query I think using the count function to count multiple
text fields for each record in the db. How do I build it? I have put Count
[field1] + [field2] + [field3]
and I get a syntex error.
Click to expand...

The Count function doesn't count fields; it counts records. Could you
explain what you mean by "counting" text fields? If you have 100
records, what does it mean to "count" a field in those records? Are
you counting non-NULL values, counting the number of instances for
which each value appears, or what?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
I want to create a query I think using the count function to count
multiple text fields for each record in the db. How do I build it? I
have put Count [field1] + [field2] + [field3]
and I get a syntex error.
Click to expand...

From what I see you want to either count the total fields in a data set
or you want to add fields together. If you want to add Field1 + Field2 +
Field3, then you would want to enter: Sum(field1+field2+field3).

Counting fields the way you have displayed does not make logical sense,
unless you explained it incorrectly.

Count(Field1)

Hope this helps...

Timothy Anderson
Millennium III Mgt Consulting
www.M-III.org
 
Back
Top