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 Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Query Results - Data in wrong column
When running this UNION SELECT query some of the rows of data are incorrect - the data is shifting right one column and causing the data from the join table to disappear. What causes this? What can I do to fix it? Thanks.- amih
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
-
Refreshing data from SQL query
I have built a Crystal report (using 8.5) which is pulling data from a SQL query. It works fine on my machine, but no one else can refresh the report to pull new data. They get a Crystal Database error, File could not be found...with the query name. They have an ODBC connection to the...- amih
- Thread
- Replies: 0
- Forum: Business Objects: Crystal Reports 2 Data Access
-
Error when converting numeric to date
A newbie here: I am trying to convert a numeric field into a date field. I created individual formulas for the month, day, year. When I go to combine those results, I receive the error, 'The string is non-numeric" Here's what I have: The formulas for month, day, year follow this format...- amih
- Thread
- Replies: 2
- Forum: Business Objects: Crystal Reports 4 Other topics
