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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

igorsandler's latest activity

  • igorsandler
    The HAVING parameter is intended for aggregate functions, so you can't use it like that. Since you seem to be new to SQL Queries, you...
  • igorsandler
    igorsandler replied to the thread sorting.
    If you need to sort a view or a cursor, you can add an additional field to it INT(VAL(grade)) AS igrade_sort. If you need to order a...
  • igorsandler
    Keep in mind the size of the table. Reaching 2GB will corrupt the table permanently
  • igorsandler
    Maybe I am missing something but if you have the totals already calculated on the form, then you don't need any report totals, just...
  • igorsandler
    igorsandler replied to the thread SQL query syntax.
    I am confused by your explanation. If you need a single record from the parent, why would you need any detail in the first place? The...
  • igorsandler
    Well, you have very valid responses from other users and I completely agree with them about this very strange request. Report with 300...
  • igorsandler
    As long as those variables are public or global and the report has to be set with default data session. It's a bit weird, quite frankly...

Part and Inventory Search

Back
Top