Recent content by kblehman

Well, the user does see the results of this query (and a couple other simple ones) but I agree with your assessment. I'll suggest to the users that the queries that they need totals for be converted to reports. Thanks, PB.

I have a rather simple query that shows the number of layoffs in a given period and would like to know if I can have the query sum the numbers. Company City Date Incident Laid-Off CompanyABC CityABC 5/3/2007 Mass...

Both statements work perfectly. Thank you, Bob! :)

Oops, I forgot I had linked the data table. I apologize. Try this one.

Bob & Pbaldy, Attached is a zip file of the database. Report = rptActivitySummary frmRptCriteria contains begin & end date fields that are used by the report for its date range. If you don't open frmRptCriteria and add dates, you'll have to manually enter the date range each time you try and...

It is the 3rd and the last statements that are causing the problem: =Sum(Abs([RecDate] Between ([Forms]![frmRptCriteria]![txtBeginDate]-365) And ([Forms]![frmRptCriteria]![txtEndDate]-365) And [NotifType]=9)) =Sum(Abs([RecDate] Between ([Forms]![frmRptCriteria]![txtBeginDate]-365) And...

Bob & pbaldy, Thank you for your willingness to help. Here are the 13 control source statements used to produce the report results. If you're willing to take a look at these statements and help me correct any syntax errors I've created, I would certainly appreciate it. I should mention that...

Okay, now I'm suspecting there's more to this than an overly complicated control source statement.... My summary report contains multiple objects that calculate totals based on a statement in their control source. The report ran fine for a few weeks but all of a sudden it started producing this...

Hi all, Presently I have a summary report that uses control source statements to put results on the report, but suddenly I'm receiving this infamous error message: "The expression is typed incorrection, or is too complex to be evaluated..." So I'm looking for some help in converting the...

I thought about that, but I wasn't sure if I could create a query with so much differing criteria and still get it to produce the correct calculated totals.

The control source for the Activity Summary report in my DB is the primary data table. The report contains about 12 fields, each with a statement like this one as its control source: =Sum(Abs(Year([RecDate])=Year(Date()) And ([NotifType]=9))) Up until yesterday afternoon the report was working...

I got it. Here's what worked: =Sum(Abs(Year([RecDate])=Year(Date()) And ([NotifType]=9)))

I have a summary report that is based on the primary data table. The report contains a number of fields that are filtered by a statement in their control source. I now need to add a second filter criteria to each statement, but I'm having trouble getting the correct results. Each statement...

Well, you're not going to believe this. The example in your zip file worked just fine; gave me a total of the layoff column. But when I copied =[runsumLayfTotal] into the control source of txtLayoffTotals in my original DB, I got the same result as before. A msg box asking me to enter a...

Rainman, I'm using =sum(LayfTotal) for the control source of the text box, but instead of summing the numbers in the LayfTotal column I'm getting prompted to enter a parameter. If I enter "1" the total becomes 29; if I enter "2" the total shows as 58. (The number of records for the 4/1/07 -...