Access 97 query to show previous 7 days data

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

Guest

I am trying to create a query that will show data for the the previous 7
days, but not the current day.
 
Select * from tablename where [somedatefield] between (date - 8) and
(date -1)
 
You could probably tell from my question that I am new to this. With that said;
I entered the following in the criteria:

Select* from [dbo_BREW_DAYAVG] where [timestamp] between (date - 8) and
(date -1)

I get a syntax error message.

I am amazed that after a week of classes on Access I have lost so much of
what I was taught. Very ego deflating.

[MVP] S.Clark said:
Select * from tablename where [somedatefield] between (date - 8) and
(date -1)


--
Steve Clark, Access MVP
FMS, Inc.
www.fmsinc.com/consulting

Dan Kelly said:
I am trying to create a query that will show data for the the previous 7
days, but not the current day.
Click to expand...
Click to expand...
 
OK, here is what I put in:
Select* from [dbo_BREW_DAYAVG] where [timestamp] between (date - 8) and
(date -1)

it returned a syntax error. Can you tell I'm new to this ;-)

After a week of classes, I would have thought I would retain more of what I
was taught. Very ego deflating...

[MVP] S.Clark said:
Select * from tablename where [somedatefield] between (date - 8) and
(date -1)


--
Steve Clark, Access MVP
FMS, Inc.
www.fmsinc.com/consulting

Dan Kelly said:
I am trying to create a query that will show data for the the previous 7
days, but not the current day.
Click to expand...
Click to expand...
 
Ok, I tried the following but got a syntax error:

Select* from [dbo_BREW_DAYAVG] where [timestamp] between (date - 8) and
(date -1)

I'm sure you can tell I am new to this. Thanks for your help.

[MVP] S.Clark said:
Select * from tablename where [somedatefield] between (date - 8) and
(date -1)


--
Steve Clark, Access MVP
FMS, Inc.
www.fmsinc.com/consulting

Dan Kelly said:
I am trying to create a query that will show data for the the previous 7
days, but not the current day.
Click to expand...
Click to expand...
 
Well isn't this embarassing. I kept getting errors when replying, now I see
that they were in fact posted.
 
Dan Kelly said:
Ok, I tried the following but got a syntax error:

Select* from [dbo_BREW_DAYAVG] where [timestamp] between (date - 8) and
(date -1)

I'm sure you can tell I am new to this. Thanks for your help.
Click to expand...

No space between "Select" and "*".
 
Back
Top