Search results

up to the top

I have a sort starting with Due date then by partner

anyone.... bueler

Correct, but how do i reference the previous record on a report i guess is my real question

What would you suggest my expression be? I believe it would require me to reference the previous cell and due to the way access works I don't know how to do that

That deals with alternating the row colors, not alternating based on field value.. I had read that before

I have a report generating from a query that has the following data: Name...Partner...Status Hospital...CML...Open Mall...CML...Open Store...CML...Closed Hospital...MDL...Open Mall...MDL..Open Hosital...JRL...Open and I want to alternate the row highlights based on the partner column- so...

can anyone help?

Can someone point me to where I could find the information on how to make this work or provide some assistance?

Can anyone help with this?

I have a database with 3 separate tables that is tracking a small law offices billing. There are the invoices, payments, and expenses paid for filing fees etc. which are all based on a table of the customers. I need to create a report that displays the invoices with a total, the payments with...

This did exactly what I wanted it to do, the only issue I have now is formatting the total that it displays- how do I go about doing that? The 3 totals that it is summing are all currency and I would like this to also be a currency cell.

No need for the snide remark- if everyone just "paid professionals" places like this forum wouldn't exist. Now if you'd like to put your "professional" skills to use and tell me how I would add a total box on my form that subtracts one subreport total from the other I'd be very grateful.

I have a query that is for customer invoices that has an invoice total column and the query auto numbers the invoice. I have a separate table for customer payments that includes the date and amount- what I want to add to the payment form is the application to an outstanding invoice. The...

I am building a database to track invoices and payments for a small law firm- I have all of our clients set up in a client table, and then I have made a separate table for invoices and another for payments. I am now trying to figure out the best way to make a client "statement" showing the...

I created a query with 3 separate multiplication totals (Hours * Hourly Rate) and then I have a query total (Total1+total2+total3) and it works fine when there is data that has been entered into all 3 totals, but if one of them is blank it does not show a sum- is there a way to fix this to show...

I'm so happy I want to cry! Thank you!

Still returning an error message.. I have tried just about every way I can think of and I can't figure the issue out

I have 3 separate tables- Tbl_Customers, Tbl_CustomerInvoices, Tbl_CustomerPayments. All three tables are linked through the field "Customers" which is the customer's "Last Name, First Name". I have set up the fields in the invoice and payment tables to reference the customer table for the list...