Search results

Thanks.. It works!!

It is a query Thanks it works when I use an existing date from my tables and simple X and Y as true. However I would like also to add that the person still is alive: [2]![Status]="alive" My dates are generate via a baseline date from table “2”: Mydate = DateAdd("d";12;[2]![Baseline])...

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...

Sorry I don´t understand what you mean with expand and "Code tags"? Can you explain it to me even simpler :confused:

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...

Well, it works now with datatype=date and with I tried with a 5 to test if it works today (I have changed to 6 now, and will see tomorrow if it is working)

I got it now - I had to go in and change the datatype to text (it was date) Thank you for your help I really appreciate it

thanks for your help, but still not working (however i don´t get any massage - the field just stay blank where it shouldn´t be)

IIf((Date()+1=DateAdd("d";12;[Baseline]![Baseline dato]) And Weekday(Date();vbSunday)=vbFriday And [Person]![Status]="Participate") OR (Date()+2=DateAdd("d";12;[Baseline]![Baseline dato]) And Weekday(Date();vbSunday)=vbFriday And [Person]![Status]="Participate");"Send";"") I get a Message...

Weekday(Date(), vbSunday),is not working either

It does not help

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...

Thanks.. for your help

I will try to explain a little more. We have a date (Date 1) for the day the person is entered into the database. Further I have made several queries to calculate the date coming 2-3-4 etc. week after Date 1. Which are called Date 2, Date 3 etc. On these dates we want to contact the person...

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...