Viewing the Database One Week at a Time

[Victor]

How do I do this? I have almost three months of data and would like to query let's say the

month in the middle.

Am also wondering since my computer takes about three minutes to run a two or three factor

query with ALL_MSA, ALL_IMPC, and ALL_X tables linked, is this normal?

Thank you.

[fred4now]

In the date field type in
>=#9/1/2001# And <=#9/30/2001#

this would give you the month of september.

[Victor]

Fred4now,

No luck with this. This is tougher than it looks?

[Rick]

You didn't say what type of computer you are running, meaning speed.

One way to speed up queries is to index fields you use the most. You are allowed 32 indexes per table.

Another way to speed things up is creating just one table and eliminating all duplicate fields. I just did that a few weeks ago. Once you make your master table you can delete the records in the old tables. You only need the old tables to import new data and to work with races without results.

Just takes a little work and a little thought to work the bugs out. I renamed the old ALL_MSA table so the master table could have that name. I thought that would cut down on the problems of creating a new ROI report. I still had problems with some changes in field names.

[Rick]

Victor,
I just did a copy and paste and it worked as it should.

Make sure you are adding it to the criteria field of the DATE field in the query.

The other thing to check is to make sure your date field is defined as a DATE and not as text.

[Victor]

Ricks,

I'm using a 466MHz Celeron Processor. But this date thing is driving me CRAZY. I have the

date field defined as date/time and it still is spitting out all dates from the database. Thank

you for your suggestions. Is it possible to filter by date?

[Rick]

Victor,
Just start with something simple like one date. Do your query with one date. Do a view of your query to see what kind of results you are getting.

If you still have trouble with your query, send me a copy in SQL view and I will try to see what the problem is.

What I normally do is enter the date as 1 Jul 01 and Access changes the date to a form that is acceptable to it. You might also try that approach.

If that don't work, send me a copy of your table without any records in it.

[Victor]

Ricks,

I had multiple lines in my query and so I needed to specify the criteria on each line. Thank you for leading me in the right direction.

Now I will look into indexing.