I need some serious help please! I have table A with customer info. I have table B with my customer number linked and several order numbers. Some order numbers may have a type which equals 1A, 2A, 3A and so on. There may be 3 order numbers equal to 1A, 1 equal to 2A and 5 equal to 3A. I need to show the values of the order numbers where type is equal to 2A. So if there is one, I will show one but if there are three, I will show all three values. The thing is I may not always know how many there will be where type is equal to 2A. The grouping in my main report is on customer number. The reason I want to return the values of order numbers where type is equal to 2A is to then pass each value to each different subreport. I would REALLY APPRECIATE YOUR HELP EVERYONE! Thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
returning value of possibly more than one order number
- Thread starter mwhalen
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question