I have a table that has from 1 to 7 records for each account number. If there are all seven, they will be numbered individually 1 through 7 in field-x. If there are less than 7, field-x may contain any combination of numbers, but there are never more than one of each number (i.e., there may be 1,3,4,6 and 7).
I'd like to display them in a form where there is a place for each field-x 1 through 7. If there is no number 1, then the fields on that line would just be blanks or zero (if amount fields).
A query provides the records based on the selected account number.
How do I set this up?
Karl
I'd like to display them in a form where there is a place for each field-x 1 through 7. If there is no number 1, then the fields on that line would just be blanks or zero (if amount fields).
A query provides the records based on the selected account number.
How do I set this up?
Karl