Default value

[torquay]

I would be grateful for some help on a default value in a table.
I use an empty table with a couple of fields with default values in i.e.
category: (default value is) Home,
image url: (default value is) www.domainname.com/images/
I then append a query to this table which will then be exported out of access and used to update an my online shop.

Problem I have is of course when I append to the table the default values are overwritten by the new data. Is there a way I can keep the default value and have whatever I am appending added to the end i.e

Catagory: Home,Chairs
Image URL: www.domainname.com/images/654284.jpg

Thanks
Kim

 

[John Big Booty]

Rather that rely on the default values of your table, which you have noticed get overwritten by the Append query. You should be able to Concatenate your static values to the information being picked up by your query, and append the result into your Table.

 

[torquay]

Thank you for your speedy reply.
Can you guide me to an example of how this maybe done?

 

[John Big Booty]

Something along the lines of;

 

[torquay]

Worked a treat on the first field, but on this field

Picture: "http://www.domainname.com.com/" & [Picture.FileName]

I am getting error Invalid bracketing of name [Picture.Filename]

Thanks
Kim

 

[John Big Booty]

Try;

Picture: "http://www.domainname.com.com/" & [Picture].[FileName]

 

[torquay]

FANTASTIC.....worked a charm
Thank you very much for your help
Kim