Recent content by evillarrealca

  1. E

    SendUsingAccount is not working

    Hi Minty, just want to let you know that I just used the code and it works perfectly!. This was great since I couldn't make .SentOnBehalfOfName to work.
  2. E

    Graph with Top 5 and "Others" as Category

    Hi jdraw, I just use the routine you sent me, using Is NULL as a Criteria in the query to only select the results I needed (I used this instead of NOT EXISTS) and it worked perfectly. Thank you very much for that input!!
  3. E

    Graph with Top 5 and "Others" as Category

    I tried to put the Querys together but I ended needing 5 querys, I guess it wasn't the way it has to be. I was also looking a way to import the data from excel. I appreciate if you can detail a bit more how to do this.
  4. E

    Graph with Top 5 and "Others" as Category

    Thanks jdraw, I'll see if I can put this together. I really appreciate your time! Have a great day!
  5. E

    Graph with Top 5 and "Others" as Category

    Thank you. Here is the file.
  6. E

    Graph with Top 5 and "Others" as Category

    Hi jdraw, thanks for the tip but I've been having trouble to write the NOT IN query correctly. If you can help with this, here is the SQL query for the original Income query which has ALL the results: SELECT tblTransacciones.tipoTran, Sum(tblTransacciones.montoTran) AS SumOfmontoTran...
  7. E

    Graph with Top 5 and "Others" as Category

    Attached is png of the query result (IncomeTable). That query is the one I used to build the Chart (IncomeChart).
  8. E

    Graph with Top 5 and "Others" as Category

    Hi jdraw, that is correct, the pie will have 6 slices. I got what you said but how do I write it into the query? or is it specified in the graph?
  9. E

    Graph with Top 5 and "Others" as Category

    Hi, I'm building a graph after a Query that groups the Categories and Sums the amount for each category, the problem is that there are more than 10 categories, so I want to just graph the Top 5 and a new category named "Other" for the rest of the Income amount, so I can show a Pie Graph with the...
  10. E

    how to insert a tab into a query expression

    thanks. I'll use this with the report. I was trying to use it in a Form but from the link of Galaxiom I guess it is still a problem.
  11. E

    how to insert a tab into a query expression

    I'll give it a try with the change of font. Because I already try the Space (12-len(Trim([fieldname] & ""))) and did not work.
  12. E

    how to insert a tab into a query expression

    I'm trying to differentiate accounts from sub-accounts by a tab indent. TI want it to look like this: Sales Uniforms Sub-account of Sales Inscription Sub-account of Sales Sales and Uniforms are the account name but Uniforms is related to Sales. In the Query I...
  13. E

    how to insert a tab into a query expression

    Hi all, I'm trying to insert a Tab into a query expression but chr(9) and vbTab doesn't work, does anybody knows what is that need to be used?
  14. E

    Hi.

    Hi to all and thank for your comments. Vba_php, Evilca was my first username, never notice that, I hope not!..😉
  15. E

    Hi.

    I'm new to this forum. Great expectations on learning from this forum
Top Bottom