Access2002: How do you build a calculation in a Text Box?

[Wozza]

Little more complicated that the subject!
I need to be able to COUNT the number of records in a table (or query) with 2 bits of criteria

I am fine with formulas in Excel, but the workbook I have created is rather large and could easily become too cumbersome.

Here's an example of the formula I have in Excel;

=SUM((BU_Data_Wk!$P$1:$P$20000=B$1)*(BU_Data_Wk!$K$1:$K$20000=$A5))

Where Cell [/color]=B$1 is an originating group and Cell $A5 is an Item that the originating group may have raised a ticket against.

Has anyone built an expression within a Database Form's control that would achieve a similar outcome?
If not, which expression(s) do you think I would need to consider?

Thanks in advance!

Warren Bennet
Wannabe Programmer.
Check out my other vocation;

http://www.aloe2happiness.co.uk

 

[JeremyNYC]

Warren,

You'll be able to do what you want in the database, but not like this. Access is a very different beast. You'll use forms to look at the data, not the tables, and the formulas will go on the forms, or in code behind them. Your data will most likely have to be broken out into more than one table. And you will be able to use queries to put your data back together, on the fly.

My suggestion is to get a good book on Access, search here for recommendations of starter books. Do some reading and then try putting your database together. You'll be amazed at how many more tools you have at your fingertips.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Access Databases for Non-Profit Organizations

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.

 

[Wozza]

Thanks Jeremy.
So essentially, get the queries to perform the calculations, get the Wizard to help me quickly compile a Form and modify from there on.
Fairy Nuff - I can do that, no probs.
Just wondered if there was a way....

Cheers for the clarification.

Warren Bennet
Wannabe Programmer.
Check out my other vocation;

http://www.aloe2happiness.co.uk