query set up question

S

Selby

Access 2003
A query has been created that pulls inventory amounts per item by an "as of"
date for each individual warehouse. It is looking at various tables such as
invoice, date, product id, activity, etc... I am now needing a query that
just gives me one ending balance per item for all of the warehouses in total.
Is there a way to group the warehouses or do I need to start from scratch?
 
J

John W. Vinson

Access 2003
A query has been created that pulls inventory amounts per item by an "as of"
date for each individual warehouse. It is looking at various tables such as
invoice, date, product id, activity, etc... I am now needing a query that
just gives me one ending balance per item for all of the warehouses in total.
Is there a way to group the warehouses or do I need to start from scratch?

Please reread this message.
Clear your mind of all your knowledge of the structure of your database other
than what you've posted.

How on Earth could anyone answer?

"Group the warehouses"??? How is the warehouse represented in the table? What
do you mean by grouping?

Give us some help here please?
 
S

Selby

I guess that is why I am posting in the New Users section.....

What do you mean by how is the warehouse represented in the table? There is
a warehouse table that has a warehouse number and a name that is associated
with the number. The current query will pull by the warehouse number.

By grouping, I mean instead of having a query that gives me an amount for an
item per one warehouse, I need to have the total amount for that item that is
in all warehouses. I was hoping that I could use the existing query just
tweek it to get the info.

I apologize for the lack of information. Perhaps someone on Earth will be
able to help me.............
 
L

Larry Daugherty

You're in one of the right places for your post but that doesn't
relieve you of having to communicate some relevant details - if you
want help.

Your schema is not described well enough for someone to provide you a
solution. Typically, you'd detail the names of the relevant tables
and the names and datatypes of relevant fields. In other cases you
might post the SQL of a query that is similar to the one you need. If
you designed your current query with the QBE designer then click View
| SQL and copy the SQL into your next post.

HTH
 
S

Selby

Thanks Steve!!! That is exactly what I will do and I really appreciate your
helping me....
 
J

John W. Vinson

I guess that is why I am posting in the New Users section.....

What do you mean by how is the warehouse represented in the table? There is
a warehouse table that has a warehouse number and a name that is associated
with the number. The current query will pull by the warehouse number.

By grouping, I mean instead of having a query that gives me an amount for an
item per one warehouse, I need to have the total amount for that item that is
in all warehouses. I was hoping that I could use the existing query just
tweek it to get the info.

You can; just don't group by the warehouse in the query.

It would give us a view of your structure if you could open the query that you
now have in design view. Select View... SQL from the menu. Copy and paste the
SQL text of the query to a message here. It may look cryptic now but you'll
come to use SQL view often - it's the real query, whereas the query grid is
just a tool to build SQL.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top