Search results for query: *

Unfortunatelty I don't know how to write SQL. Can anyone help me with unique counts by simply using the design view in a query. I've tried Dcount with works but when bring in the group names it just shows the group names and then the dcount of all records.

I have a patient table name "PATIENTS" and contains 3 fields: CLIENT PATIENT ID SALES Using access, because I don't know SQL, how do I group the Client, counting unique patients and summing sales. The patient may be in there twice for two different sales.

I have a patient table name "PATIENTS" and contains 3 fields: CLIENT PATIENT ID SALES Using access, because I don't know SQL, how do I group the Client, counting unique patients and summing sales. The patient may be in there twice for two different sales. I've been trying DCOUNT but having...

I have a form with multiple option boxes. Is there a way to have an option, for example one that says "TPA client" that when checked would allow an adjacent box to default?

I have a macro that runs several queries and reports. On report may, or may not have data. Is there any way that a macro can be created with an if statement. In other words, if the report is blank, to skip the report?

I need to show the variance in a report between two different week periods. For example I have the following in a table: Week Sales Qty 11/28 $50 4 12/5 $35 3 I need a report that would show that, plus the variance: Week Sales Qty 11/28 $50 4...

I currently have 5 reports that I would like roled into one. (For PDF purporse) Printing them to a printer s no problem, however is there any way (in any Access Version) that I can collapse all reports into 1. I.e. the first report would be pages 1-5, the second 6-10, etc...

In word, you can have an image behind the wording of the document, in other words you're able to apply letters over the picture. In excel, is there any way to have an image behind the document so whe you type in the cells, ot's over the image?

I have several excel cells that have a text string and then a character space after it, so when I do a vlookup it doesn't work. In other words,how do I go from "Chris " to "Chris".

I have a master table used to generate several reports from 20 queries. I would like to apply a filter to say a patient name from the master table and have all the reports run just from the filter applied. However when I filter by patient name, save, the run the report, all the patients are...

I have a master table used to generate several reports from 20 queries. I would like to apply a filter to say a patient name from the master table and have all the reports run just from the filter applied. However when I filter by patient name, save, the run the report, all the patients are...

Hello, I'm trying to make a month format by month name, i.e. January, february, etc.. I formatted the date with the Month fuction which made July-7, August=8, etc... However, the access manual says use MonthName function to get the month name, but when I do it I get "Undefined...

I have a combo box that lists physicians names for the user to choose. I have about 1000 physicians, and the combo box query works, however I notice when using the combo boxes it won't display all of them, stop at last names beginning with N.....any suggestions

I have a table that stores a patients notes per date. For example, one patient may have 4 different notes(memo's) for four dates. Connecting to other tables, I'm trying to pull the last date so I can get the last memo. However each time I do it all the dates and memo's appear. I've tried max...

I work with ndc's every day, they are an 11 digit id number for drugs. Usually they appear like this from my system: 06598456812. I had a concatenate formula that transferefd them into this format 06598-4568-12 but I lost it. Any help?

I have a query where I want to add number of days since last refill. How would I do this to ensure that the query knows weather there is 30 or 31 days in a month. For example, say I have a patient that on february 20th received a prescription with a 28 day supply. How could I builed a field...

I have a table that has prescription information. The patient may be repeated more than once. Using I run two queries that count the dollar amount and the other filters out unique patients so I get unqie patients and total billed. Must I always have two queries or is there any other way, i.e...

When buling a report, is there any way to autonmber the record, ?

I'm trying to build a query the pulls the null date. A patient may have several dates being serviced but while he is currently being serviced the date field will be blank. How could I write a null function telling the query only to pull the blank field (End date) Currently I have...

I have a Macro I use to produce a daily report. Each day the first query which is a make table deletes the previous day's results. However, the one field I pull in has characters longer than field size of 10. So everyday when the make table deletes and remakes the table the field size...