Search results

Jon K, just want to say thanks for the mode example database. After a bit of head-scratching I finally worked out what was going on. Up and running on my db with your help. Thanks Al

UncleJoe, this very thought occurred to me this morning. In this case I will have to contact our IT department and have them rectify it. Thanks Al

Hi Dave thanks for the rapid response! Well, this is strange. The database she is using, I created. At present, we are in a period of testing so the database is not nor has not been locked. The database is available to a number of other people accross the network and no-one else's PC has the...

Hi, a colleague of mine has Office 2000 installed on her work PC in order to carry out Access datadase responsibilities (amongst other things) as part of her job. I think (though I cannot be sure) that someone has 'locked down' the copy of Access to such a point that shift bypass no longer...

Hmmm...then perhaps GaryPanics "fart in a spacesuit" theory is more credible than I first thought :o Seriously thought, I would have thought that Excel could handle mode in a more proficient manner since it is, after all, a statistical analysis tool.

Hi Jon K, thanks for the input. I have d/l'd your example and will take a good look at it tomorrow. Right now, I'm off home ;o) Thanks Sausagefingers

Adam, thanks again for your response. I had, in fact, resigned myself to passing the problem back to my boss and suggesting we used Excel for the task. We did. He got the data from me in .xls format and has since done the calculations in Excel himself. :o) In response your second paragraph...

I shall pass your response directly to my boss! LOL!

Adam wrote : "A number of what? The number of shipments, or the number of times a CERTAIN NUMBER of PALLETS were shipped to a location?" Adam, thanks for your response. I should have been more specific in my explaination, sorry. We have +300 branches to service on a daily basis. A branch may...

Hi, I found a couple of short threads on the forum discussing the above. None of them go sufficiently far enough into detal to help me solve my (relatively simple) problem. My boss has asked me to produce both mean and mode calculations for the number of pallets we ship to our branches on the...

Meh!! Answer staring me in face! Well, have to repond to my own post before I have to suffer the embarrassment of being responded to by others convinced that I am a dufus! Answer was staing me in the face!! :mad::o:D I used the OnClick event of the date field and pasted in the code already...

Hi, I need to find a simple and efficient way to log past transactions into our database. Our deliveries can be anything from one day up to a week old before transaction data (including actual dates) is recorded. As we log in excess of 275 records a day, I'm hoping to save a few keystrokes by...

Thanks...works like a treat. Doh! I knew I should have had the guts to write what I was thinking in the first place. Sausagefingers repeats this line one thousand times... I must have more faith in my own abilities I must have more faith in my own abilities I must have more faith in my own...

Hi, I have a problem I'm trying to solve using an expression in a query So far I have a working expression giving me the result I want. Simply it's: subtotal: ([ChargeA])+([ChargeB])+([ChargeC]) etc. etc. However, I also have to apply an effective 'Cap' which I'm calling a 'Full Load...

Hi allan, thanks for this. This works as expected although I have had to extend the same logic to make all fields on the same line (rather than just the single field) not show. It appears the problem lies in the way I have structured the table :o :mad: Apparantly the table upon which all this...

Thanks for the response. I was pre-empting that this would be the answer to my problem. I'm not sure though, how this expression/criteria should be formulated. For example, lets say a record consists of 5 separate charges in the same query. That might translate into the following: Units...

Hi, I would like to know if it's possible (if so, how) to restrict the data produced by a report to records that have a (currency) value greater than £0.00. Currently, the report is based on a query which does most of the 'donkey work'...creating subtotals etc. The report itself is calculating...

One small Issue... Thanks for your quick response guys. I have taken the advice from both replies and although I have the Sub working now, I was expecting 'DoCmd.Requery "" ' to requery the field. It doesn't so I must have some kind of error to contend with. What I would like to happen if for...

Works like a charm. Thankyou :D

Hi, I'm trying to write a Sub which is to display a message box should a particular field be null as a user tabs through the form. The control itself is on a subform as you can see from the supplied example code below. I have a feeling that 'Null' is an incorrect property but I'm also uncertain...