Search results

@Minty Thank you. (y)

Good Morning Good People, when I am ranking items frequently the output is not as required, ie 10 1 9 3 9 3 8 4 7 5 I would like the rank to be interpreted as follows 10 1 10 1 9 2 8 3 8 3 7 4 7 4 Is there a global setting that can take care of this...

Good Morning Good People, Can a field name be given an alias in a select statement?

Thank you for helping me understand. (y)

@ebs17 If you get a few spare moments, would you be so kind as to try and explain for me what is going on in the second SQL statement, I don't understand why we look at the index for the top values and not the dates themselves and also what is the purpose of the comparison between the two alias's?

@ebs17 Thank you again Eberhard Second part of your SQL suggestion is now working perfectly, as I have managed to configure my data as instructed, and has solved this problem, Thank you. It is all slowly coming together for me.

I have reduced the rows to half a million and auto number has worked. Thanks June7 I will just push until I find the max. Thank you all!

I have added a new field as instructed and set data type as auto number. Get this

I currently have the following Table PrtID odate OrderID Several different parts can be on an order. For other calculations I need a unique ID for each row. The first column needs to be supplemented to the above table to produce the below table. I would like it to auto number the entire...

Good Afternoon Good People, I have converted a query to a table. I need to add a unique ID to each row Is there a simple way to add an auto number index field, I thought that it may ask me on creation but it did not.

Thank you Eberhard, I have managed to get the first bit of code to work! Thanks

So much information presented there, thank you all, I am starting to understand Normalization and Keys

That would do nicely! It did not work correctly as my access would not run it due to dangerous executable code. but I managed one attempt at a filter and it worked.

After recent frustration and deleting several queries in a temper tantrum i need to apply some kind of logic to my inadequate problem solving efforts. these are my thoughts on suitable fields Date problem area - Form, report, query etc. DB Name - query name where problem exists problem - I was...

Hi Gemma the husky can you please direct me to an article that explains what you mean?

I thought of making a small DB to log my efforts and changes I will have to do that, days of attempted solution thrown away in frustration.

Hi Mike, I have not made a form before, I dont know what the correct type of box will be, trying to find out the right way before I start. I have read a few articles on forms and watched some videos on Youtube but non seem to show this.

i tried in the main query, in a sub query, a dcount and a dcount in a subquery. it was giving me a headache so had to leave it for a few days

i gave up and deleted everything as I was having to many attempts an had half a dozen different queries messed up

I am trying to find the six most recent sales dates of a product. I have tried TOP 6 I am getting lots of blue spinning wheels of death. I think it maybe because some items have perhaps three or four sales and some perhaps none. is there a way of going null to six?