I need help writing an expression that combines several fields into one.

[alansidman]

Ben:
We will be here to answer questions for you when you are ready. In the meantime, here is a site with a number of short videos on Access that you might find helpful.

I don't want to overwhelm you, so I will only give you one site to look at. If you wish more after watching these, post back.

http://www.datapigtechnologies.com/AccessMain.htm

Good luck. I know that you can do this, I started learning Access at the age of 62.

[orange]

Glad to see you're still working at moving your database to Access.
As you will find, getting your tables defined and designed is a first key step. Once you have tables and relationships
set up to support your business, that model could be implemented in any number of DBMS software packages.

Here is a link that may help put things into context.
http://stackoverflow.com/questions/5...-order-invoice

Good luck with your project.