Jump to content


This topic is now archived and is closed to further replies.


Calling more than one query

Recommended Posts

Could I use an if statement with say

[b]goto location_id if contains "ecen" goto location_id_2 [/b]

If this is possible could I also add

[b]if location_id_2= ecen goto location_id_3 etc[/b]

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

Recordset below

[b]SELECT autonumber, coName, location_id
FROM preferredSuppliers
WHERE location_id = 'ecen'
ORDER BY coName ASC[/b]

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


Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.