Search results

  1. A

    Help with group by week query

    Hi, I built the below query to count the number of ID's for each week. The problem is that if one month ends mid-week it is counting the next month's IDs in the first month. I need to count the number of IDs within each week by month. I have the first qryGroupbyWeek that assigns a week...
  2. A

    Can't enable checkbox in a subform

    After clicking outside the form and opening the properties for both the main and subform I discovered it was locked. I unlocked it and works like a charm. Thanks!
  3. A

    Count if function in query help

    Got it! I did this: $10 - $100: Sum(IIf([amount] Between 10 And 100,1,0))
  4. A

    Count if function in query help

    I have a total of 12 items greater than 10 so it's adding them all up. I need to somehow specify to count only items between 10-100, 101-500, and 501-10,000.
  5. A

    Count if function in query help

    I have three set limits: $10 - $100 $101 - $500 $501 - $10,000 I want to count the number of transactions that are equal to or greater than $10 AND equal to $100. I want to do the same for the other sets. I started the below formula but got an error. Any ideas? Expr1...
  6. A

    Group by date/time in a query

    You're right. DateValue works better and it adds the DateValue to the sql already. I didn't have to add it. Thanks!
  7. A

    Group by date/time in a query

    Is this correct: Between CDate(Int([Start Date])) And CDate(Int([End Date])) I got a message that the expression is typed incorrectly or is too complex to be evaluated.
  8. A

    Group by date/time in a query

    I found the function CDate and created: CDate(Int([Updated_Date])) Although that worked if I want to pull data for 5/29/13 I have to put a start date of 5/28 and end date of 5/30. If I just put from 5/29 to 5/29 I get zero. Any ideas? Thanks!
  9. A

    Group by date/time in a query

    Hi, I want to count the number of tasks by department by week. I need the time so my date the task was added is formated as a date/time. I created a query and added the department (twice so that I can group and count), and transaction date. I clicked on totals and added the count function...
  10. A

    Can't enable checkbox in a subform

    Thanks, but I can edit the data in the query and the subform is set to allow edits. Any other ideas?
  11. A

    Can't enable checkbox in a subform

    Hi All, I have a subform in datasheet view. In the main form I have various combo boxes to filter the data in the subform. I want to be able to check off the checkbox in the subform then filter all records that are checked, however, I am not able to check any of the checkboxes when I'm in my...
  12. A

    Combo box with values based on another combo box

    I have a main form that filters data in a subform based on selections via combo box users make on the main form. So I have the 'department' and 'manager's name'. If someone selects 'Human Resources' from 'department' combo box, then I only want to see the managers that are in the Human...
  13. A

    Export a form's recordset to a table

    Works great! Thank you so much!!
  14. A

    Export a form's recordset to a table

    Hi pr2-eugin, You meant to put the """" around the memo fields, correct? I did this and get an error. Here's my debug.print output: INSERT INTO tblResultsTracking (Template_ID, Template_Name, Payment_Type_Description, Created_Date, Approved_Date, Approved_ADENT, Business_Line, ID...
  15. A

    Export a form's recordset to a table

    Thank you! That seems to work but not consistently. For instance I tried it and it worked. Tried it again and got error similar to Run-time error '3075' Syntax error (missing operator) in query expression "Rec'd email from Laura A. Siess-Gannon'. This is the text in memo2 field for one of...
  16. A

    Export a form's recordset to a table

    The intermediate window is showing the '%'. Here's one line item: INSERT INTO tblResultsTracking (Template_ID, Template_Name, Payment_Type_Description, Created_Date, Approved_Date, Approved_ADENT, Business_Line, ID, Updated_Date, Created_Name, Open_By_AU, Initiated_ADENT, Initiated_Name...
  17. A

    Export a form's recordset to a table

    Yes, some are null but it's adding it to the beginning of each memo even if it is not null so all three memo fields have the symbol. Here's my code: Private Sub cmdAddToTable_Click() Dim tmpRS As DAO.Recordset, tmpSQL As String Set tmpRS = Me.frmPacsVerificationSubForm.Form.RecordsetClone...
  18. A

    Export a form's recordset to a table

    Okay, got it.... I left off the ID :-( However, now I have three memo fields and it's giving me an error '3075' syntax error (missing operator) in query expression and it's showing the text that is in that memo. I have memos like this '" & tmpRS!Memo1 & "', '" & tmpRS!Memo2 & "', '" &...
  19. A

    Export a form's recordset to a table

    They are all text with the exception of the two dates. Now I'm getting erorr 'number of query values and destination fields are not the same'
  20. A

    Export a form's recordset to a table

    now I'm getting erorr 'number of query values and destination fields are not the same'
Back
Top Bottom