G
Guest
I have a query that produces a table of Part-Date-Quantity&Date, telling me
how many of that part has been ordered for date x, with the likelihood of
several records for each part.
With a second query, I have to concatenate the Quantity&Date values for each
part, up to a maximum of 50 characters, into a single Comments field to give
the planners a look at the near-term delivery schedule for a given part.
PROBLEM: Although the table produced by the first query is sorted by Part
and Date, and appears dandy on screen, the second query does not perform the
concatenation in chronological order, and update queries don't appear to
offer any kind of sort option. The query is apparently using some kind of
"natural" order for that data behind the curtains, so my final-output
concatenation does not come out in date order, earliest to latest.
Is there an easy solution, or am I going to have to write some esoteric code
to get what I need?
how many of that part has been ordered for date x, with the likelihood of
several records for each part.
With a second query, I have to concatenate the Quantity&Date values for each
part, up to a maximum of 50 characters, into a single Comments field to give
the planners a look at the near-term delivery schedule for a given part.
PROBLEM: Although the table produced by the first query is sorted by Part
and Date, and appears dandy on screen, the second query does not perform the
concatenation in chronological order, and update queries don't appear to
offer any kind of sort option. The query is apparently using some kind of
"natural" order for that data behind the curtains, so my final-output
concatenation does not come out in date order, earliest to latest.
Is there an easy solution, or am I going to have to write some esoteric code
to get what I need?