Recent content by aroraaj

I tried using that code and for Me.txtValue it says Method or data member not found. I also tried textValue but same message. Any idea why its not taking that?

I am using the following SQL Statement for a query: SELECT Sum(IIf([Development Source]=[P1 Production Source],[Target Cost],0)) AS CriteriaCost, Sum(qry_main_tbl_data.[Target Cost]) AS [SumOfTotal Cost], [CriteriaCost]/[SumOfTotal Cost] AS Percent_Development_Source, qry_main_tbl_data.[Engine...

I have a report in Access. In this report there aer different types of data and in one of the category the data has numbers. Is there a way in report for some numbers to show as percentage and some to show just as regular number? For example: Category Data Percent D 10% Percent...

I need to make an overall report for the queries that I have created. I know how to make a report with one query but I am not sure how to make a report with more then one query. All together I have over 15 queries which I have to add in a report. Does anyone know how to do that?

the second one doesn't work. but the first one work it only shows one supplier...thanks! do you know how i can count that?

I'm desiging a query to find out which of the suppliers are at gold standard. Here's what I have so far: SELECT tbl_Data.[P1 Production Source], tbl_Gold_Data.Gold FROM tbl_Data INNER JOIN tbl_Gold_Data ON tbl_Data.[P1 Production Source] = tbl_Gold_Data.Supplier WHERE...

This does work but it only counts the number for one supplier at a time. I just need one number where it'll say: Number of suppliers = 55.

I'm creating a data file. For one of the things I have calculate the number of suppliers. This is what I have so far: SELECT Data.Field8 FROM Data GROUP BY Data.Field8 HAVING (((Data.Field8)<>"")); the data shows some numbers is there a way to exclude all the numbers? And does anyone know...