Subject:
|
Re: Access Help
|
Newsgroups:
|
lugnet.off-topic.geek
|
Date:
|
Fri, 7 Mar 2003 15:08:11 GMT
|
Viewed:
|
283 times
|
| |
|
|
Scott,
Can you post and example of the type of queries you have been trying? I know
you said they where giving you errors, but at least we'd have an idea of
what you are trying to do.
jt
In lugnet.off-topic.geek, Scott E. Sanburn writes:
> To All,
>
> I have been working on a project at work for over a year now, converting an
> Excel Production Recap program into an Access program. I have been
> successful converting it, outside of some small issues, which I have finally
> resolved in the last few weeks.
>
> However, the last part of this program I need to figure out is the bonus and
> incentive based on our production numbers. While I can compute a True /
> False value for comparisons (Say our Recovery rate is >=80% the incentive is
> 2% of pay, I can't seem to figure out how to use the true / false value in
> anything like a query. Everything I do ends up in an error.
>
> Since I know this community has a lot of talented individuals, and if anyone
> has any thoughts or knowledge on Access, or maybe some thoughts on how to do
> this, you can e-mail me at ssanburn@indalex.com or perhaps might know of a
> forum or something online, I would love to know. Thanks!
>
> Sincerely,
> Scott S.
> --
> Scott E. Sanburn http://www.scottesanburn.org
> Member, MichLUG / MichLTC http://www.michlug.org
> LEGO pages: http://www.scottesanburn.org/legoindex.html
|
|
Message has 1 Reply:
 | | Re: Access Help
|
| James & All, (...) Yes, I have a total query, where it is running a sum of all the data from a date range (say 1/1/02 to 12/31/02 or whatever). The value I am trying to evaluate is a calculated sum of various percentages of our recovery numbers, in (...) (22 years ago, 7-Mar-03, to lugnet.off-topic.geek)
|
Message is in Reply To:
| | Access Help
|
| To All, I have been working on a project at work for over a year now, converting an Excel Production Recap program into an Access program. I have been successful converting it, outside of some small issues, which I have finally resolved in the last (...) (22 years ago, 7-Mar-03, to lugnet.off-topic.geek)
|
3 Messages in This Thread:
 
- Entire Thread on One Page:
- Nested:
All | Brief | Compact | Dots
Linear:
All | Brief | Compact
This Message and its Replies on One Page:
- Nested:
All | Brief | Compact | Dots
Linear:
All | Brief | Compact
|
|
|
|
