Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 20-11-2009
Member
 
Join Date: Jun 2009
Posts: 49
Access two records simultaneously and do calculations

We have a project that is on Access. I have a table called T_RENT(where there is the issue of location, start date of rental ...) and another called T_COPY(where there are the films in their chosen media (DVD, Blu-ray, K7 ...), the quantity, price per day ...).

At first, I want in my form, I hit a new record on T_RENT(it has no problem), I enter the start date of hire, the selected film and media. And that's where it thickens. I wish now that the price of renting the movie (depending on the chosen medium: dvd, k7 ...) fits into the table T_RENT depending on what was entered at the beginning (I do not want just that it shows me, I want that I write it in the corresponding field T_RENT.RENT_PRICE). Second, once that is done, I hope that the record (once you click a button "register") field COPY_QTE table T_COPY down 1 (decrement) automatically selected by film and media chosen (as it will be removed from the reserve, because it will be rented).

I really hope you can help me.

Problem: I wanted access to two records simultaneously (or successively) and do calculations inside a table through a form
Reply With Quote
  #2  
Old 20-11-2009
Member
 
Join Date: Nov 2005
Posts: 1,323
Re: Access two records simultaneously and do calculations

I do not see your table in any table T_client this seems odd.

Regarding the problem that prevents you from sleeping! I suggest you see if using a principal form and a subform there is no way to resolve this concerns. I am confident that, yes, but not make you a good service that give the easy solution is you must learn not true.
Reply With Quote
  #3  
Old 20-11-2009
Member
 
Join Date: Oct 2005
Posts: 2,389
Re: Access two records simultaneously and do calculations

Regarding the specifications, it is very thin compared to the only constraint that we have though given, the presentation of your subject appears to me to be away ()

Present us your relational model with different tables that will allow us to better return to your subject.

As for displaying multiple records: absolute55 proposed on the form and subform that is quite adequate.

Moreover, they give you may be ideas for tracking the location of your videos
Reply With Quote
  #4  
Old 20-11-2009
Member
 
Join Date: Jun 2009
Posts: 49
Re: Access two records simultaneously and do calculations

Yes, but my worry is that I want to do calculations inside tables. How can you put a field in a table (here T_RENT.RENT_PRICE) where I can put something. But here I am, therefore lock the field and how that fits inside the field T_COPY.COPY_PRICEDAY. Then the recording I want a new calculation is done in T_COPY.COPY_QTY knowing that T_RENT.COPY_FILM_ID = T_COPY.COPY_FILM_ID and T_RENT.COPY_SUPPORT_ID = T_COPY.COPY_SUPPORT_ID and calculation would T_COPY.COPY_QTY (new) = (T_COPY.COPY_QTY (before) -1)

For clarity, this is all my relationships (I did not give everything not to confuse)

I do not want someone to do it myself but I do not really know how to do a calculation inside a table because when a field as a source field name of the table is not going to make a calculation.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Access two records simultaneously and do calculations"
Thread Thread Starter Forum Replies Last Post
Where does most of the calculations done in the computer take place? Muskil Off Topic Chat 3 02-01-2012 10:39 PM
How to Querying blank records iso date in access Quattro Windows Software 3 31-07-2009 10:20 AM
To speed up calculations on a Worksheet Bankebihari Windows Software 3 10-04-2009 12:07 PM
How to use Textbox values for calculations Sonic Software Development 4 26-11-2008 08:17 PM
Excel function calculations used in MS Access query akbar MS Office Support 1 23-05-2008 08:52 PM


All times are GMT +5.5. The time now is 07:26 PM.