I have created a report in Crystal 9 Developer's Edition. The report is based of an internal ODBC (RDO) query which was initially set to use "SAMPLE" SQL Anywhere database. Everything seems fine.
Tried to run the report through a different application using Crystal runtime files...
I have a string that I need to parse out, then I need to use each unique parsed piece as a group.
For example: I want to track which people in my survey watch what stations.
"NBC, ABC, CBS",
(Ted watches all three stations)
"ABC",
(Mary watches ABC)
"ABC...
Does anyone know a work around for casting in a union query in Access. I am trying to do a report using ADO and I would like to use a query. When I create my union query, I want fields seperated
SELECT
Name
Gift Date
Gift Amount
Null
Null
From Folder, gift (blah, blah)
UNION
SELECT...
I am joining three tables. One is folder joined to gift by folderID (one to many relationship) and folder is joined to pledge by folderID (also one to many relationship). The problem is when the records are retrieved, I receive duplicate records to "Fill space" (ie. I have 5 gifts...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.