Jump to content

Counting Related Records


Troy E Hyde
 Share

This topic is 5700 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I am designing and devolping a solution... and need some help.

I will have a table with multiple records and would like to count the related records.

example:

(records)

#101, 36"x84" Wood

#102, 36"x84" Wood

#103, 36"x84" Wood

#104, 72"x84" Wood

#105, 72"x84" Wood

#106, 80"x84" Wood

would return a summary as follows

3 ea 36" x 84" Wood

2 ea 72" x 84" Wood

1 ea 80" x 84" Wood

There are endless possibilities of differences.

any thoughts?

Link to comment
Share on other sites

Question isn't specific enough...

Are you planning on basing your whole solution on this one table, or are these subgrouped in some way, and if so do you only want to display these summaries for each subgrouping. Further is this to be displayed on a standard layout or in a report?

Link to comment
Share on other sites

I was posting to Nick's question. In your case, if your data is in the format that your first post stated, then I would first create another field that is just a stored calculation of Substitute (mesaurementfield; """; ""). This will get rid of the quote mark. Then create a selfjoin relationship keyed on that new field.

Then you can create a subsummary report grouped on that new field. You can use your original field with the quote in it for display purposes, and a calc using count() or a summary field to display how many there is of each.

Link to comment
Share on other sites

Nothing, at all. But just in case somebody misses a quote mark when entering the data, I just thought it was a better choice as a match field to get rid of it instead.

Link to comment
Share on other sites

This topic is 5700 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.