Recent content by jlwmkkp

  1. J

    Help with On_Click() command for Access 2010 Form

    In my database, I have a table named "DataTable" with the following four fields: [Database_ID], [Flex_ID], [Last_Updated], [Owner]. [Database_ID] is used to link tables/queries/forms and is static. [Flex_ID] is used by the company, and is the ID that appears on all forms. [Last_Updated] is a...
  2. J

    Import to Existing Table (Type Conversion Failure)

    Hi, I need to import an excel spreadsheet into an existing Access 2003 table. Due to regulations, the spreadsheet cannot be linked. When I try to import the spreadsheet, I receive a 'Type Conversion Failure' associated with a 'Product ID' field. In the Excel file, this column is populated...
  3. J

    Sum Query Exception

    SELECT tbl_TableName.[DataName], Sum(tbl_AccountBalance.[Net Fee Accrual]) AS [SumOfAccountBalance] FROM tbl_TableName GROUP BY tbl_TableName.[DataName] HAVING (((tbl_TableName.[DataName])=IIf([DataName]="Jim" Or [DataName]="John","Jim",[DataName])));
  4. J

    Sum Query Exception

    Plog, Apologies. I misspoke. The sum field does not display the correct sum. It only shows Jim's original account balance; it does not show the sum of Jim and John. Best, jlwmkkp
  5. J

    Sum Query Exception

    Plog, Thanks so much. Most of your assumptions are correct. I'm using Access 2003, and have described the problem more in depth below. The name field is called [NameField], and I am trying to consolidate two records (Jim, John) into one record. For the purpose of this query, I'd like to...
  6. J

    Sum Query Exception

    I have created a basic query summing account balances by unique names. I need to create an exception where two particular names (ie. "John" and "Jim") are added together. How would I implement this? Thanks, jlwmkkp
See more
Back
Top Bottom