ACCESS 2003

[Guest]

Should I group all years of a database into one table or separate tables?

 

[tina]

one table. just add a field to designate the year; or, if the table already
has a Date/Time field, you can simply query for a specific year from an
expression based on that field, as

Year([DateFieldName])

hth

 

[Guest]

Tina,

I am only just learning access therefore your message only makes partial
sense to me.

I understand that if i have a table already built, then i need to put a date
field in but when all the data was in one table i queried with specifics and
still got bogus data with other years. I even did a criteria with a between
datas and still got bogus data. My question is this, would the data be
cleaner with one table, so that when I query i need to get particular dates
without bogus data?

one table. just add a field to designate the year; or, if the table already
has a Date/Time field, you can simply query for a specific year from an
expression based on that field, as

Year([DateFieldName])

hth

Should I group all years of a database into one table or separate tables?

 

[tina]

is the "date" field in your table a Date/Time data type? if so, then likely
you're not writing the query criteria correctly. please post the SQL
statement from your query. to do that, open the query in design view, then
from the menu bar click View | SQL. in the SQL pane, highlight the *entire*
text, copy it, and paste it into your reply message.

hth

Tina,

I am only just learning access therefore your message only makes partial
sense to me.

I understand that if i have a table already built, then i need to put a date
field in but when all the data was in one table i queried with specifics and
still got bogus data with other years. I even did a criteria with a between
datas and still got bogus data. My question is this, would the data be
cleaner with one table, so that when I query i need to get particular dates
without bogus data?

one table. just add a field to designate the year; or, if the table already
has a Date/Time field, you can simply query for a specific year from an
expression based on that field, as

Year([DateFieldName])

hth

Should I group all years of a database into one table or separate

tables?