tableadapter Query linked to Access 2003 table

  • Thread starter Thread starter mcolson
  • Start date Start date
M

mcolson

I'm trying to write a query for my Dataset's table adapter. It is
linked to an access 2003 database. Basically, I'm trying to duplicate
the following query.

SELECT Parts_Inventory.Aisle, Parts_Inventory.Rack,
Parts_Inventory.Shelf, Parts_Inventory.QNTY, Parts_Inventory.MFG_PN,
Parts_Inventory.Manufacturer, Parts_Inventory.Description
FROM Parts_Inventory
WHERE (((Parts_Inventory.Manufacturer) Like "*" & [?] & "*"));

I'm using a text box as my control to the manufacturer field. If it
is blank, it will show all my parts.

I'm able to get this too work, but I don't seem to be able to add wild
cards.
SELECT Aisle, Rack, Shelf, QNTY, MFG_PN, Manufacturer, Description
FROM Parts_Inventory
WHERE (Manufacturer = ?)
ORDER BY Aisle, Rack, Shelf, Manufacturer, MFG_PN

Is there anyone familiar with this?
 
I'm trying to write a query for my Dataset's table adapter.  It is
linked to an access 2003 database.  Basically, I'm trying to duplicate
the following query.

SELECT Parts_Inventory.Aisle, Parts_Inventory.Rack,
Parts_Inventory.Shelf, Parts_Inventory.QNTY, Parts_Inventory.MFG_PN,
Parts_Inventory.Manufacturer, Parts_Inventory.Description
FROM Parts_Inventory
WHERE (((Parts_Inventory.Manufacturer) Like "*" & [?] & "*"));

I'm using a text box as my control to the manufacturer field.  If it
is blank, it will show all my parts.

I'm able to get this too work, but I don't seem to be able to add wild
cards.
SELECT     Aisle, Rack, Shelf, QNTY, MFG_PN, Manufacturer, Description
FROM         Parts_Inventory
WHERE     (Manufacturer = ?)
ORDER BY Aisle, Rack, Shelf, Manufacturer, MFG_PN

Is there anyone familiar with this?
Click to expand...

I was using the wrong wild card.

WHERE (Manufacturer LIKE '%' & ? & '%')
 
Back
Top