Date record

[Jeff]

Hi

I've been reading up on creating reports in Access, and it seems that
many recommend having a date record with the dates for the beginning
and end of the reporting period.

I had questions on setting up this record in a query. Do you put a key
on it, and then just find the key using the where option? Or is there a
better way?

Thanks..

Jeff

 

[Guest]

It isn't clear what you mean by a "date record". Is this a one record table
with BeginDate and EndDate fields? If so, the table should only be a single
record since the table is in the front-end mdb. There shouldn't be a need for
a primary key.

 

[Jeff]

Hi Duane

Yes, I mean a one record table with BeginDate and EndDate fields. If
there's no key, how do I access the record in my query? I just thought
the key would provide me a way to get that record.

Thanks

Jeff

 

[Guest]

If there is only one record ever, then you don't need to have any key value.
If you have more than one record, you must specify the exact record that
contains the dates needed for your query.