M
mate
I have a query using 4 tables. One field is order
number. there can be multiple entries with the same
order number. another field is vendor number. Some
values in this field are "/" for certain orders. I want
to have all orders that contain "/" to be removed.
example of two entries with same order number and
different vendor number:
order# vendor#
123 789
123 /
When i type <>"/" in the query design in the vendor#
criteria field and run it, it removes both entries above
when i only want it to remove the one where vendor# is "/"
any help or direction would be greatly appreciated.
thanks and have a great day all. mate.
number. there can be multiple entries with the same
order number. another field is vendor number. Some
values in this field are "/" for certain orders. I want
to have all orders that contain "/" to be removed.
example of two entries with same order number and
different vendor number:
order# vendor#
123 789
123 /
When i type <>"/" in the query design in the vendor#
criteria field and run it, it removes both entries above
when i only want it to remove the one where vendor# is "/"
any help or direction would be greatly appreciated.
thanks and have a great day all. mate.