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]...

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...

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...

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...