export access data to excel

[George Applegate]

I have a data base that looks like this in access:

emp# Date Time In or out

Obviously multiple records for each employee, on each date

I would like to somehow import the data into excel though, so it looks
like this:

emp# date In Tim 1 Out tim 1 In tim 2 Out tim 2 In tim3 Out tim 3

In other words, when the date comes into excel from access, how can I
get the multiple ins and outs for a day on the same line if it's the
same date??? Do I have to write some sort of visual basic program, or
is there an easy way to do this?

I'd appreciate all suggestions

thanks,
ga

George Applegate
(e-mail address removed)

 

[lmnorms1]

Just a couple of quick thoughts:
Is there some way to tell if the cell Time contains in or out? If
there is then you might need to right a couple of queries to get the
in times and out times to results tables. Then export the access
results to excel.

Otherwise you might have to write a quick program to evaluate the
cells contents for each ee.

 

[Jeanette Cunningham]

George,
we usually call this 'concatenating child records'.
The parent table is the Employee table, the child table is the date and
times table.
There is a sample database that shows a function and how to use it to do
this.
http://www.rogersaccesslibrary.com/...Generic Function To Concatenate Child Records'


Jeanette Cunningham