Recent content by Fiona H

Ok, I still have two problems... First if one combo box has been completed, I would like to prevent data entry into the other 3 (this is purely aesthetic, the macro assigned to the control button opens a form based on the selected record in the matching combo box). Second I am trying to get a...

Morning All! I'm sure I've done this before but I can't remember how... I have a form with four combo boxes on it, the four boxes all open the same form and return a record based on the selection from a different column from the same query. To make it work smoothly I think I need to make it...

With a little help from a friend... >="1/4/" & IIf((Month(Now()))>3,(Year(Now())-2),(Year(Now())-3))

Thanks for replying, I have tried using a query, it isn't going well! I need to be able to select data from the current year and the preceding two years and use that to create a new table. I can to do this if I use the actual year, but I can't make it work using fiscal years...

So, I was wondering if I am making this too difficult... I have a linked table and I am making a new table based on this which has fewer columns. I would also like to reduce the number of rows by only including data from the current financial (Fiscal in America?) year and the last two...

I love the idea of being able to do something elegant with access... maybe one day :) Thank you again for all your help today!

You're amazing thank you so much for sorting the start and finish dates of this report for me! I feel very cheeky asking after all the help you have given me already, but do you know how to group them into 15th-14th sections for each month period? I'm having no luck with that at all!!!

whoop whoop... another lap of honour round the office!! It now works using Date() Thank you very much. Now I just need to figure out how to make it go into 15th-14th segments :confused:

Ack... I am looking at date functions and playing with DateAdd without any luck. As I don't have a full 12 months worth of rolling data yet, I tried to start small and bring back the last months worth of data with this =DateAdd("m",-1,Now()) But even that isn't working for me :(

Thanks for getting back to me do quickly John... I've just doing a lap of honour around the office for having figured out how to convert time into a decimal so that I can add it up! Once it's a decimal I think iw ill be able to manupulate it ok. Thanks again :)

Is it possible to add time in a query? I have to add the number of hours overtime worked and I'm getting a data type mismatch error message. The time field is in hours, so I am wondering if I need to covert it to a decimal to add it up? Please could someone point me in the right direction...

Hi all, I wonder if anyone could give me a starting point to set up a rolling year query? My companies month runs from the 15th to the 14th. On the 16th of each month, they want to run a report showing how many hours of overtime have been worked in the last 12 months. So on the 16th...

thanks for the welcome back :) A multinational database making company... **faints** I thought one database every three years was pushing it!!!

thanks for the reply dkinley, can I use this to duplicate 10 records in one go?

ooh sorry Faspus, I guess I didn't explain properly... I want to create 10 identical records at the same time, with one click of a button. The records are created before the work takes place, therefore they can't be completed in full at the time the record is created.