Search results

All the fields I'm using for the IIf statement are contained within the same table and form. Which is why it's puzzling me so much.

Cheers for your assistance - however it is still coming up with #Name? I have double checked all the names for relevant fields and I've checked the brackets and commas required, but it's still not working - I'm completely stumped. You were correct in assuming that I want it to say "yes" if...

Hi! I'm trying to create an IIf statement which will produce a yes or no answer, what I want to say is: =IIf(([Case Study Actual Grade]=”A”,[Audit Actual Grade]=”A”,[Exam Actual Grade]=”A”,[Project Actual Grade]=”A”),”Yes”,”No”) but it keeps coming up with #name? Can anyone assist me on this...

Hi, thanks for responding, in answer to your queries, I don't think it would be feasible to us just the Distance Delivery spec as a filter, as ideally I just want the one specific record to show (as it will be non-access users inputting data and I'd rather data wasn't able to be misplaced) I...

Cheers for your reply AlanS I've tried it but it's coming up with the message that it contains an invalid syntax. I've had a look at all the comma's and brackets but can't see anything wrong with what you gave me. Any chance you could shed some light on the subject? Cheers! :)

Hi! I'm currently transferring a load of data from an excel file to Access 2000 as part of designing our new database. I need to recreate the following Excel formula so that it works in Access: =IF(AND(G16>=15,M16>=15,Q16>=15,W16>=15),(G16*0.15+M16*0.15+Q16*0.3+W16*0.4),"") With G16=[Case...

Hi! I have a problem with a combo box in my form, which when having specific data selected from it (e.g. in this case "Distance Delivery") displays a pop-up form to request information from the user. Unfortuantely I can't seem to make the pop-up form display only the current record (rather...