Composite calculated field

[John]

Hi

How can I have a table field made up of data from two or more other fields
in the same table?

Thanks

Regards

 

[RonaldoOneNil]

Why would you want to do this ?
You can display your requirement in a query, form or report using
=[Field1] & [Field2]

 

[John]

I need to use the field in a query ORDER BY clause.

Regards

Why would you want to do this ?
You can display your requirement in a query, form or report using
=[Field1] & [Field2]

Hi

How can I have a table field made up of data from two or more other
fields
in the same table?

Thanks

Regards

 

[John]

I need to use the field in a query WHERE and ORDER BY clauses.

Regards

Why would you want to do this ?
You can display your requirement in a query, form or report using
=[Field1] & [Field2]

Hi

How can I have a table field made up of data from two or more other
fields
in the same table?

Thanks

Regards

 

[John]

Can I use this?

SELECT *
FROM Clients
WHERE [Type] & [Company] & Str([ID]) > "some value"
ORDER BY [Type] & [Company] & Str([ID])

Thanks

Regards

Why would you want to do this ?
You can display your requirement in a query, form or report using
=[Field1] & [Field2]

Hi

How can I have a table field made up of data from two or more other
fields
in the same table?

Thanks

Regards

 

[RonaldoOneNil]

WHERE ((([Field1] & [Field2])="criteria")) ORDER BY [Field1] & [Field2];

I need to use the field in a query WHERE and ORDER BY clauses.

Regards

Why would you want to do this ?
You can display your requirement in a query, form or report using
=[Field1] & [Field2]

Hi

How can I have a table field made up of data from two or more other
fields
in the same table?

Thanks

Regards

 

[John W. Vinson]

Can I use this?

SELECT *
FROM Clients
WHERE [Type] & [Company] & Str([ID]) > "some value"
ORDER BY [Type] & [Company] & Str([ID])

Ummmm...

Try it and see. Can't see why not (other than that if your ID is numeric then
93 will sort after 101 since you're converting it to a string).