Search results

It worked!. I really appreciate your input, I've been on this on and off for 2 days. thank you so much along with everyone else that replied.

#error is what I'm getting once I add the second criteria

I'm trying to get the actual Work_ID linked to the SO No and Line_No,

Access World, I'm currently in a bind with Dlookup feature in MS access. I have tried in many different formats mentioned in various forums and websites but i just have not been able to get the "AND" function to add second criteria. Any help is very much appreciated...