Search results for query: *

That worked PERFECTLY! THANKS!! I really appreicate it!

Thanks for the help, one more quick question: Where do I enter this code? Is it entered on the SQL view or somewhere else? Thanks again CrimsonLily

Please help! I need to know how to create a query that will tell me, when I give it a specific date, all the records that were created before that date. i.e. All the files dated before March 31, 2002. Any advice that you can give me would be greatly appreciated! Thanks again! CrimsonLily

Ok :) Thanks again Rudy & Coco, for all your help. I appreciate it greatly!!! CrimsonLily

Thanks for all the help! I really appreicate it. What should I change my regional settings to? Thanks for the addition to the code, I believe it did fix the problem.

The data type of the DOB field is date/time(short date). Would I be better off changing it to longer date? I changed the code and it still gives me those 2 negative numbers. It just doesn't make any sense. They are both under 30, and so are days of the month. Could it somehow be confusing...

The negative number that it's giving me are: 9/22/29 -27 4/8/27 -24 From what I've figured those number are exactly what the actual age is minus 100.

They are 4/8/27 & 9/22/29

Ok now I have a question about the results. A couple of the ages are showing up as negative numbers. Is there something I can do to remedy this? Thanks so much

That is so AWESOME!! THANKS so much!! I can be a bit dense sometimes. I appreciate your patience and your help greatly!!! Thanks Again CrimsonLily

I don't know a whole lot about Access so let me double check this code with you :) OK, so if my birth date column in my table is called DOB & my table is called People SELECT date(04/15/03) , thedate as birthdate , year(date()) - year(thedate) - iif(month(date())>month(DOB),0...

r937: do I add this code into Modules?

This is great. One more question: What would I need to do to this code so that it doesn't prompt me for a date. I just want it to figure all of the ages for all of the people in a column. Thanks so much for your help!! I've never had a response so quickly before :) CrimsonLily

Ok, I've got a database that lists people by date of birth. And for a project that I'm doing I need the actual age in years. Is there a query that will calculate a date of birth into an age in years?? Please help, I don't even know where to begin. Thanks!!! CrimsonLily

Thanks for all your help. I think I got it. I created a couple of macros to open the queries, then went to the switchboard manager and chose for it to run a macro. Thanks again for all your help :) Jen

Thanks so much for your help. It WORKED! :) I'm so HAPPY :) Thanks again! Jen

I'm not very knowledgable about Access, so please bear with me :) What I want to do is, I guess, kind of like opening a form from the switch board, but opening a query. My switchboard is created as a table and looks like this: SwitchboardID ItemNumber ItemText Command Argument 1...

Ok, I've got a switchboard set up that lists several queries. I can't seem to get them to run using the switch board. When I click the button I get an error message. If you need more info to help me, please just ask, I'm happy to supply it :) Any suggestions would be greatly appreciated...

Is there a way to add an option on a switchboard that will run a specific query? I've got it so that you click a selection and a list of possible queries pops up, and this is where the problem occurs. I can't seem to get it to run any of the queries from the form that pops up. Any suggestions...