Search results

Birdy: No, the user does not enter a month at the start. The date the query is run is the date which also specify the month for the customers. Now I got it: I show only the important part of the select sentence: WHERE (((FormatNumber(Mid([DOB],3,2),"0","0"))=Month(Now())) And ..... Don't mind...

How do I change the "[Enter Month in Digits]" (a parameter question to the user) into a computer lookup for the month the user is running this query? Is it possible to use the Now() and Month() and translate it into text with leading zeroes ?

It's not a quiz. It's not a kind of homework or to get good marks. I work in a bank in Norway and I want to send letters (DM) to our insuranse customers that has child and youth insuranse and are going to be 20 years old in April, May, June a.s.o. When these customers become 20 they are not...

I have a table with a field for the persons birthday with the content like "220361" that means March 22 in 1961. The 3. and 4. digit is for the month. I want a query to select all persons that are born in the present month. In March the persons that are born in March are selected. In April the...