Search results

Thanks, managed to get it to work by finding another thread on here with the following code: IIf(IsNull([Forms]![SearchF]![AANTAL MAANDEN MEER DAN]);True;[aantal maand test]>[Forms]![SearchF]![AANTAL MAANDEN MEER DAN]) and <>False in criteria.

So I have a multifield search form that searches the database. I have fields that if left blank will be ignored (or rather, display all results). However, I have a field that a person can fill in a number, and it'll display all results from the database that are less than said number. Which...

Yes it is.

Oh yeah no it wasn't working, as I had that code as a separate query, not set up as an expression in the database itself (I'm terribly sorry if I'm using the wrong terms, this is literally my first time working with anything like access). It didn't work as a query, so I edited it a bit and...

IIf([Aantal maanden sinds laatste verslag]=999;"Dossier afgesloten";IIf([Aantal maanden sinds laatste verslag]<12;"normaal";"Jaarverslag buiten termijn")) Is my code right now, which is set directly in the database as a calculated field, which does seem to work, is this correct or is there...

I've done so and also removed the equals sign, I'm not sure why/when I put that there, that obviously doesn't make sense. If I change the column in my database to a number field instead of text, it doesn't run the query on any field at all.

Hi all, I'm having some issues with populating a column in a database with a query. The idea is that it would fill in certain terms depending on a value of another column in said database that is also populated by a query. I've managed to get said column populated by a query which subtracts 2...