Jump to content


Photo

Calling more than one query


  • Please log in to reply
No replies to this topic

#1 essential

essential
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 22 July 2006 - 03:02 PM

Could I use an if statement with say

goto location_id if contains "ecen" goto location_id_2

If this is possible could I also add

if location_id_2= ecen goto location_id_3 etc

I have tried tweaking the recordset but it just throws up an error.

Recordset below

SELECT autonumber, coName, location_id
FROM preferredSuppliers
WHERE location_id = 'ecen'
ORDER BY coName ASC


How easy would it be to alter this to give me what I need

Essential





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users