Re: default value equals a different field value

From: David Portas (REMOVE_BEFORE_REPLYING_dportas_at_acm.org)
Date: 05/18/04 

Date: Tue, 18 May 2004 21:51:04 +0100

No. But why would you want to store the full name if you already have first
and last names? Just concatenate the two when you query the table. 

-- 
David Portas
SQL Server MVP
--

Relevant Pages

  • Re: Compare row data and input data into a new field
    ... >I have a simple query which I cannot seem to work out and would like some ... Hi Newman, ... Why store it in the table and recalculate it each time you need it? ... Hugo Kornelis, SQL Server MVP ...
    (microsoft.public.sqlserver.mseq)
  • Re: Need help with a SQL Query
    ... I get store id 6380 as a result when I run these against pubs. ... BG, SQL Server MVP ... Peter, this is a relational division problem. ... > I need help with a query below. ...
    (microsoft.public.sqlserver.programming)
  • Re: Alpha number attached to auto number
    ... the A actually means something; used with the autonumber it is almost ... >> store it, I know I can make my form show the auto number but am having ... Concatenating in my query is ... >>> variable) store it in a separate field and concatenate it for display ...
    (microsoft.public.access.gettingstarted)
  • Re: Concatenate Text Field
    ... then an update query to concatenate any Journal values into your memo field? ... If there is a date field for the importTable, you could store that as a last ... > I have tried the append query but it adds new records ...
    (microsoft.public.access.queries)
  • Re: Saving calculations done in a form back to a table
    ... Store the individual fields in the table, and just concatenate them ... You can do this in a query, ...
    (microsoft.public.access.forms)