ms-access tricky situation in product entry

I have two Access tables access one is were I make entries for products like

whitepapter | pen | startDate | endDate
5           | 10  | 31/jan    | 02/feb

Stock product table:

whitepapter | pen
10          | 20

My goals is: When a user enters data, the application will check against stock product and date: If the end date is 1st january it show those 5 papers and 10 pens minus main stock, but if today is 03 february it will put them back to main stock:

What is the best way to approach this? I know about relation but i'm asking how to apply this in best way... The users that use this DB are not professionals so I'm looking the best way to give them this feature....

Answers


You can calculate the number of products needed now with this SELECT query:

SELECT
    SUM(whitepaper) AS SumOfWihtepapers,
    SUM(pen) AS SumOfPens
FROM
    EventTable
WHERE
    Now Between startDate AND endDate;

Also in Access you can use the AfterUpdate events of the TextBoxes in order to perform some logic.


As for the rest: At StackOverflow we like to help you when you got stuck while trying to programm something, but you must show some effort. What have you tried? Can you show us some code? Did it not work like expected? Did you get an error message?

Please read the section Get answers to practical, detailed questions here


Need Your Help

Mobile Browser Disabling CSS

android html css mobile-browser

What would be causing a mobile browser to disable all CSS?

How do DVCSs (DRCSs) work?

git version-control dvcs bazaar

I have been hearing a lot of good things about DVCS systems, in particular about bazaar. Apart from the concept of distributed repository, I see two main advantages being touted: the merge is better