Search results

Ok - thank you firstly everyone. I have managed to sort out a count of symptoms by creating a query for each individual symptom which counted how many - and I put it in a report as a list box. This works now. So from what I'm reading I have to rearrange my original form or table to have one...

Thank you - so do I go into report detail and create an unbound textbox? And then do I enter the properties and add this code somewhere? Sorry for being so dumb, but I honestly don't know as much as I should.

HI Some time ago I asked for advice on here and wasn't able to test it as I wasn't able to work on the database. I am self taught so don't understand a lot of the lingo I'm afraid. I was given the advice but I have no idea where to implement the 'solution'. I have designed a client...

Not being rude by not replying - just having to get a report out - so I'll have to come back to this in a couple of days if that's ok? Sorry... I really appreciate your help so far and will definitely come back to it.

each field Diagnosis, Diagnosis2, Diagnosis3, Diagnosis4 has the same look up field with a list of diagnosis.... each client can have up to four. When totting up I don't want to have to put a sum of each field for each look up entry - so I'd like the one sum to capture all the "anxiety" in each...

Ok, so up to four diagnoses per client... and the look up fields are the same. So anxiety could be listed in any four.... I tried taking the Sum out - but it doesn't even generate a number in the report.....

Can someone please help me... This is what I want - but it doesn't work - can someone tell me how to do it properly please?? =Sum([Diagnosis]="Anxiety")+([Diagnosis2]="Anxiety")+([Diagnosis3]="Anxiety")+([Diagnosis4]="Anxiety")*-1

Sorry - it was a bit of a ramble. I have a table of "Action/Outcome Codes" Code Issue Description I have a table "Case Notes" Client ID Date Project Worker Issue References Action/Outcome Codes (look-up field linked to the above table) General Notes Case Review Date Date Case Reviewed There...

Every client has a list of actions that have happened on a certain date. These actions need to be costed but the data is variable. So I need to find a way that I can list the actions that have happened on a certain date and then add 'time spent' and an 'hourly rate'. This way I can cost how...

I feel as though you're getting upset with me, so I think I'll leave it an source further help.

Table Name: Daily Log Sheet Field 1: Client ID Field 2: First Name Field 3: Surname

Thank you for replying - however, I am self taught with Access - so I don't understand where I am to post this. Is there not a simple formula that I can put into an unbound text field on the report? Thanks again

Hi I have a daily log query whereby a number of clients can access our service more than once in a week. I want to count the number of clients that visit in a week rather than the number of client contacts in a week - I want to do this in a report (attached to the query so that I can use the...