Search results

Hello, i am new to access and i'm trying to set up an access file with a form. I've gotten the form created with no problem. What i want to do now is when the file is opened, i only want the form to pop up, not the database information. I was unable to find any information in the historical...

Is it possible to nest a vlookup within another vlookup formula? Everytime i try, i get a #n/a. I would think that it should work, but i'm not positive on that. THe only way i've gotten around it is to use concatenate, but thats adds another step that i dont really want to do

When i'm summing up values in a column like "Hours:[production]+[nonproduction]" how can i have access treat blanks as zeros? I tried "Hours: IIf([nonproduction]="",0,[nonproduction])+IIf([production]="",0,[production])" and it just gave me a #value error