Recent content by sdavid74

I have this line in a control box to count a number in a specific field =DCount("[LastName]","OrientationMain","[Session 1] = True") Now, on the same form, I am trying to multiply the result of this DCount by different numbers. I know this should probably be...

Ben, I have not been able to find that code in this forum or Forum705. I have searched by your handle in both places. Is there somewhere else I could look for it?

I have looked over the history of this forum, but I wasn't able to glean the information that I needed. I have a db with contacts to whom I would like to be able to send emails (both individually and group). I view all the contact info on a form where I would like to have a button or two that...

I got it. I found it in the Access help under parameter query, but now the prompts for the beginning and ending dates pop up twice each time. No big problem, but what's up with that? Is that normal? Is there any way I can make it only pop up once?

also in the query the report is based on, there is a field called "printdate" . That is what I want to set use to select records.

Yes, these labels are based on a query. How do I make the query prompt for a date range? I'll look around in this forum and in the Access help, but in case I don't find it...

Is it possible to set up a temp. database with the fields from my main db without rebuilding the db? Or is it possible to send selected records to a temp db? If so, can I use the same reports that I use with the main database? The reason is that I need to print about 200 labels, but I know I...

Thanks, I appreciate you taking the time to help with such an simple problem. That did the trick.

Is there any way to put a filter on a DCount function so that it will only count records that meet certain criteria? My goal is to count the number of records marked "true" that are contained in "MyTable" and record that number on "MyForm" Any ideas?

It work to count one field, but I was trying to add the number of not nulls in two separate fields and and then display that number on a form different than the one the fields are on. I used the Dcount function, specified the field and table name for each field being counted, and joined them...

I want to display the number of fields that contain "not null" values. I can do it on a report...in a roundabout way...what I did was a DCount function on one field, then the other..in two separate control boxes, and then added them together in another control box(TotalParent).....I'm...

I would like to display the number of "not null" values that exist in two separate fields. Fields "Parent_1" and "Parent_2" hold parents names, and I simply need to know the total number of parents. Will the Count function do this? If so, can anyone help me on the...

thanks...that explains some strange results I've been getting

Thanks, I used the easy way and it worked fine. Out of curiosity, where would I insert the code? Would I use a text box or what?

Is there a way that I can display the record count in a certain query on a main form page? I have a main page that I use to navigate among query results, forms, and reports, and, from that form, I would like to display how many records are in each query.