Search results

I am also trying to return a date. it's for 'financial year', based on the criteria that if a month is >03 (or March) then return the year 2002/03 and if month is <03, then return the year 2001/02. I have the following expression, however i continually get error messages...

I have tried that way and it doesn't work. What i am trying to return is a financial year, in that if the month is >3 (march or 03) then the year returned is 2001/02, else it is 2002/03. I have tried to put the '03' within quotation marks, but it didn't work. ie...

Trying to return a 'year' in a query. I am converting a db from Lotus Approach to Access, but i can't work out how to convert this query. i know Access doesn't use 'Combine', so would anyone know how to convert this. please. The expression should return the 'Financial year' each time...

my problem is that i want to find the average productivity, based on members of staff. however the number of staff is likely to change from month to month. i have a table 'staff', and 'productivity' is a calculated field in a query. at the moment the chart that produces the figures that i...

it's 1200k and hotmail only lets me send 1024k, so you won't be able to receive it, obviously. send me a different email address if you can. cheers

i have sent you an email but i am not sure if you got it, there seemed to be transmission problems at my end.

it won't let me send it. can you give me your email address?

I have now got the hang of charts. now for my next problem... when in design view, i am getting a view that differs from the actual chart i am designing (in design view i am looking at a chart with a yellow, purple, green and burgandy blocks representing default values) when i switch to preview...

ok, i've managed to create some kind of a chart. i have a new problem. i want to resize the graph, the one i have created is about 2 inches by 3, and i want it, when i print it out, to fill an a4 sheet, but it doesn't seem too straightforward, short of fiddling about with the font size of the...

I am trying to put a charts on reports. the charts will display various things, representing 6 members of staff, the number of days they work in a year, the different types of days they work etc. ideally what i would like to do it type in a staff member's name, then up should pop a chart with...