L
Linda L.
If the information is identical, use one table. Create
a query on the main table. To the new query add a
criteria for the item-sold field. The criteria would be
the value entered to indicate a sold item. This query
would give you only the sold items.
If you want only inventory items, create a new query and
add a criteria item-sold field. The criteria would be the
value entered to indicate an inventory item, which may be
a null (use IsNull). You can then use this new query as a
record source to your main table.
a query on the main table. To the new query add a
criteria for the item-sold field. The criteria would be
the value entered to indicate a sold item. This query
would give you only the sold items.
If you want only inventory items, create a new query and
add a criteria item-sold field. The criteria would be the
value entered to indicate an inventory item, which may be
a null (use IsNull). You can then use this new query as a
record source to your main table.