Multiple rows of info into 1 row

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

Guest

I have a Pt ID field which is a unique number. I have a S_field which is an
ID # that lines to the Pt ID. There are multiple Pt ID's for one S_field ID.
When I make the report, it puts each separate S-field on a different line.
Is it possible to get all the Pt ID's associated with 1 S_field to be in 1
row.

It would like like S-Field Pt ID
31 1,2,3,4
 
I looked at that and gave it try but it's not working. I don't have that
much knowledge about access so this may jsut be over my head.
 
Did you import the module into your application?
What are your table and field names? Are the fields numeric or text?
 
My fields are: Grid_ID, Sliver_ID, Grid_ID2, and Date of Dig. The first 3
are number fields and the last is date. For each grid ID, I would like all
the sliver ids to be in 1 row just separated by commas.

I imported the module but I just don't know what to change.
 
Try this totals query:

SELECT GRID_ID, Concatenate("SELECT Sliver_ID FROM tblNoName WHERE GRID_ID
=" & [GRID_ID]) as Slivers
FROM tblNoName
GROUP BY GRID_ID, Concatenate("SELECT Sliver_ID FROM tblNoName WHERE GRID_ID
=" & [GRID_ID]);
 
Sorry I'm asking so many questions about this. So, I made a new query with
just the fields from the Sliver Tracking Table. I typed in what is listed
below in a field. I get a syntax error telling me to check and enclose
subquery in parentheaes.

When you say totals query, what does that mean?

Duane Hookom said:
Try this totals query:

SELECT GRID_ID, Concatenate("SELECT Sliver_ID FROM tblNoName WHERE GRID_ID
=" & [GRID_ID]) as Slivers
FROM tblNoName
GROUP BY GRID_ID, Concatenate("SELECT Sliver_ID FROM tblNoName WHERE GRID_ID
=" & [GRID_ID]);

--
Duane Hookom
MS Access MVP

Crystal said:
My fields are: Grid_ID, Sliver_ID, Grid_ID2, and Date of Dig. The first
3
are number fields and the last is date. For each grid ID, I would like
all
the sliver ids to be in 1 row just separated by commas.

I imported the module but I just don't know what to change.
Click to expand...
Click to expand...
 
You need to view the SQL view of your query and paste this SQL view
SELECT GRID_ID,
Concatenate("SELECT Sliver_ID FROM tblNoName WHERE GRID_ID =" & [GRID_ID])
as Slivers
FROM tblNoName
GROUP BY GRID_ID,
Concatenate("SELECT Sliver_ID FROM tblNoName WHERE GRID_ID =" & [GRID_ID]);

--
Duane Hookom
MS Access MVP


Crystal said:
Sorry I'm asking so many questions about this. So, I made a new query
with
just the fields from the Sliver Tracking Table. I typed in what is listed
below in a field. I get a syntax error telling me to check and enclose
subquery in parentheaes.

When you say totals query, what does that mean?

Duane Hookom said:
Try this totals query:

SELECT GRID_ID, Concatenate("SELECT Sliver_ID FROM tblNoName WHERE
GRID_ID
=" & [GRID_ID]) as Slivers
FROM tblNoName
GROUP BY GRID_ID, Concatenate("SELECT Sliver_ID FROM tblNoName WHERE
GRID_ID
=" & [GRID_ID]);

--
Duane Hookom
MS Access MVP

Crystal said:
My fields are: Grid_ID, Sliver_ID, Grid_ID2, and Date of Dig. The
first
3
are number fields and the last is date. For each grid ID, I would like
all
the sliver ids to be in 1 row just separated by commas.

I imported the module but I just don't know what to change.

:

Did you import the module into your application?
What are your table and field names? Are the fields numeric or text?
--
Duane Hookom
MS Access MVP

I looked at that and gave it try but it's not working. I don't have
that
much knowledge about access so this may jsut be over my head.

:

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

I have a Pt ID field which is a unique number. I have a S_field
which
is
an
ID # that lines to the Pt ID. There are multiple Pt ID's for one
S_field
ID.
When I make the report, it puts each separate S-field on a
different
line.
Is it possible to get all the Pt ID's associated with 1 S_field
to
be
in 1
row.

It would like like S-Field Pt ID
31 1,2,3,4
Click to expand...
Click to expand...
Click to expand...
 
This is what I have and it tells me i have an error in my From clause

SELECT GRID_ID,
Concatenate("SELECT Sliver_ID [Sliver Tracking] WHERE Grid_ID =" &
[Grid_ID])
as Slivers
FROM [Sliver Tracking]
GROUP BY Grid_ID,
Concatenate("SELECT Sliver_ID FROM [Sliver Tracking] WHERE Grid_ID =" &
[Grid_ID]);

Duane Hookom said:
You need to view the SQL view of your query and paste this SQL view
SELECT GRID_ID,
Concatenate("SELECT Sliver_ID FROM tblNoName WHERE GRID_ID =" & [GRID_ID])
as Slivers
FROM tblNoName
GROUP BY GRID_ID,
Concatenate("SELECT Sliver_ID FROM tblNoName WHERE GRID_ID =" & [GRID_ID]);

--
Duane Hookom
MS Access MVP


Crystal said:
Sorry I'm asking so many questions about this. So, I made a new query
with
just the fields from the Sliver Tracking Table. I typed in what is listed
below in a field. I get a syntax error telling me to check and enclose
subquery in parentheaes.

When you say totals query, what does that mean?

Duane Hookom said:
Try this totals query:

SELECT GRID_ID, Concatenate("SELECT Sliver_ID FROM tblNoName WHERE
GRID_ID
=" & [GRID_ID]) as Slivers
FROM tblNoName
GROUP BY GRID_ID, Concatenate("SELECT Sliver_ID FROM tblNoName WHERE
GRID_ID
=" & [GRID_ID]);

--
Duane Hookom
MS Access MVP

My fields are: Grid_ID, Sliver_ID, Grid_ID2, and Date of Dig. The
first
3
are number fields and the last is date. For each grid ID, I would like
all
the sliver ids to be in 1 row just separated by commas.

I imported the module but I just don't know what to change.

:

Did you import the module into your application?
What are your table and field names? Are the fields numeric or text?
--
Duane Hookom
MS Access MVP

I looked at that and gave it try but it's not working. I don't have
that
much knowledge about access so this may jsut be over my head.

:

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

I have a Pt ID field which is a unique number. I have a S_field
which
is
an
ID # that lines to the Pt ID. There are multiple Pt ID's for one
S_field
ID.
When I make the report, it puts each separate S-field on a
different
line.
Is it possible to get all the Pt ID's associated with 1 S_field
to
be
in 1
row.

It would like like S-Field Pt ID
31 1,2,3,4
Click to expand...
Click to expand...
Click to expand...
 
You deleted the "FROM" from my expression. Try again:
SELECT GRID_ID,
Concatenate("SELECT Sliver_ID FROM [Sliver Tracking] WHERE Grid_ID =" &
[Grid_ID])
as Slivers
FROM [Sliver Tracking]
GROUP BY Grid_ID,
Concatenate("SELECT Sliver_ID FROM [Sliver Tracking] WHERE Grid_ID =" &
[Grid_ID]);


--
Duane Hookom
MS Access MVP


Crystal said:
This is what I have and it tells me i have an error in my From clause

SELECT GRID_ID,
Concatenate("SELECT Sliver_ID [Sliver Tracking] WHERE Grid_ID =" &
[Grid_ID])
as Slivers
FROM [Sliver Tracking]
GROUP BY Grid_ID,
Concatenate("SELECT Sliver_ID FROM [Sliver Tracking] WHERE Grid_ID =" &
[Grid_ID]);

Duane Hookom said:
You need to view the SQL view of your query and paste this SQL view
SELECT GRID_ID,
Concatenate("SELECT Sliver_ID FROM tblNoName WHERE GRID_ID =" &
[GRID_ID])
as Slivers
FROM tblNoName
GROUP BY GRID_ID,
Concatenate("SELECT Sliver_ID FROM tblNoName WHERE GRID_ID =" &
[GRID_ID]);

--
Duane Hookom
MS Access MVP


Crystal said:
Sorry I'm asking so many questions about this. So, I made a new query
with
just the fields from the Sliver Tracking Table. I typed in what is
listed
below in a field. I get a syntax error telling me to check and enclose
subquery in parentheaes.

When you say totals query, what does that mean?

:

Try this totals query:

SELECT GRID_ID, Concatenate("SELECT Sliver_ID FROM tblNoName WHERE
GRID_ID
=" & [GRID_ID]) as Slivers
FROM tblNoName
GROUP BY GRID_ID, Concatenate("SELECT Sliver_ID FROM tblNoName WHERE
GRID_ID
=" & [GRID_ID]);

--
Duane Hookom
MS Access MVP

My fields are: Grid_ID, Sliver_ID, Grid_ID2, and Date of Dig. The
first
3
are number fields and the last is date. For each grid ID, I would
like
all
the sliver ids to be in 1 row just separated by commas.

I imported the module but I just don't know what to change.

:

Did you import the module into your application?
What are your table and field names? Are the fields numeric or
text?
--
Duane Hookom
MS Access MVP

I looked at that and gave it try but it's not working. I don't
have
that
much knowledge about access so this may jsut be over my head.

:

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

I have a Pt ID field which is a unique number. I have a
S_field
which
is
an
ID # that lines to the Pt ID. There are multiple Pt ID's for
one
S_field
ID.
When I make the report, it puts each separate S-field on a
different
line.
Is it possible to get all the Pt ID's associated with 1
S_field
to
be
in 1
row.

It would like like S-Field Pt ID
31 1,2,3,4
Click to expand...
Click to expand...
Click to expand...
 
I really pasted this and I still get the error message about the FROM clause.

SELECT GRID_ID,
Concatenate("SELECT Sliver_ID FROM [Sliver Tracking] WHERE Grid_ID =" &
[Grid_ID])
as Slivers
FROM [Sliver Tracking]
GROUP BY Grid_ID,
Concatenate("SELECT Sliver_ID FROM [Sliver Tracking] WHERE Grid_ID =" &
[Grid_ID]);



Duane Hookom said:
You deleted the "FROM" from my expression. Try again:
SELECT GRID_ID,
Concatenate("SELECT Sliver_ID FROM [Sliver Tracking] WHERE Grid_ID =" &
[Grid_ID])
as Slivers
FROM [Sliver Tracking]
GROUP BY Grid_ID,
Concatenate("SELECT Sliver_ID FROM [Sliver Tracking] WHERE Grid_ID =" &
[Grid_ID]);


--
Duane Hookom
MS Access MVP


Crystal said:
This is what I have and it tells me i have an error in my From clause

SELECT GRID_ID,
Concatenate("SELECT Sliver_ID [Sliver Tracking] WHERE Grid_ID =" &
[Grid_ID])
as Slivers
FROM [Sliver Tracking]
GROUP BY Grid_ID,
Concatenate("SELECT Sliver_ID FROM [Sliver Tracking] WHERE Grid_ID =" &
[Grid_ID]);

Duane Hookom said:
You need to view the SQL view of your query and paste this SQL view
SELECT GRID_ID,
Concatenate("SELECT Sliver_ID FROM tblNoName WHERE GRID_ID =" &
[GRID_ID])
as Slivers
FROM tblNoName
GROUP BY GRID_ID,
Concatenate("SELECT Sliver_ID FROM tblNoName WHERE GRID_ID =" &
[GRID_ID]);

--
Duane Hookom
MS Access MVP


Sorry I'm asking so many questions about this. So, I made a new query
with
just the fields from the Sliver Tracking Table. I typed in what is
listed
below in a field. I get a syntax error telling me to check and enclose
subquery in parentheaes.

When you say totals query, what does that mean?

:

Try this totals query:

SELECT GRID_ID, Concatenate("SELECT Sliver_ID FROM tblNoName WHERE
GRID_ID
=" & [GRID_ID]) as Slivers
FROM tblNoName
GROUP BY GRID_ID, Concatenate("SELECT Sliver_ID FROM tblNoName WHERE
GRID_ID
=" & [GRID_ID]);

--
Duane Hookom
MS Access MVP

My fields are: Grid_ID, Sliver_ID, Grid_ID2, and Date of Dig. The
first
3
are number fields and the last is date. For each grid ID, I would
like
all
the sliver ids to be in 1 row just separated by commas.

I imported the module but I just don't know what to change.

:

Did you import the module into your application?
What are your table and field names? Are the fields numeric or
text?
--
Duane Hookom
MS Access MVP

I looked at that and gave it try but it's not working. I don't
have
that
much knowledge about access so this may jsut be over my head.

:

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

I have a Pt ID field which is a unique number. I have a
S_field
which
is
an
ID # that lines to the Pt ID. There are multiple Pt ID's for
one
S_field
ID.
When I make the report, it puts each separate S-field on a
different
line.
Is it possible to get all the Pt ID's associated with 1
S_field
to
be
in 1
row.

It would like like S-Field Pt ID
31 1,2,3,4
Click to expand...
Click to expand...
Click to expand...
 
[Sliver Tracking] is a table or query in your database, correct? I asked a
while back "What are your table and field names? " and you replied with only
the field names and no table names.

What do you get if you open the immediate window (press Ctrl+G) and enter:
?Concatenate("SELECT Sliver_ID FROM [Sliver Tracking] WHERE Grid_ID =xxxx")
where xxxx is a real Grid_ID number.

If your actual table name is [Sliver Tracking Table] then you need to
correct the expressions to include the actual table name.

--
Duane Hookom
MS Access MVP


Crystal said:
I really pasted this and I still get the error message about the FROM
clause.

SELECT GRID_ID,
Concatenate("SELECT Sliver_ID FROM [Sliver Tracking] WHERE Grid_ID =" &
[Grid_ID])
as Slivers
FROM [Sliver Tracking]
GROUP BY Grid_ID,
Concatenate("SELECT Sliver_ID FROM [Sliver Tracking] WHERE Grid_ID =" &
[Grid_ID]);



Duane Hookom said:
You deleted the "FROM" from my expression. Try again:
SELECT GRID_ID,
Concatenate("SELECT Sliver_ID FROM [Sliver Tracking] WHERE Grid_ID =" &
[Grid_ID])
as Slivers
FROM [Sliver Tracking]
GROUP BY Grid_ID,
Concatenate("SELECT Sliver_ID FROM [Sliver Tracking] WHERE Grid_ID =" &
[Grid_ID]);


--
Duane Hookom
MS Access MVP


Crystal said:
This is what I have and it tells me i have an error in my From clause

SELECT GRID_ID,
Concatenate("SELECT Sliver_ID [Sliver Tracking] WHERE Grid_ID =" &
[Grid_ID])
as Slivers
FROM [Sliver Tracking]
GROUP BY Grid_ID,
Concatenate("SELECT Sliver_ID FROM [Sliver Tracking] WHERE Grid_ID =" &
[Grid_ID]);

:

You need to view the SQL view of your query and paste this SQL view
SELECT GRID_ID,
Concatenate("SELECT Sliver_ID FROM tblNoName WHERE GRID_ID =" &
[GRID_ID])
as Slivers
FROM tblNoName
GROUP BY GRID_ID,
Concatenate("SELECT Sliver_ID FROM tblNoName WHERE GRID_ID =" &
[GRID_ID]);

--
Duane Hookom
MS Access MVP


Sorry I'm asking so many questions about this. So, I made a new
query
with
just the fields from the Sliver Tracking Table. I typed in what is
listed
below in a field. I get a syntax error telling me to check and
enclose
subquery in parentheaes.

When you say totals query, what does that mean?

:

Try this totals query:

SELECT GRID_ID, Concatenate("SELECT Sliver_ID FROM tblNoName WHERE
GRID_ID
=" & [GRID_ID]) as Slivers
FROM tblNoName
GROUP BY GRID_ID, Concatenate("SELECT Sliver_ID FROM tblNoName
WHERE
GRID_ID
=" & [GRID_ID]);

--
Duane Hookom
MS Access MVP

My fields are: Grid_ID, Sliver_ID, Grid_ID2, and Date of Dig.
The
first
3
are number fields and the last is date. For each grid ID, I
would
like
all
the sliver ids to be in 1 row just separated by commas.

I imported the module but I just don't know what to change.

:

Did you import the module into your application?
What are your table and field names? Are the fields numeric or
text?
--
Duane Hookom
MS Access MVP

I looked at that and gave it try but it's not working. I don't
have
that
much knowledge about access so this may jsut be over my head.

:

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

message
I have a Pt ID field which is a unique number. I have a
S_field
which
is
an
ID # that lines to the Pt ID. There are multiple Pt ID's
for
one
S_field
ID.
When I make the report, it puts each separate S-field on a
different
line.
Is it possible to get all the Pt ID's associated with 1
S_field
to
be
in 1
row.

It would like like S-Field Pt ID
31 1,2,3,4
Click to expand...
Click to expand...
Click to expand...
 
I entered your phrase in the immediate window and it returned this list of
numbers.
50, 487, 488, 489, 490, 491, 492, 493, 494, 495, 496, 497, 498, 499, 500,
501, 502, 503, 504, 505, 506, 507, 508, 509, 510, 511, 512, 513, 514, 515,
516, 517, 518, 519, 520, 521

I have been entering all this info into a query named Sliver Tracking Test.
The table the fields are coming from is Sliver Tracking. Do I need to change
something else to get rid of the error in the From clause.

Duane Hookom said:
[Sliver Tracking] is a table or query in your database, correct? I asked a
while back "What are your table and field names? " and you replied with only
the field names and no table names.

What do you get if you open the immediate window (press Ctrl+G) and enter:
?Concatenate("SELECT Sliver_ID FROM [Sliver Tracking] WHERE Grid_ID =xxxx")
where xxxx is a real Grid_ID number.

If your actual table name is [Sliver Tracking Table] then you need to
correct the expressions to include the actual table name.

--
Duane Hookom
MS Access MVP


Crystal said:
I really pasted this and I still get the error message about the FROM
clause.

SELECT GRID_ID,
Concatenate("SELECT Sliver_ID FROM [Sliver Tracking] WHERE Grid_ID =" &
[Grid_ID])
as Slivers
FROM [Sliver Tracking]
GROUP BY Grid_ID,
Concatenate("SELECT Sliver_ID FROM [Sliver Tracking] WHERE Grid_ID =" &
[Grid_ID]);



Duane Hookom said:
You deleted the "FROM" from my expression. Try again:
SELECT GRID_ID,
Concatenate("SELECT Sliver_ID FROM [Sliver Tracking] WHERE Grid_ID =" &
[Grid_ID])
as Slivers
FROM [Sliver Tracking]
GROUP BY Grid_ID,
Concatenate("SELECT Sliver_ID FROM [Sliver Tracking] WHERE Grid_ID =" &
[Grid_ID]);


--
Duane Hookom
MS Access MVP


This is what I have and it tells me i have an error in my From clause

SELECT GRID_ID,
Concatenate("SELECT Sliver_ID [Sliver Tracking] WHERE Grid_ID =" &
[Grid_ID])
as Slivers
FROM [Sliver Tracking]
GROUP BY Grid_ID,
Concatenate("SELECT Sliver_ID FROM [Sliver Tracking] WHERE Grid_ID =" &
[Grid_ID]);

:

You need to view the SQL view of your query and paste this SQL view
SELECT GRID_ID,
Concatenate("SELECT Sliver_ID FROM tblNoName WHERE GRID_ID =" &
[GRID_ID])
as Slivers
FROM tblNoName
GROUP BY GRID_ID,
Concatenate("SELECT Sliver_ID FROM tblNoName WHERE GRID_ID =" &
[GRID_ID]);

--
Duane Hookom
MS Access MVP


Sorry I'm asking so many questions about this. So, I made a new
query
with
just the fields from the Sliver Tracking Table. I typed in what is
listed
below in a field. I get a syntax error telling me to check and
enclose
subquery in parentheaes.

When you say totals query, what does that mean?

:

Try this totals query:

SELECT GRID_ID, Concatenate("SELECT Sliver_ID FROM tblNoName WHERE
GRID_ID
=" & [GRID_ID]) as Slivers
FROM tblNoName
GROUP BY GRID_ID, Concatenate("SELECT Sliver_ID FROM tblNoName
WHERE
GRID_ID
=" & [GRID_ID]);

--
Duane Hookom
MS Access MVP

My fields are: Grid_ID, Sliver_ID, Grid_ID2, and Date of Dig.
The
first
3
are number fields and the last is date. For each grid ID, I
would
like
all
the sliver ids to be in 1 row just separated by commas.

I imported the module but I just don't know what to change.

:

Did you import the module into your application?
What are your table and field names? Are the fields numeric or
text?
--
Duane Hookom
MS Access MVP

I looked at that and gave it try but it's not working. I don't
have
that
much knowledge about access so this may jsut be over my head.

:

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

message
I have a Pt ID field which is a unique number. I have a
S_field
which
is
an
ID # that lines to the Pt ID. There are multiple Pt ID's
for
one
S_field
ID.
When I make the report, it puts each separate S-field on a
different
line.
Is it possible to get all the Pt ID's associated with 1
S_field
to
be
in 1
row.

It would like like S-Field Pt ID
31 1,2,3,4
Click to expand...
Click to expand...
Click to expand...
 
I got it to work. My problem was that I already had an SQL statement in the
query that just listed the grids and slivers. Once I deleted that and pasted
yours, it worked fine.

Thanks So So much for your help. I really appreciate it.

Duane Hookom said:
[Sliver Tracking] is a table or query in your database, correct? I asked a
while back "What are your table and field names? " and you replied with only
the field names and no table names.

What do you get if you open the immediate window (press Ctrl+G) and enter:
?Concatenate("SELECT Sliver_ID FROM [Sliver Tracking] WHERE Grid_ID =xxxx")
where xxxx is a real Grid_ID number.

If your actual table name is [Sliver Tracking Table] then you need to
correct the expressions to include the actual table name.

--
Duane Hookom
MS Access MVP


Crystal said:
I really pasted this and I still get the error message about the FROM
clause.

SELECT GRID_ID,
Concatenate("SELECT Sliver_ID FROM [Sliver Tracking] WHERE Grid_ID =" &
[Grid_ID])
as Slivers
FROM [Sliver Tracking]
GROUP BY Grid_ID,
Concatenate("SELECT Sliver_ID FROM [Sliver Tracking] WHERE Grid_ID =" &
[Grid_ID]);



Duane Hookom said:
You deleted the "FROM" from my expression. Try again:
SELECT GRID_ID,
Concatenate("SELECT Sliver_ID FROM [Sliver Tracking] WHERE Grid_ID =" &
[Grid_ID])
as Slivers
FROM [Sliver Tracking]
GROUP BY Grid_ID,
Concatenate("SELECT Sliver_ID FROM [Sliver Tracking] WHERE Grid_ID =" &
[Grid_ID]);


--
Duane Hookom
MS Access MVP


This is what I have and it tells me i have an error in my From clause

SELECT GRID_ID,
Concatenate("SELECT Sliver_ID [Sliver Tracking] WHERE Grid_ID =" &
[Grid_ID])
as Slivers
FROM [Sliver Tracking]
GROUP BY Grid_ID,
Concatenate("SELECT Sliver_ID FROM [Sliver Tracking] WHERE Grid_ID =" &
[Grid_ID]);

:

You need to view the SQL view of your query and paste this SQL view
SELECT GRID_ID,
Concatenate("SELECT Sliver_ID FROM tblNoName WHERE GRID_ID =" &
[GRID_ID])
as Slivers
FROM tblNoName
GROUP BY GRID_ID,
Concatenate("SELECT Sliver_ID FROM tblNoName WHERE GRID_ID =" &
[GRID_ID]);

--
Duane Hookom
MS Access MVP


Sorry I'm asking so many questions about this. So, I made a new
query
with
just the fields from the Sliver Tracking Table. I typed in what is
listed
below in a field. I get a syntax error telling me to check and
enclose
subquery in parentheaes.

When you say totals query, what does that mean?

:

Try this totals query:

SELECT GRID_ID, Concatenate("SELECT Sliver_ID FROM tblNoName WHERE
GRID_ID
=" & [GRID_ID]) as Slivers
FROM tblNoName
GROUP BY GRID_ID, Concatenate("SELECT Sliver_ID FROM tblNoName
WHERE
GRID_ID
=" & [GRID_ID]);

--
Duane Hookom
MS Access MVP

My fields are: Grid_ID, Sliver_ID, Grid_ID2, and Date of Dig.
The
first
3
are number fields and the last is date. For each grid ID, I
would
like
all
the sliver ids to be in 1 row just separated by commas.

I imported the module but I just don't know what to change.

:

Did you import the module into your application?
What are your table and field names? Are the fields numeric or
text?
--
Duane Hookom
MS Access MVP

I looked at that and gave it try but it's not working. I don't
have
that
much knowledge about access so this may jsut be over my head.

:

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

message
I have a Pt ID field which is a unique number. I have a
S_field
which
is
an
ID # that lines to the Pt ID. There are multiple Pt ID's
for
one
S_field
ID.
When I make the report, it puts each separate S-field on a
different
line.
Is it possible to get all the Pt ID's associated with 1
S_field
to
be
in 1
row.

It would like like S-Field Pt ID
31 1,2,3,4
Click to expand...
Click to expand...
Click to expand...
 
Back
Top