Search results

  1. M

    bar graph day view

    can you be more specific, how to do it?
  2. M

    bar graph day view

    I already have section that filter data for specific day. I just need to know how to create the bar chart and make it look like one from the link (in previous post).
  3. M

    bar graph day view

    Dear All, I have a table for tasks. Fields: ID, TaskOwner, Task, Date(with time) Execution time, and couple more Is it possible to create a bar graph view of a day. or part of a day? similar to this...
  4. M

    change date format

    sure, Of what I was able to find, the FORMAT only works with manual date entry. In my case it gave an error when tried with datevalue(myfield) or datevalue(date()). Therefore I have returned to FORMAT. The solution proposed by CJLondon, wouldn't work in my case, as users need to see records...
  5. M

    change date format

    Need to select each day separate as this is a TASK PLANNER application, we enter tasks ahead of time and then on the day we execute whatever is due. Tomorrow, Next Monday, etc are there to preview whats coming and we can reschedule. I will look into DateValue, Thanks :) EDIT: I tried with...
  6. M

    change date format

    Hello All, I had a request from my boss to add time to out date field - "tTaskDueDate" I have changed default value from Date() to Now() in the form. I had this code working fine until now: Select Case Me.cboAPduedate Case 1 strWhere = strWhere & "tTaskDueDate = date()-1 And "...
  7. M

    how to pivot in SQL

    thanks, sorted.
  8. M

    how to pivot in SQL

    Hello, I'm attempting to learn MySql, first issue I found, It doesn't do TRANSFORM like access, Here's my old SQL from access, I need to change it into standard SQL: TRANSFORM nz(count(*),0) AS FoundMonth SELECT month(dDateFound) AS [MONTH], Count(*) AS [Found] FROM Q_Defects INNER JOIN...
  9. M

    quick question - strWhere with WHERE

    Hello again, Unfortunately I found another problem, When I open the form and click Filter button, it gives 12 records, then click REPORT button and I still have 12 records. All of it is ok. Please memorize 1st and 2nd record issue 1. When I click Common Resource button I only get 1 record...
  10. M

    quick question - strWhere with WHERE

    Yes works superb! Would never think this was the problem. Many thanks :)
  11. M

    quick question - strWhere with WHERE

    So I just need to simply add it to q_actionplanner?
  12. M

    quick question - strWhere with WHERE

    please see stripped version.
  13. M

    quick question - strWhere with WHERE

    I tried this yesterday but when I run it it shows prompt to enter userResource instead of filtering. Like it doesn't know this filled name. The spelling is 100% correct. I also tried TableName.fieldname = true. But this gives the same prompt :/
  14. M

    quick question - strWhere with WHERE

    Thank you. I think so, will try it tomorrow at work. can i skip this part? """ & Me.cboUser & """ As I don't want to select any user, just click on button and the code will run in background giving me wanter result.
  15. M

    quick question - strWhere with WHERE

    Hello all, I'm struggling to find answer online, perhaps not asking right question. In one of my forms I use Alan Browne's filtering code http://allenbrowne.com/ser-62code.html This shows all records with specific user: If Not IsNull(Me.cboUser) Then strWhere = strWhere &...
  16. M

    "Not In" Query "Not Working"

    Stupid me! mistype field name, everything works now. Thanks for your help Grumm. :)
  17. M

    "Not In" Query "Not Working"

    Oh I see, thanks. I tried that but query asks for input for dDateClosed, I tried changing for Q2.dDateClosed but no luck. Query also asks for input for Q1.uUserPK.... Then it runs and displays all names correctly but no calculation is performed for AM or PM, just displays 0.
  18. M

    "Not In" Query "Not Working"

    I have the same problem, can you be so kind and change my query as I'm lost :/ @The_Doc_Man I tried do it your way, but I'm lost at the point where I need to add my fields, as they are expressions. @CJ_London I tried your way, but when I ran the Query it asks me to enter data for...
  19. M

    show all, including non existing

    Hello, I have a similar problem, then changed my JOIN to LEFT but there was no difference, still not showing users with 0 records input. I deleted my WHERE statement and works ok. I don't understand ,why this would be causing a problem? Can anyone advice please?
  20. M

    Need help to transform a query

    Whhhoooooaaaa perfect!!! Thank you :D
Top Bottom