Why do I get a "Enter Parameter Value" when I launch my MS Access request?

In my query, I use a function IIFto assign "Before" or "After" to a field named BeforeOrAfterwith AS.

However, when I run this query, the Enter Parameter Value dialog box appears asking for a value for BeforeOrAfter. If I remove BeforeOrAfter DESCfrom the sentence ORDER BY, I will not get a dialog.

Here is an abusive request:

SELECT
    d.Scenario,
    e.Event,
    IIF(d.LogTime < e.Time, 'Before','After') AS BeforeOrAfter,
    d.HeartRate
FROM
    Data d INNER JOIN
    Events e ON d.Scenario = e.Scenario
WHERE
    e.Include = Yes
ORDER BY
    d.Scenario,
    e.Id,
    BeforeOrAfter DESC

Question: Why is mine AS BeforeOrAfternot recognized by the sentence ORDER BY? Why is he asking me to enter a parameter value for "BeforeOrAfter" when running this query?

. , , .., .

+3
1

I beleive Access , IIF- Order By -clause. ( , Access ).

+5

Source: https://habr.com/ru/post/1737584/


All Articles