Search results for query: *

I am using repeating fields with FM Pro 7. I got the design somewhere on the internet. How do you make fields repeat without the use of repeating fields? Thanks!

I have an invoice file that I use to put products on an invoice and send to customers. I have a header, body and footer. The problem I'm having is figuring out how to only show so many repetitions of the product fields. If I only have one product I just want to show one row. If I have 25...

When I use that query I get several errors: Invalid column name 'customerID' Invalid column name 'contactDate' Invalid column name 'customerID'

I'm using the following query SELECT DISTINCT contactInfo.customerID, MAX(DISTINCT contactInfo.contactDate) AS LastContact, customers.firstName, customers.lastName, customers.companyName, salesPeople.salesPerson FROM contactInfo INNER JOIN...

SELECT C.customerID, Max(contactDate) As LastContact, Count(O.customerID) As NumberOfOrders FROM contactInfo C LEFT JOIN orderID O ON C.customerID = O.customerID GROUP BY C.customerID returns an error: Invalid object orderID. Even if I change the query to read. SELECT customers.customerID...

I just realized I needed more information returned. I'm using the query you gave me above. However, I'm also needing to return the number of orders associated with the customerID. These orders can be found in the table orderID with an associated customerID column. Is there a way to return a...

I have a table, contactInfo. In it there are two columns, contactDate and customerID. I'm trying to create query that returns the single most recent row for each customerID within the table. Of course, there are mutliple rows for each customer. Any ideas?

It would seem as this is just gathering the rows that are needed for the query. I have no problem getting all the rows I need it's just displaying them in the correct place. Am I misunderstanding you?

Yes, I'm using two parameters.

I'm using CR 9. How would I merge the fields? Could you give me a more specific example of what you're suggesting? Thanks!

I have a cross tab report that is pulling orders from a DB with the following criterion: "Estimated Book Date" that's between to specified dates OR "Complete Date" that's between the same to specified dates. The row is Estimated Book Date grouped by month. The summarized fields are “estimated...

Anyone know how to do this?

I have a field called PartNumber. I know there a duplicates in it and I am wanting to create SQL query that returns those duplicates. I was looking around and it seems that everyone just wants to know what the duplicates are and not actually list the duplicate rows with a RecordID or Unique ID...

Nope, sorry. I will let you know if I do.

No one knows how to edit a dialog box in Visual C++ .NET if the activex controls are no installed on the machine?

I started a project out in Visual C++ 6.0. I then saved the project wiped out my drive. Installed Visual C++ .NET. Opened the file and converted it to work with .NET. It compiles perfectly, but when I go to edit a dialog box, I cannot even view it because of an error. It says something like 4...

bperry, I think your solution might work better. I'm not an expert at SQL. I tried this: select (OrderID + 1) as 'Gap!' from orders g1 Left JOIN orders g2 on OrderID + 1 = OrderID where OrderID IS NULL and OrderID <> (Select MAX(OrderID) from Orders) order by OrderID and I got a bunch of...

I am trying to create a query where SQL selects a break point in a row of numbers. I have a cloumn containing a number, lets say 1-100. They all exsist except 50. How would I get SQL to tell me that 50 is not in use?

Thanks darren. Unfortunatley that didn't help either. I think I may just have to upgrade from Illustrator 7.0 to 9 or 10. Thank you for your help.

BuddingDesigner, that was another generic answer I've been getting from everyone. I will just wait for derren to reply again, he seemed to be the most help full out of anyone, even Adobe. Thanks for the effort. I have been making sure the fonts download with exception to which Job distiller is...