Search results for query: *

I'm trying to group some data together in which I want to separate groups to be considered one. Below is a sample query, but basically I want LargeNail and SmallNail to be considered the group 'Nail'. The issue is that it just lists 'Nail' twice, with all the numbers separated. I want the two...

I have a query that lists the aggregate Month and DateName by month in two separate fields. I would like to merge these together so this query displays like so: 2009 1-January 2009 2-February etc. SELECT 'Year'=Year(vtr."Billing Date"), 'Month'=Month(vtr."Billing Date")...

I have a fairly simple nested formula, but I'm struggling to get the correct format. I know that the formula at the end is redundant, but I was just trying to figure out how to get it to work. Round (if isnull({tei.dteFileCreated}) then if {vtr.Mode}="LTL" then...

I did a left outer join between two tables. The order number is split into different classes. When I return data, the order number lists multiple line items for each Class, like so: Order Class 1 25 1 26 1 27 2 32 2 33 I'd like to make it so it lists the one...

I'm just using Microsoft Query. I decided to scratch the inputbox idea, and simply declare and set a variable. I did it successfully, but when I go back to edit the SQL again, all the code has dissapeared. Do you know why this is? All I added is below and then I put @Param in the SELECT...

How do I actually create the parameter? Never done this before...

Is it possible to have an SQL parameter in which is just asks for a numerical value to input into a formula? It would be a non-existing field that would just import whichever value I wanted. Everything I've seen for SQL parameters is that you input a field and it asks you which value to use...

I have a Crystal Report which is essentially just charts. Currently, the Y-axis is a count while the X-axis is a billing date. The billing date is by month of the Fiscal Year. The categories are two different locations, which are displayed in the key. Instead of just having one fiscal year...

I'd like to setup a macro so that Excel will refresh the query in each sheet in an open workbook and then copy everything to a new blank workbook. With that, I'd like it to be able to do this for all open workbooks. Here's the code I currently have, but all it does is copy the first workbook...

I got it, thanks! SELECT 'Year'=Year(vtr."Billing Date"), 'Month'=Month(vtr."Billing Date"), 'Miles'=SUM(vtr."TotalMiles"), 'Weight'=SUM(vtr.Weight), 'Total Cost'=SUM(vtr.TotalARAmt), 'Base Cost'=SUM(vtr."A/R Invoice Amount")...

Actually, George, yours works, I just missed a setting. The issue is still that I want the tbl to group by the month of the dteEffectiveDate so the counts/sums don't get skewed.

I very much appreciate this help. I had to add Group by Year(vtr."Billing Date"), Month(vtr."Billing Date") to get both of your suggestions to work. George, yours just gave me a blank screen, but no errors. chamilz, yours worked, but it isn't what I was looking for. There are four or five...

Thanks for all your help, but it says: Invalid column name 'dteEffectiveDate' Invalid column name 'nbrFuelSurcharge' SELECT 'Year'=Year(vtr."Billing Date"), 'Month'=Month(vtr."Billing Date"), 'Miles'=SUM(vtr."TotalMiles"), 'Weight'=SUM(vtr.Weight), 'Total Cost'=SUM(vtr.TotalARAmt)...

It sort of does. I changed the formatting inside the second select statement, but still have the issue. Can you clarify what else I'm doing wrong? Can I not use the first 'FSC' alias in the first select statement? SELECT 'Year'=Year(vtr."Billing Date"), 'Month'=Month(vtr."Billing Date")...

Could you please help me correct my formatting? I cannot figure out what I'm doing wrong. Thanks! The multi-part identifier "tbl.dteEffectiveDate" could not be bound. The multi-part identifier "tbl.nbrFuelSurcharge" could not be bound. Invalid Column name 'dteEffectiveDate'. Invalid column...

Thanks. I guess my next question is that the main data I actually use is in mm/dd/yyyy hh:mm:ss AM/PM. Would my date table need to have every date listed in the year in the same format? In the end, I'm going to group it by month. This is where I get a little confused with linking.

I'd like to follow this up again because I was wondering if there is another method to doing this. I have a report grouped by billing date by month. With this report, I want it display all the information for each month, and then if it's null, I want it to field out my sums and counts as zeros...

I'm trying to draw a line above a Crystal Report generated chart, but the line keeps going behind the chart. I've tried moving the chart to the back of the section, but the line still gets blocked out. Is there anyway to fix this? It's just a set number that I was trying to manually display...

This may be an unusual request, but I'm not sure. I have a report where everything has a value: Customer Order Number Date Value When I group this report by month and there is a month with no values, I want the report to automatically field out the fields as zeros. For this example, the...

I'm doing an SQL query where my first field has six different values. Theoretically, they are Blue, Green, Red, Yellow, Orange, Purple Is it possible to force them to group two or more colors together? For example, I want Blue and Green to group together, Red and Yellow to Group together...