Recent content by chris.mo

Hi, Is there any reason why the chart wizard fails with data from a crosstab query? I did 4 graphs today, the first 3 went like a dream, but the crosstab one fails like this.. It's looking great at the point where you get a sneak preview with a wee button, then next and name it, then finish...

Brilliant Harry........it's not Potter is it? Your solution worked like magic! ;-) Thanks to everyone who gave input too. Chris.

Pat - yes, I did understand your answer, and thought it would work perfectly. As you can see from the query extract below, when I made Expr20 a zero, I expected a 3 for expr22 (your code pasted in) instead, it remained at 4 so I gave up and started experementing with my own method (to no...

I've spent hours trying to get this right today...and STILL no luck. Expr17,18,19 and 20 are totals of marks given for various attributes of a soccer player as given by 4 talent scouts A,B,C and D. 17,18,19 and 20 will always be filled in, in order of Scout A,B,C and D's input as they are ALL...

Thanks, but I still have the 0 from expr19 included in the average when only 3 values are input. I want it to add expr16, 17 and 18 and divide by 3. If 18 and 19 are both 0, it should add 16 and 17 and divide by 2. I do understand some boolean and logic expressions, the syntax access requres...

I am using the following expression to display an average of 4 other expressions thus: Expr21: ([Expr17]+[Expr18]+[Expr19]+[Expr20])/4 How can I change this to show the average when there are only 2 or 3 values with input. Any help much apreciated. Chris.

You guys are great. Thanks a lot. Chris.

Hi folks, How do I create a column in a select query to show the maximum value from any of 4 fields? I tried this way (see below..don't laugh!!) but it doesnt work....... = Max ( [Goals Scored A] , [Goals Scored B] , [Goals Scored C] , [Goals Scored D] ) Can anyone help please? Chris.

Thanks Jack, It works perfectly. Chris Polhill, Liverpool, England.

Please help someone!! I'm trying to do a parameter query on age...something like Between 19 and 22 to show all goalkeepers in that age range. The thing is I have only Date of birth in the Goalkeepers table. I thought I could do a query with a simple expression to calculate age, then do a...

Wow! Thanks a lot Mr. Hicks, your response is much appreciated. However, I think we must have our wires crossed. I had had some success with this... Expr1: (Date()-[Goalkeepers]![Date of birth])/365.33 ...Simply subtracting the DOB date field from the current date then dividing by 365.33...

Please can someone tell me an expression to show an age field in a query from the DOB (short date) field in a table. Just in Yrs would do but yrs/months would be nice. Thanks. Chris.

Hello! I'm trying to show the repective total numbers of days and games a football player has missed due to a certain injury. I have an injuries table showing the date of injury and the date of recovery, so the "Days Missed" column was just recovery date minus injury date and the Days Missed...