I am trying to make an end of day cash out report and category report for the day. I have the cash out part working, but I can figure out the categories report. I have attached my database, can anyone help with that?
You're missing at least one other file, so what you've uploaded is incomplete. I looked at your Repair table, but didn't see any reference to a "Category." What were you trying to accomplish with a category report?
I am using the invoices table for the report. I have a layout made for the cash out already.
What field did you want to use for the category?
I have a category field in the products table.
Ok, I've thrown something together for your review. I had some difficulty as the data seems to be missing so when running the report there wasn't much to display. That's always an issue when creating a report - you need to have enough of the right data so when the report is run you have something to look at.
The database seems overly complex and unnormalized, making reporting and organizing the data difficult, and potentially, impossible. It appears like some of the databases I've seen that have grown organically, over time. Often, it's easier to step back, review the current business processes and requirements, and start fresh. It can help define and streamline the process of reporting.
Sorry for the late reply, I have been super busy. How do I download your copy of it?
Oh, if you're reading this via email, you'll need to log into the community and there's a link to download the file.
I took a look and it's not exactly what I was looking for. I apologize for not describing it very well.
I attached another database with a table tabled T12_Cashout and a layout as well. In that layout I have two fields, _DateOfReport, which is what the relationship to the invoices table is based on, CategoryReport, and a portal to the line items. I am trying to make a script to cycle through the line-items portal on the T12_Cashout layout and total the line items by category and place category name and total for that category onto a field on the table. I starting making the script, CategoryTotal, just not vary sure how to make the script work that way. That's at least the only way I could see it working, any help would be appreciated.
Retrieving data ...