The attached test db may helpÂ…It works with the =now() function in the table and in the for it gets converted to a date display.
Bill Perry ------------------------------------------ HYPERLINK "http://www.pertel.com"www.pertel.com Voice: 949-830-2092 FAX: 949-916-5722 ------------------------------------------ _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of mudrobin Sent: Monday, February 27, 2006 3:51 AM To: [email protected] Subject: [Access VBA Central] Date Expressions in Access I am currently working on a database for work that will print out all required parameters for a septic permit. What I am wanting to do is take a date field, add 3 months to that date and store it into a field in the necessary field in the table. I am an intermediate user of Access and am very green still to the VBA side of things. Could anyone please help me a bit with this. This is the last obstacle I have before I am able to do the beta testing on the database and I have 8 employees and 2 supervisors who would love to get their hands on this. Thanks in advance Mike Adams SPONSORED LINKS HYPERLINK "http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+database&w1=Microsoft+ access+database&w2=Database+development+software&w3=Microsoft+access+develop ment&w4=Database+management+software&w5=Inventory+database+software&w6=Membe rship+database+software&c=6&s=201&.sig=voopn1BN3CmVp8P3iA_wOQ"Microsoft access database HYPERLINK "http://groups.yahoo.com/gads?t=ms&k=Database+development+software&w1=Micros oft+access+database&w2=Database+development+software&w3=Microsoft+access+dev elopment&w4=Database+management+software&w5=Inventory+database+software&w6=M embership+database+software&c=6&s=201&.sig=6bvL2aUyoXzWqkN5bYA3pA"Database development software HYPERLINK "http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+development&w1=Microso ft+access+database&w2=Database+development+software&w3=Microsoft+access+deve lopment&w4=Database+management+software&w5=Inventory+database+software&w6=Me mbership+database+software&c=6&s=201&.sig=mtl_SoZBzSNLEr-GWzPYWA"Microsoft access development HYPERLINK "http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Microso ft+access+database&w2=Database+development+software&w3=Microsoft+access+deve lopment&w4=Database+management+software&w5=Inventory+database+software&w6=Me mbership+database+software&c=6&s=201&.sig=KK-twWSfXTZBCexmJhJdWg"Database management software HYPERLINK "http://groups.yahoo.com/gads?t=ms&k=Inventory+database+software&w1=Microsof t+access+database&w2=Database+development+software&w3=Microsoft+access+devel opment&w4=Database+management+software&w5=Inventory+database+software&w6=Mem bership+database+software&c=6&s=201&.sig=QoXfBICK17TaS7J0be9MWA"Inventory database software HYPERLINK "http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Microso ft+access+database&w2=Database+development+software&w3=Microsoft+access+deve lopment&w4=Database+management+software&w5=Inventory+database+software&w6=Me mbership+database+software&c=6&s=201&.sig=RLVa2OOHA-7pu6LQKhTr8w"Membership database software _____ YAHOO! GROUPS LINKS * Visit your group "HYPERLINK "http://groups.yahoo.com/group/AccessVBACentral"AccessVBACentral"; on the web. * To unsubscribe from this group, send an email to: HYPERLINK "mailto:[EMAIL PROTECTED]"Acc [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to the HYPERLINK "http://docs.yahoo.com/info/terms/"Yahoo! Terms of Service. _____ -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 268.1.0/269 - Release Date: 2/24/2006 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 268.1.0/269 - Release Date: 2/24/2006 [Non-text portions of this message have been removed] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessVBACentral/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
