Dlookup in Report

A

Alex

In my report control, I'm trying to show a value of the Password field in the
InstructorsLogOn table where the System field in the same table equals
"Network".

I've tried several ways of writing it and keep getting an error msg. Any
ideas why?

This is one example of what I've tried.
=DLookUp("[Password'","InstructorLogOn",'[System] = "Network"')

Thanks so much
 
A

Alex

Perfect! Thanks so much!

Ofer said:
Try this

=DLookUp("Password","InstructorLogOn","System = 'Network'")


Alex said:
In my report control, I'm trying to show a value of the Password field in the
InstructorsLogOn table where the System field in the same table equals
"Network".

I've tried several ways of writing it and keep getting an error msg. Any
ideas why?

This is one example of what I've tried.
=DLookUp("[Password'","InstructorLogOn",'[System] = "Network"')

Thanks so much
Click to expand...
Click to expand...
 
Top