query sum?

[marianne]

I'm sorry. I got tired and fall asleep. I didn't get what you mean on reply number #13. can you tell me how?

[RuralGuy]

Use the Query builder to create a query that will sum all of the records prior to June. You push the Sigma button (funny E button) to switch the query to a Sum query.

[RuralGuy]

When you have the sum query working then post the SQL for the query so we can all see it. Then work on another query that will simply select all of the records in June.

[RuralGuy]

How soon do you have to have this ready? We can switch to an IM on this if time is too short.

[marianne]

Actually I need this now for my assignment to get finish. but I guess I'm running out of time. I will have to submit this tomorrow. I will skip class today for this. I have done making a query. I have attached an access file. can you see it if it is right?

[RuralGuy]

Take a look at and run qryUnionExport.

[marianne]

that is to perfect. actually have also thought of making more that one table. but I do not know what is the purpose of other type of queries like this union query. May I know what is the purpose of union query? and what is the difference between SELECT and SELECT DISTINCTROW?

[RuralGuy]

Queries do not take up any room as do tables. They are just strings of text that are executed. A union query can put two queries together (UNION) one after the other as long as they have similar fields. Union queries are not updateable.

[RuralGuy]

You will notice I had to put in the dummy field so the two queries would have an equal number of fields and they were similar.

[marianne]

yes....i see. thank you very much ruralguy. I will study the sample that you provided me. thanks again.

[RuralGuy]

You're very welcome. Have fun.