Same SQL string works as form record source, but fils whe it is used to open form

  • Thread starter Thread starter David G
  • Start date Start date
D

David G

I have a SQL phrase that works fine as the reco look like.?
r a form. When I try to use the same SQL text to o;en a report I get
an error meesage saying a parameter was expected, then the report
operation would be cancelled.

I/ve tested it a number of times with consistant resultd.It is a very
long SQL statement that uses seversl subqueeries to pull together the
requiired fiekds. One of the fiekds is an alias name representin a
value returned by a custom functio.

Thr odd part is that the form enterprets the SQL as expected. The
report on the otherhand interprets it diffrently

Are there any know discrepencies between what the sql

I try to describe the problem in general terms to see if there is
intrest in resondubg tu my issues, Be even more happier to supply
additiohal details.
Any comments are greatly appreciated!
 
If the query is using a reference to a control on a form, then that form
must be open when you try to open the report. You'll have to post the SQL
statement of the query for us to give you more specific suggestions/answers.
 
Back
Top