Search results

pbaldy, that was it. Had to go into the VBA and put rounding there! Thanks!

I have related forms, Hdr and detail. The details total of extended and tax roll up and post to hdr fields named "totaloflines" (58.50) and "totaloftax" (2.93). That should make a grant total of 61.43. However, on the hdr I have a field name sliptotal and the control source is...

Not sure why, but it is the negative field comparison which is throwing this off.

INSERT INTO jobalerts ( cust, [job#], jobstart, esthours, esthourstotal, estmatltotal, estsubtotal, estjobtotal, jobhours, joblabor, jobmaterial, jobtotal ) SELECT jobs.cust, jobs.[job#], jobs.jobstart, jobs.esthours, jobs.EstHoursTotal, jobs.EstMatlTotal, jobs.EstSubTotal, jobs.estjobTotal...

cust job# jobstart esthours EstHoursTotal EstMatlTotal EstSubTotal estjobTotal jobhours joblabor Jobmaterial jobtotal Prange 5 30-Oct-14 1175.41 $52,893.00 ($882.00) $0.00 $52,011.00 1175.41 $52,893.00 ($882.00) $52,011.00 Pasted into and copied from Excel shown above

The numbers have been rounded before but the fields in the base table are all defined and populated with INSERT INTO - as double , currency and 0 decimals, except for hours which is fixed and 2 decimals?

I used just the < and the material amount is EQUAL even though negative in both fields ??

I have a report which ONLY shows records where the Estimated amount is LESS THAN the corresponding ACTUAL amount, on ANY 1 of the 4 comparable fields. I have the record below appearing on the report and I cannot figure out why? esthours EstHoursTotal EstMatlTotal estjobTotal 1175.42 52894...

You have MADE my Day (and maybe I WILL be able to get some sleep tonight). Spot on! Case Solved! Thank you MUCH!

I wish I could say YES ;-)

SELECT Left([cust],InStr(1,[cust],"-")-1) AS custx, Val(Right(Trim([cust]),Len(Trim([cust]))-InStr(1,[cust],"-")+1)) AS Job Above works IF there is a blank in byte 1, but NOT if byte 1 of field to be split is filled! custx Job....... Cust w x y 1.......... w x y-1 w x y...

I missed what U said. You meant that the Rate table should NOT be tied to the Job table, right?

Either way, it would be.

Either way, it would be.

System is evolving! Right now, there is no Job # or job table. Just a simple customer table tied to a rate table which has an effective and discontinued date for the rates (may be multiple start/end combinations which skip no calendar dates) used to apply toward billings - by work accomplished...

Thank you. I never thought of that rate code, but that sounds like the best Design! I will revisit that!

What's the cleanest way to do this: I have a customer master which has a 1 to many relationship with 2 different rate tables. Customer = Jones, and a few other master fields such as addr., etc. ----------------------------------------------------------------------- Rate1 Table looks like this...

I changed it to a Private class and that seems to solve it!

Option Compare Database Public Sub EditTableData() Dim count As Single Dim savestart As date Dim saveend As date Dim rs As DAO.Recordset Set rs = CurrentDb.OpenRecordset("SELECT * FROM rates") count = 0 'Check to see if the recordset actually contains rows If Not (rs.EOF And rs.BOF) Then...

I don't understand: Forms![Rick - Customers Table Update NEW]![Rates Subform]!SaturdayStart Checking the debug value of the above - I am getting a value of 'true' ????