Re: Table Field Auto Update?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Export the data to your old databases from a query, not a form. Then just
build the concatenated field in a new column of your query, then export the
data from the query.

If it were me, I'd have the other departments normalize their data though.
It is silly to enter it in multiple formats. What if they want to print the
name as First, then Last for some name tags or a report some day? You can't
(shouldn't) store data in every conceivable format.

Also, I would put all of this in ONE database and then let the various
departments LINK to it, not export it. Again, it seems silly to be
distributing the data and hoping that you are using up-to-date information.


--
Rick B



"Dj" <Dj@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BCE2CFB7-71AE-4E56-A4FF-E71EBA0B1AE7@xxxxxxxxxxxxxxxx
My newly created DB is being used to export data into an older existing
database with two different tables for two diferent departments.
Currently,
one department enters First and Last in their table and the other
department
enters Full.
A third department now has the responsibilty of entering the data (names
plus a bunch of other data) and we're exporting it to the older DB and
appending to the existing two table. Both existing tables have thousands
of
records and neither wants to change their format. That way my DB has to
be
able to export First, Last and Full.

"Rick B" wrote:

You don't need Full Name. In your forms, queries, and reports, you can
build that by concatenating the two fields.

For more details, read the hundreds of previous posts on the topic of
redundant data in a table.

--
Rick B



"Dj" <Dj@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AFBF5575-2C97-4B43-B4A6-87451F36A575@xxxxxxxxxxxxxxxx
My table has the following...
Last Name (Smith)
First Name (John)
Full Name (Smith, John)

(The short reason why is because different departments have different
needs/wants).

My question; with just entering Last and First, can I have Full
populate
automatically? Either from the table design or using a query? Seems
like
a
simple thing; or so I'm hoping. Thanks! j





.

Relevant Pages

  • Re: As a generale rule - Query or VBA?
    ... I agree with you Rick, I was recently working on a database that had ... the query is saved, then JET will save the fastest execution path. ...
    (comp.databases.ms-access)
  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)
  • Re: OT: SQL
    ... query processing. ... FROM Employees e, Employees m, Management mgt ... Manager and Employee Salaries. ... The scheme used does not model database files in general, ...
    (sci.logic)
  • Re: Query Data on a Form
    ... "Rick B" wrote: ... If you need to export it to another database with the address ... then Crete a query that will show the address for each record. ... the site name is found have the query auto populate the address data on ...
    (microsoft.public.access.forms)
  • Re: access 2003
    ... I removed the parameters from the form query source. ... boxes from the form header, events, code, etc and ran the form query source ... forms queries and the SQL because syntax of the SQL will change randomly. ... the Access 97 database, I wouldn't have thought any expressions would be ...
    (microsoft.public.access.conversion)