Recent content by solomon

Thanks Pbaldy, but the formula has generated some error with the message: "The expression you entered contain invalid Synthax. you may have entered an operand without an operator". Can you please advise what you think might be wrong with the forlmula. Appreciate the time. Anyone with a...

Hi I have a query that divides two fields and returns the result to another field. Example: Table A: Field 1,Field 2,Field 3 Table B: Field 5,Field 6,Field 7 I have a query that joins both tables in a relations and now have both fields combined in the query to make one table. And i also...

Thanks Rich. Appreciate the time. It worked fine, Magic! Thanks everyone who helped out......

This field is not for a date but just numbers and what i am trying to do is that: i have created a report from a query and two fields in the query seem not to show zero as default when there's no data or number entered in them. they are rather blank and i don't want this to show blank but zero...

Need some help again. How do i make a field in a report show or display zero if there's no value for that field. Currently the field i have just show blank when there is no data and i'd rather this show zero. I have checked the properties and i cannot find any function that has the name...

Thanks KH, you have worked your magic again. Appreciate it. :cool: Sol

I have set the default to zero in the table design but when i run the query, doesn't show up as zero but blank.

Sorry, maybe i didn't explain the problem clearly, I already have two fields setup Amount earned and Amount spent, in two different tables which were joined to build a query with this two field. The situation is that, sometimes these two fields are not populated and left blank, but what i want...

Can anyone please help: Amount spent and amount earned needs to be defaulted to zero when the fields are blank in a query. Please help me on how to go about the IIF in query to solve this problem. Help will be much much appreciated. Thanks also to those who have helped so far. Sol

Thanks SJ McAbney, This seems to run fine. Can you please tell me how i can default the values of Amount spent and Amount earned respectively to zero when there's no figure entered. I am new to Access especially the IIFs'. Thanks alot everyone for your help. Sol

Thanks for your reply KH, but the system is coming up with an error message when i try to run the query. Message: The Expression entered has too many closing parenthesis. iif(isnull([Amount spent]),0,nz([Amount earned],0)/[Amount spent])) Sol

I am having some problems with my query, any help will be most appreciated. Problem: I have created a query from two joined tables example: Table A and Table B. Table A tend to have a field which when divided by Table B should create a new field with the result of the division. Example Table...

Star You are a star!! Thanks, that works great!!

I am running croostab queries over a huge a mount of data and require only data that falls within a certain period. This period changes throughout the year (funny that) and the columns created by the crosstab in one period might not be the same in the next. My Problem; Other queries run off...