Access - maths calculation

[Wayne-I-M]

Hi

If you have a simple sum calculation like this
=Sum(IIf([PassType]="Adult" Or ([PassType]="Junior"),1))
and the answer is 123 or 456

how can I add to the calculation to give the multiples of 25
123 = 4 (thats 25 X 4)
456 = 18 (thats 25 X 18)

I can't use a decimal (123=4.92 or 456=18.24) as I need just the whole
number for other "stuff"

It's "quite" important I get this right 1st time as it it a part of the
report that works out the group discounts for ski passes for a whole season -
thats discounts of around Euro 2.7 million - so if I get it wrong it would be
a small problem

Thank you

 

[Wayne-I-M]

Its OK I got it

Int((sum(********)/25)

seems to work

 

[Wayne-I-M]

That is excelent = I have never heard of that before (I learn every day)

Thank you


--
Wayne
Manchester, England.

You use integer division which is a backslash character, instead of regular
division, which is a slash character. Example

456 / 25 = 18.24
456 \ 25 = 18

Chris
Microsoft MVP

Hi

If you have a simple sum calculation like this
=Sum(IIf([PassType]="Adult" Or ([PassType]="Junior"),1))
and the answer is 123 or 456

how can I add to the calculation to give the multiples of 25
123 = 4 (thats 25 X 4)
456 = 18 (thats 25 X 18)

I can't use a decimal (123=4.92 or 456=18.24) as I need just the whole
number for other "stuff"

It's "quite" important I get this right 1st time as it it a part of the
report that works out the group discounts for ski passes for a whole season -
thats discounts of around Euro 2.7 million - so if I get it wrong it would be
a small problem

Thank you

 

[Wayne-I-M]

I don't know what "comp sci" is (they did not teach it in Trento, Italy,
"back in the day") but if it involves making cakes then I may be interested.

I do remember the school administror had a "really big" white box in the
office that we were told was like a electic filing cabinet - but it was not
not too bad though - they also had a very modern electic typewritter

Can you belive that they teach about that stuff in history lessons now - OMG

 

[Klatuu]

I think your answer is a bit flippant. In 1962 there was no such thing a a
computer science degree. We did have math courses.

Having gone back to take some comp sci courses later, it has been my
experience that the technology of college courses are usually 5 to 10 year
out of date and the professor is usually not really that good.

 

[Klatuu]

Not because of when.
I just think it was a smart a** reply that had no relevance and was a bit
insulting to the OP or anyone else.

I am not talking about one school specifically.

And 46 years ago the literacy rate may have been lower, but it was a much
more polite society.

You think my answer is a bit flippant because 46 years ago colleges didn't
have a degree that's been commonplace in most colleges for decades? How
is
education of 46 years ago (when nearly 40% of the world's population was
illiterate) relevant to tech courses offered on today's campuses?

I've attended colleges in three different states and every one of them
teaches freshman computer science courses that include integer division
and a
whole lot more. The professors were great, most worked in industry and
shared their experiences with real world problems that computer science
solved, including programming. I went to college when Java was new, and
they
were teaching Java 2 to students, not Cobol. On Windows 2000 the same
year
it came out.

If your school doesn't have great professors and is teaching old
technology
in your computer science classes, it's time to find another school to
spend
your tuition on.

Chris
Microsoft MVP

I think your answer is a bit flippant. In 1962 there was no such thing a
a
computer science degree. We did have math courses.

Having gone back to take some comp sci courses later, it has been my
experience that the technology of college courses are usually 5 to 10 year
out of date and the professor is usually not really that good.

Sorry, it's short for computer science.

[quoted text clipped - 3 lines]

I don't know what "comp sci" is (they did not teach it in Trento, Italy,
"back in the day")

 

[Klatuu]

Perhaps I misread the tone of your post, Chris.
I would agree with what you are saying.

It may also be you had better luck than I with technology professors. I
found those who were pure academians could not relate to real world
scenerios and those who came from the real world had escaped into academia
because they were not competent enough to remain employeed in the real
world.

 

[Wayne-I-M]

I teach (un paid) "comp sci" to some local unemployed people twice a week in
the evening at the local college. Most of them only use the "comp " to
play games on. I have tried to show that they can also be used to earn a
wage.

We call Comp Sci - Computor Studies

Some people do not use MS Office but most companies do. The basic
requirment of many companies is to be able create a Word doc and use "some"
of the features. To create an excel sheet and use "some" of the "basic"
features. To be able to use access forms - but not to create the forms in
the 1st place, etc, etc.

I have never come accross a company that requires you to understand vba,
sql, C++, etc. I do (I also write java, html, etc, etc ). Of course there
"are" jobs that need you to understand other stuff - but these are not the
jobs that I prepare student for.

Most people who teach (full time) have no idea what so ever about the real
world they are training people for - like teaching someone to cook if you
have use a modern oven. BUT what they do have is the time and (government)
money to go on a continual stream of courses to keep them up to date. They
know the theory but when it come to actually doing the work - which is
different from just "doing" the work (hope that makes sense) they just cant
do it due to being insulated rom the real world requirements of being good at
what they do.

Oh and Chris - I still think your "trick" was good, many thanks for that.
And in the real world your "trick" is now allocating discounts (over 2
million euros in the next few months) to real people. These people pay our
wages indirectly.

I am like most people who work in the real world - sometime I do one job
other times I do others - there were 8 of us from the Manchester office last
week over in the Belfast office helping out with a store-room move - can't
see a proffesor "lowering" themself to do that - but this is the real world.
Oh and Belfast has some brilliant pubs ???

 

[triton]

Hi

If you have a simple sum calculation like this
=Sum(IIf([PassType]="Adult" Or ([PassType]="Junior"),1))
and the answer is 123 or 456

how can I add to the calculation to give the multiples of 25
123 = 4 (thats 25 X 4)
456 = 18 (thats 25 X 18)

I can't use a decimal (123=4.92 or 456=18.24) as I need just the whole
number for other "stuff"

It's "quite" important I get this right 1st time as it it a part of the
report that works out the group discounts for ski passes for a whole
season -
thats discounts of around Euro 2.7 million - so if I get it wrong it would
be
a small problem

Thank you