ok i understand what you said.
maybe you help me to resolve my last question.
i have a main form and 2 subforms, the criteria of my subforms (value from my queries) can be supplied from my main form.
criteria:
1. Party1Name
2. Dialled_number
3. Direction
to get the total calls of the project coordinator, the criteria must be true, or exactly the same as what recorded on the table.
SQL: Total_Direct [filename of this query]
SELECT [Smdr(backup1-6-2009)].Party1Name, [Smdr(backup1-6-2009)].Dialled_number, [Smdr(backup1-6-2009)].Direction, [Smdr(backup1-6-2009)].[Call duration]
FROM [Smdr(backup1-6-2009)]
WHERE ((([Smdr(backup1-6-2009)].Party1Name)=[forms]![FrmLog]![combo17]) AND (([Smdr(backup1-6-2009)].Dialled_number)=[forms]![FrmLog]![text135]) AND (([Smdr(backup1-6-2009)].Direction)=[forms]![FrmLog]![text30]) AND (([Smdr(backup1-6-2009)].[Call duration])<>#12/30/1899#));
this query gives me 8 records.
to get the total number of records, I created another query to get the count of all records from the given criteria. I used the filename [Total_Direct] to get the 8 total counts and I got it. Then I save it as Total_Direct_Sub.
Now, I created a form named Frm_Direct_Sub to see the value of my Total_Direct_Sub and I did.
Lastly, when I added a subform to my main form using Total_Direct_Sub and when I enter all the criteria, there's no value shows on the subform. Though I followed every properties.
Please if you an idea on how to resolve this, im asking your kindness and patience to newbie in access.
I know it's too long, but this is the whole situation. Hope you understand it.
Thanks a lot for being such a nice person.
Regards,
Jerry
Ex: (name="Adriana Recalde") AND (
Jerry
You don't do that. The count could change from time to time so whenever you need that value recalculate it in the same way as you did with the query you mentioned.
Good database design says that you do not store calculated values. In rare cases there is good reason to do so but I don't think your situation is one of them.
If I can help further let me know.