Recent content by jbrod812

There is nothing there. The function does not refer to what it needs to. I need to be able to input the company and end date in the form and have the dsum in the report calculate a running sum based on the beginning date (January 1st, 2013) and the end date for that specific company.

It unfortunately did not work. I do not understand the correct syntax for using the dsum function. I need it to narrow it down based on the company that has been selected in the form, based on the start date of January 1st and end date of the end date selected on the form, and for it to sum as a...

I understand how to get the combo box and how to refer to another data point. It just when selecting the row value that I desire, I would just like to be able to input it into the record that I am adding. Example: Date Invoice Number Security Name CompanyID Deductions I just type in...

I have records with dates. I have the report that is linked to a query that is controlled by a form. On the query it says in the criteria box: Between [Forms]![Report Generator]![Beginning_Date] And [Forms]![Report Generator]![End_Date] On the form I state my beginning_date and my end_date...

Here's a picture of the relationship:

I am trying to use a combo box to select the Company in an input record form for my Transactions. In the Transaction table, each record contains the Company ID, but not the company name (I have a relationship with a Company ID primary key in a separate table that has all the companies...

Thanks, but it didn't work. What control names do you mean? The report comes from a query that is controlled by an input form. The formula did not come up with any result, just a blank box. I need to literally just start it at January 1st and end it at whatever date my cutoff is in the interval...

Ok, so now I am putting the running sum in the report. The only problem that I now face is to keep the running total of ALL of the records starting from January 1, 2013. I have a "Report Generator" form that directs a query. The report is based on that query. I need to be able to report the...

I am trying to create a user-friendly database to enter invoice records (deductions and additions) for securities. I would like to be able to run queries with running totals from month to month inclusive (end total of one month = starting total of next month). I have already figured out how to...