Search results

I tried this, but comes up with an error#??

Thanks Brian....

I put a blank to start with but was messing up my formatting.

Hi All, Tried doing this within query, my current expression is... Cost Difference: IIf(Len([SumOfBudget Cost£] & "")=0,[SumOfActual Cost],([SumOfActual Cost]-[SumOfBudget Cost£])) When i replace the zero with a "-" or "blank" then it messes up the formatting of the percentage. Is there a...

Sound good to me. Could you supply any samples of this code?? Could be very useful in the future

Brian, After making tables from queries.. (3 Times) it has given me the results I wanted. Thanks for your info. appreciated. I can now take the thorn out of my side. Cheers

Shall try this tomorrow. Thanks for your reply

I have tried your suggestion, although i was a bit sceptical. This still gave the same outcome. I am struggling to see why this would happen?

Here you go.... More information. Any ideas??? http://www.box.net/shared/xscx8o6ck4

Thew DB is huge... I can put some screen shots up to make what im saying more clear... 2 ticks...

Anyone lend a hand???

Is there any reason why some are duplicating and others are not? I have tried another sequence where initial query not sum or count and sum and count at the end but this is not coming out with correct figures either? Why would some be duplicated and not others? I tried dividing by 2 but this...

Hi, When I am doing this, it is coming up with silly figures... I have got a query which consists of 4 costs which have been summed in a previous query. The result of this query is a rows of datas per criteria E.g. Day 4, Day 4, Day5. When I sum this, I would expect a sum of 13, but i am...

RESOLVED, Edited Joins to get data what i wanted. Thanks

The db is huge. There is only a feild in the left table called activity which is basically a count of rows = activty . I know the joins which i have will not diplay any as there no matches in the left table. Is there a way if there are no matching fields in the left table to still display the...

http://www.box.net/shared/xscx8o6ck4 Done this for more information

Anyone up for a challenge, this issue is cracking me up?

It is a lot more complex than my first example... Would you mind if I send you an example?

Example db?

Hi , recently posted a thread about a union query. I have got over that hurdle now but face a new problem which is: When I have created a right join to bring back data from a table, if there is no data it will leave the fields blank. Is there any way I could bring back the row data of the...