P
Pontificateur
Hi.
I'm trying to get data from three Foxpro tables, Employees, Earnings, and
Absences. I need to sum the Earnings records for each Employee record
(between two dates), and count the Absence records for each Employee record
(between the same two dates). I need all active Employees whether they had
earnings or absences or nothing. The resulting spreadsheet should look
something like:
Employee# Name Earnings Abs
123-45-6789 Joe $50,249 1
234-56-7890 Jane $75,456 3
345-67-8901 Jack
456-78-9012 Jill 2
567-89-0123 Jeb $10,000
In all my attempts, it doesn't appear that MS Query is capable of handling
the level of subqueries, sums and counts needed to perform this relatively
straightforward data retrieval. I'm trying to use the Data menu, Import
External Data, select the Foxpro ODBC, then edit the resulting SQL manually.
I posted some code earlier to get input, but no one has tackled that yet.
Help! I've run out of things to try!
Thanks!
I'm trying to get data from three Foxpro tables, Employees, Earnings, and
Absences. I need to sum the Earnings records for each Employee record
(between two dates), and count the Absence records for each Employee record
(between the same two dates). I need all active Employees whether they had
earnings or absences or nothing. The resulting spreadsheet should look
something like:
Employee# Name Earnings Abs
123-45-6789 Joe $50,249 1
234-56-7890 Jane $75,456 3
345-67-8901 Jack
456-78-9012 Jill 2
567-89-0123 Jeb $10,000
In all my attempts, it doesn't appear that MS Query is capable of handling
the level of subqueries, sums and counts needed to perform this relatively
straightforward data retrieval. I'm trying to use the Data menu, Import
External Data, select the Foxpro ODBC, then edit the resulting SQL manually.
I posted some code earlier to get input, but no one has tackled that yet.
Help! I've run out of things to try!
Thanks!