Search results

Hello: Every time I create an Access query and before the FROM clause, it adds ,* Is this a problem that any of you have detected? Is there a solution? It does this both in grouped data queries, as well as in other queries. Example: SELECT TblHechos.DiaSem, Count(TblHechos.DiaSem) AS Veces, *...

I have reduced the number of products for better visualization, but in the attached database I include the number of 77 products. I think we can be happy. I pointed this out, but if I had made the request to Microsoft, they would have paid little attention to me. Your intervention was really...

Colin:I had taken a wrong path when building the Pareto chart. I had an "AutoNumber" as the ProductID and it seems that it doesn't support it properly. After several attempts and seeing your chart, I have corrected my operation. I have converted the First field into a string and the result is...

Hi Colin again: Doing tests, the closest I have managed to get is the graph that I attached in a .png file. The main problem that I see is that it does not allow each series to be projected on a specific axis. Greetings again >> Jacinto

Hello Colin: My first impression was >> Great I activated the Beta channel and version 2412 appears, with the "Pareto" item In a later analysis I saw that the representation was not correct. 1.- On the Y1 Axis there should be the values of >> VtaporProd 2.- On the Y2 Axis there should be the...

I forgot to mention that until now, when I needed this utility, I used Excel. Regards >> Jacinto

Hi Colin: This is very good news for all Access users. I don't have that version yet (my version is 2410 from the "Current Channel"), but I'll keep an eye out for it because it's a utility I use frequently. I'll post here when I see it. Thank you for your help in getting it. Kind regards >> Jacinto

Thanks again. It works perfectly. I had to import the table "zzTable" to avoid the code error. Regards >> Jacinto

Thanks arnelgp: It is a very interesting exercise and also demonstrates your mastery of the Access/Excel tandem. Obviously it is a longer path, but it is a solution in the meantime that Microsoft solves the problem, as Colin announces. My best regards >> Jacinto

Colin: I'm sorry I didn't explain myself so that the problem I had was clear from the start. I've been following your posts, and that link has also been very useful to me. Regards >> Jacinto

Thanks Azhar and Colin: Colin: The truth is that I had spent hours trying to get it without success. I would be happy if it was modified and to hear from you when it is done. I had already built it in Excel. Kind regards >> Jacinto

Thanks for the link:It's interesting and I had looked at it, but I'm trying to do something similar in "Access 365" and I can't do it. As I explained in my initial post, it doesn't let me sort (or I can't do it) by the Sales values descending and Cumulative percentage ascending. It sorts me by...

Here is File >> Jacinto

Hello:I intend to create a Pareto chart with modern Access graphics.Using the Combined option, I have placed the series on the appropriate (Y) axis.On the (X) axis I have the products and they are ordered in ascending order without letting me sort by Sales (descending) and Cumulative percentage...

Hi Colin: Certainly we have been in contact by email, through your database. I used to help at Todoexpertos a long time ago. A website in Spain. I follow your teachings through Isladogs and some other websites. I have seen that you have a very developed sense of help. I regret the passing of...

Hi Colin: That's exactly the file I was referring to. Thank you very much for your collaboration. Yes, it is also useful for klsblues, great. My regards >> JTJ

Colin: Congratulations because I was able to find what I was looking for. It is Example 242. I think because I am a newbie to this forum it doesn't let me upload links. In any case, if it's up to you and you want to provide it, it would be good for klsblues. Greetings >> JTJ

klsblues: Excellent work from you. However, if you want to see other sources, I recommend a very good development by Helen Feddema. Thanks Helen if you read this. There is a sample on office-watch. I don't see that the File can be downloaded. On her day I downloaded it from her website which is...

Hi Jon: I forgot to translate. Hello to all members of this forum. I have been following him for a long time and I think his posts are very good. I am Spanish. My profession "was not computer science." I am retired, but with a great interest in Access. I hope to be useful on some occasion. My...

Hola a todos los miembros de éste foro. Desde hace tiempo que lo sigo y sus post me parecen muy buenos. Soy Español. Mi prefesión "no fué informatica". Estoy jubilado, pero con un gran interés por Access. Espero ser de utilidad en alguna ocasión. Mis cordiales saludos >> Jacinto Trillo