Forms drop-down box does not list all db rows

B

Barry

The query below is set up as an Access view. When I run it from views, it
returns 77,155 records.

SELECT TOP 100 PERCENT CC.dbo.inv_mast.item_id,
CC.dbo.inv_mast.item_desc,
CC.dbo.inv_mast.delete_flag,
dbo.VBH.Item_Id AS VBH_Item_Id,
dbo.VBH.P21_Item_Desc AS VBH_Item_Desc
FROM CC.dbo.inv_mast WITH (NOLOCK) LEFT OUTER JOIN
dbo.VBH ON CC.dbo.inv_mast.item_id = dbo.VBH.Item_Id
WHERE (CC.dbo.inv_mast.delete_flag <> 'Y')

When I use this view as the record source for a drop=down box on a form, it
only returns a small portion of the records (~10%). What could be
restricting the returns on the form? Thank you for your help. Barry
 
B

Barry

The delete_flag qualifier is included as there are about 6,000 "deleted"
records in addition to the 77,155. I do want to filter out those records.

I tried deleting the "TOP 100 PERCENT" from the query, but Access reinserts
it whenver I save the view/query.

Thanks for the hint... I'll check it out.
Barry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top