Database Construction Query

M

Matthew DeAngelis

Hello everyone,

I am rebuilding an existing database and was hoping that I could build
an update query to do some of the work for me. We have too many memo
fields, some of which are used in some records and some in others, and
we would like to collapse most of them into one field with divisions
between the data and eliminating the nulls. To illustrate:


Technology IP BusinessModel
Record 1: Gene 1 yadda yadda yadda

Record 2: yes and so forth

I want it to look like this:

ConcatenatedField
Record 1: Technology: Gene 1

Business Model: yadda yadda yadda

Record 2: IP: yes

Business Model: and so forth


I figured that I could just build an expression in the Update To field
with some variation on "Technology: " & [Technology] & <two carriage
returns, although I don't know how to do this> & "IP: " & [IP] & <two
carriage returns>...

However, I discovered that I can't even get the update query to update
with information from a single field in the same record (i.e. can't
just put [Technology] or [Companies]![Technology] without it prompting
for the value), much less figure out how to mush them all together with
the proper spacing and tests for nulls.

Can anyone out there get me started? Any tips at all would be better
than where I am now.


Thanks,
Matt
 

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

Delete Duplicate records 1
adding a Carriage Return or Line Feed character to an update query 3
Null or NOT in another table 5
Query returns Arabic and/or sanskrit characters 4
Update query - fill in null field with value from record above 3
Update Question 0
IIF Function Within A Query 8
update query 2

Top