query results into table

[jerry28ph]

hi,

How can I save the results of my query into table? Please need your help, I'm stuck with this.

REgards,

 

[RainLover]

Jerry

What do you mean by "Results"

Please explain a little more.

 

[Preyzar]

You could use an append or update query.

 

[jerry28ph]

hi nedkelly,

I had a query getting the total no. of record being filtered by a certain criteria using =count(*) and I can see it after I ran. How can I save the value of my query into table.

Jerry

What do you mean by "Results"

Please explain a little more.

 

[RainLover]

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.

 

[jerry28ph]

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.

 

[RainLover]

Jerry

I am having difficulty understanding your process. Could you please post a copy of your database here and I will have a look.

Make sure you only post the relivant tables queries and forms so as not to confuse the issue and of course to make the file as small as possible. Also do a compact and repair and back up first.

 

[jerry28ph]

hi nedkelly,

I wish to attached a copy of db on this forum and i tried to compress the file but still not to fit in 748 KB. Would you mind to send you on your email address? If ok to you, please send me your email.

i also note on the FrmLog form. incase you dont understand, I can also post you private message.
Thank you so much for your kindness. I really appreciate it.

Regards,
Jerry

Jerry

I am having difficulty understanding your process. Could you please post a copy of your database here and I will have a look.

Make sure you only post the relivant tables queries and forms so as not to confuse the issue and of course to make the file as small as possible. Also do a compact and repair and back up first.

 

[Mike375]

I wish to attached a copy of db on this forum and i tried to compress the file but still not to fit in 748 KB. Would you mind to send you on your email address? If ok to you, please send me your email.

Did you Zip it.

1) Make a copy of your DB
2) Remove things that are not relevanto the problem
3) Leave just a couple of records, that is, delete most of whatever tables are required.
4) Compact and Repair
50 Send it to Zip and attach the Zip

 

[RainLover]

I said, >Make sure you only post the relivant tables queries and forms so as not to confuse the issue and of course to make the file as small as possible. Also do a compact and repair and back up first.<

What you have sent to me is totally confusing.

Read also what Mike375 said.

If you want help you must make things as easy as possible for me to understand.

None of the queries or forms that you mentioned here actually appear in your database that you emailed me.

You also need to read up on naming conventions. Search this site and also Google.

I hope the next DB that you send is much improved. If I cannot click on a query and get the eight records as you mentioned I will not continue.

Sorry if I sound tough but you must help.

 

[jerry28ph]

hi nedkelly,

i had 3 queries, the other 2 are related, 1 main form and 2 subforms and 4 tables the table that im using for main form is Smdr(backup1-6-2009). I cant delete those 3 coz they're linked to each other.
Thank you so much.

Regards,
Jerry

I said, >Make sure you only post the relivant tables queries and forms so as not to confuse the issue and of course to make the file as small as possible. Also do a compact and repair and back up first.<

What you have sent to me is totally confusing.

Read also what Mike375 said.

If you want help you must make things as easy as possible for me to understand.

None of the queries or forms that you mentioned here actually appear in your database that you emailed me.

You also need to read up on naming conventions. Search this site and also Google.

I hope the next DB that you send is much improved. If I cannot click on a query and get the eight records as you mentioned I will not continue.

Sorry if I sound tough but you must help.

 

[RainLover]

Jerry

Place a new Text Box on your Main form.

Place this =Count(*) in the Control Source of that Text Box

 

[jerry28ph]

hi, i did what you said =count(*) but the total is showing up though i didnt enter the criteria. did you opened my attachments? how do you find it? is it confusing?

Jerry

Place a new Text Box on your Main form.

Place this =Count(*) in the Control Source of that Text Box

 

[RainLover]

hi, i did what you said =count(*) but the total is showing up though i didnt enter the criteria.

Does this mean it worked or it didn't work?