DogLover2006
Technical User
Hello,
I have a table called SPF_2003_2004 it has a field in it called REQ it is a memo field (which are about 20 different names). This data was pulled from another application. I created a query that parse but eceeded resources. So now I am looking for code that will parse it and then create a query form that. The boss does not want to make another table in the database. Just a query that will be used to create a report that show each name, amount, total amount, and count. I needed this like yesterday. I have been working on this for day. Please respond asap. Thank you
Data:
REQ:
AUBRY, CARROZZA, CLARK, COHEN-M, COOK, GIANARIS, GRODENCHIK, LAFAYETTE, MARKEY, MAYERSOHN, MCLAUGHLIN, NOLAN, PERALTA, PHEFFER, SCARBOROUGH, SEMINERIO, TITUS, WEPRIN
AMT REQ:
500.00
SingleReq: False
I have a table called SPF_2003_2004 it has a field in it called REQ it is a memo field (which are about 20 different names). This data was pulled from another application. I created a query that parse but eceeded resources. So now I am looking for code that will parse it and then create a query form that. The boss does not want to make another table in the database. Just a query that will be used to create a report that show each name, amount, total amount, and count. I needed this like yesterday. I have been working on this for day. Please respond asap. Thank you
Data:
REQ:
AUBRY, CARROZZA, CLARK, COHEN-M, COOK, GIANARIS, GRODENCHIK, LAFAYETTE, MARKEY, MAYERSOHN, MCLAUGHLIN, NOLAN, PERALTA, PHEFFER, SCARBOROUGH, SEMINERIO, TITUS, WEPRIN
AMT REQ:
500.00
SingleReq: False