Need Querry expression help

[wannabepro]

[combo]![Processes] Sum Processes ="Deal" count "Deal"= [totals]![Total New Prospect]

k this is my dumb try. What I am trying to do is counting how many times word Deal has come in the Process column which is in combo table and sending it to totals table where it will be added to total new prospects.

I know this is dumb, but plz help me out

thanx

 

[neileg]

Not making any sense to me. The expressions you are using might be valid in a form, but I can't see what they would do in a query. Also, what is a combo table? Combo usually referes to a particular type of form object, a combo box.

You need to give us more info if you want proper help!

 

[wannabepro]

Not making any sense to me. The expressions you are using might be valid in a form, but I can't see what they would do in a query. Also, what is a combo table? Combo usually referes to a particular type of form object, a combo box.

You need to give us more info if you want proper help!

combo table is one table which is being used by several forms. and processes its own table and so does total. but these are all being input in combo using diff forms. Now for the question you asked me here is an example.
process are used as status level, like new, closed, active, now these processes are in drop down menu, the option in menu are described above, each time user selects one of these option it should add up individually and automatically move this count to form called total. This is the one I was asking for in above post.


my other problem is I just need to lock the whole record after one time entry except for one drop down menu, which will be changed based on its status level by user on different dates. Do I need a query for this?


Thanx for the reply

 

[The_Doc_Man]

It is hard to understand your question, perhaps because English is not your native language. That won't stop us, but it might slow us down.

First, I think I understand enough of your question to see that you are perhaps counting something into a table, which you should NEVER do. If it can be determined through use of SQL aggregate functions, you never store a count or total. Instead, you use a query as the basis of whatever needs the total or count. This is because a query does at least everything a table can do, plus include formulas. I.e. MORE powerful than a table.

Second, of course it is your database so you get to choose names, but it is a bit awkward to use names that have another meaning in the context of Access. For instance, NEVER name a field Date or Long or Integer (or any of the other keywords.) And for avoidance of confusion, never use a name that could be misleading - like Combo for a table, because there is a type of control called a Combo Box.

The combination of using confusing words by someone for whom English is not a primary language can be a formidable barrier to communication. Therefore, please forgive us if we have some difficulty with your question.