I am trying to use a DLOOKUP in a report To lookup a value in a
stored
query from information that is the report. I have a report that
gives
me a customers parent account name and I am trying to then use that
parent account name to look up a comment stored in another query.
This is how my formula looks

=DLookUp("TXTFIELD","Query","Query.ParentAccount"="ParentAccountFromReport"*)


Any sugesstions?

You'd likely be better off using a query that combines the two tables, and
use that table as as the RecordSource for your report.

As it stands, your syntax is incorrect: the equal sign needs to be in
quotes, and, unless ParentAccountFromReport is a constant text value, you
don't want quotes around it:

=DLookUp("TXTFIELD","Query","Query.ParentAccount=" &
ParentAccountFromReport)


--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


<(E-Mail Removed)> wrote in message
news:5844b551-fa84-41d8-bd02-(E-Mail Removed)...
I am trying to use a DLOOKUP in a report To lookup a value in a
stored
query from information that is the report. I have a report that
gives
me a customers parent account name and I am trying to then use that
parent account name to look up a comment stored in another query.
This is how my formula looks

=DLookUp("TXTFIELD","Query","Query.ParentAccount"="ParentAccountFromReport"*)


Any sugesstions?

You'd likely be better off using a query that combines the two tables, and
use that table as as the RecordSource for your report.

As it stands, your syntax is incorrect: the equal sign needs to be in
quotes, and, unless ParentAccountFromReport is a constant text value, you
don't want quotes around it:

=DLookUp("TXTFIELD","Query","Query.ParentAccount=" &
ParentAccountFromReport)


--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


<(E-Mail Removed)> wrote in message
news:5844b551-fa84-41d8-bd02-(E-Mail Removed)...
I am trying to use a DLOOKUP in a report To lookup a value in a
stored
query from information that is the report. I have a report that
gives
me a customers parent account name and I am trying to then use that
parent account name to look up a comment stored in another query.
This is how my formula looks

=DLookUp("TXTFIELD","Query","Query.ParentAccount"="ParentAccountFromReport"*)


Any sugesstions?

(E-Mail Removed) wrote:
> I am trying to use a DLOOKUP in a report To lookup a value in a
> stored
> query from information that is the report. I have a report that
> gives
> me a customers parent account name and I am trying to then use that
> parent account name to look up a comment stored in another query.
> This is how my formula looks
>
> =DLookUp("TXTFIELD","Query","Query.ParentAccount"="ParentAccountFromReport"*)
>
>
> Any sugesstions?

Add the query to the RecordSource of the report and the value will be available.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

>wy may name ys



"(E-Mail Removed)" escreveu:

> I am trying to use a DLOOKUP in a report To lookup a value in a
> stored
> query from information that is the report. I have a report that
> gives
> me a customers parent account name and I am trying to then use that
> parent account name to look up a comment stored in another query.
> This is how my formula looks
>
> =DLookUp("TXTFIELD","Query","Query.ParentAccount"="ParentAccountFromReport"Â*)
>
>
> Any sugesstions?
>