Search results for query: *

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.

This is exactly what I want. All individual dates between the starting and ending dates. I am assuming we will have to use a local variable, but am not to familiar with how to set this up.

After playing with your query some more, its pulling up the starting and ending dates but not the ones in between. Do you know how to do this. Thanks for your help Angel

Not quite, The values are not distinct. There are multiple orders and each order has different start and end dates, that may overlap each other. What I need is for my query to show all days that an order will be working as individual days of the week. I tried what you suggested, but it didn't...

I need help with a date range problem. I have an orders table which has a starting date and an ending date. For example; order 1111, starting date Nov 1, 2002 endig date Dec 31, 2002 I need to pull all individual dates in this date range for all orders. HELP!!

My report is not only for a one month period. It's sorted by Year/Quarter/Month/Client, will a selection formula work for this? I would really rather get the Subreport working on its own. Do you have any ideas why its only pulling up the first invoice number for a client instead of all...