combining three fields of data into new field from one table

G

Guest

I think this is possible but am having a hard time figuring it out and help
is not helping.
I have three fields in one table: Lesson1, Lesson2, Lesson3, and I would
like to combine them into one field: Lesson, for use in a query. Any help
would be greatly appreciated.
I also will need to combine the Grade1, Grade2, Grade3 for each of these
lessons.
 
R

Rick B

Add a new column to your query and put something like the following in the
"field" field...

Lesson: [Lesson1] & [Lesson2] & [Lesson3]


Are you sure you want this? Seems like this would end up stringing three
course names together which would result in a pretty meaningless field.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calculating averages from form fields 1
Save formula result into a field 0
Consolidate records in ACCESS 2
Combining multiple fields into one field (list). 3
Combining 3 fields into one 6
Count Yes/No for three fields in one column 2
Merging First and Last Name fields 13
Combining Three Queries into one 2

Top