Hi all,
trying to speed things up in the office but having a headache from this problem. Fairly new to access but learning more each day!
We have two forms of information from our vendors containing ticket numbers and cost per ticket. Because of the difference in the format,it has to be manually checked to ensure that there are no errors.
Table 1:
Ticket No Cost
415253 -
414254 $60
414255 $60
414256 $60
Table 2:
Ticket No Cost
415253 -
414254/414255/414256 $180
Is there a way to compare Table 1's Ticket No with Table 2's? And at the same displaying the cost of a singular ticket?
Tried using DLookups but they don't seem to work..
trying to speed things up in the office but having a headache from this problem. Fairly new to access but learning more each day!
We have two forms of information from our vendors containing ticket numbers and cost per ticket. Because of the difference in the format,it has to be manually checked to ensure that there are no errors.
Table 1:
Ticket No Cost
415253 -
414254 $60
414255 $60
414256 $60
Table 2:
Ticket No Cost
415253 -
414254/414255/414256 $180
Is there a way to compare Table 1's Ticket No with Table 2's? And at the same displaying the cost of a singular ticket?
Tried using DLookups but they don't seem to work..
