Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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). |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
|
|||
|
|||
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.
|
#4
|
|||
|
|||
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
|
#5
|
|||
|
|||
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
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vba code to filter the data like a group with group header | Excel Programming | |||
Range.Group Method - group rows, not columns | Excel Programming | |||
Group a range - closing the group does not hide the controls.... | Excel Programming | |||
Taking age group Ie ages 20-29 and picking out net sales for group | Excel Worksheet Functions | |||
How do I group worksheets (Lotus 123 function is "Sheet>Group Shee | Excel Worksheet Functions |