And, as a stylistic suggestion, don't use a separate field for
transaction year, calculate it from transaction date. The reason is
that you've created a new classs of issue for yourself by doing this,
keeping two fields in step.
In general it's best to store basic data and calculate
On 10/04/2012 06:29 AM, Mark Stanton wrote:
And, as a stylistic suggestion, don't use a separate field for
transaction year, calculate it from transaction date. The reason is
that you've created a new classs of issue for yourself by doing this,
keeping two fields in step.
In general it's
Register1a is a table with field Trans-Date of type TIMESTAMP. Field
Trans-Date-Year is either TIMESTAMP or INTERGER. I have tried with both.
Update Register1a Set Register1a.Trans-Date-Year =
YEAR(Register1a.Trans-Date);
Looks like is should be a very simple SQL statement. It does absolutely
Base will only run SELECT statements that way. If you want to use other
than SELECT the only way IIRC is to use Tools-SQL which opens Execute SQL
statement but can only handle typed stuff, not stored queries. It is
useful for one-off tasks such as merging two tables into one or doing a
field