Search results

Well Colin: I have no doubt they use the same engine. I'm sure they do, but the starting pulley is slightly different. Don't lose your sense of humor. Regards

Colin: Post #16 wasn't for you. I've seen your articles a while ago and downloaded the examples, which have served as a guide for me on several occasions. As I mentioned before, this isn't very important. It's just to make the reading more "intuitive." In short, I was looking for: Decimals >>...

Note: Commas are visible in the thousands separator of my previous post.Logically, in my case they should be periods.

Hi Colin: I think I also mentioned that in addition to removing the decimal places, I wanted it to show the thousands separator format. Example: 2,000,000 or -1,500,000 Thanks for your help

Just one clarification: Are you actually working with Access's "Modern Charts" or with "Classic" charts?. The latter also offers more options. Best regards.

Hi again Gasman: Looking at the chart you posted, it seems to me that the values (in this case, the vertical axis) have two decimal places. Regarding your subsequent question, the data format in my population chart (which in my case is the horizontal axis) uses values from 0 to 3,000,000. To...

Thanks Gasman: There's a substantial difference between Excel charts and Access's "Modern Charts." Excel offers many more options. Regards

Okay: It's not a big deal, but I still can't figure it out. It's a "Modern Chart" in Access, and I don't see it in the Formatting Items. I don't see it in the properties either. It might not be available. I just saw your message, Gasman. As I mentioned, it's not Excel. Thanks again.

Hi Blue: Yes, I do have that configuration, but that's not what I want to change. According to the image I attached, on the X-axis, where some quantities are displayed, that's where I want the quantity to be shown without the two decimal places, but I don't know how to do it. Thanks

I've successfully created a Modern Chart in Access. I've set the Minimum Value to -3,000,000 and the Maximum Value to 3,000,000.Value Axis Range >> FixedValue Axis Format >> StandardAnd >> here's where my problem is: I'm getting two decimal places. I don't know how to remove them. Is it...

Well: Bill Gates is definitely on vacation. We'll always have the A-Team, with whom you have influence. Have a good weekend.

I agree, Colin: I didn't quite express what I wanted to point out. I know there's a circular reference, and from there, I didn't explain myself well. What I'm trying to say is that even with a circular reference, Monaco shows differences when expanding. In the one I cited,(Post # 18) despite the...

Thanks, Colin: In principle, I see this as a very important step in uncovering the deficiencies in the query's construction. I've followed your instructions for replacing field names to avoid circular references. They produce an occasional result. If I close the query with the field disabled...

Colin: I think it was a good idea. Let's wait for the outcome.Thanks again.

Thanks, Coling:I'm attaching a sample. Just a Qry that doesn't expand or that I don't know how to do. Best regards>> JTJ

Thanks, Colin: There may be an error in one of the queries, but I can't see it, and all the queries that are grouped together are running normally. As I mentioned earlier (Post #10), Ctrl + K isn't working for me. I'm not sure which version of Access I'm using because I have three pieces of...

Thanks again, David:Just a few minutes ago, I found an article by Colin Riddington (Isladogs), which mentions that using Ctrl+K to convert it to Line Formatting by Field. I assume it's coming in a new update, because I run it and it doesn't do anything. The article is quite comprehensive and...

David: What I'd like is to see the query like the left side. That is, with one line per field. As I mentioned to Pat in my Post #3, I already see several like this. On the other hand, I see others in a block, with the fields joined together (separated with a comma, of course): I'm not...

Thanks, Pat, for your response. I can assure you 100% that I didn't manually format the query on the left.I have a few more in that format, and several in a block. For someone with more knowledge than me, it's probably not a mystery, but for me it certainly is. Best regards.

Without making any changes to my databases, when I open queries in the Monaco SQL editor, they appear differently. Some have fields separated by lines, but others are displayed in blocks. Do any of you know why this happens, and more importantly, how can I get the fields to appear in lines? See...