Report Question

Hello All.

Hope I have found the correct spot for my question.

I am trying to learn how to create reports.

My records look like so:

ActDate SalesID ProductID SalesVolume
15-Dec AAA SPY 10
15-Dec AAA SPY 5
15-Dec BBB SPY 40
15-Dec BBB IBM 10
15-Dec CCC SPY 2
16-Dec AAA SPY 500
16-Dec AAA IBM 10
16-Dec BBB CAT 25
16-Dec CCC SPY 100
16-Dec BBB IBM 2

I need a report to list out by ActDate and ProductID, a ranking of the
SalesID.

Was hoping I could get a report that was layed out as so:

15-Dec 16-Dec
CAT 0 BBB
IBM BBB AAA;BBB
SPY BBB;AAA;CCC AAA;CCC

For example, on Dec 15, BBB had the top SalesVolume for SPY. AAA was second,
CCC third.

Can someone show me how this can be done ?

Thank you in advance.

I believe you could use the generic concatenation function found at
http://www.rogersaccesslibrary.com/f...sts.asp?TID=16.

--
Duane Hookom
Microsoft Access MVP


"carl" wrote:

Hello All.

Hope I have found the correct spot for my question.

I am trying to learn how to create reports.

My records look like so:

ActDate SalesID ProductID SalesVolume
15-Dec AAA SPY 10
15-Dec AAA SPY 5
15-Dec BBB SPY 40
15-Dec BBB IBM 10
15-Dec CCC SPY 2
16-Dec AAA SPY 500
16-Dec AAA IBM 10
16-Dec BBB CAT 25
16-Dec CCC SPY 100
16-Dec BBB IBM 2

I need a report to list out by ActDate and ProductID, a ranking of the
SalesID.

Was hoping I could get a report that was layed out as so:

15-Dec 16-Dec
CAT 0 BBB
IBM BBB AAA;BBB
SPY BBB;AAA;CCC AAA;CCC

For example, on Dec 15, BBB had the top SalesVolume for SPY. AAA was second,
CCC third.

Can someone show me how this can be done ?

Thank you in advance.

Thanks.

Can you show me how to create this report ?

"Duane Hookom" wrote:

I believe you could use the generic concatenation function found at
http://www.rogersaccesslibrary.com/f...sts.asp?TID=16.

--
Duane Hookom
Microsoft Access MVP


"carl" wrote:

Hello All.

Hope I have found the correct spot for my question.

I am trying to learn how to create reports.

My records look like so:

ActDate SalesID ProductID SalesVolume
15-Dec AAA SPY 10
15-Dec AAA SPY 5
15-Dec BBB SPY 40
15-Dec BBB IBM 10
15-Dec CCC SPY 2
16-Dec AAA SPY 500
16-Dec AAA IBM 10
16-Dec BBB CAT 25
16-Dec CCC SPY 100
16-Dec BBB IBM 2

I need a report to list out by ActDate and ProductID, a ranking of the
SalesID.

Was hoping I could get a report that was layed out as so:

15-Dec 16-Dec
CAT 0 BBB
IBM BBB AAA;BBB
SPY BBB;AAA;CCC AAA;CCC

For example, on Dec 15, BBB had the top SalesVolume for SPY. AAA was second,
CCC third.

Can someone show me how this can be done ?

Thank you in advance.

Tell us what you don't understand about the solution. Did you copy the
code/module into your application? Did you try it? Do you have a table/query
name you could share?

--
Duane Hookom
Microsoft Access MVP


"carl" wrote:

Thanks.

Can you show me how to create this report ?

"Duane Hookom" wrote:

I believe you could use the generic concatenation function found at
http://www.rogersaccesslibrary.com/f...sts.asp?TID=16.

--
Duane Hookom
Microsoft Access MVP


"carl" wrote:

Hello All.

Hope I have found the correct spot for my question.

I am trying to learn how to create reports.

My records look like so:

ActDate SalesID ProductID SalesVolume
15-Dec AAA SPY 10
15-Dec AAA SPY 5
15-Dec BBB SPY 40
15-Dec BBB IBM 10
15-Dec CCC SPY 2
16-Dec AAA SPY 500
16-Dec AAA IBM 10
16-Dec BBB CAT 25
16-Dec CCC SPY 100
16-Dec BBB IBM 2

I need a report to list out by ActDate and ProductID, a ranking of the
SalesID.

Was hoping I could get a report that was layed out as so:

15-Dec 16-Dec
CAT 0 BBB
IBM BBB AAA;BBB
SPY BBB;AAA;CCC AAA;CCC

For example, on Dec 15, BBB had the top SalesVolume for SPY. AAA was second,
CCC third.

Can someone show me how this can be done ?

Thank you in advance.