Search results

  1. E

    New to Access, but find it very useful!

    Thanks for the help!
  2. E

    New to Access, but find it very useful!

    Thanks Rain for the validation that Access will be useful in the energy industry ;) I am busy trying to design my own time billing access template, which is taking a surprisingly long time! My employees want to port across to another time billing option, as at the moment they are using Excel...
  3. E

    New to Access, but find it very useful!

    Indeed! The wines around here seem to be well known.
  4. E

    Question Time billing form

    Hi Burrina, I seem to have your input on Grandtotal in the query working properly!!! Thanks so much. I now have a total number of hours worked on each task that's getting inputted into the table from the form. Brilliant! I just now to multiply total time (Grandtotal) by the hourly rate to give...
  5. E

    Question Time billing form

    Hi Burrina, thanks. I cannot post links because I am new here and only have 4 posts total. I followed your screenshot, I was putting your code into the Criteria row, when it should have been in the top field row, as in your example. The query is now running, but the output is not correct for...
  6. E

    Question Time billing form

    Hi. I've just tried using this instead in the criteria row, DateDiff("n",[StartTime],[EndTime])/60 This returns a query output table with just a single column populated with one date. The rest of the columns with start/end and billablehours are blank. Any ideas?
  7. E

    Question Time billing form

    Hi, Thanks for the advice, unfortunately I don't know how to input that code into the query. When I place it into the Criteria row and run the query, I get the error, "The expression you entered has an invalid . (dot) or ! operator or invalid parentheses. You may have entered an invalid...
  8. E

    Question Time billing form

    Hello everyone, Just have a general query that I couldn't place in the relevant thread, because I don't know Access well enough. What I am trying to do, is create a time billing form to track time spent on different tasks, with the following items in a neat form, in this format: 1) Client 2)...
  9. E

    New to Access, but find it very useful!

    Hi everyone, Just introducing myself. I'm from South Africa, and I'm in the energy industry. New to Access but so far have found it quick versatile and streamline to use. Hope to speak to some of you soon, Cheers Energy
Top Bottom