Search results for query: *

Hi, I've found something different and easier. Here is the query: SELECT Last(VERT_F) As Contrat FROM MA_VUNGEN WHERE (MAN = '85557732') AND (ABDAT <= 5143) With this one I always get the last contrat. Thanks for your time guys, it helps me to find another way. Nice WE

Hi Lespaul, If I try your query I get all the records that are before the defined date. That's not what I'm looking for; I just need the last closest to the date. Thanks anyway

Hi Jebry, I tried your solution but didn't get the expecting result. Here is the query now: SELECT (SELECT MA_V.VERT_F FROM MA_VUNGEN MA_V WHERE MA_V.ABDAT IN (SELECT MAX(MA_A.ABDAT) FROM MA_VUNGEN MA_A) AS Contrat FROM MA_VUNGEN...

Hi, I get an error message (cannot have aggregate function in where clause MA_V.ABDAT = MAX(MA_A.ABDAT) AND MA_V.MAN = MA_A.MAN) when I try to execute a query created in MS_SQL. I've tried to modify the query but always got an error. Maybe is it too simple but I don't see the solution. Here is...

Hi cmmrfrds, The Access MDB can reside on the server or on the client machine. It doesn't matter, just need to change the ODBC datasource on every client machine. First I let it on the server and then put the MDB on each client but same result. As I saw that Access was the problem, I took a...

Hi cmmrfrds, Thanks for your answer but it's not that, because the same Access database is used on all the PCs and it works without any problem on few PCs. How can it be possible that this windows appears for a small selection and not for a big one ? Thanks for any idea. ;-)

Hi everyone, Here is my problem. I run a query which works on some PC's but not all. Doesn't matter which version of Access I use. This query uses a MS_SQL linked table and is integrated in a Crystal report. This report is integrated in another application which uses a crystal report runtime...