Need a little help......

[scottgzero]

Hi there,

I am not a full time programmer and don't know all that much about Databases.

I have however designed my own databse for my Music Shop etc.
Nothing spectacular...but it works.

My problem.......

I have to alter the database to do the following :

Example:

Database has ONE Table. Table Name "MAIN".

4 Fields in this table are :

ENGL1
ENGL2
ENGL3

TITLE

ENGL1-3 are fields that need to be added together so that they end being AUTOMATICALLY input in TITLE.

Example :

ENGL1 : Howard Jones
ENGL2 : New Song
ENGL3 : Maxi CD - 1989 - D

Result I am looking for :

TITLE : ="<b>"&[ENGL1]&"</b><br>"&[ENGL2]&"<br>"&[ENGL3]

which would look like :

<b>Howard Jones</b><br>New Song<br>Maxi CD - 1989 - D


When working in the Forms, it automatically transfers....but is not ACTUALLY save as such in the Table.

Can anyone help me on this one?

Much appreciated.

Regards

Chris

 

[ColinEssex]

You don't need to concatonate the fields and store the result. Just concatonate them in a query when you need it.

Col

 

[scottgzero]

Hi Col,

thanks for your reply.

Unfortunately, I need them to collaborate immediately as the table is used to send the data....not a report or form.

That's my prob...it needs to happen in realtime.

Can you, or anyone help me?

Thanks

Regards

Chris

 

[ColinEssex]

Unfortunately, I need them to collaborate immediately as the table is used to send the data....not a report or form.

send the data? not sure what you mean but if you mean export, then you'd use a query anyway wouldn't you?

Col

 

[scottgzero]

send the data? not sure what you mean but if you mean export, then you'd use a query anyway wouldn't you?

Col

Hi,

I use and EXCEL query which only allows me to import set fields...not combine them.

I have to do it this way so my data is set for use.

I want to try to avoid converting too much.

Chris

 

[Bartek]

combine fields ...

Hi scottgzero,
I am not sure if I got your question right, but how about using an Update Query. Sth that may look like this:
UPDATE tbl SET tbl.title = [tbl].[ENGL1] & [tbl].[ENGL2] & [tbl].[ENGL3];
where tbl is the name of your table. If needed any text can be added too ...
...[tbl].[ENGL3] & "<b>".

 

[scottgzero]

Hi scottgzero,
I am not sure if I got your question right, but how about using an Update Query. Sth that may look like this:
UPDATE tbl SET tbl.title = [tbl].[ENGL1] & [tbl].[ENGL2] & [tbl].[ENGL3];
where tbl is the name of your table. If needed any text can be added too ...
...[tbl].[ENGL3] & "<b>".

Hi Bartek,

that sounds like what I could do with......though I am pretty thick when it comes to slotting these things in.

Where would I have to do this?

Would be great if you can help.

Thanks

Chris

 

[Bartek]

create a query

pls go to the main view, select queries and click on new. Pick the design view from the list. Then switch to the SQL view and paste the code i sent before. Correct the name of the table and run the query. Then you can play around by adding new text and symbols to the SQL statement. Like ... & "<x>".

 

[scottgzero]

Hi Bartek,


I would like to express a BIG BIG THANK YOU!

You taught me something new today which really has helped me a heck of a lot.

Thank you
Thank you
Thank you!

Much much appreciated.

Regards

Chris

 

[scottgzero]

Hi Bartek,

just one more question....

If I were to do this procedure with, let's say 10 fields......how would I list them in the query?

I tried it with TWO, but get an ERROR READING......

Here's my example :

UPDATE MAIN SET MAIN.v_products_name_1 = "<b>"&[MAIN].[TitleFixENG] &"</b><br>"& [MAIN].[TitleFixENG2] &"<br>"& [MAIN].[TitleFixENG3];
UPDATE MAIN SET MAIN.v_products_name_2 = "<b>"&[MAIN].[TitleFixDEU] &"</b><br>"& [MAIN].[TitleFixDEU2] &"<br>"& [MAIN].[TitleFixDEU3];

Is it to with the semi colons at the end?

Or the "UPDATE"?

Looking forward to your reply.

Regards

Chris

 

[scottgzero]

Hi Bartek,

I did it...(almost) all on my own....

UPDATE MAIN SET MAIN.v_products_name_1 = "<b>"&[MAIN].[TitleFixENG] &"</b><br>"& [MAIN].[TitleFixENG2] &"<br>"& [MAIN].[TitleFixENG3],SET MAIN.v_products_name_2 = "<b>"&[MAIN].[TitleFixDEU] &"</b><br>"& [MAIN].[TitleFixDEU2] &"<br>"& [MAIN].[TitleFixDEU3];


Without your help, I would have got no further. You saved my so much!

again....

Thank you
Thank you
Thank you!

You're a star!

Chris

 

[molsonbubba]

2 fields into 1 field

Hi,

I am new to this and need a bit of help please.

There are three fields:
Field 1
Field 2
Field 3

Field 1 is always constant and = X
Field 2 is always dynamic = Y+1 (new number for every new record)
Field 3 - this is where I need help

Question. Can I combine Field 1 and Field 2 to get Field 3 to show X+(Y+1). In other words can I have whatever is in Field1 added to Field 2 and have the result listed in Field 3. There are no reports. This needs to be done inside the table. Access 2000.

Thanks in advance.