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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Access Query comparing 2 sets of data with 2 sets of dates
I have a database that calculates the yield of product produced. We query it to find the yield based on gross and net weight for different products each month (or week). It is a select query that calculates the Yield in the query. We need to design a new query/report that compares this years...- lynng
- Thread
- Replies: 1
- Forum: Microsoft: Access Other topics
-
can't summarize this field
I am trying to place a sum for this formula field in the group footer, but I keep getting a message telling me this field cannot be summarized? It calculates the number of pieces for a product and then I want to sum it for each day. Any suggestions? Thanks. if GroupName...- lynng
- Thread
- Replies: 1
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Sorting Time Date Field Group
I have a time/date field and have grouped by it in my report. The report has the field formatted as date for the group. Within the group is the same field formatted as time and I would like to have it sort ascending. No matter what I do the time part does not sort correctly (am/pm intermixed)...- lynng
- Thread
- Replies: 1
- Forum: Business Objects: Crystal Reports 4 Other topics
