Search results for query: *

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

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 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?

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

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?

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

I currently have generated an access report built off of a crosstab query with month as the column header. The issue I am having is that the months change. How can I build a query or report where if the months change from JAN FEB MAR to APR MAY JUN, it won't produce an error in the access report.

I currently have generated a report built off of a crosstab query with month as the column header. The issue I am having is that the months change. How can I build a query or report where if the months change from JAN FEB MAR to APR MAY JUN, it won't produce an error.

Can you utilized a Dlookup to get a text box value from one report, sourced to another report which are actually on the same report due to subreports?

Is there a statement in access similiar to the IF/AND statement in Excel? I need to know, if days is > 30 and qty = 4,

In MSFT Access, I created a report with headers in which this report includes a subreport of additional detail. In the subreport, I have included a page break in the subreport to separate bar charts. However, when viewing the initial report that includes headers, it does not recognice the page...

I have a List box the pops up in excel with the cell is selected. Each cell in the column when selected with pop up with the same list box because I made a form. However, if I make an entry, complete it, and move on to the next row to make another entry the list box opens in the desired cell...