2 Standard Options along with query results

[TallMan]

Good Morning,

I am working on my first list box. Currently an associate selects an acct number and clicks a button. The code below fills the list box. it is only one field.

[SELECT DISTINCT Test1.ID FROM Test1 WHERE (((test1.acct_nbr)='12345678'));

What I really need to happen is to have two select options always present no matter what the underlying query returns. It would be great if they could be the first two options to select.

"YES" and "NO" are the two entries I would need.

so the list would always be something like this:

YES
No
Query Result
Query Result
Query Result
Query Result

Does anyone know if this is possible?

 

[pbaldy]

You can use a UNION query to combine the results of the query with fixed values. One way would be a table with the desired values, since there are more than one.

 

[TallMan]

Perfect! I will try this.

Thanks Pbaldy!

 

[pbaldy]

No problemo!