Access 2000 Problem, Can anyone help?

[afcb1_743]

Access 2000

How do I copy the results of a query to a new table that serves as an archive?
How can I then clear or reset the original query?

I am doing a project that records the names of students who have had more than 5 merits in school. I want to use this data to generate a certificate to give out at assembly and to send a letter home.
I have run a count query but want to send the results to another table which acts as an archive. I want to have the original query reset.
Can anybody give me any suggestions?

Very much appreciated.

 

[RuralGuy]

What do you mean by "reset the original query"?

 

[afcb1_743]

query reset

I mean for the query to return to its original state after finding the records, allowing me to produce a report and afterwards archive the data found. However i want the totals which have been found to then return to zero after being produced on a report and then archived.
I want my system to find all children with 5 merits and once this has been done i would like to be able to print the selected details on a report, then the totals for the merits resets minusing the 5 merit slips.
Sory if confusing, i am a bit of a novice in access.

 

[RuralGuy]

A query does not have an original state. It simply gives you a current view of an existing table. To change the output of the query you would need to either modify the parameters of the query or change the table.

 

[ghudson]

How do I copy the results of a query to a new table that serves as an archive?

Use a make table query.

 

[afcb1_743]

Still stuck!

If anyone could help me by showing or telling me what i have to do it would be very much appretiated as i have no idea whatsoever about what needs to be done

 

[adrian.stock22]

Hi, I don't know how to do what you want to do AUTOMATICALLY, but manually the idea is as follows. So I just want to explain what an earlier correspondent meant when he said you have to change the table (and you can NOT 're-set' the query).

The query always shows the same record for a given state of the table. Example from our work: We have to phone a number of people once every month. So we have a column called 'BatchDate' in our table; e.g. 2006_03 in that column means 'must be phoned in March 2006'.

Now we set up a query which shows all records which have 2006_03 in that column.

Sometimes we have to try many times before we get through or get the information we want. So if we have to try again, we leave the batch date unchanged. The moment we consider that record DONE FOR THIS MONTH, we change the batch date in the table (or in our Form) to 2006_04

Now it will no longer show in our query for March.

When all calls for March have been made, the query will be empty. (Like your 're-set').

Come April, we change the batch date in the query to 2006_04

So the list will come up again. If there is somebody who should NEVER be phoned again, we remove the batch date from the table (or Form), or we type 'never' into the batch date field.

So in your case, you might want a field in the table which tells you that you have to send letters of award, etc etc. Call the field Action (or whatnot). So if a student merits that Action, put "do" or "merit" in that field. Once the Action has been done, put 'done' in that field. So the results of your query will change.

Play with that idea, and refine it to suit your purposes.

Hope that helps a little at least.

Best wishes,

Adrian (fellow beginner)

 

[afcb1_743]

Thank you

Thanks for the help mate, very much appretiated.