Search results

I need to display the corresponding NCR number for whatever id is the current record on the form. And if there is no NCR, I need the NCR field to say so, which is why I'm using the NZ function. =Nz(DLookUp("[NCR#]","Input Query1","ID = " & [Input Query1].[id]),"None") Modified the query in...

When I run this in the immediate window and in the control source, it brings back what I need. But when I try to expand the scope beyond the single record, I get the error.

It does make sense! However, no joy. Running it in the immediate window gets me a compile error - external name not defined. This is what I ran in the immediate window. ?Nz(DLookUp("[NCR#]","Input Query3","Input_ID = " & [Input_ID].[id]),"None") I know using that pound sign in the field...

I can't post the database but here is the SQL for the query: SELECT Input.ID AS Input_ID, Input.[Accept/Recheck], [Non Conformance].ID AS [Non Conformance_ID], [Non Conformance].[NCR#] FROM [Non Conformance] INNER JOIN [Input] ON [Non Conformance].ID = Input.ID WHERE ((([Non...

The ID field is an Autonumber field in the Input table. In the Non Conformance table, it is a number field. The values in the field when I run Input Query3 are right justified.

So I used this: =Nz(DLookUp("[NCR#]","[Input Query3]","ID = 291527"),"None") It now displays an NCR number on the record for that ID but it is the wrong one. It shows the very first NCR number in the query. When I tried this: =DLookUp("[NCR#]","[Input Query3]") I got back the first NCR...

Thanks for the suggestion but I had already tried that. I tried it again to no avail - still getting the #name error. I agree completely about not using special characters in field names. I didn't create this system - I inherited the problems. :) Any other ideas?

Here's the scenario: The Input form is tied to the Input table, which holds an Autonumber ID field. If the value of the Accept/Recheck field is equal to Recheck, a record is created in the Non Conformance table that includes the ID and an NCR number. What I am trying to do is display on the...

Hello everyone. I just signed up and wanted to say hi. I've been working with Access for about 15 years so I guess I would consider myself an Intermediate user. Some days I feel more advanced than others. ;) Right now I'm working a contract to repair and update the databases for a...