R
Reb
My database is filled by a form that enters salesmen names, date of sales,
and state of sales. I have a two fold problem. Is it possible to write a
query that gives me the date of first sale and last sale for each salesman?
Then is it possible to have all states of sale put in the same column?
Form enters:
Salesman SalesDate State
1 3/ 3/2001 Texas
1 3/4/2001 Maine
1 3/5/2002 Texas
2 3/7/2002 Missouri
2 3/9/2002 Missouri
2 3/10/2002 Texas
3 4/1/2002 Illinois
3 4/2/2002 Texas
3 5/5/2002 Texas
3 5/6/2002 Missouri
I would like the resulting query to look like:
Salesman FirstSale LastSale SaleStates
1 3/3/2001 3/5/2001 Texas, Maine
2 3/7/2002 3/10/2002 Missouri, Texas
3 4/2/2002 5/6/2002 Texas, Missouri
Thanks for any help. Or is it even possible?
Rebecca
and state of sales. I have a two fold problem. Is it possible to write a
query that gives me the date of first sale and last sale for each salesman?
Then is it possible to have all states of sale put in the same column?
Form enters:
Salesman SalesDate State
1 3/ 3/2001 Texas
1 3/4/2001 Maine
1 3/5/2002 Texas
2 3/7/2002 Missouri
2 3/9/2002 Missouri
2 3/10/2002 Texas
3 4/1/2002 Illinois
3 4/2/2002 Texas
3 5/5/2002 Texas
3 5/6/2002 Missouri
I would like the resulting query to look like:
Salesman FirstSale LastSale SaleStates
1 3/3/2001 3/5/2001 Texas, Maine
2 3/7/2002 3/10/2002 Missouri, Texas
3 4/2/2002 5/6/2002 Texas, Missouri
Thanks for any help. Or is it even possible?
Rebecca