Recent content by dufc

Thanks for the replies guys. bob - yes I tried changing all those things (input masks etc) but that didn't seem to solve the problem when adding a new record, so I put everything back to its original state when I posted it on here. Howere I obviously overlooked something as your solution seems...

Hello folks, I am using an access db which is one of the free one which can be downloaded from the Microsoft site. The db is an issue tracker and its pretty much ideal for my needs except for one little problem that I hope one of you lovely people might be able to help me with. When submitting...

Thank you so much Chris! Like I said in my first post, I am very new to Access, I have only been using it a matter of weeks, and I am learning new things everyday. I have a couple of books, but I find that having things explained on forums such as this is much more helpful. I will read the...

In fact I now get an error message stating that the expression is typed incorrectly, or it is too complex to be evaluated etc. My expression is now:- =CStr(Int(Sum(CDbl([TotalTime])*24))) & ":" & CStr(Int((Sum(CDbl([TotalTime])*24)-Int(Sum(CDbl([TotalTime])*24)))*60))

Woops, yes I did copy and paste his code and forgot to change it to my own field name. However, after changing it, I still have the same problem.

I have uploaded an example of my db, hopefuly that will explain what I am trying to do. Cheers. :)

OK I have now built a query that calculates the TotalTime using the StartTime and FinishTime fields. I am now trying to build a report which uses the query as its record source. Like I said earlier, I now need a grand total of all those TotalHours on the report. I did a search on this forum...

Can you point me in the right direction of how I would achieve this? Thanks.

Thanks for the reply maxmangion, appreciate it. I understand I shouldnt hold a calculated value at table level and should calculate it in the query. Like I say, I have just pulled this data that was already in a spreadsheet. I am just playing around with it at the mo so can change that in the...

Hi there folks, newbie to the forum and newbie to Access. I have problem that I hope you guys can help me with. I have a table which I have inmported from an xls spreadsheet. It shows me a StartTime, a FinishTime and a TotalTime worked. I want a report that will show me these records and...