Search results for query: *

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...

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...

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

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 :=...

The date feild I am using is {hub.date feild} its is a date time 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...

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...

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...

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

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...

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

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...

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

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

Ace man how do I find the forms record source??

thanks harley i'll give it a try

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...

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?

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??

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...