Search results

Really stupid calculation What I am trying to attempt to do (and something probably pretty simple) is to have a running balance remaining for every donation made. Thanks for your help :)

Is it possible to have a calculation in the detail section of the report that would subtract each line item from a set balance. i.e., I have a budget amount (in the page header) and in the detail section I have donations made....for each line of the report I want to have the donations made...

Duplication in Queries I thought so to, I've even combined two tables and then brought into a new query with the other table...but the duplication gets worse (288). I've tried all the joins but it's not right :(

Here's an interesting little problem...I have a query which combines three tables. One table has payment information related to grants awarded (101 records). The second table gives the payee information (36 records). The third table gives the contract information (51 records). The ultimate aim...

Cross Tab and Date Thanks Rich! It worked 95%...it still labels it the wrong year (2002 instead of 2003) etc, but the important thing is that it's pulling the amounts into the right columns. What I'll probably do (for now) is fudge it by renaming the column headers in the report (no one will...

cross tab query and date IIf(invoice Date < DateSerial(Year(invoice Date), 10, 1), 1, 0) I entered this line on the expression line of the crosstab query for the date column and though it changed the date on the header to be 10/01/2002, 10/01/2003, it actually did not pull the correct amounts...

I have a crosstab query that pulls data into columns headed by years--problem is that I need to define the years as our fiscal year (10/01/??-9/30/??) rather than the default calendar year. Any quick and easy way to do this?

I knew it had to be something I overlook and of course it seems so simple :) Thanks for your help!!!

Ok, I've finished my beautiful dbase and have set up a work group and set permissions (mostly read-only) for the staff. However, I obviously I have missed something because only one person at a time can have access to the dbase. Where and how do I switch it from exclusive mode to share mode.

Cosmo--in the same boat as you :) It's great for this forum because I don't have any experience beyond the simple (canned) queries--let alone sql or vba--but I'm good at mucking about if pointed int he right direction (tenacious) :)

And (almost forgot) Group by expression

And the winner is: Sum(IIF([TYPE]="EVAL",[AMOUNT]))

Little more info on my dbase: I have a field for (contracts signed) amount and also type of contract. I actually tried your idea first...made a separate query for each of the type of contract that we have (three in total) and then made another query that incorporated the first query--except...

Thanks for your help--I hope this works as it will make my work on this database almost complete :)

Thanks so much for your help--I will try this out and hope that it works :)

Another stupid question... Is it possible to total on a number field (in a query) only if it meets a criteria for another field in the same record. If so, how do I do it (my head is getting sore from banging on the brick wall) and (there's more) if it doesn't meet the criteria, either leave...

Help with SQL And VBA Thank you so much for your help...it got me started in the right direction. What ended up working was this: IIf([Amount Awarded]>=1000000,[Amount Awarded]*0.1,IIf([Amount Awarded]>=300000,[Amount Awarded]*0.12,IIf([Amount Awarded]>=100000,[Amount...

I have used simple queries before but I am tackling something beyond my current realm of experience. I am trying to set up a budget field that will calculate the budget amount based on rate assessed to a certain parameter of dollar amounts. I.E. Grant award amount >$1,000,000 then the budget...