Search results

Thanks :) Much shorter than my way :)

Ekhm. Got is sorted :) Sorry for the trouble :) Just added 'Is Null' for Payment2 & 3 in 1st critiria and for Payment3 for 2nd critiria :)

I have a strange problem. Must be my error otherwise it means that Access is quite stupid... I have 4 fields in the querry - Quote, Payment1, Payment2, Payment3. All being number/currency type. In that querry I want to display only records which fall into this rule Quote <> Payment1 + Payment2...

Ha! I did it :) Thanks for all the suggestions anyway but I did it slightly different. I made a union of these 3 queries and then made a report from that. Simple as that. I have no idea why the sum didnt want to work the way I was doing it earlier? Nevermind now :) Thanks again!

Could anyone please have a look on this and see if they could help? Thanks!

Would it not be better to do it with a macro? Unless the report will always be the same name and should overwrite the existing one with no questions asked.

Do you need to have it exactly like in that pdf? What version of Access do you have?

Hello! My experience in Access is let's say very limited, yet I understand all principles and sometimes I just lack some of detailed knowledge about how to go with some of the stuff I want to do. I have created a db (well, to be honest I did not know much access before I started building it...

Still the same :( What difference is between the ! and . in this statement?

Hello guys! I hope that maybe someone here will be able to help me as I can't get one thing to work on my reports. I will try to describe it in few words. I have a database in which I have enquiries. Each enquiry can be either a potential or a sale - potential, we quoted for something, sale -...