Show only one of each application number w/o primary key function

[JReneau35]

I have a table that has multiple item numbers under different applications.

Example:

App Number App Description Item #
00250 FIXED FEE PAYMENT 000001
00250 FIXED FEE PAYMENT 000002
00500 PREPAID SERVICES 000001
00500 PREPAID SERVICES 000002
00500 PREPAID SERVICES 000003
00500 PREPAID SERVICES 000004
00600 BUNDLED ACCOUNT FEES 000001
00600 BUNDLED ACCOUNT FEES 000002
00600 BUNDLED ACCOUNT FEES 000003

I am trying to make a combo box that captures just one of each of the app num and app desc.

Example:
00250 FIXED FEE PAYMENT
00500 PREPAID SERVICES
00600 BUNDLED ACCOUNT FEES

Any suggestions?

[Rabbit]

Use a SELECT DISTINCT

[MMcCarthy]

Base the combobox on the following query:

SELECT  [App Number], [App Description]
FROM TableName
GROUP BY   [App Number], [App Description]

Mary