Will Actinic work for me?

[gigicbrown]

I currently am looking at the evaluation version of Actinic Business / Audio store to use for setting up a website to sell cds. My database is set up in Access with various tables for main cd details, tracks, categories etc. I can see how to link in my main catalogue by using the external link but as the categories and tracks for each cd are stored in separate files to the main product details I can not see how to link in the tracks to fit it all together. Can anyone give me any advice here?

[Pneumatus]

One way of doing what you require is to write a query in Access that joins several fields (your track lists) into one field with appropriate formatting along with all the other actinic data to create a new table then use that table to link to Actinic.

In access, the query syntax to select data and put it into another table is like this:

SELECT *
FROM mySourceTable
INTO myTargetTable
WHERE 1;

Using field concatenation in the SELECT part you could do something like

SELECT "!!<" + Track1 + "<br>" + Track2 + "<br>" + Track3 + ">!!" AS TrackList (or probably [Full Description])

Hope this makes some kind of sense

[gigicbrown]

Many thanks for pointing me on my way. Think I have just about solved it. Found a great example on

http://www.rogersaccesslibrary.com/O...p#Hookom,Duane

[gigicbrown]

Undefined function

HELP

almost there but getting an error message

Undefined function 'Concatenate' in expression

what am I doing wrong?

SELECT catalog.catalog_id, catalog.catalog_id, Concatenate("SELECT track_name FROM tblTracks WHERE catalog_id =" & [catalog_id]) AS track_name
FROM [catalog];

[Pneumatus]

Did you copy the contents of the basConcatenate in the Modules section over to your database. That modules file contains the Concatenate function used in the example.

[CymraegKev]

Concatenate is not an MS Access function - by the looks of it you are trying to UNION two queries together. Take a look at UNION in the Access help and that should get you going.

Hope that helps,

Kevin

[gigicbrown]

Ahhhhh

table1
158042 1038 track1
158042 1039 track2
158043 1040 track1

table 2
158042 albumtitle tracksfield


i want create in table1

158042 albumtitle1 track1,track2
158043 albumtitle2 track1

cant see how the UNION command can do this

please help, I am going round in circles

[wjcampbe]

You just need an update query something like this

UPDATE Table1 SET Table1.[FieldName] = 
[Table1]![Fieldname]+' '+[Table2]![Fieldname]; 
on [Table1].[FieldName] = [Table2].[FieldName]

Try it out on a backup table and keep overwriting the backup till you get it right.