Search results for query: *

I have a CR that reads results from a SQL Stored Procedure. When I look at the sp in query analyzer I see the first records as null and then the next set of operator records for Andrewsk99, but when I look at the CR I cannot see AndrewsK99 on the report, all I see is the results of AndrewsK99...

OK. Here is what I have done. Looks like it works now. Sorry for the confusion. I am very stressed with this project and not knowing CR. numberVar vol; numberVar secs; numberVar productivity; vol := Sum ({sp_get_Operator_Stats_ByDate_More_Than_One;1.Scan_Imgs}); secs := Sum...

I need to divide volume by hours to get a productivity total. The number of scanned images (volume) is 8837. The hours for that total is 06:57. When CR does 8837/6:57, it is reporting 21 mins. Its not right. When I do the formula below on a calculator I get a number that is right. Here...

I am trying to update a field with itself plus another field in SQL Query Analyzer. Update ECMTTConversion set EntryDate = EntryDate + '' + Starttime go EntryDate has only a date in it. StartTime has only a time in it. I need to concatenate them into one field. I keep getting: String or...

I am a real new newbie to CR. I want to make sure this is an accurate formula. START.... numberVar vol; numberVar secs; numberVar productivity; vol := Sum ({sp_get_Operator_Stats_ByDate_More_Than_One;1.Imgv_Imgs}, {sp_get_Operator_Stats_ByDate_More_Than_One;1.operatorid}); secs := Sum...

Is there a way to reuse one formula on several different fields by way of passing in that present fields data? I have about 20 fields on a report that need the same formula. Do I code it on all fields or can I call a function?

I neglected to mention that I will then need to use the hours in a calculation. Volume/Hours = Productivity. Should I convert the seconds first to hours then do the division or do the division using seconds (which I tried first but got erroneous results) then convert?

I exec a stored proc thru a CR. The stored proc returns a field called secondselapsed. How do I convert the secondselapsed to hours and display on the report?

This code works fine after a few minutes. If I leave the web page up and running for a long time (there is a hidden timer in the background), some of the variables go missing causing an Out of Present Range error. The holdstarttime session variable gets populated with now() when I click a...

OK. I am a newbie. I was given this query and must make mods to it to get it to work. There are 2 halves. The first half queries for volume data. The second half queries for time data. Each query half used to read data from the same tables. Now the query needs to read data from a different...

How do I loop thru a table and set a calculated value on every record? Do While Not EOF Read First Record set intField = DateDiff(Second,Date1Fld,Date2Fld) Next Record Loop Syntax please. Thanks.

Why does my SQL DTS run fine and then crap out after the last record?

Now I am getting the invalid procedure call error on this line (line 7): Ln 7: if DTSSource("Associate") = "Tarabiya, Danielle" then DTSDestination("AssociateID") = "999999" end if

GOT IT!!! CDATE!!! I finally made it pass the first few date lines in my DTS VB Script !!! Thanks.

Well, still get the same DTS error on the same line. ??? DTSDestination("FStartTime") = DTSSource("StartTime") StartTime looks good in Access. ????? What should I do now? CSTR ??? Anyone ???

I GOT IT !!! SELECT ([Date] & " " & [Start Time]) AS EntryDate

OK...this one ran but came back with #ERROR in all the cells. ??? SELECT DateAdd('[Start Time]',0,[Date]) AS EntryDate

Here is a select statement that I am trying to run in Access: SELECT Date AS EntryDate(DateAdd([Start Time],0,Date)) ...but it doesn't work. This one doesn't work either: SELECT Date AS [EntryDate(DateAdd([Start Time],0,Date))]

Thanks, but I don't really know Access either. I do not want to add dates, I simply need to concatenate them. Is there a function for that?

I made the changes that Alex suggested and still got the same errors. I flipped the padding from Date to End Time and still got the same errors. Now what? Help! Under a deadline! Thanks. Source "Date" is Access 2000. Datatype = Date/Time Short Date with a default format value set to...