add value to results returned by a query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Daniel - 02 Jul 2006 15:26 GMT

Good morning,

I have a very simple query that returns a lists of reports. I use this
listing to populate a listbox. I would like to know how I can populate the
listbox with the values of the query + the entry "DRM Report"?

How can I add an extra entry into the results returned by the query?

Thank you,

Daniel

Reply to this Message

Duane Hookom - 02 Jul 2006 16:24 GMT

I'm not sure why you didn't provide the "very simple query"...
Since all of my report names begin with "rpt", I would use a union query
with SQL like:

SELECT Name as ReportName
FROM msysObjects
WHERE Name Like "rpt*"
UNION
SELECT "DRM Report"
FROM msysObjects;

Signature

Duane Hookom
MS Access MVP

> Good morning,
>
[quoted text clipped - 8 lines]
>
> Daniel

Reply to this Message

Marshall Barton - 02 Jul 2006 16:37 GMT

>Good morning,
>
[quoted text clipped - 3 lines]
>
>How can I add an extra entry into the results returned by the query?

Add a description field to the table of reports so your
query can retrieve both values. Then use the standard list
box mechanisms (BoundColumn, ColumnWidths, etc).

Signature

Marsh
MVP [MS Access]

Reply to this Message