Recent content by ErickaMeade

Figured it out. I had to do the original query without the models per Pat Hartman's suggestion. Then I had to run a secondary query that added in the models. The secondary query gave me the results I needed. Thanks!

Thank you for your suggestion. If I remove model from the query then the following queries that use this one as part of the join query does not give me the results I need. This is my conundrum. I need the model in the there but it needs to not be considered in the count function. I did attach...

That's a lot of high;y confidential front end and back end data to delete and there is a lot going on in that db to send the whole thing stripped of data. There are many other tables and many other queries. This is a pretty complex db and I am trying to get help on a single piece of the puzzle...

I have created a query to get a count of items based on "Pricing Category" and "Location" columns. If I leave the query to only include the location, amount, and pricing category then I get the desired count. However, I need to build another query off this, so I need to carry another column...

plog - Yes, I will change to 51% and that will get past the perfectly halved categories. Thank you

CJ_London - Thank you. That got me to exactly where I need to be.

I'm not sure if this is possible or what it would be called to even search. I am trying to create a query that will pull data from one column of, for each customer, the value of 50% or more of a category is the same. The ones that are not the same as the other 50% will pull data from another...

In an effort to delete the records to share the database, I found the root cause of my problem. I have as I said a form with two subforms and one of those subforms list invoice details. During my initial build I made the amateur decision to link the tables by [project_title]. After starting to...

I am using a macro for the print and Email button (both use the same report) on the form that filters it by [ID]. I have attached a snapshot of the macro but it does this on an unfiltered report as well. I ran it unfiltered to see if it the problem was with my filter but only about 6 records are...

I have an Access Database that I use to keep track of open projects with 2 subforms. One for contacts for the project and another for invoices for the project. On this form I have a print button that prints the current record in a summary report that I place as a hard copy in the physical...