Check this out

Results 1 to 3 of 3

Thread: Check this out

  1. #1
    Join Date
    Dec 1969

    Default Check this out

    I need to query data. There are 3 columns. col a has a p/n col b has the new p/n and col 3 has desc. I want the user to be able to query the new or old part # but bring up the same description.<BR><BR>Example if a query pn 12345 I want it to bring up the same part number as 09876 each number is the same description.<BR><BR>Thanks<BR>

  2. #2
    lagerBoy Guest

    Default Like this?

    SELECT PartsNumbers.new_pn, PartsNumbers.old_pn, PartsNumbers.desc<BR>FROM PartsNumbers<BR>WHERE (((PartsNumbers.new_pn)="12345")) OR (((PartsNumbers.old_pn)="09876"));<BR>

  3. #3
    Join Date
    Dec 1969

    Default RE: Like this?

    Excellent..<BR>Yes thats it.. I thank you kindly.<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts