Creating a Dynamic % Solution

J

John

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
 
J

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
 
J

John

Many Thanks that solved the problem

Gary Walter said:
PMFBI

I think John wanted more specifically


for Criteria row under date field.

Apologies again,

gary
Click to expand...
 
J

John

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