Recent content by dg3249

It seems to have worked, sort of. When I insert this formula into my report it pulls all the orders and displays them as follows. Apr, May, Jun Order 123 Apr, May, Jun, July Order 122 Order 124 How do you get it to group so that it shows all orders per month instead of the way it is above.

Is it possible for you to expand on this. I'm not sure where the Join fits in..

I have an order start date and an order finish date and I need to pull all the months that a particular order spans. i.e. start date mar 1,03 finish date jun 30, 03 spans mar, apr, may, jun How would I achieve this? Any help would be appreciated.

I have posted my whole query so that you can get a better idea. select dbo.NA_invoice_lines.hours_worked, dbo.NA_Invoice_lines.billing_amt,dbo.NA_invoice_lines.branch_number, dbo.NA_invoice_lines.invoice_number, dbo.NA_invoice_header.client_name, dbo.NA_invoice_header.invoice_net_amt...

I've done what you suggested and it seems to not add the entry with the second branch, it only includes an entry for the first branch.

I need help in joining two tables where the invoice # is not unique. The same invoice number can exist in different branches. Invoice_Header -Invoice_Number -Invoice_Total -Branch -79322 -259.00 -11051 -79322 -450.00 -32165 Invoice_Lines -Invoice_Number...

Hi Angel, I have created a Union query and it seems to pull up the data correctly. Now, I have other fields that I need to include as part of the query, how would you go about this without including it in the union itself. D

I understand what you both have suggested, but its not exactly what I need. orders.office_id and na_orders.office_id may not necessarily have the same office_id for the same order, but one of those two fields will match with clients.office_id. So essentially what I need is to show all clients...

I have three tables that I need to join and I am having some trouble with it. Please help.. Tables: Client Orders NA_Orders OFFICE_ID OFFICE_ID OFFICE_ID group_id Order_id Order_id group_id Now, these three tables have the...

I am using the special fields data date and data time. Can you use the above formula with these special fields. Diana

Hi, I need to adjust the data date/time fields for Australian time. Not sure how to go about this. Any help would be appreicated.

That's what I thought, Thank you..

I have an Invoice Report that I am grouping by Client Name/Invoice Numbers. Some clients may have duplicate invoice numbers within a group. How do I display all invoice numbers, including the duplicate ones?

I was actually able to get this working in Crystal without changing my SQL Query. Thank you for all of your help.

I have decided to use a drill down report instead. The subreport just isn't working. Thank you for all of your help.