Recent content by Christopherusly

reading VBA for access dummies as we speak ! :D

I know, but its a team of 20 engineers with on average 4-500 time sheet entries, there seems no way to normalize it from the system so i would have to do it manually, which would take even longer than i currently spend writing the reports. I wonder if this has been done on purpose by the...

I have an online timesheet system - its basic but does what i need - every week i pull out a CSV file with everyones time and then make a report. In order to expedite the reporting process i thought I know, lets make a database with a nice report already formatted. So far so good. HOWEVER the...

If i am honest, i am not sure i follow the logic in your approach ... would you be able to explain further ? Cheers namliam. To evaluate dates pre 2009 and post 2010 i was going to look at a nested IIF statement, just trying to get my head round the syntax at the moment. Christophe

So with some minor tweaks of TrevorGs suggestion to: Rate: IIf([Week] Between #01/04/2009# And #31/03/2010#,[2009],[2010]) I now have a working IIF statement in my database that quite correctly evaluates the date of the record and returns the correct rate. Thanks Trevor G !

Sorry its a lengthy post guys, i have tried to keep things as precise as possible. Once upon a time, my employer used to have a lovely crystal reports system that gave me all the information that i needed, then one day they decided that upgrading to SAP would be the best thing to do and oh, if...

Gents, Please find attached a blank copy of my database. Thanks for taking the time to have a look at it. Christophe.

The Gurus on this forum have always been great at helping me with the most mundane of questions, one thing i have missed out is the very basics of database normalisation - i always figured since i could get my database to do what i want, i must be doing it right. Since i have had a verbal...

See attached sample database (same as original post) which contains: tbl_BIWeek -Week -BIWeek -Billing Period tbl_BIWeek comprises of the actual week ending dates and then the SAP key weeks to match tbl_finance - this is the record of the transactions for each job - Project Manager - Field...

The only issue i see with this approach is that for a table - tblrates RateID (auto, pk) + StaffMember RateStartingDate Rate_Value I would have to repeat the list of staff each year when adding new rates, potentially there are up to 400 members of staff that i would need to add into the table...

Oohhh quite a lot to think about here :) thank you guys for taking the time to reply. it is hugely appreciated.

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...

AHHHHHHH :) thank you for your help, appreciated as always.

ahhhhhhhhhh, you are a STAR vbaINET :) thank you. one further question, how would i use NZ() ? Cheers Christophe

I have a query based on two tables. Table one gives a list of staff time transactions i.e. hours spent on a particular job. Table two gives a list of the staff rates, so enable project costs to be calcuated - hence there is a relationship between the Staff Name fields of both tables. IF i do...