T teiben Registered User. Local time Today, 18:35 Joined Jun 20, 2002 Messages 462 May 20, 2003 #1 Can this be done? I have a query with one field called typeofbusiness, it is feed through a combo box. there are 7 possible values (new, service). How would I, add each type of "type of business up".
Can this be done? I have a query with one field called typeofbusiness, it is feed through a combo box. there are 7 possible values (new, service). How would I, add each type of "type of business up".
mark curtis Registered User. Local time Today, 18:35 Joined Oct 9, 2000 Messages 457 May 20, 2003 #2 use a totals query!
T teiben Registered User. Local time Today, 18:35 Joined Jun 20, 2002 Messages 462 May 21, 2003 #3 I'm using 97, there is no such type
dcx693 Registered User. Local time Today, 13:35 Joined Apr 30, 2003 Messages 3,263 May 21, 2003 #4 In query design view, go to the View menu and choose Totals.