more questions sorry sql this time i think

[Chuckie]

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

[Darren]

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]

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

[Chuckie]

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

[Darren]

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