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!
-
Select Date that is closest to a date within a range
I am trying to find a solution to retrieve an individual record by selecting the date that is closest to a certain date but within a given range. The solution I've come up with is rather unwieldy and I wondered if anyone has suggestions on a more elegant solution. For this example, I am trying... -
Calculating differences between rows
I am trying to figure out the best way to calculate differences between a value and the value in the previous row. I have come up with several possible ways to do this, but I don't have a lot of SQL experience and would be grateful for help from someone who has done this before. Here is a... -
CRViewer in MS Access VBA does not work
Hello, I am trying to use the CRViewer control in MS Access VBA, but something is not working. When I insert the CR Viewer Control onto a form in Access, it appears as just a square, not the usual control. When I try to set custom properties, I get the error, "The operation on the...- natrons
- Thread
- Replies: 2
- Forum: Business Objects: Crystal Reports 3 Integrate
