Search results for query: *

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...

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...

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...

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...

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...

Hi - I need to create groups based on time. Crystal 8.5 & SQL 2000 The report needs to show all transactions between set hours: i.e. 9am-11.59am 12-3.59pm 4pm-10pm My problem is the date and time are in the field together and I also need to choose a range of dates. Can I set up a parameter...

Had a search of the forum but can't find exactly what I need. I need to filter addresses for selected postcode areas i.e. NE8 1TH , NE8 1DF , NE8 1SA , NE8 4HG , NE8 6GH etc and NE10 1RT , NE10 1GR etc (for NE9, NE11 areas also) however I only want to return the areas based on the first part...

I have data which shows a persons age and I want to group the data into to groups i.e. 5-17yrs, 18-59yrs , 60-75yrs How do I set up the bespoke groups? Thanks Jazztpt

Hi - I need to filter my report by the word "Booking" in a memo field but the select expert tells me I can't use formulas on a memo field. Is there another way of achieving this? Using ver 8.5 Thanks Jazztpt

Hi - Hope someone can assist. I am trying to return 'Members' who have no transactions. Basically a members card is swiped and then a transacation is processed which logs the transaction (usage) against the member. Rather than looking at transactions by member (the easy bit) I am trying to...

I am very much a beginner but need to build a report that looks at data for a partricular day, i.e. use a parameter to choose a day, say Mondays and then a date range. Not sure how to marry the dates up with the day of the week, can format the dates so the day is shown but stuck on how to use...

I would like to open a word doc and force it to open in web view everytime. I have tried a macro and named it AutoOpen but it applies globally and I only want to force this particular document. Presume a bit of VBA or a macro to run on file open would do it but not sure how to go about it...

Hi - I have used Flash text for my navigation, I have 5 options but having published my site one of the buttons does not appear on a couple of the pages. I have re published and also re-done that text but no joy. Anyone got any ideas. Thanks Jazztpt

Using Access 2002 I have this placed in the control source property and it works. =Dlookup("[OWThres]","COIndex","[Age]= " & forms![BIData]!Age) However, I need to sort using an additional field [Sex] but everything I have tried returns an error, could someone give me the correct syntax to ref...

First off I am new to Crystal, I have some experience with Access but am by no means an expert. Here is what I can do and what I need to achieve: I can extract customers and their recorded transactions. I can group transactions by each customers name. I can apply a date range parameter. Each...