Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Queries / April 2008

Tip: Looking for answers? Try searching our database.

My query doesn't display all data - records from tables! HELP

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ivan - 19 Apr 2008 09:30 GMT
Here is problem:

I have table with buyers, they are buying in two separate shoops, and are
paying it trough compezation- to me. So I have two diferent tables, forms
where I record their expenses and one table with their id, names..., one
table with articles, and two tables for two different stores. I need to
calculate how much they have spent in both stores, and the query need to have
these fields: Buyer name, articles, sum of amount in first store and amount
in second store, and total of first and second store.
I have tried to do this, but the query displays only those buyers who have
bought goods in both stores, not in single stores, so I can't see all buyers,
and that's a big problem for me.

Please, please help

Thanks in advance,
p.s. my English is bad, SORRY
John Spencer - 20 Apr 2008 14:40 GMT
Your problem seems to be that you have a table for each store. You
should have one table for both stores with a field in the table to
indicate which store is involved in the transaction.

You could use a UNION query to get the data for both stores and then use
the union query to generate the needed information.

I don't understand your structure enough to give you specific advice.

'====================================================
 John Spencer
 Access MVP 2002-2005, 2007-2008
 Center for Health Program Development and Management
 University of Maryland Baltimore County
'====================================================

> Here is problem:
>
[quoted text clipped - 13 lines]
> Thanks in advance,
> p.s. my English is bad, SORRY
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.