Solved

how can i count a column in a list box in access 2010

Posted on 2011-02-23
5
363 Views
Last Modified: 2012-05-11
i want to count a list box via a text box control source i tried this code:
=Count([ListRecurringPayments].[column](6))
but it's not working and it's return a error
0
Comment
Question by:bill201
  • 2
  • 2
5 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 250 total points
ID: 34967518
This will give you the list count of the List box:

=[ListRecurringPayments].[ListCount]

I don't think you can directly get the count of a specific column ... say a True/False column ... and count the number of True's.

mx
0
 
LVL 3

Expert Comment

by:DockieBoy
ID: 34968696
What are you trying to do here?  Count the number of items?  Get a total?  Count instances?
0
 

Author Comment

by:bill201
ID: 34969099
ok it's not a problem i will make a dcount
0
 

Author Comment

by:bill201
ID: 34969109
DockieBoy
i want to get a total
0
 
LVL 3

Assisted Solution

by:DockieBoy
DockieBoy earned 250 total points
ID: 34972685
You could try this.
Dim MyTotal as Currency ' if you are totaling currency values'
For i =  0 to Me.ListRecurringPayments.ListCount - 1
 MyTotal = MyTotal + Me.ListRecurringPayments.Column(6, i)
Next i
 Me.MyTextBox = MyTotal

Put the code behind the on change event for the list box so that it will update your total if the list changes.
 
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question