I have a database which has multiple Product fields ( Prod Name, Prod Name 1, Prod Name 2, Prod Name 4). It is set up this way because one customer can order more than one product up to about four. The products are listed by number and the users can enter a product number into each of the fields, so it is possible to have one product number in any of the fields with different orders. EX. A customer can order 1088 from Prod Name 1 another customer can order the same product but it might be in Prod Name 4 depending on the order they entered it. Is it possible to make Access produce a report that can grab all of the same product numbers form each of the different fields into one report and to a cumulative total for the number ordered at the same time? I tried to figure out a way to do it but so far no luck. Any help is greatly appreciated. Thank you in advance.
July 31, 2011 5:37 PM
March 31, 2012 7:32 PM