Search results for query: *

That works a treat, I had to start with a blank report but the concept works perfectly. Just need to buoild my report up bit by bit and take it from there. Really appreciate your help. One thing I don't understand is the use of the A.? what exactly does this mean/do. Jazztpt

Thanks for your quick response, will give this a go asap. Cheers Jazztpt

Took a bit to find the time to try this at work, had a go earlier. Not working as yet. I created the SQL expression: %Attend (select count("Transdate") from vwTransactDetail where "MemberNo" = vwTransactDetail."MemberNo") And the group @Count if {%Attend} in 1 to 20 then "1 to 20" else if...

Many thanks for your help with this lbass, I will try this out as soon as I can and let you know how I get on. Really appreciate your assistance, this is something I can use for lots of reports. Jazztpt

I created a group on memberNo Group #1 Name: tblAttendance.MemberNo(number) and in the group 1 header I added the formula Count of tblAttendance.Transdate(number) I Suppressed the detail to give me the grouped MemberNos with the count of the number of transaction dates. Cheers Jazztpt

Sorry Crystal 8.5. Thanks Jazztpt

Hi - I have built a report that groups members and totals the number of attendances for each member. What I normally do then is export to Excel and use a Frequency Array formula and 'Bins' to group the attendances i.e. 10 members came 1-5 times , 20 members came 11-20 times etc. I would like to...

I am thinking along these lines now. I have probably already built most of the reports/templates that would be needed myself, but as everyone sets up their data/systems in a different way, and this is the industry knowledge bit, each report will need some tweeking for it to work. So I will...

Thanks for the input. The software I am working with is configured so that .rpt files can be saved and run from within the application. They can then be exported as PDFs, xls etc or emailed so that extra functionality is built in which makes life easier for me. One thing though which I am...

Thanks for the replies and the very good advice. I am going to take it and not sell myself short. Cheers Jazztpt

Hi - hope someone can give me some advice. I am going to be a bit vague about the details as I don't want anyone borrowing my idea. I work for a local authority which uses an application which is the market leader of its type, it is used by many other Councils across the country and by many in...

No, definitely not 'freeze panes'. Jazztpt

Hi - I have a shared xls workbook on the network at work. There are ten tabs for ten different groups, though no real chance that users would be trying to change the same data. Problem with this workbook is the only way to navigate is to use the keyboard arrows. Scrolling on the screen using the...

Found the solution - need to copy the structure of the table and make the fields with duplicates in Primary Keys. You then create an append query from the table and append to the new table. The query will not duplicate values due to the primary key. Jazztpt

Of course the title of this thread should have said 'Deleting Duplicates' Jazztpt

I have the data from a membership DB which has quiet a few duplicated Names and addresses (though they may have a 'type' field which is different) I have identified these using the find duplicates wizard. Is it possible to use this query to delete the duplicated entries and leave one record. or...

Thanks for the reply, I'll give that a go. Cheers Jazztpt

Hi - (Excel 2000) I am trying to lock a range of cells when a checkbox is 'ticked' - I thought this would work, but it doesn't ! Private Sub CheckBox1_Click() If CheckBox1.Value = True Then Range("A1:E4").Locked = True Else Range("A1:E4").Locked = False End If End Sub Can anyone tell me what...

Got this all working - thanks again for all help.

Thanks for the replies - I did try with parens like this: hour ({vwTransactDetail.TransDate}) etc but not like this: if (hour{vwTransactDetail.TransDate} >= 9 and hour {vwTransactDetail.TransDate} < 12) then I'll give this another go tomorrow and post back how I got on. Cheers Jazztpt