Re: Table Field Auto Update?



"fredg" wrote:

On Tue, 25 Apr 2006 08:40:02 -0700, Dj wrote:

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



You seem intent upon using Access improperly.

Store just the First Name in it's own field, and the Last Name in it's
own field.

Then create a query that concatenates the first and last name

FullName:[LastName] & ", " & [FirstName]

add whatever other fields to the query that are needed.

Export the query, not the table.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail


Trust me, it's not me who's intent on using the db improperly. I'm just the
lowly newby - wannabe Access developer who's trying to do things the right
way which is why I've become so dependant on this wonderful message board.
It's the experienced developer(s) who set up their original db and said they
don't want to have to change anything in their existing database to
accomodate the exporting of my data which in the end is going to save them a
ton of time.

.

Relevant Pages

  • 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: 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)
  • RE: Import external data - web query
    ... Your reply for my query is very extensive, this is for importing a file from ... The data source I want isn't listed in the Select Data Source dialog box. ... information used to connect to a database. ... Check your driver First, make sure you have the right ODBC driver (Open ...
    (microsoft.public.excel.misc)
  • Re: access 2003
    ... I removed the parameters from the form query source. ... synchronize combo boxes to the detail section or the parameter form query ... 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 ...
    (microsoft.public.access.conversion)