AnsweredAssumed Answered

counting related records

Question asked by grantenquire on Mar 28, 2018

I have four tables –

 

Shopping trips

Shopping Trip ID|Date

1 | 12/1/10

2 | 19/1/10

3 | 25/2/10

 

Trolley

Shopping Trip ID|Foods ID

1 | 2

1 | 1

2 | 3

2 | 2

3 | 2

3 | 1

 

Foods

Foods ID | Food

1 | Apples

2 | Pears

3 | Bananas

 

Food characteristics

Foods ID | Characteristic

1 | Core

1 | Pips

1 | Crunchy

2 | Core

2 | Soft

3 | Seeds

 

All tables are linked on ID.

 

I want users to be able put in a date range and be able to get a report that says within a user-specified date range, how many foods have been purchased that have a core in it?  Is there a calculation field that can count related records within a found set of records?

 

Thanks

G

Outcomes