Subject Re: Preview.wfm and report printing From trevor <bob@bob.com> Date Thu, 02 Nov 2023 17:59:37 -0400 Newsgroups dbase.getting-started Ken Mayer wrote: > Try this. fdat1 is a variable, not a field. It is assuming a field. > It should be in quotes most likely, SQL and dates ... since you > delimited the string with single quotes, we're using double-quotes > around the fieldname ... To see what the string looks like once you > have filled it, try: > > ? q.sql > > That should show in the syntax is correct, at least. > Ken,    Thanks for the suggestion, although there always seemed to be a stray terminator " or ' when I tried it. I think I've solved it eventually. I placed on my main form  the query, Sql select  & parameters I had in the report. Using Append() and a temporary table. Thanks for all the help and the books. Trevor.