List Box

[MIKIEMILLER]

I have these field names:

Unit

Total

Cash

Credit

Tip

Date

Year

Card Type

I want to have a list box that contains only these fields: Total, Cash, Credit, and Tip.

What is the easiest way about doing this?

[MIKIEMILLER]

Yes Rob.  That is what my data looks like.

[rwunderlich]

Take a look in the Help at the CrossTable prefix.  Your statement will look something like:

CrossTable (TranType, Amount, 1 ) LOAD Unit, Total, Cash, Credit, Tip

FROM ....

-Rob