does Access have WITH clause?

[johnseito]

similar to some other SQL codes, such as sequel server



something like this,

If not, how can access adjust to this? Thx

;WITH t100 AS(
 SELECT n=number FROM master..spt_values WHERE type='P' and number between 1 and 100)                 SELECT    ISNULL(NULLIF(    CASE WHEN n % 3 = 0 THEN 'Fizz' Else '' END +    CASE WHEN n % 5 = 0 THEN 'Buzz' Else '' END, ''), RIGHT(n,3)) FROM t100

[ItsMe]

I am not an expert but I would assign my SELECT statement to a declared DAO recordset. Something like Set rcd = ""

Then you can do something like... WITH rcd.

I believe you can use the CASE statement within your SQL. You can build an Access query and put something in the criteria field at the bottom of the querry window. Then check SQL view to see what it looks like.

Not sure how the IF statement will fit in though.
Oh, and you close WITH using WEND. Just going off memory here so....