Recent content by briesen

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