Recent content by Noah114

I have a database that is built for prevalence modeling; My main driver is, if a new client comes on that has 60,000 customers, what can we expect for sales. I have historical data for 1,500 clients all at different sizes. I would like to bucket client size ranges. For example, if the client...

Does anyone know how to set a password into a database that requires one for accessing an ODBC connection. Everytime I log into the database it prompts User Name: Password: Server: I only have to enter the password once, but didn't know if there was a command that coul do it?

I have a form that through control boxes established values for the assigned table. I have set 'required' in the table properties for each field. The problem I am running into is if I start entering data into the form, and then just wish to exit without saving, I get an error mandating the...

I have a excel workbook that I get on a monthly basis that has 30 tabs (worksheets) each containing different sets of data. Is there a way to consolidate all the information into one tab without cut & pasting all the information from one tab to the other to get a so called "consolidated...

Is their a formula that can be creat in excel that lookups up to variables. I want to create a financial report that would have the following fields; Payer January February March ACS $10 $12 $14 What I would like is for each's month cell to have a lookup...

Hi dhookom, I apologize for the vague response on why it did not work, I ask my supervisor for the call center work hours which we are closed 11pm to 8am, which would be 8 hours which is why i inputed (16/24). After changing the "+1" to 16/24 I reran a practive run on one rep. I got the...

i did this, but it didn't work Public Function WeekdayHours(dtStart As Date, dtEnd As Date) As Integer Dim dblDuration As Double Dim dtThis As Date 'used in loop If DateValue(dtStart) = DateValue(dtEnd) Then If Weekday(dtStart) Mod 6 <> 1 Then dblDuration = dtEnd...

Any way to exclude 12:00am to 7:00 am in a module?

Does anyone know a way, or have a module that can be used in Access, where the calculation between a start date and end date are calculated in hours, and does not count weekends? In other words, a start date on Friday a 6:00pm and and end date of Monday 9:00am would show "15" as the result?

I have a spreadsheet in excel in which if the value of say cell c2 is >= c3, then it would display a picture of a green arrow, if not a red arrow. I have the pics, just don't know how it works in excel.

I get counts all over the board; SELECT [Express Scripts Financials tbl (#4)].[PLAN NAME], Sum([Express Scripts Financials tbl (#4)].SALES) AS SumOfSALES INTO [Top 20 Plans Reference tbl] FROM [Express Scripts Financials tbl (#4)] GROUP BY [Express Scripts Financials tbl (#4)].[PLAN NAME] ORDER...

I have a query that takes the field 'PLAN NAME' and 'SALES' and the purpose of the query is to total sales for the plan name. How do I create a field that will count the records. In other words PLAN NAME SALES RECORD I.H.A. $100 1 U.P.M.C. $98 2 TUFTS...

How would I create a function that utilizes an "IF" statement which turns the visible marker from yes to no or no to yes on a image in a report?

I have a report, and what I would like to do is generate something where is sales increase, bring in a picture and if they decrease to bring in a separate picture. How do I link?

I have two tables, one with a table for physicians with totals sales, the other, a breakout of the physician sales by drug. Is there a way to create a query that will break out the physicians, list their top 5 products, and then an all other category that will match their total?