Search results for query: *

I Changed the null tests into nz and I found out that I have forgotten to test the null value of "Datum herstelmelding". That solves the problem. Now I have to change the date constants into data variables. The code :SELECT Verzuim.RelID, Verzuim.[Datum ziekmelding], Verzuim.[Datum...

Hello, I Try to calculate the number of days someone is ill. I use the following Query : SELECT Verzuim.RelID, Verzuim.[Datum ziekmelding], Verzuim.[Datum herstelmelding], Verzuim.Maandnz, Verzuim.[Aantal uren ziek], CInt([B])+CInt(([Datum herstelmelding]-IIf([Datum...

Hallo PHV, Once more you heave given me the right solution! Thanks! Small question, where can I find the rigth syntax or is there a way to see what is missing? Best regards Apestaarten.

I try to use Dsum to sum the ours ill for a particulair location whereby the recover date or the moth still ill are valid for a month. Here under my code : [code]Ziekteuren = DSum("[Aantal uren ziek]", "Verzuim Query1", "[StationID] =" & StationID & " AND (Datepart('m',[Datum herstelmelding])...

Thank you PHV, You ask the right question. I managed to solve the problem with conditional formating. Thanks also BUBBA100 Regards, Apestaarten

I did. But the the conditional format is then dependent of an other recordset. See here under the code. Private Sub Form_Open(Cancel As Integer) Dim jaar As Recordset, strSQL As String, rst As Recordset strSQL = "SELECT * FROM Jaar" Set jaar = CurrentDb.OpenRecordset(strSQL) strSQL = "SELECT *...

Hi, In a recordset (Access 2007)I select a record using the find methode (rs.find(expession)). I find my record and I want to change te background color of one of the fields. In my case rs!day. I don't know how do this. Who can help me? regards Apestaarten