Text Box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

awalker - 06 Mar 2008 21:33 GMT

Hi,
I have a report that pulls from a cross tab that comes from a make table
querey. In the report I need the ability to have a text box where the agent
can enter certain data when promoted. For example =[Enter End Date] or
=[Enter Reporter Name] However, when I enter this into a text box I am
recieving a error that states that it is not reconginzed as a valid field
name or expression. How do I get around this?

Reply to this Message

Rob Parker - 06 Mar 2008 21:50 GMT

Omit the = sign at the start of your expression.

HTH,

Rob

> Hi,
> I have a report that pulls from a cross tab that comes from a make table
[quoted text clipped - 4 lines]
> recieving a error that states that it is not reconginzed as a valid field
> name or expression. How do I get around this?

Reply to this Message

Duane Hookom - 06 Mar 2008 21:54 GMT

This question gets asked a lot. You need to specify the data types of the
parameters. If you can't figure this out, GOOGLE is your friend (or come back
here).

Signature

Duane Hookom
Microsoft Access MVP

> Hi,
> I have a report that pulls from a cross tab that comes from a make table
[quoted text clipped - 3 lines]
> recieving a error that states that it is not reconginzed as a valid field
> name or expression. How do I get around this?

Reply to this Message