Get data from a query that is not attached to a form

[Diana]

Hello,

I have a form with a button appending data from Excel to
Access. I have set primary keys in the Access table in a
way that no dublicate values can be appended from Excel.
The warnings are turned off.

What I would like to do is check the count of lines in
the main table before and after the export. My guess is
that I need to use recordset but I don't know all the
steps.

Thank you for all your help.
Diana

 

[Kelvin]

How are you going to show the before and after? Once you perfrom the append
the old record count will not be kept. You can create a simple count query
to create a table with the before count, then an append query to add the
after count. You can then call up the info anytime you need. Otherwise you
would have to save the information in a global variable before the query is
run, but then this will only last until you close the database.

Kelvin Lu

 

[Diana]

I need to create a global variable then. How do I do this?