Search results for query: *

I'm trying to show these titles when month number is input. When number 1 to 6 is entered all the months is visible but when number >=7 is entered JUL to DEC is not visible. Where did the code go wrong. Help.. Also if there is more elegant way of coding this that would be great. Thanks. The...

I'm using CR XI. I have two group headers GH1 and GH2. GH1 is a grouped by Name and GH2 is grouped by Run Numbers. I have column titles for GH1 in Page Header but how to create column title for GH2 and not have it repeat in the same page but on different page? Thanks.

Hi: We lost our CR Enterprise 9 CD. We called Crystal and the Customer service said that they've just took down the link to download it last week and don't have the CD anymore, which is hard to believe. But if anyone out there knows of any link to download or anyone can burn us the CD, we would...

I'm designing a report with 150 fields and wanted to find out a way to fit them in a single design view report. If using a legal size landscape page setup I have to use 4 design view pages and therefore have 4 different reports instead of having 1 report with 4 pages. Thanks.

Using CR 9. My Data: PCR# MEDS 10-01-2446 MID 10-01-2446 MOR My Formula: Minimum(Meds, PCR#)&" & " &Maximum(MEDS, PCR#) to get "MID & MOR". I want to filter the report that only shows "MID & MOR". How can I bind the formula to the selection criteria? Thanks.

Hello: Environment: CRX field1: PC 647(F) PC 647F,647F,647F,647F,647F CONDITI ;PC 148(A) 30/10 would like to count how many times the variation of PC 647(F) or 647F or 647(F)occurs in this field. I tried instr function but only gives me the first occurence. Thanks.

Hello: I am trying to create a report that uses two queries and both queries uses parameters. q_HRI and q_HRI_Refs both is prompting for start and end date. How can I pass the start and end date from q_HRI to q_HRI_Refs. The reason for using two queries are the data from each queries are...

Hi: Is it possible to dlookup fields from queries? I tried this: =DLookUp("[HRI Refused Svcs]", "q_HRI_Ref/Refsd_Cnt", "[Program] = '10'") It didn't work maybe because the syntax is wrong. Perhaps there is a better way to reference fields from queries. If it's not possible, maybe I can...

Ok. Looks like I'm having about the same problem as some people but not quite. I am using CR9. Here is my data: Name Jan Feb Mar Apr EMT1 Ttl Runs 4 18 19 25 Ttl Late 0 1 6 2 % Compliance I'm not sure how to do that because %...

Hi: This is my formula: =DLookUp("[CONTACT/REF DATE]","tbl_Referred","[NAMEDATE] = '" & [Reports]![rpt_Ref_Clients_All]![NAMEDATE] & "'") This works to look up the same value of the same record but I would like [CONTACT/REF DATE] value from the next record and so I tried...

I would like to concatenate these records so that they are in one record like: RECNO PTID ICD_TEXT 4 0002 TWO STAB WOUNDS TO BACK;L THIGH HEMATOMA; RECNO PTID ICD_TEXT 4 0002 TWO STAB WOUNDS TO BACK 5 00003 L THIGH HEMATOMA 6 00004 MULTIPLE LACS 7 00004 R MIDDLE AND LOWER LOBE...

I am trying to background color the whole GroupHeader Section but this code doesn't work. What's wrong? Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer) If [Mos_Enrolled] > 0 Then GroupHeader0.BackColor = 12632256 End Sub This is an Event Procedure that I put in...

Is this even possible to overide the formula to enter data manually for a particular record? Do I need to write a macro to overider the formula function?

My SQL query: SELECT tbl_Providers.Org_Type, tbl_Providers.Providers, tbl_OBGYN_List.Providers FROM tbl_Providers LEFT OUTER JOIN tbl_OBGYN_List ON tbl_Providers.Providers = tbl_OBGYN_List.Providers Where tbl_Providers.Org_Type = "OBGYN" UNION SELECT tbl_Providers.Org_Type...

I would like to link two tables. From table1 - a formula field to table2 - string field. Is this even possible? If not what other solution? Thanks.

These are my Data: ID Name Enroll Stats Stat Date 00001 Babe Ruth 1- Enrolled 10/13/07 00001 Babe Ruth 7 - Disenrolled 02/20/07 00001 Babe Ruth 0 - Referred 06/01/06 I want to show the the data that correspont to the last date in the list ie. 00001 Babe Ruth 1- Enrolled 10/13/07. Using...

I have start Date (7/1/09 - field type date) and start time (0350 - field type string) and end date time (7/2/09 0450 - field type string). I want to find the time duration. I've tried using concatenate to convert 0350 to time but no success in calculating the duration. Pls help. Thanks.

In the 'safely remove hardware' it shows the hard drive but did not register the drive on 'my computer'. Anyone have any ideas?

Hello: I would like to get some advice on how to improve LAN communications between two building. We use Catalyst 2950. Network traffic is really slow. Any suggestion?

Just purchased one. Want to know if I can plug & play, like Linksys routers.