Search results

Need some advice on building a query.. I'm utilizing 2 tables: Region,AccountData The region table contains 35 regions.I'm using Prin_Bal and SScore fields from AccountData. The AccountData table contains around 50,000 accounts each containing a prin_bal and SScore. I need to sum the prin_bal...

have an Access Database trying to utilize Sequel Server as my back-end. I have set-up a odbc connection, but when a user request data, they have to enter the connection criteria(username & password). How do I code in Access to automatically pass this info. If somebody is currently doing this...

I have a form I want to close when I open another. In the form I want to close I have an ID number that is being passed to a filter query that is used in the form that should open. I have tried alot of things that don't seem to work. I know when you close a form, the code basically stops...

I hopeful there is an easy way to do the below. I'm tying to add up my employees 1/2 day Leave and full day leave to get total leave. The only I can get this to work is to write two queries then put them together. Is there any way I can get this answer in one query. I have sickdays, FMLA...

I'm trying to delete a record from mu subform. If I hightlight the record and press delete on the keyboard or highlight record and delete from menu it works fine. I can't seem to get it to work using a button on the main form. I have a relationship between the main and sub form using employeeID.

I'm trying to use Dlookup to pull a value from a query into a report: ThI want the Salary where the field section is BankPro.. =DLookUp("Salary","qryChartQtr2","Section = BankPro") The value of BankPro is text. Thanks for the help...

I'm tying to get a procedure to work in a module. I have Access Security Installed an want to supply my own error message and routine. I know I'm doing alot of things wroung. Any help would be appreciated.. Public Sub ErrorHandler() On Error GoTo ErrorHandler Dim msg As String If...

I have two tables "tblEmployees and "tblResults", the employees tables holds current salary dollars and results holds incentive points, etc. My relationship is a one(Employees) to many (Results)using EmployeeID as the key. For each new record input in the Results table I want to pull the current...

First, let me say the experst on this site are the best........ I have two tables "tblEmployees and "tblResults", the employees tables holds current salary dollars and results holds incentive points, etc. My relationship is a one(Employees) to many (Results)using EmployeeID as the key. For...

My query sums up 3 months of data (quarterly) Employee data. My problem is I have a field called Disqualifier. The Disqualifer can be null or can be a numeric 1-7. If I do not enter a disqualifier, for example in January and February, but enter one for March I get two entries for the...

Overview of problem: The query I have consist summing up employees Ind Points, Team Points, and calculating payouts and potential payouts using my month and year field for my criteria to break my data down into quarer years. Jan,Feb,March w/ year 2002 would be QTR1. I also have a field in my...

I have a select query with a calculated field, Potential Payout: ([Total Points]-50)/(200-50)*0.12. I have other fields called Actual Payout and Disqualifier in the query. My question is how do I get the Actual Payout field to = 0, if the disqualifer field is not empty.

Hopefully somebody can tell me what the heck I'm doing wrong.. On my main form I have a combo Box named section, pulling all my sections in, using qrysection. It is the only field in this query. On my subform I have a combo box named employee, that is supposed to filter all employess that...

I'm working with the following table data.. tblEmployees tblACDStats Bnumber Bnumber Lname Incoming Fname Missed Dept WaitTime TalkTime My one to many relationship is the Bnumber field. I can have many Bnumbers in the tblACDStats. We want to setup a...

An overview of what I have been tasked to try to do. We have a text file that is downloaded every day from a progam called Observer/Composer which monitors productivity on our ACD lines. We would like to automatically import this data from the txt file and place in an Access 97 table on a...