Creating a Dynamic % Solution

[Guest]

I,m still a novice with Access so this may seem a simple thing, I have a
database which amongst other things tracks Parts for an I.T Break Fix
Company, I want to show a Current Running % For all parts ordered/Returned in
past 30 days, I have a section which shows the running % since account open,
I created this using 3 different quiries, one for all parts ordered, one for
all parts returned and one for all parts not yet recieved, I then did the
maths bit etc, The part im having problems with is the 30 days section, if I
enter -30 in the criteria field then all I get is the day which is 30 days
back from the current date, I want it to show everything in the past 30
days... anyone any suggestions please

 

[Jeff Boyce]

John

Are you saying you want to find rows where the date in the field is greater
than today's date, minus 30 days? If so, add a criterion under your date
field in your query. That criterion would be (something like):

Date() - 30

 

[Gary Walter]

PMFBI

I think John wanted more specifically

= Date() - 30

for Criteria row under date field.

Apologies again,

gary

 

[Guest]

Many Thanks that solved the problem

PMFBI

I think John wanted more specifically


for Criteria row under date field.

Apologies again,

gary

 

[Guest]

Cheers Jeff for getting back, unfortunately I tried that and it only returns
the day 30 days prior, cheers anyway

 

[Jeff Boyce]

"Trees", not the "forest" -- Thanks, Gary!

Jeff Boyce
<Access MVP>