Question Concat fields and insert text

[Lizlien]

In Excel I can do the following;

Field A Field B Result
Chips Fries Replacement of 'Chips' with 'Fries' on menu.
(null) Fries Addition of 'Fries' on menu.
Chips (null) Deletion of 'Chips' on menu.

Can I do this in Access using some form of append query?

 

[MarkK]

Hello and welcome to the forum

Maybe it's because I don't know Excel very well, but I have no idea what you are getting at here. Is menu a document on which chips and fries appear? Or is this a menu in Access? Where in Access do you want to make these changes?

Maybe you can describe what happens here in more detail?

 

[Lizlien]

Sorry clear in my world, but not in others!

Yes by menu I mean food menu.
I want to be able to take the contents of two fields in a table and merge them with some additional text. So the end result is another field with the new merged data.

 

[MarkK]

OK, so what are the exact rules that govern these merges? What does this mean?

(null) Fries Addition of 'Fries' on menu.

Where do those fries get added, to what? Where?

 

[Mihail]

Sorry clear in my world, but not in others!

Yes by menu I mean food menu.
I want to be able to take the contents of two fields in a table and merge them with some additional text. So the end result is another field with the new merged data.

The red part break the main rule of databases: Do not store what you can calculate.
Database Normalization and Table Structures - Microsoft Access / VBA
I know: this is the approach for Excel, but, in Access, you should create a report where to display the concatenated values from your fields.

 

[smig]

Sure you can.
Create a query using your table.
On an empty field put
[chips] & " " & [fries]
This will contcat what ever you have in the chips and fries fields.