Search results

Access 2007 query that has a specific date range between #6/1/12014# and #7/1/2014# returns the date I need. How do I now get it to pull just occurrences on Fri Sat and Sun of the month of June?

How would I get 12 months of data laid out like this in a report? I can design the report, but how do I get the individual data from a query? Would I have to make 12 queries for each month? Then how do I get that information into one report? ...........Jan Feb Mar Apr Name 1 276 260 270 280...

My report is totalling after each procedure type and I have told the properties to 'hide duplicates', but the white space is still showing on the printed report, before the total. How do I remove the white space and keep the totals? I meant to include that I am using Access 2007.

I do not understand how to use the default value expression. For instance, I am importing an excel spreadsheet into an Access db. I need for this field Abdominal>ABD & PEL DUPLEX SCAN LIMITED to default in the database to ABD & PEL DUPLEX SCAN LIMITED How do I do...

How do I make the parameter value show "Key in the Month"? Right now it displays Date and it works fine, but I want the instruction to be specific.

Can you please tell me why all of the data that is showing in a label does not print. Only the first line prints. The data does not appear in Print Preview either. The label is designed to type a Vendor Name, press enter for the second line (if needed) to add additional addressing information...

Can you tell me how to make the labels in my access report to appear in the same diaganol alignment as in the attached sample excel spreadsheet? Thank you

I have a query that is pulling 463 records of dates and then the data is either a 1 or 0. 1 = Yes, 0 = No. SELECT [Pacer QA tbl].Pneumothorax, [Pacer QA tbl].PericardialEffusionTamponade, [Pacer QA tbl].HematomaRequIntervention, [Pacer QA tbl].Other, [Pacer QA...

In this query I need to report on Volume of cases and Volume of Complications. My problem is I do not know how to add the Complications to the report. I have tried creating a group header for the different complications but that results in the data being placed on the report mixed in with the...

Can you please tell me why this query will not count all of the occurences that exist in a quarter. The query counts only one occurrence of each date, ie., if there are two or more occurrences of 3/24/2009, the query only counts one occurrent vs, two or three occurences. SQL: SELECT [Pacer QA...

Can you tell me what to put in this query to make Quarter 1 appear with '0' data if there is not data in the quarter? TRANSFORM Count([ICD UPGRADE Total Volume qry].PacerorICD) AS CountOfPacerorICD SELECT [ICD UPGRADE Total Volume qry].NewImplantorGeneratorChange, Count([ICD UPGRADE Total...

I have a db with patient names that appear multiple of times with multiple different procedures. Is it possible to query all patients who have had procedure X AND procedure Y AND procedure Z? Using AND in the criteria returns no data.

I have an Access DB query that returns the following results by using this formula, Qtr: DatePart("q",[DateofProcedure]). I need a report that will count how many of these records are in each quarter and by running quarter. Our quarter one is Oct, Nov, Dec. Please show me how to do this...

I have an Access db that contains DateofProcedure_________Procedure Type 1/2/2009_______________ ICD 3/2/2009_______________ Pacer 5/2/2009_______________ ICD 8/2/2009_______________ Pacer Please show me how the criteria would look to query a total of procedures by each quarter of the year.