Search results

ahh that worked perfectly! thank you very much :)

Hello i'm doing a college project, making a database for a financial institution handling unit trusts.. i've made a form with 2 combo boxes. the first one is to choose a customer from a list. once the customer is chosen, a macro requery's the 2nd combo box in this 2nd combo box, you choose a...

Hello everyone, i'm stuck in a school project (yet again), this time the problem lies with a query here's a simplified version of a query result UnitTrust SumOfVolume Type 1 5000 Buy 1 3000 Sell 2...

oh..ok here goes initally for the hidden RunningSum field, i used a =sum() function which contained the exact parameters as the subtotal revenue field after using the Iif function, it appears that the runningsum wouldnt work properly, so i just replaced it with =[SubtotalRevenue] which is the...

oh nevermind i solved it somehow o_o

thanks for your quick reply! your method works, but now another error seems to popup.. To count my revenue subtotal from each stock i used: =Sum(IIf([Type of Transaction]="Buy",[Volume]*[Price]*0.01)) i have this Total Revenue earned field at the page footer, which made use of a hidden...

pardon my ignorance, i'm very new to access.. i'm doing a college project right now.. and i have a report which shows the stocks purchased/sold by a client.. i'm supposed to calculate the revenue earned from commissions on PURCHASES of stocks by the client.. but my transactions are all in one...

ahh i think i've been blindly following my teacher's instructions :s from my lab notes, i understand that many-to-many relationships are joined by a junction table..which was why i included it in the first place.. perhaps i ought to just delete that table anyway, the point of this...

it's a college homework project

Hello everyone, I'm currently learning the basics of Access, and I have a project which requires me to set up a database for a financial institution which deals with unit trusts and customers. Each customer has a certain risk tolerance, and each unit trust has a risk rating, both on the scale...