[ACCESS] Query and IF THEN ELSE....is possible?

T

tranky

Hi Boys,
i'm italian and i need your help!
Is there the possible to realize an access query like this?

IF SELECT ETC...ETCCC.... IS BLANK THEN
DO ANOTHER QUERY (AN INSERT QUERY FOR EXAMPLE)
ELSE DO OTHER

I search it to google, but no results.
Can you help me?
Thank u!

:) Is Possible?

Can i use macro for do it? In what manner?
Thank u so much![
 
D

Douglas J. Steele

You can't use a Select query in an If statement like that.

Depending on exactly what your SQL was suppoed to be doing, you could either
use DLookup, or open a recordset and look at whether the recordset has any
rows.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ASK Field Formatting 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
How to create portable Excel applications? 2
Running balance for debit and Credit using query in Access 2007 0
query to show where no data in a stated column 0
can't find the right query 0
#error - Blank 3
If/Then/Else Query 6

Top