Recent content by logs22

Thanks for the answers....That is what I suspected but I was hoping maybe I was wrong because things would have been a lot easier that way. What you said about calculating on the fly makes sense though, I was still thinking in terms of excel rather than access. Dan

Here is my question: I am designing what to me is a reletively complicated database and was wondering if it is possible to use formulas in tables. For example I have opening balances with total debits for the day and total credits for the day. I want to include the closing balance in the same...

John K Thank you!! Your code works perfectly and after two days of frustration I am finally getting somewhere.......

Does that code still work when the client name is not in the same table as the call date/time. The call date and time is in a table that contains all data regarding the call such as date, what was discussed, is client satisfied..etc.. the client name is in a table that has information about...

Is there any way to accomplish this without SQL, I am not to familiar with it. I have tried the above suggestion and it has not been bringing up any records. It is also asking me for parameters which I am not looking for.

I hope someone out there can help me, here is my situation: I am making a databse to track client calls. Each client may be connected to multiple sales calls. I need a query that will scan through all of the records and pull the most recent call for each client. I tried using the group- max...