Search results

Can I generate an IIf statement with two-true values? I have these two statements but don´t know how to combine them: IIf((Weekday(date);1)=vbMonday or vbTuesday or vbWednesday or vbThursday or vbFriday;x;””) IIf((Weekday(date);1)=vbSaturday or vbSunday;y;””) I have at field with a date and...

I have 2 Table that I will like to search in. I want to be able to search on a date and get the “ID” and the name of the column the date was found. Is that possible? I am thinking some kind of a Search-box, that will give a table/report. The names of the tables are “2_PT_datoer” and...

I have an access database I have uploaded to a SQL server. However in the variables where I had predefined answers, it is not longer possible to choose from a list. It is possible to make the list of "predefined answers" in Access again, but for some reason it does that I can´t use the...

I have tried this code in queries. "Send" should only be showed if the current day is a friday, however I can´t get it to work: IIf((Date()+1=DateAdd("d";12;[Baseline]![Baseline dato]) And Day(Date())="vbFriday" And [Person]![Status]="Participate") OR...

I have a table with several (many) variables showing different dates. Is it possible to create a new variable that indicates whether one of the other variable containing today's date? How do I do it? If the above is possible, it is also possible to search for today + 1 and 2 days (we have a...