Search results

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...

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.

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.

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...

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...