Hi there,
I have a very large table [WTN Table] that contain information about the billing details for working telephone numbers (WTNs) installed by one of my client's clients at sites across the country. These are the relevant fields:

[WTN Table].[WTN] = Working Telephone Number (i.e. 123-456-7890)
[WTN Table].[Line Item] = What kind of line this WTN is (i.e. LINE, TRUNK, T1/PRI, or the field may be left blank)
[WTN Table].[Description] = Literally what is written on the bill for this line item (i.e. "Metered Business Line")
[WTN Table].[Charge] = The charge for this bill line item, (i.e. $17.95)

A normal WTN may have several entries in the table, for instance,

123-456-7890, "LINE", "Metered Business Line", $17.95
123-456-7890, "", "FCC Universal Sevice Fund", $1.95
123-456-7890, "", "Caller-ID", $0.50
123-456-7890, "", "State and Local Taxes", $1.27

However, sometimes there is a unique [WTN] in the table that has no [Line Item] entry at all. The information may still be in the description, but the person doing the data entry didn't update the [Line Item] field. For instance:

123-456-7890, "", "Metered Business Line", $17.95
123-456-7890, "", "FCC Universal Sevice Fund", $1.95
123-456-7890, "", "Caller-ID", $0.50
123-456-7890, "", "State and Local Taxes", $1.27

Now I need to identify a [Line Item] type for every [WTN], so I need to manually go through the blanks any do this manually. Out of about 150,000 unique WTNs, there are about 20,000 that have no [Line Item] field--- so I still need to put the data into a readable format.

What I would like is a table (or something table-like) that shows only unique [WTN]s where the [Line Item] field is never used, and then a listbox with all of the [Description]s that match that [WTN], listed in the order they are in the original [WTN Table] table, and then a blank [Line Item] field where I can enter in the Line Item type based on a manual read of the data.

So the above example could be represented as:
123-456-7890,(Metered Business Line, FCC Universal Service Fund, Caller-ID, State and Local Taxes), -blank line item field-
..imagine the parenthesis represent data in a listbox.

I know how to create a make-table query to pull out all of the [WTN]s that never have a [line item], but I don't know how to represent the description data in a listbox. How do I do that?

Thanks, Jared

I would recommend that you use a sub form and not a list box. It is a lot more flexible and cab eb set up to allow you to edit the data.

Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com