Is it possible for me to have a Query that pulls up the information I need and then it automatically starts up the windows calculator?
IE: information comes up then the calculator pops up so you can do calculations based on the information being shown.
I have a table that a created to calculate a running balance.
Fields look like this.
Desc = Text - Description of transaction
Type = Text - Combo Box Debit or Credit on Form
Amount = Currency - Obvious
Date = Date/Time - Obvious
I have two questions. In my form I have the combo box for debit/credit. I want to have the amount field to be either negative or positive depending upon what is selected for the type field.
Secondly, I would like to create a running amount. I have a field in my form for the amount. How would I link it up to create an amount.
Thanks
I want to open the Calculator by clicking a command button (using the On Click event).
I have tried the code below but can't get it working. What do I need to change?
Private Sub Command7_Click()
Dim RetVal As Integer
RetVal = Shell("C:Windowscalc.exe", 1)
End Sub
I am trying to build an incentive calculator for my company. I need a query that will take, for each employee,
Append rows as follows:
Emp1 | Attendance |
Emp1 | CSAT Score |
Emp1 | Quality Score |
Emp2 | Attendance |
Emp2 | CSAT Score |
Emp2 | Quality Score |
...etc...
The Attendance, CSAT Score, Quality Score are from a table named PARAMETERS where each department will have them listed as
Dept1 | Attendance | >90% |$10
Dept1 | CSAT Score | >8.0 |$10
Dept1 | Quality Score | >3.5 |$20
Dept2 | Attendance | >95% |$15
...etc...
I can do the lookups needed to find out which department an employee belongs to, but how to get the Employee to be listed in multiple rows like this.