Search results

Thanks for the help and guidance guys. The article by Allen Browne has been quite a help, thanks jdraw

Hi, I am looking to create a simple database which has a list of parts and their stock levels and when I raise an order it takes the quantity ordered from the current stock level. I have looked at lots of templates but they're far too advanced for what I need. I simply want to be able to...

Thanks guys, I'll play around with this and see if I can get It to work

Hi Bob, Here is the expression used to calculate the job duration 'Duration: ElapsedTime([TIME IN],[TIME OUT])' Thanks

Hi, I have a query in my Access database which works out the duration of a job. The Query has 2 columns 'TIME IN' and 'TIME OUT' then there is a calculated column which calculates the duration of each job. The problem I have is that when there is no times entered into TIME IN or TIME OUT...

I'm not sure how to upload it onto here. I'll try using the query wizard to see if I can get a total. Thanks for your help

Thanks, The result is the same 'Syntax of the subquery in this exception is incorrect check the subquerys syntax and enclose the sub query in parentheses'

Not sure if this is how you want to view it but here goes SELECT [SHIFT PATTERNS].ID, [SHIFT PATTERNS].SHIFT, [SHIFT PATTERNS].[MON START], [SHIFT PATTERNS].[MON FINISH], CDate(([MON FINISH]+IIf([MON START]>[MON FINISH],1,0))-[MON START]) AS [MON TOTAL], [SHIFT PATTERNS].[TUE START], [SHIFT...

SELECT MONTotal, TueTotal, WedTotal, ThurTotal, FriTotal, SatTotal, SunTotal, (MONTotal+ TueTotal+ WedTotal+ ThurTotal+ FriTotal+ SatTotal+ SunTotal) As WeekTotal FROM [SHIFT PATTERNS Query];

Thanks for your response. The Totals are all columns with the total column at the end of my query. I have tried entering your above solution but it returns 'The Syntax of the Subquery in this expression is incorrect'. I'm not the greatest at using Access !!

Good morning, I received some help on here yesterday which enabled me to find out the total hours worked by one of our employees for a day. I am now looking to see if there is any way I can add these daily total hours together to find out the weekly total? I have a query which has MON...

IT WORKS !! Thanks So much for your help.

Good Afternoon, I'm looking for some help with an Access Query. I am creating a time sheet / pay roll database and I want to be able to get a total of the daily hours in a query. For example I have 'Mon Start' and 'Mon Finish' for Mondays in/out times and I have a 'Mon Total' which...

Hi, Thanks for your reply I'm not sure what you mean by 'Control of the query' (I'm not too hot with Access!!) Regards

Hi, I am looking for some help with displaying the totals from a query onto a form. I have a query which has a total line showing a count of the number of entry's in each column. I would like to be able to display these totals on one of my forms in text boxes (or any other way). Is...

Hi, Tried both formulas and keep getting errors with syntax ??

Thanks for the reply Mihal, the Datediff function doesn't appear to work. I just need a similar formula like one I would use in Excel =Sum(Return Date - Sent Date) if that's possible ?

Hi, I have an Access query which has 2 fields 'Sent Date' and 'Return Date'. Sent date is input by the user when they return an item for repair, return date is input by the user when the item is sent back to us from repair. What I need is a 3rd calculated field which will work out the number...

Thanks for the reply Galaxiom, I not the best user of Access, what will I need to do in the event procedure to change the value in the combo box ?

Hi, I have an access form which has a combo box on it which allows a user to select YES or NO. I also have a command button on the form which when pressed sends a report to the intended recipient. What I want to know....is there any way that when the command button is pressed the combo box on...