Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to create this column?
I need to create a calculated column named "25% percentile". I was told to use the two date fields, start_date and end_date, from the dataset. First of all I have to ignore those data rows if one of this date field is null. Then calculate the duration between the two date fields using...- paulmak
- Thread
- Replies: 0
- Forum: Cognos solutions
-
I need help to create this report...please
I have a recordset with 5 different fields, ID (Text), Program (Text), Program Type (Text), Year (Number) and Amount (Currency). For example: ID Program Program Type Year Amount 1 Maths Type A 2002 1000 1 Maths Type A...- paulmak
- Thread
- Replies: 1
- Forum: Microsoft: Access Modules (VBA Coding)
-
I need help with UPDATE query
I have a table consists of 4 fields, ID (autonumber), Sort_Order (number), Text1 (text) and Text2 (text). The data from this table displays in datasheet view, order by the Sort_Order ascending, in a subform. I put the VBA code for the Sort_Order field so that the Sort_Order always start from 1...- paulmak
- Thread
- Replies: 0
- Forum: VBA Visual Basic for Applications (Microsoft)
