Search results

I am not an expert with access and appreciate any advice on the following query. I'm tring to select the first occurance of a faculty member identified teaching an online section. So far, I have this information and access does not like. Thank you, SELECT DISTINCT min[term], [emplid]...

As you can see, I'm not an expert and appreciate both suggestions. I have created the additional table and linked the fields - WONDERFUL SUGGESTIONS EVERYONE! Again THANKS! Mel

I've come this far trying to create an if statement as I do not know VBA. Can someone help me determine how and where to place the missing verticle bar? I'm not even sure I know where to locate such on the keyboard ;-0 Thank you for your help! Mel IIf(If[TERM]= '2122', 'Spring...

Does anyone have an idea as to why "Copy HS Diploma" still shows up when i run this query? I'm sure I'm missing something. I would like to replace the wording with nothing or a dash. Thank you for your help, Mel Meets SACS Criteria: IIf([How Criteria Met?]="Copy HS Diploma","-",IIf([How...

I changed the code and placed it in design view under criteria (carefully to How Criteria Met?): IIf([How Criteria Met?]="Copy HS Diploma","-",IIf([How Criteria Met?]="GED","-",IIf([How Criteria Met?]="High School transcript;","-",[How Criteria Met?]))) It ran and I didn't lose records...

Thank you Pat, Let me warn you - I'm a beginner/moderate access user . . . I have found that if I use the code Replace(Replace(Replace([How Criteria Met?],"Copy HS Diploma",""),"GED",""),"High School transcript;","") I lose records - about 25 or so. So what you are describing above sounds...

Hello experts, I was able to utilize the replace feature with one table but now am having difficulty coding it to work with multiple joined tables. This works with no joined tables: Replace(Replace(Replace([Degrees],"Copy HS Diploma",""),"GED",""),"High School transcript;","") What I've...

Well that will teach me!!!!!! I will need to start using notepad to draft queries instead of MS Word - it worked - thank you, thank you, thank you :)

Thanks! I'll give it a try shortly! Mel

I'm new to Microsoft Access Help Center. I've frequently browsed this site when I have questions and found it most helpful. I currently work at a community college and this is my First Forum - all new to me. Mel

Hi, I'm new to the forum and hoped I could get advice on how to make my Replace function work in Access 2010. I'm trying to remove two statements in my colum and I can get one to remove but have difficulty (brain freeze) on how to make multipe. I do not know VBA only took a beginning Sql...