Search results for query: *

I inherited and am making alterations to an access db that stores prospect bidding information. All of the bidding data is stored all in 1 main table, with supporting tables to hold predefined values for columns in the main table, basically foreign key type stuff. There is a form set up to...

I did an IsNull. I also check the properties of the database and the column is not nullable. There is a default constraint on the column set to ' '. I thank you for your time. I worked around it by converting the value to minutes and subracting them like this...

I am using CR XI, yes. However, I can't run the report within CR XI because the application I'm integrating this with creates the data and stores it into a temp table I run off of.

I've tested for nulls. There are none. Here's the original database fields. Note that the wo_date_list2 field is a datetime field and all times are 12:00:00 am. I also, I ran this report for just 6/20, so all wo_date_list2 values are 6/20/08: WO_date_list2 estimated_complete_time my...

I want to go on record as saying I didn't write this report, I was asked by the author to try to figure out why this report errors. I'll have to ask the author why she's taking that field from a date to text. Anyway, I made that change and it still errored. I also tried putting in a formula...

{@DateTaken(Requested)} is totext(cdate({WO_HEADER.WO_Date_List2})) WO_HEADER.WO_Date_list2 is a datetime. The problem is the application does not let them specify the time part of the datetime, so all the times are 12:00:00 AM. They have this separate varchar field where they can put in the...

I added that, but still get the error. I do not know if there can be spaces - this is day 3 on the job for me and I'm not sure how to get to this data through the app they use. However, the data that comes back does not show any record with "000001". It is all good-looking data. What stumps...

Thanks for responding. Length command brings back values of 6. There are no nulls in my data.

I am trying to write a report that does a datediff or dateadd, such as: Dateadd("d", 1, {@DateTimeTaken}) < CurrentDateTime. The error message I get is 'Hour must be between 0 and 23'. Now, the formula field I created that is causing the problem is: @datetimetaken...