complicated cross table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I have a crosstable with the following result for my greyhound race database.

Dogname WonatDistances Amount

Brett Lee 400 2
Brett Lee 425 1
Brett Lee 500 3
Fido 389 1
Fido 400 2

I would like to create a query to be able to group them together to show a
result as such:

Brett Lee 400(2), 425(1), 500(1)
Fido 389(1), 400(2)

any ideas??
tks in advance
 
thanks Karl,
Ok i do that works fine, so now i have a table looking like this:
Dogname Won at:

Brett Lee 400(2)
Brett Lee 425(1)
Brett Lee 500(3)
Fido 389(1)
Fido 400(2)
but how do i group them together so it just shows the one dog name and then
the 'won at' field.when i just do a simple group by select query it just
shows the one 'won at' field like below:

Brett Lee 400(2)
Fido 389(1)

when i'm after it too show like this
Brett Lee 400(2), 425(1), 500(1)
Fido 389(1), 400(2)

cheers




KARL DEWEY said:
Concatenate the two fields like --
[WonatDistances] & "(" & [Amount] & ")"

Mark said:
Hi
I have a crosstable with the following result for my greyhound race database.

Dogname WonatDistances Amount

Brett Lee 400 2
Brett Lee 425 1
Brett Lee 500 3
Fido 389 1
Fido 400 2

I would like to create a query to be able to group them together to show a
result as such:

Brett Lee 400(2), 425(1), 500(1)
Fido 389(1), 400(2)

any ideas??
tks in advance
Click to expand...
Click to expand...
 
A crosstab query should accomplish your goal. Create a new query based
on the query that you just made, and invoke the Crosstab Wizard.


thanks Karl,
Ok i do that works fine, so now i have a table looking like this:
Dogname Won at:

Brett Lee 400(2)
Brett Lee 425(1)
Brett Lee 500(3)
Fido 389(1)
Fido 400(2)
but how do i group them together so it just shows the one dog name and then
the 'won at' field.when i just do a simple group by select query it just
shows the one 'won at' field like below:

Brett Lee 400(2)
Fido 389(1)

when i'm after it too show like this
Brett Lee 400(2), 425(1), 500(1)
Fido 389(1), 400(2)

cheers




KARL DEWEY said:
Concatenate the two fields like --
[WonatDistances] & "(" & [Amount] & ")"

Mark said:
Hi
I have a crosstable with the following result for my greyhound race database.

Dogname WonatDistances Amount

Brett Lee 400 2
Brett Lee 425 1
Brett Lee 500 3
Fido 389 1
Fido 400 2

I would like to create a query to be able to group them together to show a
result as such:

Brett Lee 400(2), 425(1), 500(1)
Fido 389(1), 400(2)

any ideas??
tks in advance
Click to expand...
Click to expand...
Click to expand...


**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
 
tks jack. a crosstable doesnt quite work how i want it to display.it comes up
with say '400(2)' as a column heading. i need to somehow also concatenate the
same dog in my current table so it looks like

brettlee 400(2),425(1),500(3)


Jack MacDonald said:
A crosstab query should accomplish your goal. Create a new query based
on the query that you just made, and invoke the Crosstab Wizard.


thanks Karl,
Ok i do that works fine, so now i have a table looking like this:
Dogname Won at:

Brett Lee 400(2)
Brett Lee 425(1)
Brett Lee 500(3)
Fido 389(1)
Fido 400(2)
but how do i group them together so it just shows the one dog name and then
the 'won at' field.when i just do a simple group by select query it just
shows the one 'won at' field like below:

Brett Lee 400(2)
Fido 389(1)

when i'm after it too show like this
Brett Lee 400(2), 425(1), 500(1)
Fido 389(1), 400(2)

cheers




KARL DEWEY said:
Concatenate the two fields like --
[WonatDistances] & "(" & [Amount] & ")"

:

Hi
I have a crosstable with the following result for my greyhound race database.

Dogname WonatDistances Amount

Brett Lee 400 2
Brett Lee 425 1
Brett Lee 500 3
Fido 389 1
Fido 400 2

I would like to create a query to be able to group them together to show a
result as such:

Brett Lee 400(2), 425(1), 500(1)
Fido 389(1), 400(2)

any ideas??
tks in advance
Click to expand...
Click to expand...


**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
Click to expand...
 
There is a generic concatenate function with sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

--
Duane Hookom
MS Access MVP


Mark said:
tks jack. a crosstable doesnt quite work how i want it to display.it comes
up
with say '400(2)' as a column heading. i need to somehow also concatenate
the
same dog in my current table so it looks like

brettlee 400(2),425(1),500(3)


Jack MacDonald said:
A crosstab query should accomplish your goal. Create a new query based
on the query that you just made, and invoke the Crosstab Wizard.


thanks Karl,
Ok i do that works fine, so now i have a table looking like this:
Dogname Won at:

Brett Lee 400(2)
Brett Lee 425(1)
Brett Lee 500(3)
Fido 389(1)
Fido 400(2)
but how do i group them together so it just shows the one dog name and
then
the 'won at' field.when i just do a simple group by select query it just
shows the one 'won at' field like below:

Brett Lee 400(2)
Fido 389(1)

when i'm after it too show like this
Brett Lee 400(2), 425(1), 500(1)
Fido 389(1), 400(2)

cheers




:

Concatenate the two fields like --
[WonatDistances] & "(" & [Amount] & ")"

:

Hi
I have a crosstable with the following result for my greyhound race
database.

Dogname WonatDistances Amount

Brett Lee 400 2
Brett Lee 425 1
Brett Lee 500 3
Fido 389 1
Fido 400 2

I would like to create a query to be able to group them together to
show a
result as such:

Brett Lee 400(2), 425(1), 500(1)
Fido 389(1), 400(2)

any ideas??
tks in advance
Click to expand...


**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
Click to expand...
Click to expand...
 
handy site.tks heaps duane

Duane Hookom said:
There is a generic concatenate function with sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

--
Duane Hookom
MS Access MVP


Mark said:
tks jack. a crosstable doesnt quite work how i want it to display.it comes
up
with say '400(2)' as a column heading. i need to somehow also concatenate
the
same dog in my current table so it looks like

brettlee 400(2),425(1),500(3)


Jack MacDonald said:
A crosstab query should accomplish your goal. Create a new query based
on the query that you just made, and invoke the Crosstab Wizard.


On Tue, 2 Aug 2005 17:43:02 -0700, "Mark"

thanks Karl,
Ok i do that works fine, so now i have a table looking like this:
Dogname Won at:

Brett Lee 400(2)
Brett Lee 425(1)
Brett Lee 500(3)
Fido 389(1)
Fido 400(2)
but how do i group them together so it just shows the one dog name and
then
the 'won at' field.when i just do a simple group by select query it just
shows the one 'won at' field like below:

Brett Lee 400(2)
Fido 389(1)

when i'm after it too show like this
Brett Lee 400(2), 425(1), 500(1)
Fido 389(1), 400(2)

cheers




:

Concatenate the two fields like --
[WonatDistances] & "(" & [Amount] & ")"

:

Hi
I have a crosstable with the following result for my greyhound race
database.

Dogname WonatDistances Amount

Brett Lee 400 2
Brett Lee 425 1
Brett Lee 500 3
Fido 389 1
Fido 400 2

I would like to create a query to be able to group them together to
show a
result as such:

Brett Lee 400(2), 425(1), 500(1)
Fido 389(1), 400(2)

any ideas??
tks in advance


**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
Click to expand...
Click to expand...
Click to expand...
 
Back
Top