Recent content by TClark14

Great - this worked. You have been a great help. Thank you very much!

I can't get this to work - it says the expression has too few arguments. I probably didn't explain what I need very well. I have a field called RigNum created by the Union qry above. The following is what I need, but I can't get the expression written correctly. I need something like this...

Yes, I have been able to get it to count "permitsout", but not able to get it to count "permitsout" for only RigNum=1

Yes this works. It is counting the number of records for only Rig1 which I need, but I also need for this to look at a specific field, such out permitsout, and count the number of populated fields (not blank) only for Rig 1. Can this be done as well? Thanks, as always!

I have a count on this report that counts the number of wells, the number of permits out, etc. Is there a way to get this to not count duplicates (the second time the well shows up for RIG2) THANKS!

Perfect - thank you!

Okay - I got the last problem worked out. It looks like this is going to do the job for now. I have another question. I have two fields that will be included in this query Program Year and District. I need the query to Prompt for these two fields. How can I add this to the code? Thanks so...

I am getting the following error when I run the qry: Syntax Error (missing operator) in qry expression 'WellRigs.WellName'.

I have been out of town an am just now getting back to this. i am going to give this a try for the short term while I try to clean up the mess in the original db. Thanks for all the help and I'll post back after I have a chance to work with this.

Thanks for your reply - that does make sense to me. I Always knew this database was put together wrong, but it was created many years ago by someone else, probably in the first version of Access that came out. I have inherited this monster and managed so far to keep it running, but knew it...

I am so confused - I realized I told you wrong on the sort I need - I was able to do that report with a subreport, but what they want is ahown an the revised attached document. Sorry about that, I have messed with this too long.

I am having trouble getting the sort I need for a report. I am probably overthinking it or maybe should go about this in an entirely different way. My table contains well names with drilling rigs assigned. Some, but not all will have 2 rigs assigned. Some rigs may the 1st rig on one well and...

I hope I can explain this. I have 2 reports, each is based on a query (each a separate query). Each query has 2 criteria set to ask the user what year and what district. Individually the reports work perfectly. I made the second report a sub report of the first. I would expect when opening...

Is that in the combo Box properties? I don't recall see that, but I'll look. I do have more than 1000 records.

Actually I did use the wizard to create the combo box and I also realized the records were scattered, but unfortunately I am still missing records in the combo box that are definetly in the table. Thanks for the suggestions though. I am at a loss.