Search results for query: *

I have written a Crystal 10 report that duplicates the customer invoice feature in our accounting software. Our existing software allows reprinting invoices, but only one at a time. Now, I am at the same wall with Crystal. I have successfully joined two tables, one containing the invoice header...

I am using UPS WorldShip to write to a Pervasive V8 table. After each shipment, the software sucessfully writes the fields that I specified to correct columns in the table. The WorldShip software, however, does not have a time or date field anywhere that I can find that I can use to timestamp...

I have a asp page that queries a local psql database and a remotely stored mysql database. They both have a 'Customer' table with a 'CustomerNumber' column. I am currently comparing each customer in the local table with the customers in the remote table, and if the remote customer is missing, I...

I have a local psql database and a remotely stored mysql database. They both have a 'Customer' table with a 'CustomerNumber' column. I am currently comparing each customer in the local table with the customers in the remote table, and if the remote customer is missing, I list that customer from...

I apologize in advance, there's at least 3 forums this could fall into :) My company has a psql based program that stores 'customers' in a local database. Our offsite website has a MySQL database that stores SOME of those customers as 'dealers'. There is a flag in the local table that specifies...

I have a local server that contains our inventory that changes constantly. Our online store is hosted elsewhere and uses a mysql database for storing the inventory. I would like to update the online database every hour. I have a local SQL script that pulls the local updated inventory data (2100...

OK, I have a pretty extensive report pulling data from 3 different tables, and working perfectly. Now, of course, anytime management sees something good, they want to break it. The only solution that I can see would maybe be a Expression Field, but it's not recognizing any of my syntax. Here's...

I have been tasked with producing a report that groups data by the first part of the item number. 90% of the item numbers contain a hyphen but hardly any are the same number of characters. An example of the data pulled would be: Item Number Qty Cost Ordered AB1234-01SM 10...

I am attempting to join 2 tables, but for optimization purposes, I want to "filter" one of the tables down. I posted this originally in the standard SQL forum, you can read about it here: http://www.tek-tips.com/viewthread.cfm?qid=1521676&page=1 What I am trying is this: SELECT...

I'm wondering if I can "filter" out what I need from a table before I join it to another table. Table "Items" has 2,795 rows Table "ItemsMonthly" has 39,352 rows I need all rows returned from table ITEMS with the corresponding data from ITEMSMONTHLY that meet the following conditions: TYPE =...

I need to pull several columns from a table on a SQL server and then populate a Access mdb with the data. I have searched for software, but can only find apps that convert mdb to sql, the opposite of what I need. I've tried an asp page and can sucessfully pull the data that I need. I can even...

Forgive me if I've posted this in the wrong forum... We have a Database 'CP' with several tables, one of which is 'Customers'. We went into the 'Customers' table and made changes to both the 'SalesRep' column and the 'Category' column. Now, 45 days later, they want the changes made to the...

Forgive me if I've posted this in the wrong forum... We have a Database 'CP' with several tables, one of which is 'Customers'. We went into the 'Customers' table and made changes to both the 'SalesRep' column and the 'Category' column. Now, 45 days later, they want the changes made to the...

OK, We have a Database 'CP' with several tables, one of which is 'Customers'. We went into the 'Customers' table and made changes to both the 'SalesRep' column and the 'Category' column. Now, 45 days later, they want the changes made to the 'SalesRep' column to be undone. I have a backup of...

OK, Lets say that I have an online catalog with 20+ pages. I am putting a 'table of contents' at the top of the page. It is an image that looks like several buttons and a map that will take you to "page04.htm" when you click on "widgets", etc... If in the future the catalog changes and now when...

OK I have a table with data like so: COL1 |COL2|COL3| COL4 | COL5 ------------------------------------ 12340001 | 01 | 24 | XXXX | ________ 12340002 | 08 | 03 | XXXX | ________ 12340003 | 12 | 22 | XXXX | ________ And I have a csv like so: 1234001,ABCD 1234002,EFGH 1234001,IJKL I...

OK I have a table with data like so: COL1 |COL2|COL3| COL4 | COL5 ------------------------------------ 12340001 | 01 | 24 | XXXX | ________ 12340002 | 08 | 03 | XXXX | ________ 12340003 | 12 | 22 | XXXX | ________ And I have a csv like so: 1234001,ABCD 1234002,EFGH 1234001,IJKL I need...

Hello again guys, I am making excellent progess with my application especially with all of your help. I have a 50 char text column in a table that I am storing my data in. I can't create new columns. My page takes input from a form and writes it into the field like such: 1A01A 1A01B 1A01C...

Hello all, thanks again for all the help so far. I have a table with 9 columns, I need to pull 4 columns and split up a 5th into peices. This is what I have so far and it is working: Set con = Server.CreateObject("ADODB.Connection") con.open "DSN=FTInventory" strQuery1 = "SELECT Barcode...

I have a single entry form on an .asp page that reads in a barcode number and queries a database and returns the details for that item. When the page first loads, and when it reloads after the query, I need the cursor to be automatically placed into the input for the form. Is there an easy way...