pls help with logic

Results 1 to 2 of 2

Thread: pls help with logic

  1. #1
    Join Date
    Dec 1969
    Posts
    230

    Default pls help with logic

    I have the following recordset:<BR>lngIndex Merchant City Amount Tax Item Qty UnitCost<BR>1 McDo CityA 14.49 1.25 burger 1 6.00<BR>1 McDo CityA 14.49 1.25 salad 1 6.50<BR>1 McDo CityA 14.49 1.25 fries 1 1.99<BR>2 Depot CityB 29.95 2.99 <BR>3 CCCC CityC 128.25 12.82 <BR>4 DDDD CityD 259.25 25.92 paint 1 59.25<BR>4 DDDD CityD 259.25 25.92 tool 1 200.00<BR>5 EEEE CityA 25.25 2.52 <BR>6 FFFF CityF 12.25 1.22 <BR><BR>and should be displayed like this. <BR><BR>McDo CityA 14.49 1.25 <BR>&nbsp;burger 1 6.00<BR>&nbsp;salad 1 6.50<BR>&nbsp;fries 1 1.99<BR>Depot CityB 29.95 2.99<BR>CCCC CityC 128.25 12.82<BR>DDDD CityD 259.25 25.92<BR>&nbsp;paint 1 59.25<BR>&nbsp;tool 1 200.00<BR>EEEE CityA 25.25 2.52<BR>FFFF CityF 12.25 1.22<BR><BR>I know I can display this in an html table, but I don&#039;t know what logic to use as I loop thru. Will someone pls write the pseudocode for the logic? Thanks.<BR>

  2. #2
    Join Date
    Dec 1969
    Posts
    96,118

    Default ASPFAQs, category Databases, General

    There is a link to the ASPFAQs at the top right corner of this very page.<BR><BR>Look in the category noted in the subject line of this message for your question.<BR><BR>The ASPFAQs are your friends. Visit your friends often.<BR><BR>**************<BR><BR>Look for the categories/subcategories question. It&#039;s *exactly* what you are looking for.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •