add value to results returned by a query

[Guest]

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

 

[Duane Hookom]

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;

 

[Marshall Barton]

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?

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).