Christopherusly
Village Idiot.
- Local time
- Today, 12:25
- Joined
- Jan 16, 2005
- Messages
- 81
SOLVED - Date dependent element of query.
This is probably a stupid question, but having searched the forum(s) and scoured my Access book i am damned if i can find an answer, so i turn to you good people for a hand.
What i think i need is some sort of IF statement, let me explain.
I have a query which is run from three tables
- tbl_finance
- tbl_graderates
- tbl_BI week
tbl grade rates has rates for 2009 and for 2010 which are used in calculating the cost of time spent on a job by any member of staff. Rather than having two separate databases for the different hourly costs, i want to have a single database which will look at the date of the record and determine which rate to use
i.e. between 01.04.2009 and 31.03.2010 USE 2009 RATE
between 01.04.2010 and 31.03.2011 USE 2010 RATE
So when i run the query it will look at the date of the record and use the correct rate and enable me to have some jobs that straddle the financial year AND use both 2009 AND 2010 rates.
HELP ? - please see attached sample database if i have not explained myself clearly enough please shoot with the questions.
THANKS GUYS
This is probably a stupid question, but having searched the forum(s) and scoured my Access book i am damned if i can find an answer, so i turn to you good people for a hand.
What i think i need is some sort of IF statement, let me explain.
I have a query which is run from three tables
- tbl_finance
- tbl_graderates
- tbl_BI week
tbl grade rates has rates for 2009 and for 2010 which are used in calculating the cost of time spent on a job by any member of staff. Rather than having two separate databases for the different hourly costs, i want to have a single database which will look at the date of the record and determine which rate to use
i.e. between 01.04.2009 and 31.03.2010 USE 2009 RATE
between 01.04.2010 and 31.03.2011 USE 2010 RATE
So when i run the query it will look at the date of the record and use the correct rate and enable me to have some jobs that straddle the financial year AND use both 2009 AND 2010 rates.
HELP ? - please see attached sample database if i have not explained myself clearly enough please shoot with the questions.
THANKS GUYS
Attachments
Last edited: