how to date records with no date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have rebuilt a crosstab query to use the datecreated field (data type=date)
that vived me a table to visualise my creative productivity. It's part of my
studio database system I am building (ongoing).

However I have struck a wee problem and unsure what to do.
The old crosstab used a year field and a date field and worked reasonbly well
the new crosstab uses datecreated and an expression that extracts the year
from the date.

That works.

The problem lies with some early art works of mine that i only know the year
created as I didn't write he date on the rear of the drawings.
The new crosstab doesn't "see" these works as they only had a year created
but not a date created.

I'm unsure how to work out what date I should put in for these early works.

The reason for rebuilding the crosstab query is because I am wanting to
remove the year field as for at least 90% of records this is redundant data
 
I'm unsure how to work out what date I should put in for these early works.
Click to expand...

Well, if you know that a work was created in 1992, what date do you
WANT?

You could pick an arbitrary date - January 1, or July 1 - and use an
expression:

NZ([DateCreated], DateSerial([YearCreated], 1, 1))

to replace the NULL DateCreated value by January 1 of the year
created; for July 1, use 7, 1 instead of 1, 1.

John W. Vinson [MVP]
 
Thanks.

I think I will look at the drawing, try to decide whether it was drawn early
or late in the year and then assign a date.

It's only some early works - 1993/94 that I have to do this for.

A few modern digital projects have a similar problem such as website
redesigns but for those I can consult the archive and look at the last
modified date as for those I use the date of completion.

Once I have finished dealing with this then I can remove the year field.
The date is used in a crosstab query that tables my creative productivity

John W. Vinson said:
I'm unsure how to work out what date I should put in for these early works.
Click to expand...

Well, if you know that a work was created in 1992, what date do you
WANT?

You could pick an arbitrary date - January 1, or July 1 - and use an
expression:

NZ([DateCreated], DateSerial([YearCreated], 1, 1))

to replace the NULL DateCreated value by January 1 of the year
created; for July 1, use 7, 1 instead of 1, 1.

John W. Vinson [MVP]
Click to expand...
 
I think I will look at the drawing, try to decide whether it was drawn early
or late in the year and then assign a date.

It's only some early works - 1993/94 that I have to do this for.

A few modern digital projects have a similar problem such as website
redesigns but for those I can consult the archive and look at the last
modified date as for those I use the date of completion.

Once I have finished dealing with this then I can remove the year field.
The date is used in a crosstab query that tables my creative productivity
Click to expand...

Well, pretty clearly there is no built-in Access solution; assigning these
dates requires USB (Using Someone's - yours in this case - Brain).

John W. Vinson [MVP]
 
This is when I confirm my offline project archives work. They are on either
cdr or dvdr disks.

In the case of digital projects I am looking up the archive volume number
(wich is written in each record for digital works), pulling the disk and
opening the finished (or last file) to retireve its created date.

The early drawings will require cranking up the old Mk1 grey matter unit.
 
Back
Top