Updating a date field in msacess

Updating a date field in msacess

There's a lot more to it than the basics I've described above I was thinking about this last night and I agree, the data is probably not normalised; suppose you have three salesmen, Mr A, Mr B and Mr C, they are in charge of selling a range of different products - including apples, oranges and bananas; you wish to keep a record of exactly how many of each item each salesman has sold...You're presuming a lot about the database structure here...The solution is to store the data something like this: That way, if we want to find out which product sells most/least globally, or it we want to find out which salesman has the least turnover, or which salesman is the best at selling apples, they are all very simple queries.The next step is to notice that the words 'Apples' etc are very commonly repeated - it's wasteful to store the data like that (and if someone types in Aplles, it will be overlooked by your query criteria) - so the product descriptions are moved into another table, thus: The column Prod ID in the sales data table is then called a foreign key and it can be joined to the ID field in the product descriptions table whenever you want to see the description alongside the sales data.

It is designed to find the lowest value in the column passed as the only argument.

I was thinking about this last night and I agree, the data is probably not normalised; suppose you have three salesmen, Mr A, Mr B and Mr C, they are in charge of selling a range of different products - including apples, oranges and bananas; you wish to keep a record of exactly how many of each item each salesman has sold...

In a spreadsheet, you'd do it like this: And it's tempting to set up your tables the same way; a column for each salesperson and rows for each product (or worse, and we'll see why in a minute) a column for each product and a row for each salesperson. - you have to redesign your entire application to accommodate a new column (and if the columns represented single products, that's an even bigger problem because most businesses have more products than employees and change them more frequently).

This approach has many advantages, such as when you decide to change the description of Apples to 'Juicy Apples' - you only need change it once, in the product description table.

The process of conforming your data to this kind of model, unlocking the true power of relational databases, is called Normalizing.

updating a date field in msacess-5updating a date field in msacess-66updating a date field in msacess-40

I have a Access 2007 database that I wish to be able to click a button and update Null values in a table column with the current date when the button is clicked. I created a query qry Submit Update that has the following SQL.

Join our conversation (84 Comments).
Click Here To Leave Your Comment Updating a date field in msacess.

Comments:

  1. 1
    Steve

    The Bible does not talk about "dating," but it does talk about relationships.

  2. 1
    Steve

    Often, foreign men don’t know how to date Ukrainian girls and what Ukrainian dating traditions to follow.

  3. 1
    Steve

    After you’ve posted a few comments and liked her status updates, photos, videos etc, go ahead and message her to get the ball rolling.

  4. 1
    Steve

    All names presented here were gathered at a past date.

Leave a Reply

Your email address will not be published. Required fields are marked *