Dollar sales by salesperson

[wthoffman]

I want to be able to see how much each sales person has sold over a specific
period of time. I would like the sales by salesperson to be subtotals by
each sales person.
I am sorry if I did not make myself clear. How do I establish the sales
period and how do I subtotal the sales by each sales person?

Thanks,

 

[karl dewey]

Try this --
SELECT [SalesPerson], Sum([SaleValue]) AS Total_Sales
FROM YourTable
GROUP BY [SalesPerson]
WHERE [SaleDate] Between CVDate([Enter period start date]) AND CVDate([Enter
period end date]);

 

[wthoffman]

Where do I put the code? I was hoping in a query, I have 2007 Access and I
am a novice at this. Thank you for your patience

Try this --
SELECT [SalesPerson], Sum([SaleValue]) AS Total_Sales
FROM YourTable
GROUP BY [SalesPerson]
WHERE [SaleDate] Between CVDate([Enter period start date]) AND CVDate([Enter
period end date]);
--
KARL DEWEY
Build a little - Test a little

I want to be able to see how much each sales person has sold over a specific
period of time. I would like the sales by salesperson to be subtotals by
each sales person.
I am sorry if I did not make myself clear. How do I establish the sales
period and how do I subtotal the sales by each sales person?

Thanks,

 

[karl dewey]

You paste it in the SQL view.
Open query in design view, then click on the pull down, paste, edit field
and tables names. Correct any word wrap, in particular the WHERE statement
as it is long enough to wrap.

--
KARL DEWEY
Build a little - Test a little

Where do I put the code? I was hoping in a query, I have 2007 Access and I
am a novice at this. Thank you for your patience

Try this --
SELECT [SalesPerson], Sum([SaleValue]) AS Total_Sales
FROM YourTable
GROUP BY [SalesPerson]
WHERE [SaleDate] Between CVDate([Enter period start date]) AND CVDate([Enter
period end date]);
--
KARL DEWEY
Build a little - Test a little

I want to be able to see how much each sales person has sold over a specific
period of time. I would like the sales by salesperson to be subtotals by
each sales person.
I am sorry if I did not make myself clear. How do I establish the sales
period and how do I subtotal the sales by each sales person?

Thanks,

 

[John W. Vinson]

This IS a query. This is SQL, the language of queries. Create a new query and
go into SQL view using the View menu; copy and paste this query; edit the
tablenames and fieldnames to match yours, and then go back to the query grid
if you want to see it in that form.

Where do I put the code? I was hoping in a query, I have 2007 Access and I
am a novice at this. Thank you for your patience

Try this --
SELECT [SalesPerson], Sum([SaleValue]) AS Total_Sales
FROM YourTable
GROUP BY [SalesPerson]
WHERE [SaleDate] Between CVDate([Enter period start date]) AND CVDate([Enter
period end date]);
--
KARL DEWEY
Build a little - Test a little

I want to be able to see how much each sales person has sold over a specific
period of time. I would like the sales by salesperson to be subtotals by
each sales person.
I am sorry if I did not make myself clear. How do I establish the sales
period and how do I subtotal the sales by each sales person?

Thanks,

 

[wthoffman]

It is giving me a syntax error message. I have four tables: a Brokerage
table which lists the sales person and info from the company, a Vessel table
which has the listing price and the listing date, A buyers table that shows
the sales date and sales price.
Tanks,

You paste it in the SQL view.
Open query in design view, then click on the pull down, paste, edit field
and tables names. Correct any word wrap, in particular the WHERE statement
as it is long enough to wrap.

--
KARL DEWEY
Build a little - Test a little

Where do I put the code? I was hoping in a query, I have 2007 Access and I
am a novice at this. Thank you for your patience

Try this --
SELECT [SalesPerson], Sum([SaleValue]) AS Total_Sales
FROM YourTable
GROUP BY [SalesPerson]
WHERE [SaleDate] Between CVDate([Enter period start date]) AND CVDate([Enter
period end date]);
--
KARL DEWEY
Build a little - Test a little


:

I want to be able to see how much each sales person has sold over a specific
period of time. I would like the sales by salesperson to be subtotals by
each sales person.
I am sorry if I did not make myself clear. How do I establish the sales
period and how do I subtotal the sales by each sales person?

Thanks,

 

[karl dewey]

Try it this way --
SELECT [SalesPerson], Sum([SaleValue]) AS Total_Sales
FROM YourTable
WHERE [SaleDate] Between CVDate([Enter period start date]) AND CVDate([Enter
period end date])
GROUP BY [SalesPerson];

--
KARL DEWEY
Build a little - Test a little

It is giving me a syntax error message. I have four tables: a Brokerage
table which lists the sales person and info from the company, a Vessel table
which has the listing price and the listing date, A buyers table that shows
the sales date and sales price.
Tanks,

You paste it in the SQL view.
Open query in design view, then click on the pull down, paste, edit field
and tables names. Correct any word wrap, in particular the WHERE statement
as it is long enough to wrap.

--
KARL DEWEY
Build a little - Test a little

Where do I put the code? I was hoping in a query, I have 2007 Access and I
am a novice at this. Thank you for your patience

:

Try this --
SELECT [SalesPerson], Sum([SaleValue]) AS Total_Sales
FROM YourTable
GROUP BY [SalesPerson]
WHERE [SaleDate] Between CVDate([Enter period start date]) AND CVDate([Enter
period end date]);
--
KARL DEWEY
Build a little - Test a little


:

I want to be able to see how much each sales person has sold over a specific
period of time. I would like the sales by salesperson to be subtotals by
each sales person.
I am sorry if I did not make myself clear. How do I establish the sales
period and how do I subtotal the sales by each sales person?

Thanks,