Search results for query: *

Recommendations please.....has anyone had experience with Data Direct software? I write Crystal reports using an ODBC driver to connect to an Oracle database. I also write reports using a different ODBC driver to connect to a Sequel database. I can create a report using both databases with...

Can you sort on a calculated field in a grp footer? I have a calculated percent field based on 2 tot fields created in the grp footer and want to sort on the new percent field. The field does not show up as a sort field.

I am having a problem with a linked table (Oracle 73.ver2.5) and Access 2002. All other linked tables are coming across great except for 1 table – and the only difference I can see is that there is a memo field. When I look at this table in Access – all fields show as #Name?. When I do a...

I am having a problem with a linked table (Oracle 73.ver2.5) and Access 2002. All other linked tables are coming across great except for 1 table – and the only difference I can see is that there is a memo field. When I look at this table in Access – all fields show as #Name?. When I do a...

Database was converted from Access 97 to Access 2002. Users preview a report in Access (looks great) and then click on “W” at top of menu (Publish it with Microsoft Word) and report is shown in Word as a .rtf document. The problem is the Word document does not look like the Access report...

I have a problem comparing dates in a query. I’m using Access 2002 and the “date” fields I’m comparing were text fields. I’ve converted them to date fields using CDATE. Example: IIF ([Acceptdate]>=[RejectStart],[Acceptdate],[Rejectdate]) Example of Acceptdates: 06/01/2003, 06/12/2004...

I have a master report with 4 subreports. They are linked to the master report by Vendor nr. The Master report uses the Vendor Master table which has all vendor nrs. Everything looks good and data is accurate for any of the subreports that have vendors with data. The problem occurs when...

I have 4 reports from different tables that I want to merge into one report using 3 subreports. I link 3 subreports to the master report using either cont # or vendor # - works great – no problem. The problem comes in when I want to add a date pulldown “>=[date_field]” The master report pulls...

I have 4 reports from different tables that I want to merge into one report using 3 subreports. I link 3 subreports to the master report using either cont # or vendor # - works great – no problem. The problem comes in when I want to add a date pulldown “>=[date_field]” The master report pulls...

I'm using the Lookup Wizard in one table to lookup a field in another table. Works like a charm for a TEXT field - but does not work with a MEMO field. Is there any way to do a lookup on a MEMO field?

I've made new fields for my report using the expression builder and it always works great with text fields or date fields - but I get errors if I try to mix text and date fields. Example that works: ="This report has been designed by " + [NameField] + " and it works great&quot...

When I export a table that contains number or currency fields to a fixed-width text file, the numbers in these fields become left-aligned automatically. Does anyone know how I can export these fields and make them right-aligned??

Can a text field be converted to a date field? I would need to do this in the query - not change the field type in the table. Help please!

I have 2 tables that need a new po nr added. So I made a form adding the Po nr to table 1 but I'm not sure how to add the new po nr to table 2 without rekeying. Do I use update, addnew, insert??? I would like to go the easy route as I'm not good with vb.

We are beginning the process of evaluating scheduling software for Crystal. Thanks to Ken Hamady's Crystal Links, we have limited our search to Crystal Desk Report Scheduler and Visual Cut. I think we are more limited in our selection because we are still using Crystal Ver 7 and are still...

I have created a macro using the SendObject Action. I have about 30 people to email (using Outlook) a report to – so I tried to use a distribution list created in Outlook instead of typing 30 email addresses. I got an error “Unknown message recipient(s) – message was not sent”. I just left...

I'm trying to use embedded IIF Statement in a query (first time using it) and I keep getting the error "expression you entered is missing a closing parenthesis,bracket or vertical bar". The first 2 IIF statements work great but when I add the last two - I get the error. Can anyone...

I have a text field (CurHrs) in a linked ODBC table that I want to change to numeric. I created a query with this table and made a new field: NuCurHrs:CDbl([CurHrs]). The field looks great. I then created another query with this new field and used the Total: Sum option on the NuCurHrs. It...

I created a Shared StrVariable in my subreport - link to the main report and display this subreport on my main report. When I look at this text field on the main report(from the subreport) - it is correct. I then created a Shared StrVariable in the main report and show that on the main report...

I have linked Table A left link to Table B. Report Record Selection formulas from Table A produce the correct results (i.e.Record from Table A without matching Record from Table B) - but when I add a selection formula using Table B - it appears to loose the left join and I no longer get records...