Combining fields into one

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bernd - 03 Jun 2007 22:11 GMT

Hi all,

I'm busy with an assett database to record all IT eqioment. I now have the
following problem..

I have aa field called "speed" in which I type the speen of the CPU ie
"2.4GHz"
I'm a bit too lazy to type it 120 times so I created a table for it and
think I have gone too difficult for myself.

I wound up creating teo tables, one for the speed (called speed with speedid
and speed and clockid) and another called clock (with clockid and clock)

In speed I would only type the number and then have a drop down that looks
up if it is KHz, MHz or GHZ from the clock table - this works fine so far.

How can I now combine all the info into a single field so I can use it in
other forms as "one" field showing me my initial "2.4GHz"

Stuck on this. I either only get the 2.4, or the ID.

Help :)

Reply to this Message

Ofer Cohen - 03 Jun 2007 22:53 GMT

In the form RecordSource you need to combine both tables

SELECT speed.*, clock.clock, speed.speed & clock.clock As CombinedField
FROM speed INNER JOIN clock ON speed.clockid = clock.clockid

In that RecordSource there is another field, CombinedField, that combine
both fields, you can use it in the form for display only

Signature

Good Luck
BS"D

> Hi all,
>
[quoted text clipped - 18 lines]
>
> Help :)

Reply to this Message

Bernd - 03 Jun 2007 23:33 GMT

Nope, I'm not getting it... Would you be willing to look at a small sample
and e-mail it back to me?

if so, you can download the small mdb file at http://e-biss.co.za/a.zip

Thanks a million

> In the form RecordSource you need to combine both tables
>
[quoted text clipped - 26 lines]
> >
> > Help :)

Reply to this Message

Ofer Cohen - 04 Jun 2007 05:58 GMT

What is your email?

Signature

Good Luck
BS"D

> Nope, I'm not getting it... Would you be willing to look at a small sample
> and e-mail it back to me?
[quoted text clipped - 33 lines]
> > >
> > > Help :)

Reply to this Message

Bernd - 04 Jun 2007 09:08 GMT

bernd "at" e-biss.co.za

> What is your email?
>
[quoted text clipped - 35 lines]
> > > >
> > > > Help :)

Reply to this Message

Ofer Cohen - 04 Jun 2007 18:38 GMT

I sent the MDB

Signature

Good Luck
BS"D

> bernd "at" e-biss.co.za
>
[quoted text clipped - 37 lines]
> > > > >
> > > > > Help :)

Reply to this Message

fredg - 03 Jun 2007 22:55 GMT

> Hi all,
>
[quoted text clipped - 18 lines]
>
> Help :)

You don't combine it into a field.
Keep the data in two separate fields.
When ever you need to combine the data, in a report or in a form,
concatenate it, using an unbound text control:
=[Speed] & [Clock]

in a query you would use:
NewColumn:[Speed] & [Clock]

In either event, there is no need to save the combined value.

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message