Search results

Sorry to waste so much of your tome but if i use: Expr1: Int([job log in]![time qc totally complete]) in my query expr1: returns this output in that field Expr1 37957 37931 37935 37935 37935 37937 38006 38006 38006 38006 38006 38006 38006 38006

So in the query would that loook like expr1:int(job log in]![time qc totally complete]) ??

at this point a quick fix, and then the technical answere when you have time. Thank You

I have thousands of records in the table that are NOW(), can I cange the NOW in the query to date()??

yes I am using NOW(), how can I change that to date in the query?

forgot attachment sorry forgot attachment

I have a report that calculates "total pages" by group and then overall. If I run 1/1/05 - 1/31/05 I get 10326 pages for report total If I run 2/1/05 - 2/28/05 I get 11206 pages for report total If I run 3/1/05 - 3/31/05 I get 9567 pages for report total this totals 31,099 pages for the...

SELECT [Job transfered to].[Job Number], [Job transfered to].[assigned to], [Job transfered to].[Start time], [Job Log in].[Client Number], [Job Log in].[Matter Number], [Job Log in].[Client ID#], [Attorney Profiles].[Client Name], [Job Log in].[Work Type] AS [Job Log in_Work Type], [Work...

See attachment

Yes unless you change the form background color. Otherwise the tab box will blend in to the background with the exception of the outline

see attachment

In yoou query under "Criteria" say you want records for a specific employee number. put [Enter Your Employee Number] then when you run the query or report a pop up will appear saying "enter your Employee number" and only those records will pull from the query.

Why not do the calculation in your report or on a form? sum the amounts and then subtract them to come up with the difference in a text box.

are you displaying them on a form or report? if so run the form or report from a query and just omit that field.

shorttime: Int([job completed time]-[job start time]-CDate("0:0:" & DatePart("s",[job completed time]-[job start time])))*24+DatePart("h",[job completed time]-[job start time]-CDate("0:0:" & DatePart("s",[job completed time]-[job start time]))) & Format([job completed time]-[job start...

I have a query with the field "start time" this field is autofilled with NOW() when a button is clicked and the macro runs. This has worked for 4 years all of a sudden the field "Start Time" in the query has decided to become locked or un-updateable. If I open the table the field can be...

I have this calculation in my query: ColorTime: [ColorTotal]/([ColorSpeed]*0.6) However [color total] and [color speed] can be 0 and this gives me an error message. How can I change it so that if they are 0 it will give me 0 for an answere? all help appriciated.

Thank You! It has been a great help.

Thanks that did it one more question if you don't mind. I am trying to search between dates. In the criteria field I am using the code. Between [forms]![Report Date Range]![BeginDate] And [forms]![Report Date Range]![EndDate] however, it only returns the dates that equal the date and month of...

I have a text firld that I am converting to a date with this code in a query. Hired: Year([POSITIONSTARTDATE]) & "/" & Left([POSITIONSTARTDATE],5) However my date comes out backwards 2004/01/01 Can I format this correctly? 01/01/2004 Also it will not let me search by a date range. any...