consolidate customer names

S

Shawn

I have a customer work request database where several different offices are
able to access it over the network and submit their request. Generally,
there are no more than fifteen customers who submit requests on a regular
basis. I need to search those requests by name. It's easy to extract all
the names from the table, but how do I consolidate them?
 
K

KARL DEWEY

Sounds like you want a totals query. In design view click on the icon that
is a Greek letter Epsilon - Totals.

Your database would be better if you place your customer list in a separate
table from the request. Have an autonumber as primary key and set a
relationship to the request table.
 
L

Larry Daugherty

Typically you'd have a multi-select list box that lists all the
requesters in the table. you are then able to select just those of
interest. You can base subsequent action on whether the name is
selected in the listbox. It can be complicated to think it through
and get it going the first time. After that it works a treat!

HTH
 
Top