Search results for query: *

I have (what I think is) a very simple question... When using Sharepoint 10.0, I added a Content Query Web Part to look at a list and return a subset of that list based on a single field. In the filters, I want to have anything that contains '*Need*', but I can't figure out the syntax that...

It seems like this should be easier than it is turning out to be, but I can't get this to work! The Case table has the case ID number. The Inventory table has the Inventory ID and item #. There can be several different item #s for each case ID, and even several of the same item # in each case...

Hello! I'm new to Sharepoint and am having fun trying to figure out how to make certain things work in this environment. I currently have a list set up that looks like this: Interventional Cardiology When you click on that title, it opens up and displays more items under: Interventional...

I am created a report in Crystal 10 to pull a list of case counts for the year. It's using a chart to break down by case type for each month. The report currently looks like this: Jan Total Diagnostic 76 76 Interventional 37 37 Pacers 33 33 Specials...

I have a report that is pulling cancelled appointments. In the select expert, the formula is currently set to this: (if dayofweek(today) = 2 then {apptcancel.canceled_datetime} in Today-2 to Today ELSE {apptcancel.canceled_datetime} = TODAY) This is working great with one exception. Each...

I have several setups where 1 PC is running 2 large flat screen monitors. All PC's are XP, running IE V6. On startup, I need 2 webpages to open. Page 1 of 2 should display on the left monitor (monitor 1, which is primary) and page 2 of 2 should display on the right. Both need to be in kiosk...

I have a list of procedures on my report. I'm using the below formulas, with a running total formula placed in the report footer (with labels). The data looks like this: CathID Proc Name Billing Code 28563 Procedure 1 6452 28569 Procedure 1 6452 28570...

I have a list of 4 procedures, with a code attached to each one. Proc 1 = 123 Proc 2 = 456 Proc 3/2 = 789, 456 Proc 1 and 2 each have a single code attached to them. For proc 3, I want to find all cases that have both proc 3 and proc 2 in a case. So, if a case has only proc1, list proc one...

I have a list of 4 procedures, with a code attached to each one. Proc 1 = 123 Proc 2 = 456 Proc 3/2 = 789, 456 Proc 1 and 2 each have a single code attached to them. For proc 3, I want to find all cases that have both proc 3 and proc 2 in a case. So, if a case has only proc1, list proc one...

I recently upgraded an Access 97 database to 2003. Everything works great with 1 exception. When I get to the button with the below code, I get an error - 'Database or file is read only'. If I run the same code from Access 97, it has no issues. It's a copy of the same database - same tables...

I have a table with the below fields: ID Date 1 3/29/08 2 3/25/08 3 3/15/08 4 3/14/08 I have a cross tab report with a Saturday label as the row, the date (by month)as the column, and a distinct count on the ID number. This all works...

I have a form with a combo box and 3 text fields. The combo box is pulling the list of facilities from table 'hospitals'. This table includes the below fields: Hospital Community Teaching Normal When the hospital is chosen from the drop down box, I want the other 3 text fields to be...

Hello! I have a list box with the values of Yes, No, and Unknown. If the user selects 'Yes' from the list box, 2 text boxes below should become visible, prompting the user for the date and time. If they choose No or Unknown, the text boxes should remain invisible. I've figured out how to do...

I have a data set that looks like this: bill# seq# line # reason 123 1 1 18 123 1 1 R1 456 1 1 18 789 1 1 R1 789 1 2 18 789 1 2 18 789 2 1 18 Each bill and seq# is unique and...

I have a data set that looks like this: bill# seq# line # reason 123 1 1 18 123 1 1 R1 456 1 1 18 789 1 1 R1 789 1 2 18 789 1 2 18 789 2 1 18 Each bill and seq# is unique and...

Hello, I'm using CR10. I have a data set like the one below: case 1 type Diagnostic Case 2 type Diagnostic type Interventional Case 3 type Interventional I want to ignore all cases that have a type of Diagnostic only, or cases that have a type of Interventional only. I want to count the...

I am trying to create a calendar of sorts from our scheduling software. I am using CR 10. Basically, I have data that looks like this: Procedure Room Start Time Duration Procedure 1 1 7am 3 hrs Procedure 2 2 6am 3 hrs Procedure 3...

Hello! I have a number of different values in a field: Total Time: 1, 6, 2.4, 32, 8,.... I need to chart this data, in increments of 2 minutes. The Y axis would have the number of cases - just a simple count. So, the 1 would fall into the '0-2 minutes' group, the 6 would fall into the...

Hello, I'm using CR10. I have a data set like the one below: case 1 type Diagnostic Case 2 type Diagnostic type Interventional Case 3 type Interventional I have used the following formula to create a tally for each case type: if {CATH_PROC_V.CASE_TYPE} = "Interventional Cath" then 1 CDbl(...

I'm using CR 10, and am in need to create a chart. I have a table simplified below: CaseID Amount 1 15 2 15 3 10 4 20 5 25 6 20 7 10 8 05 9 15 I'd like to...