Does anyone have any experience with Microsoft Access 2007?
By TheDwarf
@TheDwarf (138)
United States
July 26, 2011 10:37am CST
I'm trying to figure how to do a few things and if they are even possible. If you can't answer the specific question, you can leave a few tips if you'd like.
1. If I have them enter a number(which is the number of months) in one column and a date in another, is there a way to add them together. For example, if they enter 12 and today's date, it will add them and make it display next year in the next column.
Is this possible and how would I do it?
2 responses
@sais06 (1284)
• Philippines
26 Jul 11
Hi TheDwarf!
You may use the DateAdd() function of MS Access. Say for example you have Table1 that has fields named as month and currentdate. Data type of month should be number and currentdate as date/time. Then enter valid values for each field.
Next is to create a query. This query will display the result you are looking for.
Suppose you have month and currentdate, then you may use the sql code,
SELECT month, currentdate, DateAdd("m", month, currentdate) AS nextDate
FROM Table1;
There you have it! Feel free to modify the tables and the queries, especially the names. Good luck!
@sais06 (1284)
• Philippines
27 Jul 11
Oh I'm glad you are able to get it. It's actually easier that we we usually thought. There are also lots of resources from the internet. You can also look for the help section of MS Access or other Microsoft products. I've also been using that help function as it is very useful. Are you currently working on a project?
@frontvisions101 (16043)
• Philippines
26 Jul 11
I suggest you just download the manual on any torrent sites out there. As far as I know, the software came with the manual already so you should search first on your computer for that manual before downloading anything.
