Recent content by doma23

It's not the join problem. When I just bring in two tables in query, tblRevenues and tblCategories, I get all the records. But the problem is when I bring in the third table, tblClients, because then I have two connections from tblCategories, one that goes to tblRevenues and other that goes...

I have 114.195 records in tblRevenues, however when I try to do the query (in order to replace various foreign keys to actual names) after I add the tblCategories, my count of records goes to 113.850, and more, after I add tblProductLines it goes down to 102.488 records. These both tables...

Great! That should work. Yes, I got the results in the format I wanted. Thank you. It takes about 25 seconds to open the query, than it takes about 35 seconds to show all records (I mean - to show the exact number of records in a query - it's about 20k). However, this was tested locally, I...

Thanks! This works fine now. However, now I have the problem that it completely ignored the "nulls". When none of the records had the value, it just didn't show them. That's why I have now about 20k records instead of 90k. Do you have an idea how could I add those records?

Actually, I've made a mistake, there was 4.5M records because I forgot to match the ValueType, now there is 115k records (25k more than in original union query). So, for the next step, do I make another query or? I've put it within the same self join query, I've added Max(ReportDate) from the...

When I run the union query alone it has about 90k records, however when I self join it, it has 4.5M records. It repeats the each record 41 times? Also, how do I go from here, how do I take the latest available value?

No, I haven't done it yet. That's what I'm trying to understand now. But my brain processing ability is...aaaahhhh...and I don't have influenza at all. Hope you are feeling better though. :) I guess I'm still sleeping.

Yeaaaaah! It works, and very fast as well. Like you've already mentioned, it gave me "the query is too complex", but after I removed "_opt" fields it worked nicely. Now I will take some time to fully understand how it works and how to implement it the best way possible.

Well, what can I say - there is first time for everything. :) Just kidding...the field really can be either calculated or stated and there is a strong reason behind it. In this case it's necessary to distinguish and store both values. The tool itself has about 7-8k lines of code. Yes, you're...

In the qryFitler_Latest you can the relationship when searching for the latest date. I thought it would indicate what the unique records are. Anyway, the unique record is identified by following fields: [R_Quarter], [Period], [Odjel], [Drustvo], [Br] and [R_Date] The project definitely has the...

Ok, I've attached the trimmed database. I left it open as I deleted all other code not needed for this task. The current version only makes the table with takign the values from the latest record. Like discussed before it should take the latest values available from all records. You can see...

I have some experience with recordsets and VBA loops. I just don't have the idea where would I start. If I would know how to correctly set up the algorithm I could probably make it. However, since the tool will be running over the network, I would also have the issue of speed if it would be...

There is an intrinsic difference between numbers, so I would definitely need another field (let's call it Description). Thing is that I have around 2500 records, so if I make my table look like: Identifier------Description-------Value I would have 2500*40 = 100,000 records And the "Description"...

I couldn't agree more, it seems almost impossible to make that kind of a change now. Unfortunately, the query is the same as the table, with only difference that the data from the table is being filtered by Date in the query. I think I now understand to some degree how I needed to structure the...

Yeah, I am at liberty to change the data structure, but the problem is that I've built quite complex tool based on this table structure, and it would just take too much time to connect everything once again if I was about to change the data structure. I've heard also from other source that the...