By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,495 Members | 1,002 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,495 IT Pros & Developers. It's quick & easy.

Can I auto-combine 2 cells into 1 in a table?

P: n/a
Hi all

I have a table, where there's AutoID, Name of Person (looked up from
tblPerson), Name of Dispute (looked up from tblDispute), Date, Details
(Memo). What I have is another table that need to look up to records in
this table, but I couldn't because Access wouldn't let me look up just
an AutoID on its own...

So I created a new field in the table called Title. On the form it's
basically =[Dispute]+[AutoID]; I can get it to work ok on the form but
how can I get the end result of this to automatically appear on the
table field for the lookup?

I'm very much a novice so please accept my apologies if there's a really
simple answer to this!

Thanks for your time and help!

Best wishes
Will

Dec 18 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a

Will wrote:
Hi all

I have a table, where there's AutoID, Name of Person (looked up from
tblPerson), Name of Dispute (looked up from tblDispute), Date, Details
(Memo). What I have is another table that need to look up to records in
this table, but I couldn't because Access wouldn't let me look up just
an AutoID on its own...

So I created a new field in the table called Title. On the form it's
basically =[Dispute]+[AutoID]; I can get it to work ok on the form but
how can I get the end result of this to automatically appear on the
table field for the lookup?

I'm very much a novice so please accept my apologies if there's a really
simple answer to this!

Thanks for your time and help!

Best wishes
Will
sounds like you use Excel and think Access should work the same way.
Newsflash. It doesn't. use queries. Lookups are the work of the
devil. And do not store calculated values. you can't get lots of
things to show up programatically in a table because Access is not
really designed that way. You should use queries if you want to create
expressions or combine data from different tables. That's what they're
for.

Dec 18 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.