I have a tabular report that I am trying to get the grand total from a related table. This is a one-to-many relationship. There are multiple records in tblB_Summarythat match one record in tblProperty based on PropertyID.
tblB_Summary has a field called XBSRent that I need to get the total of all of the rents for the Property and display it in my tabular report
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
Hiperf
Thank you in advance.
I have a tabular report that I am trying to get the grand total from a related table. This is a one-to-many relationship. There are multiple records in tblB_Summary that match one record in tblProperty based on PropertyID.
tblB_Summary has a field called XBSRent that I need to get the total of all of the rents for the Property and display it in my tabular report
tblProperty
PropertID PropertyName TotalRent
1234 Williamson Towers $5000 <-SUM of XBSRent
tblB_Summary
XBSPropertyID Unit# XBSRent
1234 Unit 1 $1000
1234 Unit 2 $1000
1234 Unit 3 $1000
1234 Unit 4 $1000
1234 Unit 5 $1000
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.