Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #109730 > unrolled thread

SQL help? group? anything?

Started byMatthew Dyer <matthew.e.dyer@gmail.com>
First post2016-12-06 12:35 -0800
Last post2016-12-07 08:26 +0000
Articles 5 — 5 participants

Back to article view | Back to microsoft.public.excel.programming

Contents

  SQL help? group? anything? Matthew Dyer <matthew.e.dyer@gmail.com> - 2016-12-06 12:35 -0800
    Re: SQL help? group? anything? GS <gs@v.invalid> - 2016-12-06 16:23 -0500
    Re: SQL help? group? anything? Amandabui252 <Amandabui252@gmail.com> - 2016-12-07 05:39 +0000
    Re: SQL help? group? anything? Stevenlinh1 <Stevenlinh1@gmail.com> - 2016-12-07 07:57 +0000
    Re: SQL help? group? anything? Luannguyen992 <Luannguyen992@gmail.com> - 2016-12-07 08:26 +0000

#109730 — SQL help? group? anything?

FromMatthew Dyer <matthew.e.dyer@gmail.com>
Date2016-12-06 12:35 -0800
SubjectSQL help? group? anything?
Message-ID<0d5bf0ac-ee8c-45e4-82bb-cd1248018e0a@googlegroups.com>
So I'm starting to expand my 'data' knowledge into relational databases and wondering if there's a google group out there similar to you'se guys. the ones I've found are... inactive to say the least. 

Similarly, if someone here could answer that'd be great - 
how do I build a new field as a calculation of two other fields?

ex. I have fields Due Date and Completion Date, and I want to take Due Date minus Completion Date (a negative result meaning completion was past due).

[toc] | [next] | [standalone]

#109731

FromGS <gs@v.invalid>
Date2016-12-06 16:23 -0500
Message-ID<o27a5q$gov$1@dont-email.me>
In reply to#109730
> So I'm starting to expand my 'data' knowledge into relational 
> databases and wondering if there's a google group out there similar 
> to you'se guys. the ones I've found are... inactive to say the least. 
>
> Similarly, if someone here could answer that'd be great - 
> how do I build a new field as a calculation of two other fields?
>
> ex. I have fields Due Date and Completion Date, and I want to take 
> Due Date minus Completion Date (a negative result meaning completion 
> was past due). 

If this is a worksheet datatable then just add a column and the 
appropriate formula to calc the diff between the 2 dates...

  =DueDate-CompletionDate

..assuming your fields have defined names that are 
row-relative/col-absolute!

-- 
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
  comp.lang.basic.visual.misc
  microsoft.public.vb.general.discussion

[toc] | [prev] | [next] | [standalone]

#109732

FromAmandabui252 <Amandabui252@gmail.com>
Date2016-12-07 05:39 +0000
Message-ID<Amandabui252.128d5848@excelbanter.com>
In reply to#109730
Thông tin khá bổ Ã*ch, mong mọi người sẽ đóng góp nhiều
hÆ¡n thông tin dạng nhÆ° thế nÃ*y để forum thêm phần Ä‘a
dạng.




-- 
Amandabui252

[toc] | [prev] | [next] | [standalone]

#109733

FromStevenlinh1 <Stevenlinh1@gmail.com>
Date2016-12-07 07:57 +0000
Message-ID<Stevenlinh1.128d8278@excelbanter.com>
In reply to#109730
Thanks bác, giờ mình má»›i biết đến thông tin hữu Ã*ch nÃ*y.
Ai có những thông tin dạng nhÆ° thế nÃ*y post lên cho mọi
người cùng tham khảo luôn nhé. Đang rất quan tâm




-- 
Stevenlinh1

[toc] | [prev] | [next] | [standalone]

#109734

FromLuannguyen992 <Luannguyen992@gmail.com>
Date2016-12-07 08:26 +0000
Message-ID<Luannguyen992.128d8278@excelbanter.com>
In reply to#109730
Thanks bác, giờ mình má»›i biết đến thông tin hữu Ã*ch nÃ*y.
Ai có những thông tin dạng nhÆ° thế nÃ*y post lên cho mọi
người cùng tham khảo luôn nhé. Đang rất quan tâm




-- 
Luannguyen992

[toc] | [prev] | [standalone]

Back to top | Article view | microsoft.public.excel.programming

csiph-web