Hi everyone,
I am new to access and encountering the first real problem:
I have an access database where colleagues can enter their expenditures for various projects from January to December. I created a query with 13 columns, one for the project number and one for the expenditures of each month.
I now want to provide a simple form from which one can filter the query. In particular it should be possible to filter only those projects where no expenditures for a given months have been recoorded (i.e. the relevant fields are empty)
I have created a form with a combo box from which one can select the months from January to December and a subform in which the data from the query is displayed. It is supposed to work like this: When the user selects "January" from the combo box, the subform should display only the projects for which no expenditures in January have been recorded.
I thought to realize this by including filter criteria in each of the monthly columns of the query according to the following example:
IF[Forms]![Formname]![Comboboxname]="January";"Is null";"")
Somehow it does not work. What am I doing wrong here?
Thanks!
I am new to access and encountering the first real problem:
I have an access database where colleagues can enter their expenditures for various projects from January to December. I created a query with 13 columns, one for the project number and one for the expenditures of each month.
I now want to provide a simple form from which one can filter the query. In particular it should be possible to filter only those projects where no expenditures for a given months have been recoorded (i.e. the relevant fields are empty)
I have created a form with a combo box from which one can select the months from January to December and a subform in which the data from the query is displayed. It is supposed to work like this: When the user selects "January" from the combo box, the subform should display only the projects for which no expenditures in January have been recorded.
I thought to realize this by including filter criteria in each of the monthly columns of the query according to the following example:
IF[Forms]![Formname]![Comboboxname]="January";"Is null";"")
Somehow it does not work. What am I doing wrong here?
Thanks!