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...
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?
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...
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...
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?
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...
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.