Recent content by marc515151

Thank you all for being so patient! and so extremely helpful! greatly appricate all your help and support!

http://www.centrepointbowl.com/access/Database02-03.mdb Many thanks!

i renamed the table when i looked at what you had wrote. I give up! in way over my head lol. But this might be the easiest option. Here is the file itself if you dont mind looking at it. http://www.centrepointbowl.com/access/Database.accdb

Below is what my query is looking like. in that first field i have the following entered into it. SELECT LastName, FirstName, DOB, DateDiff("d",DateSerial(Year(Date()),Month([DOB]),Day([DOB])),Date()) AS Upcoming FROM tblClients1 WHERE...

ok ill try post 10. ill rename the fields, just one question, do i add that into the field part of my query, like i did with the other one?

sorry brian i have found a problem when testing this before putting it into use. If a birthday is on say 31/10/1986 and i do a search between 20/10/2009 and 31/10/2009 = the birthday shows up. If i do a seach between 20/10/2009 and 01/11/2009 = i get no result at this moment i only have...

Brian i would like to thank you so very much!! i have got it to work with your help and it is greatly appriciated! Very greatful, Marc

Thats strange, i only uploaded it to imageshack. I apoligize for that if it had anything to do with me, ive uploaded the image to my own webserver where i no it is safe.

Right here is what i have. Now in the table i have my date of birth entered as 18/10/1986. Everytime i run the query i dont get any results. --LINK REMOVED --

im sorry for sounding stupid but where do i put the: DateSerial(year(date()),month(dob),day(dob))-date()

Hey all, I am very new to access 2007, i can do the basics of creating tables, queries and reports. nothing too fancy. I have a list of records of customers with DOB as one of the fields set as date/time. I need to have a query that will look at the dates and show records whos birthdays...