Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. tazibc

    time formula feild

    Ibass the date feild would be the same for both the PTA and ATA as we are running a parameter on one feild the date feild. So we have in our record selection of the report:- {Weekday_Hub_Data.Late Trunk, Inbound/Outbound} in ["IN", "OUT"] and {Weekday_Hub_Data.Date} in {?Start Date} to {?End...
  2. tazibc

    time formula feild

    I have now converted my datetime feild to a date feild as below:- date({hub.date}) and now inserted it into the formula below:- whileprintingrecords; numberVar dur := datediff("s",datetime({@convert to date},{@PTA}),datetime({@convert to date},{@AAT})); numberVar hrs; numberVar min; numberVar...
  3. tazibc

    time formula feild

    Sorry the error is a date feild is required here and my date feild is a datetime feild could this be a problem??
  4. tazibc

    time formula feild

    Ibass I have replaced currentdate with my date feild in my report as the following below:- whileprintingrecords; numberVar dur := datediff("s",datetime({Weekday_Hub_Data.Date},{@PTA}),datetime({Weekday_Hub_Data.Date},{@AAT})); numberVar hrs; numberVar min; numberVar sec; stringVar hhmmss; hrs :=...
  5. tazibc

    time formula feild

    The date feild I am using is {hub.date feild} its is a date time feild
  6. tazibc

    time formula feild

    essentially each time is for a different vehicle i.e Vehicle ID PTA AAT Mins Early HARLOW -02T 23:55:00 00:25:00 uses formula BASINGSTOKE -3T 22:10:00 22:20:00 so on each day the above vehicles could run on differnt times as the report is run...
  7. tazibc

    time formula feild

    thanks Ibass its sort of works but what it doesnt do is take into consideration the 24hour clock for example if i have a PTA time of 23:55:00 and a AAT time of 00:20:00 this gives me using the formula above -23:-35:00 which is incorrect is there anyway to overcome this. The actual answer should...
  8. tazibc

    time formula feild

    For example my PTA (planned time of arrival) may have the value 22:35:00 and my AAT (actual arrival time) has the value 23:20:00. Using common sense to get my mins early formula I use:- PTA - AAT using the values above this returns a value of 83,700.00 which is incorrect I want to get the...
  9. tazibc

    time formula feild

    hi my formulas for PTA are:- TIME({Weekday_Hub_Data.Arrivals, Hub Planned Arrival Time}) my formula for AAT is:- TIME({Weekday_Hub_Data.Arrivals, Hub Actual Arrival Time}) this is driving me mad pls help anyone
  10. tazibc

    time formula feild

    I have a string feild which I have converted into time called PTA(planned time of arrival) and another string feild also converted into a time feild called ATA(actual time of arrival).I have put these feild son my report and they appear fine as time feilds. I want to work out the mins early...
  11. tazibc

    date formula

    All I need the report to give me is the previous weeks data from Sat to Sun. Ive tried the above fromulas but with no success
  12. tazibc

    date formula

    when i run this formula it brings back blank values on my report. I have created both formulas as suggested and put them in my record selection formula below:- {Weekday_Hub_Data.Arrivals, Vehicle Route ID} <> "" and {Weekday_Hub_Data.Late Trunk, Reason Code} <> "" and {Weekday_Hub_Data.Late...
  13. tazibc

    date formula

    Pls can some one help I have a date feild and I want to run a report over a week period with out the use of parameters so the report will only give me a weeks worth of data. {date.feild} how can this be done pls help
  14. tazibc

    help running a report over a week period without parameters

    Hi All, an anyone help..... I have a report that I need to run over a week period without the use of a parameter. I need to know how to create a formula that could be implemented into a record selection. {weekly hub date} is the field can any one help with this please
  15. tazibc

    is there away I can tell??

    Ace man how do I find the forms record source??
  16. tazibc

    i want to add more data to a form

    thanks harley i'll give it a try
  17. tazibc

    i want to add more data to a form

    so would my code look like this??? DoCmd.OpenForm "Manchester", , , "[Service Centre / Satellite] = 'Manchester' and [Service Centre / Satellite] ='Chester'and [Service Centre / Satellite] ='nwales'and [Service Centre / Satellite] ='penrith", , , strUser so in essence the form will open...
  18. tazibc

    i want to add more data to a form

    Thanks Harley, but what if i wanted the form to show information for manchester and chester and penrith all together would I replace the OR statement with AND?
  19. tazibc

    is there away I can tell??

    is there away I can tell what database a specific from was generated off. I have 12 forms and two similar databases is there away I can tell what data source a form is using??
  20. tazibc

    i want to add more data to a form

    pls help I have created a login form which opens up another form teh code looks like this:- ElseIf strUser = "user4" And Password = "user4" Then MsgBox "Access Granted" DoCmd.Close DoCmd.OpenForm "Manchester", , , "[Service Centre / Satellite] = 'Manchester'", , , strUser can any one tell me...

Part and Inventory Search

Back
Top