Concatenate FROM Clause

[Tyork]

I'd like to use the left, mid and right functions to populate information in the FROM clause of the following query portion.

 
FROM LetterEval & LEFT(Forms!LA_Main!ReportDate,2) & MID(Forms!LA_Main!ReportDate,4,2) & RIGHT(Forms!LA_Main!ReportDate,4)

I would like to use the query as the basis of a report but can't seem to get the correct syntax. Is this possible?

[Bob Fitz]

Hi

If you are creating a SQL string as the basis for a recordset, then the following syntax should work:

"FROM LetterEval " & LEFT(Forms!LA_Main!ReportDate,2) & " " & MID(Forms!LA_Main!ReportDate,4,2) & " " & RIGHT(Forms!LA_Main!ReportDate,4) & ";"

Hope this helps

Regards
Bob