Report messing up..

  • Thread starter Thread starter stephendeloach via AccessMonster.com
  • Start date Start date
S

stephendeloach via AccessMonster.com

I have a report run by MainQuery. When I click on the main query it is
queried my LeaseName. I type in Cromer #10 and everything comes up. I type
Franks 19 #1 and it comes up fine. When I go to the Report and click on it,
Cromer #10 comes up in the report but when I type Franks 19 #1 it says.. The
expression is typed incorrectly or is to complex to be evaluated. For example,
A numeric expression may contain to many complicated elements.. Any
suggestions?
 
SELECT Main.Operator, Main.LeaseName, Main.Rig, Main.SpudDate, Main.Date2,
Main.Invoice, Main.Vendor, Main.[3rdParty], Main.Description, Main.Category,
Main.Tax, Main.Parish, Descriptions.[1Quantity], Descriptions.[1UnitPrice],
Descriptions.[1Description], Descriptions.[1Total], Descriptions.[1Invoice],
Descriptions.[1Category], Descriptions.[1Taxes], Descriptions.[1PartNum],
Descriptions.[1Parish], Descriptions.Taxx, Main.TDDate
FROM Main INNER JOIN Descriptions ON Main.Invoice = Descriptions.[1Invoice]
WHERE (((Main.LeaseName)=[foms]![param]![LeaseName]));


I fixed it.. somehow.. There was an empty record in the table that i deleted.
after i did that it worked?? Thanks

Duane said:
Could you share the SQL view of your report's record source?
I have a report run by MainQuery. When I click on the main query it is
queried my LeaseName. I type in Cromer #10 and everything comes up. I type
Click to expand...
[quoted text clipped - 3 lines]
A numeric expression may contain to many complicated elements.. Any
suggestions?
Click to expand...
Click to expand...
 
Back
Top