Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: WaveyDavey
- Content: Threads
- Order by date
-
Excel - offer subset of values in a list
I have a worksheet which records client details - each client has a unique reference number as the first column. I then have other worksheets which record (for example) client placements (date started, date ended and type). Each of these also has the unique client reference number as the first...- WaveyDavey
- Thread
- Replies: 5
- Forum: Microsoft: Office
-
Selecting records NOT marked as "Invalid"
I have a report which works fine but I need to exclude "Invalid" records from the totals. Records are indicated as Invalid by the existence of a record in the "InvalidDets" table. E.g. a user marks a Referral record as invalid and a record is created on the...- WaveyDavey
- Thread
- Replies: 6
- Forum: Business Objects: Crystal Reports 1 Formulas
-
CR8.5 - Date Range in RecSelFormula doesn't return any records.
I have imported my Crystal Report into the RDC in VB6 and followed the guidelines for converting from OCX to RDC. Everything is fine except for date ranges. I am applying them thus: Dim vReport as CrystalReport1 Dim a as String a = "{Table.DateField} in Date(2002,1,1) to...- WaveyDavey
- Thread
- Replies: 4
- Forum: Business Objects: Crystal Reports 1 Formulas
