I am trying to get the average pay for a group of people, but the way the database is setup everytime someone gets a raise it is a new entry, so someone could have 1 entry or 20. This is screwing up my average because it is taking the average of what they originally got paid through what they are making now and I just need their latest pay rate.
For instance this is what I see
Joe Mc $8
Joe Mc $8.50
Joe Mc $10
John Cour $9
Average = $8.88 where it should be $9.50. Joe should only count the one time.
I hate sub reports and always consider them the last resort in any reporting solution. The negative effect on performance and maintainability is just not worth the easy ride they give the report writer. Nine times out of ten reporting requirements…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples).
Crystal Reports uses a two-pass reporting process to provide greater …
this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management.
Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…
Watch the video to learn how one can deal with PST file corruption issue with an outstanding Kernel for Outlook PST Repair Tool easily. Using this tool, non-technical users can swiftly perform the repair process to restore their essential data witho…