Question on Date in a tble

[Lensmeister1968]

Good evening all,

I have started building some table in a DB I'm hoping to create.

In the Table TOC
I have a field for a date.
Many of the dates are older ones.
BUT
There are a number of then that are on going so I need only those ones to be the current date when the DB is opened.
Is this possiblt if so how ?

Thanks in advance.

 

[XPS35]

Use a query to select the records with the current date. Something like

SELECT * FROM TOC WHERE TocDate = Date()

 

[Gasman]

You need some sort of rule.
If you cannot do it on paper, you cannot do it in Access.

 

[oleronesoftwares]

hi,
i don't seem to understand what you are trying to achieve, snapshots of your table will help me understand better. Though a select query as record source should help you achieve what you want.

 

[mike60smart]

Good evening all,

I have started building some table in a DB I'm hoping to create.

In the Table TOC
I have a field for a date.
Many of the dates are older ones.
BUT
There are a number of then that are on going so I need only those ones to be the current date when the DB is opened.
Is this possiblt if so how ?

Thanks in advance.

Can you upload the database?

 

[The_Doc_Man]

What I did for "future dates" was that ALL dates that didn't default to Now() or Date() (today's date with or without seconds) would default to 31-Dec-9999, which is the largest - and most distant - future date you can have. Easy to trap, too, because the day number is absurdly large. Doing that, I was easily able to exclude dates with something like "WHERE .... AND ( EventDate <> #31-Dec-9999# ) AND ...."