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!

Register Log in
  • 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: SJMcAbney
  • Content: Threads
  • Order by date
  1. SJMcAbney

    SQL Expressions for Date Range

    I've been using Crystal Reports for a while now and some of my reports, as far as I have been able, have been reduced to run as fast as possible. They are, sometimes, still too slow. I have since heard that SQL Expressions can reduce the time a report takes to run. With that in mind I would...
  2. SJMcAbney

    Convert String To Formula Reference

    I'm wanting to create a loop in crystal that moves through 12 formulas, numbered 1 to 12. Is there any way that I can create a string in the loop and have it reference as a formula? This is what I have: numberVar Total := 0; numberVar Counter := 0; For Counter := 1 To 12 Step 1 Do ( If...
  3. SJMcAbney

    Use VBA to Read XML From External File

    I'm wanting to read XML into a recordset with MS Access but, after a good time searching on MS KBase, here, other forums, and the web, I've been unable to find anything. Can anyone provide an example - or a link to one - of making this possible? Stewart J. McAbney | Talk History
  4. SJMcAbney

    Minimum if meets criteria

    I would like to calculate the minimum value in a group but only if a certain field in that group has a value. i.e. Group, InvoiceDate, Earned 001, 1st Jan 2005, £0 001, 1st Mar 2005, £0 001, 1st May 2005, £0 001, 1st Jun 2005, £45.32 001, 1st Jul 2005, £0 002, 1st Jan 2005, £0 002, 1st Feb...

Part and Inventory Search

Back
Top