PDA

View Full Version : Solved: Concatenate -Control Source



Victor
04-29-2009, 07:17 AM
Hi:

I have the following concatenation in a report text box control source:

="From : "&[FromDate]&" To: "[ToDate]

The problem is that when I run the report it works as a parameter query and keeps asking to enter [FromDate] and [ToDate].

Any clues why this is happening, so I can correct it.

Thanks for the help.

Victor

orange
04-30-2009, 07:17 AM
Instead of ="From : "&[FromDate]&" To: "[ToDate]
try
="From : " & [FromDate] & " To: " & [ToDate]

Victor
05-01-2009, 10:35 AM
Thanks, I found the problem.

I did not define fields in the table that were used in the query.

Victor