Search results for query: *

Hi, I have some reports that are scheduled using Info 7. All these reports work fine however some of our users recently had their email addresses changed and now these select users don't receive the reports. The new email addresses are valid as I can send them emails directly from Outlook. Are...

Thought as much. No I can't write to the Oracle DB. Your tips were still helpful as it works in SQL using the same connection. Hopefully I can try and do this using lookups and some VB script. I don't want to have to import all the data as this would take too long.

I get an ORAOLEDB error saying that it can't find that SQL table.

All of this works when the main table and the excel imported table are using the same connection. When trying to reference the new SQL table from the Oracle connection it can't find that table as it's not part of the Oracle connection.

This works fine if the table exists in the same connection. The problem is that I can't import the temporary table into Oracle. My query selects data from an Oracle table.

Hi - I need some help using lookups in DTS(SQL 2000). I have 2 tables. Source is Oracle DB with a table called Titles and Destination is SQL Server 2000 with table called Titles with no records. I have a excel spreadsheet called SBNList with one filed called SBN that has 250 SBN numbers. I need...

Thanks Ibas - That works in the same way as lastfullweek. What happens if the end of the month is a Thursday. Then I would only want to how sales for Monday to Thursday.

Hi - Can anyone help me with a formula that will calculate sales for the last week. I know there is a formula called lastfullweek but what happens if the week finishes on a Wednesday? My report will run every Monday and needs to calculate sales for the week Monday - Sunday. Thanks

Thanks Madawc. Just the job. 8.5 is my version. I'll rememember to mention it next time.

Hi, I need to format my numbers to thousands. Example: 57,000 to 57 58,985 to 59 58,350 to 58 Thanks