Creating a Dynamic % Solution

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

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
 
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
 
Cheers Jeff for getting back, unfortunately I tried that and it only returns
the day 30 days prior, cheers anyway
 
Back
Top