Search results

No, it's only time.. If I was to change it to use a date I have one field in my table where the user has to type the date each day (Short Date, 26/08/2012), can I referance that some how to show.. I'm not adverse to re-writing the entire table, however I have 13 Place and 13 Pull records to...

Hi all, please help me... I have a form that calculates time (In Minutes) however i'm having a little trouble with one specific iif statement (Below).. What it should do: Place Time (KPI) 01:00 Place Time (ACT), could be any time from 22:00 - 04:00 Hours It should process the time in...

OK, so I have managed to create a report containing the roster, what I need to do now is have the ability to filter the results so I get only the selected 5 weeks show on the report. Main Issue: Each set of five weeks is contained in one record, with the date fields as follows. [RoDate]...

Thank you, I really do appreciate this. Please dont laugh too loud when you open this, i have good hearing, lol. :eek: I think one of my problems is that each late code and cancelled code for that matter has about 15 or 20 lookup's in it's list. If you have any better ideas how I could...

Now comes two stupid questions. 1: Where it says LateCode1, do I have to repeat this through to 13 2: Where does this go, into VB on report??

Hey all, just wondering if there is a way in a query to count what was selected in a combo box from a form, these selections are written back to the main table. I have many codes, however I need to count how many times each is used in a week, month, year... I have a query that can grab and...

I was tasked with making a roster, not so bad, threw it together... Now I have been asked to make some changes to it that I'm not so sure I can do... If someone is able to spend some time looking at it and helping me out, I would really appreciate it. :confused: We have 5 staff, our roster...

Hi All, I am from New Zealand, I am a newish Access user and will have plenty of questions, I live in the shaky city of Christchurch and am into RC monster trucks... I'm very pleased to be here and hope to participate as much as possible. :) Cheers B