Forum Discussion

StevenPearson's avatar
Qrew Assistant Captain
3 years ago

Two summary fields to one table

I have three tables:
Scanned Assets

In the trucks table, I have a summary field - Distinct Count - Scan Dates in the last 30 days
The summary field works fine and the number is correct.
I have the same field in the Equipment table, set up exactly as the trucks, the field doesn't work. Everything is zero.
The scanned assets table shows a date and the info for the truck/equipment every time they are scanned. (Imported from a csv)
Report links for both tables show all scans in 30 days but I need a distinct count for each table since they are tracked separately. 
Why would one work and the other not? Both use truck/equipment number as primary key, tables are nearly identical. 
Thank you

Steven Pearson

1 Reply

  • Can you explain your table to table relationships. Which are parents and which are children?

    Mike Tamoush