Sammenligning af datoer med IIf() og CASE

Still cant use CASE in Access :-)


I assume you are doing this in a query, so I would suggest using the Expression builder to help you get the syntax right.

Right click in the field and choose Build

Your also welcome to send your dB to me and I'll try see what the problem is.

ekspertenATsanthell.dk
AT = @

Jeg dropper CASE udtrykket :-)

Jeg må heller komme med den lange forklaring så.

Jeg prøver at samle noget data fra vores sagsbehandlingssystem i Acces så det bliver nemmere at rapportere på.

Jeg har to tabeller som oprettes i Access via ODBC pass through queries ned i en MS SQL database. Tabellerne har jeg kaldt: Change Data og Task Data.

Disse to tabeller joiner jeg så i en forespørgsel og vil her gerne nøjes med at have den nyeste af datoerne i hhv.
[Change Data]![Last_Modified_Date]
og
[Task Data]![Modified_Date]

Jeg bruger Expression Builder allerede, så jeg spekulere på om det er Dato formatet jeg ikke kan bruge i IIf().

@Terry: assume it's ok to write in Danish :-)

@Terry: assume it's ok to write in Danish :-)

Yes :-)


Now I see why you placed your question in MS SQL ...

If you have two linked (ODBC) tables in Access you should be able to make an Access query and use Access syntax (IIF). If you make a passthrough query (execute SQL on SQL server) then you need to use SQL Server syntax (CASE or whatever ..).

So you have an Access query which works (doesn't give an error) but just doesn't give you the right answer?

Could be date format, maybe try formatting date in query ..

You could also make stored procedure in SQL server and call this to give you result.

I'll have a play around and get back ...

this works

IIf([Change Data].[Last_Modified_Date]>[Task Data].[Modified_Date],[Change Data].[Last_Modified_Date],[Task Data].[Modified_Date]) AS [Sidst sagsbehandlet]

change ! to .

.

don't forget to accept answer if it works :o)

.

Thanks Johan