Jump to content

Archived

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

essential

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

Essential

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.