[AccessD] Data Access Pages

Susan,


Here is the sql statement.  Hope this helps.  Why so many restrictions on 
DAP's?

SELECT CardInventory.item_no, CardInventory.item_desc_1, 
CardInventory.prod_cat, CardInventory.loc, CardInventory.item_weight, 
CardInventory.user_def_fld_1, CardInventory.user_def_fld_2, 
dbo_IMLSMST_SQL.ser_lot_no, CardInventory.user_def_fld_3
FROM dbo_IMLSMST_SQL INNER JOIN CardInventory ON dbo_IMLSMST_SQL.item_no = 
CardInventory.item_no
WHERE (((CardInventory.loc)="c"));



Julie Reardon-Taylor
PRO-SOFT OF NY, INC.
www.pro-soft.net

_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE*  
http://join.msn.com/?page=features/virus