I have a form where in the header i select record by selecting person by name, surname, date o birth. In the end there might be a thousand records per year.
This part works well.
Now I'd like to add a few checkboxes, that would limit the records range.
A checkbox that would only select children, Int(([bolnik]![DatumVpisa]-[bolnik]![DatumRojstva])/365,25)<15
a checkbox that would only select women etc, only those that have one or the other thing.
Is that possible?
I guess i'd have to put some kind of iff sentence - iff checkbox is true then only display records with this and this
But where?
sql of the combobox is like this
This part works well.
Now I'd like to add a few checkboxes, that would limit the records range.
A checkbox that would only select children, Int(([bolnik]![DatumVpisa]-[bolnik]![DatumRojstva])/365,25)<15
a checkbox that would only select women etc, only those that have one or the other thing.
Is that possible?
I guess i'd have to put some kind of iff sentence - iff checkbox is true then only display records with this and this
But where?
sql of the combobox is like this
Code:
SELECT all.ID, [surname] & " " & [name] & ", " & [DateBirth] AS Expr1, all.surname, all.name, all.DateBirth, all.[popis - travma]
FROM all
ORDER BY all.surname, all.name, all.DateBirth;