Search results

ummm I'm no genius and really dont have a clue so dont lidten to me but... couldnt you have your query +1 to a table and look at that table each time in the loop to check if its the number you want? probably not but sounds logical to me lol

Sorry I'm not great explaining things, I'm still confused to wether my query does act in the way I want it to

But isnt the module going a bit over board? I tried:- NewAge: (DateSerial(Year(Date()),Month([tblMembers.Dob]),Day([tblMembers.Dob])))- (DateSerial(Year([tblMembers.Dob]),Month([tblMembers.Dob]),Day([tblMembers.Dob]))) And as I'm sure your know that didnt do it lol My thinking behind mine...

I understand what your saying but I dontthink its needed. correct me if I'm wrong though but this is my reasoning why its not. The query returns the peoples whose birthday falls into the future. say you select 7 when asked you get all the peoples who's birthdays are in the following week (check...

I know this is bumping and sorry but I thought I'd say thanks. I've used both of your help. ScottGem I used your solution but changed the criteria too: Between Date() And Date()+[Please enter how many days from today you wish to be displayed: ] So it could have any number of days, decision is...

The title tells it all really. I need a way to take a list of records with the field D.o.B in short format e.g. 12/10/1990 and be able to find out who's birthday it will be in the next week. I cant find a way to take the date of birth and search it to find, say the week starting 11/10 and get...