Search results

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?

Frequently I attend different functions where a bottle of whisky is auctioned off after dinner. People tend to spend about a fiver. Sometimes there maybe another donated prize or two. Two whisky or a whisky and a couple of bottles of wine as separate prizes, in these situations I buy more...

Thanks Arnelgp In theory, can two or three "Conditions" be conjoined or will that have to go through Sub Forms?

If I have a selection box with ten identifiers France, England, USA, Ireland etc Can I configure it somehow to filter on that selection?

Because the odds of selecting the correct numbers is still the same. Therefore, the higher the "prize" the more projected " value" you are getting for your pound. Some people just cant resist a bargain.

Are you trying to identify a band? measure the value determine which band it falls into? rising to the band and descending to the band/value?

I remember calculating the odds on the UK lottery a year or so after it started, the odds back the were approx 28 million to 1 by my calculations. I didn't have another go after that eye opener. You are far more likely to get cancer than win the lottery, 50/50.