Search results for query: *

I have a simple report that is linked to 1 Access db table. In the table, there is an Account# field and a Cost field. If there are multiple costs with the same amount associated with the account, then it only shows up one time in the report. But, if the amounts are different, then the report...

That worked perfectly! Thank you all for your help. I believe the user has them in 2 different spreadsheets to begin with.

Hi checkai, It's hard to explain so here's how it looks... CM# Des. Fees Cost Total CM#2 Des. YTDFees 1230 Cloth 32.50 20.40 52.90 1230 Cloth 3,407.50 1232 End1 16.25 76.18 92.43 1231 Splin 2,925.00 1235 Pipe 39.00 29.38 99.38 1232 End1 3,091.25 1238 Short 67.50 66.96 34.46...

I have an excel document that has 2 fields that need to be matched up. Field1 is monthly totals and Field2 is yearly totals. Field1 may not an entry, but Field2 has them all. So, to match them up, I am inserting a blank and shifting cells down. This takes forever! I haven't been able to...

Hi, I need a formula to match 2 fields, if field1 doesn't match field2, then add blank line in field1 until the fields match. I have an excel document that has 2 fields that need to be matched up. Field1 is monthly totals and Field2 is yearly totals. Field1 may not an entry, but Field2 has...