Displaying records for one ID from query in form

[bpownall]

Hello,
I am new to access and was hoping for some help as I have been stuck. I am creating an inventory database where of equipment and I created a query to determine how many tanks of certain sizes and types exist on a given location. I also have a query that pulls my suggested types and sizes. I want these queries to be shown on a form where a user can select a well name from a combo box, etc and the queries then show the results for this name. I cannot for the life of me figure out how to make a query display only one result on the form from this. Any help would be greatly appreciated.

[Rainlover]

In 2003 you can use Totals in a Query.

2010 must have something similar but I can't help a lot. I would think if you search TOTALS in Access help you should find something. Or perhaps there is something in the Northwind DB.

[bpownall]

sorry I do not want to just display the total amount of tanks. What I am wanting is on a given form to select a wellname, then have the queries as subforms below show the results for that well name.

[orange]

Why don't you show us the query sql? Explain what you want to happen; tell us what isn't working specifically; and perhaps someone will have an answer/suggestion.

It's hard to offer advice when we are having to guess at what you have tried, what you really want and how you are doing testing.

[bpownall]

Pretty simple crosstab query. I get the name of the lease, have different rows for water, oil, and the separator tank, then in the columns count the different number for each type of volume tank since each tank has a different serial number. I would like to show the results for one lease name on a form. I have tried a parameter query but it just ran query in background instead of on form. Below is the sql for the tank query.

TRANSFORM Count(Tanks.Serial) AS CountOfSerial
SELECT Tanks.LeaseName, Tanks.TankContents
FROM Tanks
GROUP BY Tanks.LeaseName, Tanks.TankContents
PIVOT Tanks.Volume;

[orange]

I created a table and some sample data. With your query I get the attached output.

[Rainlover]

sorry I do not want to just display the total amount of tanks. What I am wanting is on a given form to select a wellname, then have the queries as subforms below show the results for that well name.

`
What was wrong with the Totals query?

What didn't it show?

[bpownall]

Orange: I get a similar output but I would want that query to show just john smith breweries results in a form. Maybe a combo-box in a form with those 2 names and the query underneath as a subform wouuld show results for which name is selected.

Rainlover: Please read above. Would a totals query do this?

[orange]

Why are you using CrossTab?
Can you mock up a jpg of what you'd like to see?

The output I showed previously doesn't really tell me much, but it's your query not mine.

[bpownall]

See attached picture. If I could make this work I could also have another query of suggested volumes for the tanks below. A button could be included to run the query on the form if that is what would make it work.

[orange]

Ok what are the tables and fields involved? There was nothing in earlier material re oil, water, separator...