Variables - Database Table?

[Jim Riley]

We're adding some custom variables to our products

Anyone know in which ActinicCatalog.mdb table these variable will be stored in?

I'm trying to create a SQL query to output some sales data by product & want to include the product variable along with usual stuff (e.g. prod description, product ref etc)

Jim

[NormanRouxel]

This requires several tables to be looked at.

Example code on http://community.sellerdeck.com/arch...p/t-49736.html

[Jim Riley]

This requires several tables to be looked at.

Example code on http://community.sellerdeck.com/arch...p/t-49736.html

Fancy a short consultancy job to help me get the queries right Norman?

Quite an urgent one and I'm no Access whizz

jimriley@tutor2u.net

[fergusw]

I'm trying to create a SQL query to output some sales data by product & want to include the product variable along with usual stuff (e.g. prod description, product ref etc)

As Norman suggests, getting sales data, populated with product details AND userdefinedvariable fields is not a straight forward task. It covers several tables and potentially several different order detail permutations.
It would involve quite a long, multiple-nested SQL statement to get close to something that you would need.

I'd recommend paying Norman for some "In Sellerdeck" code (as per his post) to query the database, if time is short.

[fergusw]

Ah - you already reached that conclusion. Ignore my post!

[NormanRouxel]

I'm no Access whizz

Unfortunately, neither am I. The code in the other topic is PHP / SQL but if you dissect out the SELECT statement from example (2) that should also work in Access with minor tweaking.

[NormanRouxel]

Jan at www.mole-end.biz may be worth contacting.