Search results

ah! come on now , that's not irrational. ;):D Brian

Col, the news may be true but it only reports a very tiny part of life, the sensationalist part. In something like a dozen visits to various parts of America I only saw one gun, it was on the hip of a cop, and yes there are obese people in America but I don't think the percentage is much...

I think that is an understatement. Brian

I think I must have been having a senior moment when I wrote the sentence you quoted. I cannot argue with your logic but I don't try to second guess where the program may need to change. Brian

To avoid a leading blank code GetUOM = mid(strReturn,2) Brian

I would tackle this using the Sum(Iif(. Approach. Your query would have three cols of the form Count1: Sum(IIf(field1="A",1,0)) Brian

Did you try end_date-due_date or use Datediff, which date will normally be the later? Brian

The code as provided has no spaces in the field names but I see that your query does, personally I never have spaces in object names be they field, control, table etc etc, but you need to ensure that what you code is consistent. Brian

Don't worry it's happened before,, after all this an Access forum. Brian

Dan, I'm sorry I didn't word my post very well. I was not suggesting the USA was not civilised or that all of the population was against gun control. Brian

I don't think that switch exists as a Worksheet function, but I could be out of date. Brian

Don't we need some brackets? DaysOverdue = Date() - (InvoiceDate + Terms) Brian

Dan fieldsports is not to do with owning guns for shooting people , it is concerned with hunting, fishing, and, as most of the entries were about, clay pigeon shooting. The hunting is licensed and controlled, similar to that practised by Ken Higgs, ditto the fishing. Nobody is saying that...

Well now Sam you have changed some of the values, as noted by James, but let's not let that get in the way of your education. You did understand the issue of the quotes? James, I would test in the order I stated as then non integer values are catered for =If(AE30=0,0.2,If(AE30>5,0,0.1)) Ie...

Decided that I couldn't leave it like that so had a quick play. If the cells had been formatted as number then overfilled cells give ##### and they will be enlarged to contain the number, if however no formatting given before the data is entered then a too large number will be changed to...

Thanks for coming back, so many people get an answer elsewhere but don't tell us causing us to waste our efforts and of course not passing on the knowledge to others who are searching the forum. Brian

There is an auto fit command so Activesheet.Columns.Autofit But note that this does not apply to numeric data, I think. Brian

Rx_ Craig, one of the main actors of Red Dwarf has just quit Coronation Street to start work on a new series. I have the theme tune from Benny Hill as the ring tone on my phone. This caused an amusing incident recently. Going walking I and two ladies had just boarded a train when the phone...

I feel sorry for James as you keep changing the requirements. Note that putting the number in quotes "0.2" means that the number will be stored as text. The formula is resolve from left to right, therefore a test can ignore previous tests as they will have been met. Assuming only integers are...

WOW, I'm glad I never knocked on anybody's door during any of my visits to the States, and I'm sure as hell glad I don't live there. Brian