Recent content by jckokko

The table have total 17547 records. Below query returns 1980 records: SELECT DISTINCT [mytable].[SUB NO], [mytable].TAX, [mytable].DATE, [mytable_1].TAX, [mytable_1].DATE FROM [mytable] INNER JOIN [mytable] AS [mytable_1] ON [mytable].[SUB NO] = [mytable_1].[SUB NO] WHERE...

dhookom!!!! You da man! I see you everywhere. I don't know what Tek-Tips.com can do without you. You deserve MVP! Thanks a lot for quick response. God bless you.

Needs some help to rewrite this query so that memo field does not get truncated: SELECT DISTINCT ServiceRecords.ServiceRecordID, Customers.CustomerName, ServiceRecords.CustomerID, Orders.PONumber, OrderItems.ItemNumber, ServiceRecords.SerialNumber, ServiceRecords.ProblemDescription...

Here's my query that returns what I need. This query sorts the tblContribution.Type in ascending order: PARAMETERS [Forms]![YearlyReport]![Start] DateTime, [Forms]![YearlyReport]![Start] DateTime; TRANSFORM Sum(tblContribution.Amnt) AS AmntOfSum SELECT tblContribution.Type...

I just decided to cancel the Report Open event using "On No Data" event. Thanks.

Yes to the first and second questions. tblContribution.Type, tblContribution.Amnt are the control source where I see #Error.

Here's the query. PARAMETERS [Forms]![IndividualContributionReport]![cbxIndividualName] Text ( 255 ); SELECT tblContribution.Type, tblContribution.Amnt FROM tblContribution WHERE (((tblContribution.Contributor)=[Forms]![IndividualContributionReport]![cbxIndividualName])); This query may return...

This time I am changing the design of the query. A customer never used a service so there's no charge. So the customer's report has no data to display, and I get #Error for the Amnt field. I tried =[Amnt]+ " ", but it didn't work.

Thanks Duane. It worked. It seems that Microsoft Access is full of quick and dirty or inconsistent solutions which are patched as issues occur.

Yes, it could help if I added a statement explaining what I am trying to do. Sorry Duane. I will be more careful next time. I will try your suggestion and let all know. Thanks.

[Forms]![?????????]![???] = [Forms]!YearExpenseMonthlyReport]![BeginDate] [Forms]![?????????]![????] = [Forms]!YearExpenseMonthlyReport]![EndDate] AS ?? = AS Total

PARAMETERS [Forms]![?????????]![???] DateTime, [Forms]![?????????]![????] DateTime; TRANSFORM Sum(tblExpense.Amnt) AS AmntOfSum SELECT tblDepartment.Name AS DepartmentName, tblExpenseCategory.Category, Sum(tblExpense.Amnt) AS ?? FROM (((tblExpense INNER JOIN tblDepartment ON tblExpense.DepId =...

Yes, the query is a crosstab.

What if the field [NoOfDaysTaken] does not exist? In another word, the query didn't return the field. The query will return the field for next month. Can I put a place holder?

Thanks Duane. It works.