Search results

apologies I have edited the above. it is only working on first hid giving the six most recent dates accurately I need it to look at all hid in the field and give six most recent dates for each

SELECT top 6 odate, hid FROM rf1 ORDER BY hid, odate DESC I have restricted the size of this query by generation of a "supply" query rf1 and narrowed it down to 700,000 rows. Large due to varying numbers of order dates for each "hid" so have restricted to this decade. The above select works...

Your post prompted me to have another attempt at solving this problem. Have query 1 with date, query 2 based solely on query 1 (inc date) query 3 was the dcounts referencing 1&2. In one of the dcounts I referenced the date from query 1 when I had already referenced date in query 2. Thus...

Thank You ALL for your replies and considered advice. There is lots and lots of new terminology there, for me, which I do not yet fully understand. I will need some time to re-read and attempt to digest all the information that you have kindly provided. I am not being ignorant if i do not reply...

I am getting the data from a Db that has around 30 tables of between 10-50 fields. some fields 10,000 rows some 200,000+, some 2million I found that I am using 6 or 7 tables regularly and a 10-12 fields from each of those, max, from the totality to answer my queries. I cannot slim down the...

I have a huge query and I do not want to run it every time I want to look at it or call on it. If it is saved as a table then will the data be permanent and thus eliminate updates everyday. I may only update it once or twice a week or so whats the best way to look and call this data?

Good Evening Good People, I have hit another snag, I have (I think) tried every combination of solutions that I know about. I have adapted the previous DCOUNT formula's into another query. But rather than search by SalesRep I am doing a sales analysis by store...

pissed off or pissed up

That's interesting, there is also the possibility of "suck, swallow or draw" with relation to a cigarette/other burning product. "give us (me), a quick drag on your fag"

I have a different colloquialism for that, "Tiresome or time consuming" which I suspect would be equally difficult to translate. " I walked down the river to the next village, it was quite a thug"

I have had problems explaining to an American that I was just "nipping outside for a quick fag".

@The_Doc_Man Thank you for that clear explanation, after only a few short weeks I am starting, with the help received from your good self and others, to understand the basics of this new language that I have embarked on trying to learn. It is ok reading the books and watching you tube but the...

@ebs17 Thank you so much for that! I have transposed the format section from that line into the Dayrank calculation also and it has worked beautifully. I cannot believe how powerful Access is in only a few lines of code and in only a few words really. To You all, a sincere thank you. The...

Hi David, this is the foundation of a query that will have approx 20 other fields attached to it and will go back 4 or 5 years. I think there will be about 70,000 rows at the end of it. I will then transform to a table where I can perform other queries and generate more specific reports. I cant...

ta da......... Now for the tricky part, moving to the next day (28/5/2024) and then performing that same operation on that day.

@cheekybuddha Thank you so much for clarifying that and helping me understand. (y)

Hello @CJ_London , at the time I did not realize how beautiful the code that you made for me was. It is magnificent. I have learned so much from it. DCount("*","Q1","PrizeConvert>=" & [PrizeConvert] & " AND drcname='" & [Q2].[drcname] & "'") in the criteria above I have a feeling, could be...

Good Morning Good People, @cheekybuddha What had I done wrong to cause the data mismatch error? I am trying to understand and Learn I think that I have called a number field a string where as CJ original code the field was a text field cname=' OrderId=' does this act differently on a text or...

The day rank messes up as soon as the data table includes extra days. The extra dates taken out.

Yes that works on unit price, I had it like that using DESC. However the dayrank has gone to pot.