Re: [MS_AccessPros] How do I make the query I need?

Hey Walter, I got an idea out of your sugestion... You see, a year actually has 365.25 days, that's why every 4 years feb has an extra day, so 365.25 divided by 2 is 182.625, meaning I can round it of to 183 and it should work as you said.

Thanks for the light on the matter
Edgar
Sent from my BlackBerry® smartphone

-----Original Message-----
From: "nkpberk" <wgriffin48@mchsi.com>
Sender: MS_Access_Professionals@yahoogroups.com
Date: Sat, 25 Jun 2011 23:04:58
To: <MS_Access_Professionals@yahoogroups.com>
Reply-To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] How do I make the query I need?

Edgar;
6 months is (on a non leap year) is 182.5 days based on the average month being 30.466666 days long. Use 182 or 183 days for your interval,run some tests to see which is most accurate and test a few leap year dates as well, This should be a bunch more accurate.
Walter Griffin

--- In MS_Access_Professionals@yahoogroups.com, "rivera_vazquez_edgar" <xtintores@...> wrote:
>
> John,
> I tried it and here is what i get...
> I put the service date as febuary 1st, and the nest service date should be six months latter (august), I used the 180 as interval but it tells me that the next service date is in july (31st)to be excact. I figured that its adding 180 days to febuary first, but the thing is that since febuary has 28 days, it takes me to the end of july and not august, wich is realy the date needed (six months latter).
>
> Any advice?
>
> Edgar
>
>
> --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@> wrote:
> >
> > Edgar-
> >
> > If the underlying field is Date/Time, adding a number of days *will* give you
> > the correct month in the future. The month display using Format has no bearing
> > on what's actually stored.
> >
> > John Viescas, author
> > Microsoft Office Access 2010 Inside Out
> > Microsoft Office Access 2007 Inside Out
> > Building Microsoft Access Applications
> > Microsoft Office Access 2003 Inside Out
> > SQL Queries for Mere Mortals
> > http://www.viescas.com/
> > (Paris, France)
> >
> >
> >
> > -----Original Message-----
> > From: MS_Access_Professionals@yahoogroups.com
> > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of
> > xtintores@
> > Sent: Saturday, June 25, 2011 1:53 PM
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: Re: [MS_AccessPros] How do I make the query I need?
> >
> > Ok John, but the problem I see doing it that way is for example, if the service
> > was done in febuary 1st, and the next service is 6 months latter, and the
> > interval says 180 days, than it would realy show up to be july for the next
> > service date. Keep in mind that both the service date and the next service date
> > are both formated to "mmm" to show only the month of service scince the service
> > can be done at any time during that month. This is because the NFPA code says
> > service should be done every so many months, sometimes monthly. The thing is
> > adding days to a date won't allways give me the right month for text service.
> >
> >
> >
> > Any sugestions?
> >
> > Sent from my BlackBerryR smartphone
> >
> >
> >
> > -----Original Message-----
> >
> > From: "John Viescas" <john@>
> >
> > Sender: MS_Access_Professionals@yahoogroups.com
> >
> > Date: Sat, 25 Jun 2011 08:11:02
> >
> > To: <MS_Access_Professionals@yahoogroups.com>
> >
> > Reply-To: MS_Access_Professionals@yahoogroups.com
> >
> > Subject: RE: [MS_AccessPros] How do I make the query I need?
> >
> >
> >
> > Edgar-
> >
> >
> >
> > That is correct as long as Interval contains a number of days. You can always
> >
> > add an integer value to a date/time to get another date/time value - a date
> >
> > either in the future (add a positive interval) or a date in the past (a negative
> >
> > interval).
> >
> >
> >
> >
> >
> > John Viescas, author
> >
> > Microsoft Office Access 2010 Inside Out
> >
> > Microsoft Office Access 2007 Inside Out
> >
> > Building Microsoft Access Applications
> >
> > Microsoft Office Access 2003 Inside Out
> >
> > SQL Queries for Mere Mortals
> >
> > http://www.viescas.com/
> >
> > (Paris, France)
> >
> >
> >
> > -----Original Message-----
> >
> > From: MS_Access_Professionals@yahoogroups.com
> >
> > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of
> >
> > rivera_vazquez_edgar
> >
> > Sent: Saturday, June 25, 2011 12:33 AM
> >
> > To: MS_Access_Professionals@yahoogroups.com
> >
> > Subject: [MS_AccessPros] How do I make the query I need?
> >
> >
> >
> > Hello to all.
> >
> >
> >
> > I'm working with my main form but need a little help. The form is called
> >
> > frmCustomerDetail. In this form I have a few tabs: General Info, Contacts, and
> >
> > Addresses. In the Address tab I have a sub-form using my 'tblInventory', wich
> >
> > has the inventory found in that specific address, so far so good.
> >
> >
> >
> > Now I need a sub-form within the 'frmInventory subform' using the 'tblServices'.
> >
> > The catch is that the 'tblServices' has the following fields: IdService(PK),
> >
> > IdInventory(FK), ServDate (formated as NOW() ), Service (to identify the service
> >
> > done to that specific item), Interval (to state how often that item should
> >
> > recieve service, expressed in days), and now I need to make another field wich
> >
> > takes the ServDate value and adds the Interval value to get the NxtServDate
> >
> > (next service date for that item).
> >
> >
> >
> > Here is what I think I should do:
> >
> >
> >
> > Make a query with all the fields in tblService and add a field in that query for
> >
> > the next service date. For example: NxtServDate: [ServDate] + [Interval]
> >
> >
> >
> > Is this correct, or is there a better way to do this?
> >
> >
> >
> > As always, Edgar
> >
> >
> >
> >
> >
> >
> >
> > ------------------------------------
> >
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
>

[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/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/