Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Noah114
  • Order by date
  1. Noah114

    Bucket ranges

    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...
  2. Noah114

    Set ODBC password?

    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?
  3. Noah114

    Required Field Error

    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...
  4. Noah114

    Multiple Excel Worksheets into one consolidated

    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...
  5. Noah114

    Double Lookup (V or H)?

    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...
  6. Noah114

    Hours - Weekday count module

    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...
  7. Noah114

    Hours - Weekday count module

    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...
  8. Noah114

    Hours - Weekday count module

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

    Hours - Weekday count 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?
  10. Noah114

    Link picture in excel

    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.
  11. Noah114

    Record count

    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...
  12. Noah114

    Record count

    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...
  13. Noah114

    If statement with visible function in report?

    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?
  14. Noah114

    Input Images

    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?
  15. Noah114

    Top 5 per Selection

    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?
  16. Noah114

    Multiple address, need to select one

    No such luck yet
  17. Noah114

    Name space issue

    I am trying to create a function in a query that will pull the first letters of a name before the space. For example, I can get "JOHN" or "JOHN S." under first name. I try Trim(Left([FIRST_NAME],InStr([FIRST_NAME]," "))) But when I do than I get nothing back for the first on and JOHN back...
  18. Noah114

    Cool Reports / Report Tricks

    Does anyone know of any websites to learn so neat tricks with access reports, like maybe 3-d effects, or gauages, or neat charts / pictures?
  19. Noah114

    Multiple address, need to select one

    I have a query that pulls physician info. I then trim the doctors name due to the fact that the same doctor will be in the data multiple times with slight variances in info. For example; Robert Hull 150 West Chester Dr, Robert Hull 150 W. Chester Dr. I trim and store the name in a...
  20. Noah114

    Changing Month Crosstab issue

    That sounds great, how can I change the labels programmatically?

Part and Inventory Search

Back
Top