I am creating a application that collects numbers from a labratory experemnt, and sends them to Excel (using OLE/VBA automation) to print up a nice graph (and I _realy_ want to do this in excel: it took me a couple of days to format the graph correctly (the X axis is non-linear))

I also want to send over some info from the customer table (the adderess, ATTN:, etc) as well as data from a specification table (which is to be used to draw spec bands on the graph.)

How do I select the specific records and access there fields in the code of the button that executes the data transpher to Excel?). There should be only one record in both the customer or spec tables that have the same file # or spec-type name respectivly.