Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jckokko

    Delete From table where exists (select...);

    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...
  2. jckokko

    Memo Field Truncated

    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.
  3. jckokko

    Memo Field Truncated

    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...
  4. jckokko

    How to format or order the Row Heading in a Crosstab query

    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...
  5. jckokko

    Add text based on results

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

    Add text based on results

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

    Add text based on results

    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...
  8. jckokko

    Add text based on results

    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.
  9. jckokko

    Add text based on results

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

    Add text based on results

    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.
  11. jckokko

    Add text based on results

    [Forms]![?????????]![???] = [Forms]!YearExpenseMonthlyReport]![BeginDate] [Forms]![?????????]![????] = [Forms]!YearExpenseMonthlyReport]![EndDate] AS ?? = AS Total
  12. jckokko

    Add text based on results

    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 =...
  13. jckokko

    Add text based on results

    Yes, the query is a crosstab.
  14. jckokko

    Add text based on results

    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?
  15. jckokko

    Grouping dates to months and display results as columns in a report

    Thanks Duane. It works.
  16. jckokko

    Grouping dates to months and display results as columns in a report

    I have a query which returns expense date (ExpDate). I would like to group the ExpDate by months: 2004/01, 2004/02, 2004/03,...,2004/12. Then I want to display the months as columns. But I can not think of a way how to do it. Help. Below is the query statement that selects departments and...
  17. jckokko

    Query result as the value of a textbox

    Oops never mind! I was too lazy to look up the usage of the DSum func. :) I am alright now. Thanks.
  18. jckokko

    Query result as the value of a textbox

    Sorry for lack of explanation on the problem. I have a select criteria: select sum(amnt) from ExpenseTable where expenseType = "Auto" and anotherCriteria = "somethingElse".
  19. jckokko

    Query result as the value of a textbox

    Is DSum(..) the only solution? I thought Dsum() func is not efficient (probably I am wrong about this). Thank God for your help :)
  20. jckokko

    Query result as the value of a textbox

    On a report, I have a textbox. I would like the textbox's data source be a query result. For example, the query statement is "select sum(amount) from ExpenseTable". What's the work around?

Part and Inventory Search

Back
Top