Problems getting records from 2 tables based on date

[CurtR]

I am trying to get records from 2 tables that are linked by the date field.

Table one Table two
DateField WeightField DateField WeightField

09/01/2000 15000 09/01/2000 16500
09/01/2000 15600
09/02/2000 18000 09/02/2000 17500
09/02/2000 18000
09/02/2000 17800

I need to get the total weight for each date

so the report would give me: 09/01/2000 47100
09/02/2000 71300
I do not know why I am having such trouble with this. Just having one of those days
Thanks [sig][/sig]

 

[kenhamady]

I don't think you want to link these tables together, I think you need a union query of these two tables, which appends one to the other. This can be done in Crystal by editing the SQL Query in Crystal. It was discussed a week or so ago. See the posting called:

Creating a 'UNION' between a Credit and Debit table

[sig]<p>Ken Hamady-

http://www.kenhamady.com<br><a

href=

http://www.kenhamady.com/>Crystal

Reports Training by Ken Hamady</a><br>[/sig]