Search results

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...

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...

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 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...