la_luna_llena: (Default)
I created an RSS feed for the Effing Dykes blog, which means you can add it as an lj friend and read it whenever it updates. Check it out: http://syndicated.livejournal.com/effing_dykes/profile
la_luna_llena: (make mistakes)

I am trying to calculate the difference between 2 dates in an MS Access Query, and then have that difference impact the addition of a value to a new column.

I have [PepsiDate] and [VisitDate] from a couple of
For example, the first date is [PepsiDate] and the second date is [VisitDate].  If [VisitDate] - [PepsiDate] is within 7 days, I want to update a new column [PepsiWithin7] to say 'Yes.'

Is there a way to create this populating? or for the new field to maybe just subtract dates the way I've described?

x-posted to [livejournal.com profile] ms_access 
la_luna_llena: (books)
I did a large f-list cut today, cutting my list by half.   It's just something I had to do. 

For those who were cut, we will be able to keep in touch in other ways.  Most of you have my email, phone, or facebook contact.    
la_luna_llena: (ravenclaw smart chicks)
[livejournal.com profile] slushmaster makes a case for subscribing to the short science fiction market here.

Profile

la_luna_llena: (Default)
la_luna_llena

November 2009

S M T W T F S
1234567
891011121314
1516 1718192021
22232425262728
2930     

Syndicate

RSS Atom

Most Popular Tags

Style Credit

Expand Cut Tags

No cut tags
Page generated Jul. 26th, 2017 08:45 pm
Powered by Dreamwidth Studios