Search results for query: *

Sorry. yes, i seen the example in your post. I got myself confused but i get the idea now. Your help is much appreciated. Thanks and Merry Christmas

OK. Sorry to ask yet another Dsum question (Brains not working this close to the holidays) I'm using I've got this so far: Dsum("[Amount Paid]", "payment" Presumably this will sum all [amount paid]'s in the table "payment". I now need to narrow down what is summed. I have a another three...

Thanks for that. The "not storing it in a table" idea sounds like a good one. If i went with that approach, would i just create a textbox and set the control source to a DSum formula? Cheers

I don't like macros either but i'm sticking with how it was initially started and just trying to get this one problem sorted. How would i go about using the DSum function? i need to update the value in the field as a new record is added. WHere would the DSum be used? Thanks for the reply.

Hi All I have a question regardin and access application i am helping to build. I have a subform with a number of text fields in the details section as follows: Date Paid - Bound to field in payment table Weeks Elapsed - shown as result of calculation (works fine) Fee Due - shown as result of...

Hi all. Hopefully someone has experienced this problem and can give me a little help in solving it. I have an application that a user can use to view various reports. This program was done using crystal reports 9 and VB6. I have since upgraded to crystal 10 and kept 9 on my PC for older...

Hi all Not to sure if this is the correct forum to be posting on for this or not but here goes. I have an application that lets a user select the specific type of report they want. It then prompts them to click on different options and then goes and creates the report through a Crystal Viewer...

Hi Mark I've been trying to get round the example that you posted. Its a great start but i don't think it quite does what the original code does (Please correct me as i may be wrong). In my original program the idea is as follows: It takes a record, then checks the patient_number. From that...

Thanks for that. I'll look into adding it into my project and see if it speeds things up. Your help is much appreciated.

...= Array(0, 0, 0, 0, 0, 0, 0) 'array to store duration sums for each of the 7 seven day periods sqlGetContactsForPatientNumber = "SELECT * FROM LHCC_CONTACTS WHERE LHCC_CONTACTS.Patient_No = '" & CurrentPatient & "'" rsReducedContacts.CursorLocation = adUseClient rsReducedContacts.Open...

Brian, LB Thanks so much for your help. Both of your suggestions worked great. I am going to go with Brian's suggestion (no offence to your suggestion LB), only as it is not specific to font choice and i'm not yet sure what the final font will be. Thanks to the both of you. Cheers

Hi LBass Thanks for that suggestion. Sounds like a really good idea, i'm going to go try that just now. Thanks for your help.

Hi Croaks Not to sure if this is what your looking for but: you may be able to use ({Operatives.TARGETTURNOVER}) / month(currentdate) the month() formula should return the month number. HTH

hi all Crystal 9 with Access 97 database I would like to know if something like this is possible: At present i have a report which just has some data shown on the details section. There is a text box which has its coulour set depending on the value of a formula. This text box is the full...

I got the problem resolved. I ended up splitting the large formula into three smaller ones. One for Interventions, one for Primary_Reason_For_Care and one for Other_Reason_For_Care. like so: if instr({CONTACTS.INTERVENTIONS}, "BLM")<> 0 or instr({CONTACTS.INTERVENTIONS}, "BLW")<> 0 or...

Thanks for your suggestion. I've changed part of the code to what you have posted. Upon checking each part individualy against the database the seperate formulae seem to work. The problem occurs when they are joined together. I also tried a method of counting the relevent details according to...

Hiya Crystal Version: 9.0 Database: Access 97 I have a number of running totals in my report but i am having particular problems with one of them. The running total counts the number of visits to a patient and is evaluated using the following function: ( {CONTACTS.PRIMARY_REASON_CARE} =...

I've realised what is causing the problem. The dependency changes for each contact, so when it comes to out putting the graph, it only shows the last value that dependency has taken. Would anyone be able to suggest a way of getting round this so that the dependency value is stored for each...

Thanks for the response. I've tried what you said, and unfortunately it returns the same chart. The dependency value which is shown on the Y access (which can only have the values 1, 2 or 3) always reads 1 for each date. I can't help but think that this happens because the dependency value is...

Bcastner: Thanks for the reply. Could you let me know how i should be doing this as i'm a newbie with XP. Thanks