pending report

[kmayo503]

i have created a database where the data is entered into a form with a subform. I need to get a pending total for records that have no data in them. Any suggestions on how to do that. I have a table with all my data and there is a pending field there. That info is not on ths subform. the subform is the only place you can enter data. where should i put the field for the pending and how can i get it to come up in the reporty

 

[GingerR]

not sure what you mean by 'a pending field' in the table? do you mean you have a field called [Pending] that has some value in it that you want to sum up? and this field is not on your subform...is that an issue? and if you want a field on your report, simply put it in your report's recordsource....i guess i'm not clear on your issue, sorry.

 

[kmayo503]

yes i need a field that gives a percent of the records that are "pending" results yet. i created an access database based on an excel work book. and we would run pivot tables to give us the total sale, canceled, alternative cancled. we would then have a field for percent sold, percent cancled, percent alt. cancled. percent pending, and a percent closing. I have all the others setup and now i need the percent of the sold, cancled, and alt cancled, that have no answer yet. i hope that makes sence.

 

[GingerR]

there are surely other ways, but this is what i would do:
use dsum to count how many records are SOLD, then dsum to find count of all records, and divide. this is just one example:
put a text box on the report that will hold the count of all records.
make it =dcount("ID","TableName&quot
call it TotalCount.
then you can make another text box,
=dcount("ID","TableName","Sold = True&quot/[TotalCount]

you will substiture your table name for TableName, and a key or unique field for ID. also dont know if your SOLD field is called SOLD or not....

you can follow the same way for other fields:

=dcount("ID","TableName","Pending = True&quot/[TotalCount]