how to combine data from several fields on a form

[Seasider]

I am truly baffled! Can anyone help me figure out how to combine the contents of several fields into another separate field or if there is a better way to achieve my goal that would be appreciated also.

I am developing an application to keep track of projects. The users can pull up a form, called frmDatabases, and check boxes to indicate what databases a client has access to (these are researchers at a university). They can check from 1 to 10 possible databases. Of course, when a box is checked, a "-1" is placed in the field in the tblPROJECTS table

Then I need to be able to include a field on a report that lists the names of the databases checked for each record and separate these with a comma. For instance, the label on the first checkbox may be called "ASD" and the second box "CIHI" and those are the terms I need to have appear in the list on the report.

Hope this is not too confusing. Any ideas?

 

[jtvcs]

Use a Concatenated, calculated field. Example... = [ASD]& ", " & [CIHI] . You can put whatever characters in the literal string (between ther quotes) you desire. HTH JT

 

[liddlem]

Hi Seasider

i can think of two possible solutions here.

The first depends on whether your report is based on a query or not. If it is based on a query, then simply insert a new column to the query and put in the parameters into the Field.

E.G. In your list of fields you have name and surname. To display the two together, type the following into the field block.

FullName:[Name] & " " & [Surname]

The word "FullName" defines a name for this field and the balance tells access what data this field is made up of.

Now simply add this field to the report.


The second possibility is to add an abject (field) to the report and then it the objects properties / data section, use the expression builder to create the criterea. (I.E. [Name] & " " & [Surname])