I
idta
Hi there, I want to put a text box in a report that refers to the 1st
row in a specific column in another table.
Any help?
row in a specific column in another table.
Any help?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Duane Hookom
Have you considered using DLookup()?
I
ida
Yes but I could not get it to work. It keeps asking me to enter in the
parameter? It was forcing me to use the expression builder.
parameter? It was forcing me to use the expression builder.
I
ida
I should mention that the report is not based on the table I am trying
to pull data off of. And the table that I am trying to pull data off of
only has one row.
to pull data off of. And the table that I am trying to pull data off of
only has one row.
I
ida
Alright, figured it out. I am new at VB programming specifically so I
was trying to find some information on how to use the syntax. Came upon
a microsoft wbsite from msdn and bingo.
=DLookUp("[LastName]", "Employees")
I think my criteria was screwing it up.
was trying to find some information on how to use the syntax. Came upon
a microsoft wbsite from msdn and bingo.
=DLookUp("[LastName]", "Employees")
I think my criteria was screwing it up.
D
Duane Hookom
So you have
-only one employee or
-all employees share the same last name or
-you don't care which last name is returned
-only one employee or
-all employees share the same last name or
-you don't care which last name is returned