SQL help? group? anything?
 

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).

SQL help? group? anything?
 

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

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.

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

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