Announcement

Collapse
No announcement yet.

more questions sorry sql this time i think

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    more questions sorry sql this time i think

    i have found me a program that will build me a pdf from the microsoft access database, what i was wondering is, can anyone tell me the sql or a way of creating a new table in the database that will put all the products in order it would fill a table like this

    parentsection title
    subsection title
    product
    product
    product
    product
    subsection title
    product
    product
    product
    product
    parentsection title
    subsection title
    product
    product
    product
    product
    subsection title
    product
    product
    product
    product

    the hope is then the program can just read the table and place all the info in order on the pdf file with out any messing.

    Help please someone i will be very grateful if you can help me in my quest. thanks
    James
    ------------------
    ModelPower.co.uk - Quality Batteries - Affordable Prices

    #2
    Hi there.

    I have some SQL (JET SQL from Access) below that copies the product short description and the price into a new table called tblNew. It sorts them into order of product desciption.

    I though this may help.


    SELECT Product.[Short description], Product.Price INTO tblNew
    FROM Product
    ORDER BY Product.[Short description];

    The built in help in Access is quite good, if you type in make table sql into the help, it comes up with some useful info.

    Hope this helps
    Darren

    SellerDeck

    www.sellerdeck.co.uk

    Comment


      #3
      Hello Again.

      One thing I forgot to mention, make a backup of your ActinicCatalog.mdb before making any changes as Actinic cannot support changes made to the database.

      Kind regards
      Darren

      SellerDeck

      www.sellerdeck.co.uk

      Comment


        #4
        Hiya darren, would that code display it in the table like it is in the actual actinic program, cause it uses another table to reference where the product is in each section and which subsection is in each parent section or would that code give a long list of details like it does in actinic ?

        Ps ran that sql code whilst creating this response and it pastes all the relevent information into the table but it loses the structure, all the sections and subsections are lost

        if i could create a table with the same structure as actinic displays the details with would be very happy


        thanks james
        James
        ------------------
        ModelPower.co.uk - Quality Batteries - Affordable Prices

        Comment


          #5
          Hi there.

          It is worth looking at Jan;s website http://www.mole-end.biz

          Jan has been producing customer reports for Actinic for some years.

          Definately worth a look!

          Hope this helps
          Darren

          SellerDeck

          www.sellerdeck.co.uk

          Comment

          Working...
          X