MS Access

 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me



Go Back   Tutorialized ForumsDatabasesMS Access

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Tutorialized Forums Sponsor:
  #1  
Old February 28th, 2017, 07:21 AM
raviaccess raviaccess is offline
Registered User
Tutorialized Newbie (0 - 499 posts)
 
Join Date: Feb 2017
Posts: 1 raviaccess User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 10 m 18 sec
Reputation Power: 0
Cerating navigational summary table/form

Hi,

I wish to make navigational summary table by joining different tables:

Just brief you about the table (User ID will be unique):

Load table: here we are having a table where user can load amount in his prepaid instrument and consume this amount, consumption amount will never more than load amount.
(I had limited the data with semi-colon for illustration)
Load Table
User ID; Load Amount
123; ₹ 2,000.00
345; ₹ 1,000.00


Consumption table: Here user will use the load amount in multiple number of times, e.g User 123 had loaded his prepaid instrument with Rs. 2K and now can use this amount in multilpe transaction (Rs. 1000 + Rs. 500) or in one go.

Consumption table
User ID; Consumption amount
123; ₹ 1,000.00
123; ₹ 500.00



Summary of Load & Purchase: now I want to have summary in below format

Summary of Load and Purchase
User ID; Load Amount; Consumption amount; Unused amount
123; ₹ 2,000.00; ₹ 1,500.00; ₹ 500.00
345; ₹ 1,000.00; ₹ 0.00; ₹ 1,000.00


But what Im getting after making relationship and running the query:
  • User 123 had loaded ₹ 4,000 (it might be because user had consumed its load in two transactions hence access added 2K +2K. i'm getting this calculation across my summary table.
  • User 345 is not reflecting in summary table as it had not made any purchase. In my summary table only those users are reflecting who had made atleast one purchase transaction. But I want history of Users like user 345

Aside this I also want to make navigation fields where employee can enter the User ID and User's total load and total consumption history appears and employee may download this history in excel by clicking the button only( Don't know if it is possible! )

Thanks

Last edited by raviaccess : February 28th, 2017 at 07:27 AM.

Reply With Quote
Reply

Viewing: Tutorialized ForumsDatabasesMS Access > Cerating navigational summary table/form


Developer Shed Advertisers and Affiliates


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 

Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.

© 2003-2017 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap