Search results

  1. G

    Summing up sums

    Results are as... The reply that I recieved did not help very much but try and try again and sometimes you fiqure it out on your own. This is the way it should look and it works just fine. =Summe([Fieldname]+[Fieldname]+[Fieldname]+[Fieldname]+[Fieldname]) Hope someone else kann use this info.
  2. G

    Summing up sums

    Hi and I´m not the best access programmer but I try. I have summed up different fields in my report by useing =summe([fieldname]) and this works out great. Now it would be even nicer to be able to summ up the total of all summs. How should my formula look like ?? Thanks Geneo
  3. G

    where is the Database backup

    Where Does, if even does Access store itself in a .bak form ? A coworker resently deleted a complete collumn and since then the computer has been rebooted. It would be very nice if I could retract the deleted information. Thanks Yes this is somewhat urgent Geneo
  4. G

    List field selection

    Hi everyone, I am trying to pull data out of a Table through a list field and place it in a text box. So far so good. Now the problem beginns: The customer nummers are more than 1 digit of course. When I wish to find the customer with the nummer 123, all I can get is either the 1 or the 2 or...
  5. G

    Help with maximizing reports from parameter

    Maximize Maybe you should use set macro to open your report 1. choose "open report" and in the box choose the report wished. 2. choose "maximize" 3. save new macro This must work. I wish you luck. Geneo
  6. G

    Ack! Please help.

    How you by any chance in the report foot or the page footing. The summing must be in the report foot.
  7. G

    Summing two columes

    My two fields are date fields with the format "09:00:00>LL;0;_" in my table and in the report as "time24h". The singel colum addition works perfect but adding both together is the problem. Thanks for your advise and cooperation.
  8. G

    Summing two columes

    Sorry Alley but it didnt work. What does happend is, I recieve in my report both summs next to each other and not added together. I am attaching the file so you can see my problem in the flightlog, bottom right. It should read 47:20. Thanks anyway, we are getting closer.
  9. G

    Summing two columes

    Well I´m back for another simple question (atleast for the most of you databankers). I have used the following formular to add all of my given hh.mm. exceeding more than 24 hours. Now it would be nice if I could add these two results inorder to get a total of both fields. How is this possible...
  10. G

    Time addition

    time addition Thanks for the tip and for those that wish to know here is the secret formula. "Feld" shall be replaced with your own field name. =Format(Int(Summe([FELD]))*24+Stunde(Summe([FELD]));"00") & ":" & Format(Minute(Summe([FELD]));"00") Geneo
  11. G

    Time addition

    How is it possible to add time farther than 24 hours ?
Back
Top Bottom