processing Access data

I need to process records from 2 tables in an Access database, calculating counts of occurrences of various values in some of the fields in those tables and then output those counts to an Excel file.

I know how to connect the Access database and tables to data controls, but don't have any idea how to go through the tables accumulating the counts. Also, don't know how to output those counts to Excel.

Assuming I know zip about this, anyone able/willing to help me figure out how to do this?

TIA,

Don Goyette

I can probably give you a hand with this. If you can tell me what the pertinent fields from each table are (using the actual table and field names) I can probbaly work up some code for you. Re-post here and let's see what we're working with.

Thank you, Bruce.

Database name is Serenity.mdb.

One table is AdmitInfo and I need to count number of records with Child_Nbr = 0, Month_Income =0, 0<Month_Income<=500, 500<Month_Income<=1000, 1000<Month_Income, Emp_Stat=.true.

Other table is ExitInfo and I need counts of Emp_Exit=.true. and Res_exit>0.

Both are for records within a user-specified date range on Admit_Date and Exit_Date.

I really do appreciate your help on this.

Don

....early binding of data. This is bad design....slap your own palm with a ruler. Do not data bind controls.


Hmmm got over that, does the client machine have excel on it, if so have a look at the excel object. Need more explanation happy to help...running out of time....will knock something together if you want to demonstrate non-early binding of data, as well as export to excel. Just email me at [email protected], and will provide full working code of your requirement.

Bruce

Tell em not to bind his data with data controls.