Recent content by JahJr

I got it working. The db had some files that were not stored as dates in the tblFees. I corrected those along with the Query1 edit and everything is working as it should . Thank you

That is really close. It works for 3/31/20 but all other dates return the following error "At most one record can be returned by this subquery." It is Query1 that is throwing this error. I changed Query 1 to the following SELECT tblAccountValues.AccountNumber, tblAccountValues.AccountValue...

I have 3 tables tblAccountNumbers tblAccountValues tblAccountFees I need to build a query that pulls the account value for each account number and pull the correct % Fee. The account fee that is getting pulled in from tblAccountFees should be the fee that has an effective date that is <= to...

I don’t believe I’m changing my request. From my example I posted in #7 I’m needing to calculate the total cash from dividends. This calculation will always start at the beginning and need to figure out how many shares were owned on the dividend date and then multiply the shares owned by the...

Ok so i could use the date from my form but i still need to know how many shares were held on each dividend date. I don't know how I can do that with out comparing it to itself. If you look at my post #7 I don't see how i can get the results needed in the second table without creating some...

I've made it a little bit closer but still can't get it. I've got the following query which gives me the total of all shares for all dates. If I remove the date criteria it gives me the total of the all shares for the correct symbol. The date criteria is giving me problems. SELECT...

Dividend Table Example DATE Symbol Amount 8/1/2020 A .50 8/1/2020 C 1 8/16/2020 A .51 8/16/2020 C 1.01 10/1/2020 A .52 10/1/2020 C 1.02 I'm trying to figure out how much cash would be available on a particular date. Below is what I'm looking for and can't get a query to work...

I've got the above working, I also have a table titled dividends. It has 3 Columns DATE SYMBOL AMOUNT I need to create a query that will tell me what the divided received is. The query would need to have a calculated column that was suming the number of shares held on the dividend date...

I did that and I'm getting the following result. To further check where my problem was I included the Symbol column from both of the queries and I keep getting a result that looks like this. DATE PRICES.SYMBOL SHARESHELD.SYMBOL SUMOFSHARES CLOSE 10/1/2020 B B 1,000 20 10/1/2020 C B...

I have an access db that has the following tables Symbols Prices Transactions The symbols table shows all possible symbols SYMBOL A B C D E The prices table shows closing price for all symbols for all dates DATE SYMBOL PRICE 9/30/2020 A 1 9/30/2020 B 2 9/30/2020 C 3...

You seem to be getting close to the desired result, thank you. I tried it and I have never seen that problem before. I also tried it in a .accdb file, same result. Hopefully someone knows why the query is crashing Access.

In the example I gave the user will put in the date that is in Column E, ValueDate. In my example the user entered 12/31/2019, 3/31/2020, & 6/30/2020. The billing should always run to the end of the next Quarter or Account Close date, or Change in Fee. The billing should always start on the...

Where are you getting 88 days? The first and second set should be 91 days and the 3rd set is 92 days.

I'm taking the value as of the last day of the Qtr and billing for the next Qtr. 3/31/2020 is the last day of Q1 2020. Take that value and bill on it for Q2 2020 which is 91 days. The new fee for account A2 starts on 4/18/2020 so the fee for the first 17 days would have been charged at the...

I've attached a sample DB and a spreadsheet which shows what the Query results should be. I've been banging my head against the wall on this for several months now. I don't know if i have a major design flaw or if i just don't know how to write the Queries. There is a user form and the user...