Search results

This might not be the best way to do it, but change your query to a make table query, and when someone enters the criteria on the form, run that query. Then just have word reference that table instead of referencing that query.

where does "Sally" show up twice? Which of her 2 entries do you want to take?

that was exactly what i wanted. Thanks!

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

This almost works for me as well. I had to change it to tgtNum=left(regnum, instr(regnum,"/")) but it returns the "/" as well. is there a way to omit that?

I achieved the results i wanted by using dsum. I needed to use multiple criteria to sum something, and dsum worked like a charm.

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

that worked. Thanks

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