Search results

I get this error message when I run a make table query. The message is very generic. I ran for two periods (Dec-08 and Jan-09) I only get the error message in Jan data. I am not able to paste the long error message from MS Access in here so I am going type it out....please see below...

Here is the scenario: The teacher is evaluating math, science and writing scores of his students and award them with prices. Mark got A's in all three subjects will receive $50, Martha got 2 A's and 1 B will receive $40 and Megan got all B's will receive $20 etc. I have one table for each...

I want to replace a blank field in a table with letters AA. If the table has something in the name field, then return that field, if blank, then return AA. I've only written queries in design view. So I've tried something like IIF([tbl1]![name]="","AA",[tbl1]![name]). I guess Access doesn't...