J
Jaybird
My users need line item information contained in a report to be contained on
a single line for every Order Number. They don't like the grouping function
which does essentially the same thing, but in the interest of keeping the
peace I've been trying to use the fConcatChild function from Allen Browne's
website. I'm having trouble with it, however. If my Orders table is called
[Order Entry5], and my Order Details table is called [tblOrderDetails], they
are linked by field [Order Number], and the field from [tblOrderDetails] that
I would like concatenated is called [ID], shouldn't the SQL expression be
written like this?
SELECT [Order Entry5].*, fConcatChild("tblOrderDetails","[Order
Number]","ID","Long",[Order Number]) AS SubFormValues
FROM [Order Entry5];
I'm getting a compile error in query expression
fConcatChild("tblOrderDetails","[Order Number]","ID","Long",[Order Number]).
(Error 3075)
I am using DAO 3.6. A number of other users have managed to get results
from the query, so it can't be THAT difficult. Does anyone have an idea
where I am going wrong?
a single line for every Order Number. They don't like the grouping function
which does essentially the same thing, but in the interest of keeping the
peace I've been trying to use the fConcatChild function from Allen Browne's
website. I'm having trouble with it, however. If my Orders table is called
[Order Entry5], and my Order Details table is called [tblOrderDetails], they
are linked by field [Order Number], and the field from [tblOrderDetails] that
I would like concatenated is called [ID], shouldn't the SQL expression be
written like this?
SELECT [Order Entry5].*, fConcatChild("tblOrderDetails","[Order
Number]","ID","Long",[Order Number]) AS SubFormValues
FROM [Order Entry5];
I'm getting a compile error in query expression
fConcatChild("tblOrderDetails","[Order Number]","ID","Long",[Order Number]).
(Error 3075)
I am using DAO 3.6. A number of other users have managed to get results
from the query, so it can't be THAT difficult. Does anyone have an idea
where I am going wrong?