Search results

Dudes! Never mind - I answered my own question... the format was the problem. Had to input <#03/16/80#, instead of <#03/16/1980#, even though Access changes it to a 4-digit year anyway. Go figure. :D

Ok - I've been searching, but not finding, so I'll put it out there, and maybe one of you talented folks can give me the simple answer that's been eluding me all afternoon... I need to pull all the records from my db of students over the age of 25. I thought perhaps I could use a simple < or >...

Well now that didn't take long. Ok, this is what I've done: In the query design grid, I have added 2 new columns: Field: Month: DatePart("mm", [DOB]) Table: tbl2004_2005Student Sort: Ascending and Field: Day: DatePart("dd", [DOB]) Table: tbl2004_2005Student Sort: Ascending When I save it...

I'm a self-taught Access user, so some things are a little muddy for me... Sonny, your answer sure did sound good - I just wasn't sure of the application! The_Doc_Man - let me look into that DatePart function and see if I can make it work - that sounds like what I'm looking for. Good thing I...

Call me thick, but that didn't make any sense to me. First: What does MID mean? Second: Where do I put that information? I have a Date/Time format from the original table, 99/99/0000,0,0. Not using a text field. Are you suggesting I create a second field in the report and use...

Happy New Year all! I'm new to the forum and have been lurking for a few weeks... gotten some very good answers to my questions. I have been searching and searching for the answer to a particular problem, which could fall under either reports or queries, I'm just not sure which is the...