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 strongm 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: AdventurGurl
- Content: Threads
- Order by date
-
How can "@formula >= {?parameter}" whilePrintingRecords?
I have 3 formulas created to have an end result of all customer balances added up. I need a parameter to pull >= the total customer balances. However, I cannot select my formula in the Select Expert to equal my parameter? FORMULA 1 : tot1 //Placed in Report Header WhilePrintingRecords...- AdventurGurl
- Thread
- Replies: 6
- Forum: Business Objects: Crystal Reports 1 Formulas
-
GF (x-y) formula for "New Page After"
What would the formula be in GF (x-y) button beside "New Page After" if I don't want the very last record to create a new page after? Thanks in advance, Carrie- AdventurGurl
- Thread
- Replies: 2
- Forum: Business Objects: Crystal Reports 1 Formulas
-
UPDATE statement help for Access
The following query tells me incorrect syntax near FROM?? UPDATE c SET c.ac_id = b.ac_id FROM ((Account a INNER JOIN Account b ON a.ac_number = b.ac_number) INNER JOIN scanned_document c ON a.ac_id = c.ac_id) WHERE a.ACT_ID IN (59,60,61,62,63,64,65) AND b.ACT_ID IN (71,72,73,74,75,76,77))...- AdventurGurl
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
-
How/Can CR 8.5 use TopN without grouping?
I want to be able to pull the top 3 records from a result set that is sorted by date descending. I am better in T-SQL and would say: select top 3 * from tablename where... Is there a way to do this in CR 8.5 without grouping first? Thanks!- AdventurGurl
- Thread
- Replies: 11
- Forum: Business Objects: Crystal Reports 1 Formulas
