Recent content by Guinifi

Ok John, Please don't knock yourself out about this. I'm just trying to learn this thing to help my business a little, but it's not a crisis, heh heh. I really appreciate your help. Take your time. It's Sunday morning here and we're getting set to move along to church here in a few minutes. By...

Thanks John, I've moved the criteria to the criteria line in the calculated field column which is titled "Upcoming_Birthday". Now, when I run the query, I get an error msg saying "data type mismatch in criteria expression". Once again, thank you. Guinifi

Yes, my intent is to get a return of all records where the birthday falls in the next ten days. If I remove the criteria completely, the query returns ALL records. As I said, I just used the -10000 to see if it would give me past birthdays, and it does perfectly, because it's looking at the...

Hi John, I guess we're posting at the same time. As I said, when I run the query at a -10000, I get results for all the people who are 27 years old and less. And the c_DOB field is already set to "date". Thanks again for your assistance. Guinifi

I've just discovered something. The query is still looking at the year. When I change the query to this: Between Date() And Date()-10000 I get the desired results. So the code I've placed in the field line is not doing anything, it seems. Guinifi

Ok John, I guess this is on the right track, but still a problem. When I entered the code as instructed and ran the query I got a pop-up box asking for input on "birthday". It occurred to me that it is looking for a field in the record named "Birthday". My birthday field is designated as...

Thanks JOhn, I've tried this, cut and paste and also typing it in by hand, being careful of course to get it right. In both instances i get this error msg: "The expression you entered is missing a closing paranthesis, bracket (]), or verticle bar (|)." hmmm Guinifi

Hi John, and thanks for your quick reply. Since I'm extremely new to this Access thing, I only opened the program for the first time the day before yesterday, I have another question. I know I put the Between Date() And Date()+10 in the criteria line. Where do I put the code...

Hi, I'm new to the forum and have learned alot just lurking but I can't seem to find what I am looking for specifically. I have a table of clients and a field for their birthdate. This birthdate field included month, day, and year. I want to do a querry to see who's birthday is coming up in the...