Search results

tyvm!!! :)

I have the following Query Example... SELECT [Name], [Reason 1], [Reason 2], [Reason 3], [Reason 4], [Reason 5] FROM [tblTest7] as Q WHERE [Region]='Canada' ORDER BY [Name], [Reason 1] Is it possible to have another column that would contain an 'x' is any of the 5 Reasons start with 'Data'?

It's not really a function, it involves using excel and creating a connection via the Data Ribbon.

I have an excel pivot table that uses the Access Data/Query as it's source. So with this change, I get a connection error that Excel can't get to that function. :mad: Is there a way around this? Or is it best to go back to the Nested IIF?

I am using Access 2007 and in one of my queries, I have a lengthy nested IIF statement where I "Group" records based on the [Cost] Field...can this portion be shortened/condensed with another function I'm not aware of? IIf([Cost]<0,"Proceeds Recv'd", IIf([Cost]=0,"$0"...

I have a table that I want to utilize 6 Fields...1 [Name], [Reason1], [Reason2], [Reason3], [Reason4], [Reason5]. Basically, the Reasons could contain all the same values, just in prioritized differently and possibly blank. I am able to create a query that will list [Name] as the Column Header...

I utilize ADO in Excel 2007 to connect various Access databases. I have 1 database that has 2 forms that I need to print....is it possible to do so via this connection? If so, how? :o Thanks!

They are just labelled as "Item" and "Item Cost". Also, there is another Field that is used for the query. The query would also require [Status] = "Sold"

I am wondering if the following "query" can be created using PIVOT in SQL. If so/how? I have the following non-descript Fields which are used...[Year1], [Year2], [Item] and [ItemCost] What I am looking to accomplish is having Year1 be the RowHeader, with Year2 being a ColumnHeader...however...

Is it possible to display a Pop Up box for the user, but not have the code wait for a response? :o

How would I go about adding a Y/N field to the records that the Unmatched query returns? I'm going to be using SQL code, as I will be doing this via a connection to Excel.

OK, I have 1 query that is an Append query, of which I assume I could easily copy/change to a Delete query....however, once I run the append query, the delete query will not have any records, as the records that were just appended will be in both tables.

hmmm...I'll have to look into the "Flags". :o

So I need to create the unmatched query, store those results on Table3, append the unmatched records from Table1 to Table2 and then delete the matches between Table3 and Table1?

I have a query that Appends unmatched records from Table 1 to Table 2. Is it possible the Delete the records from Table 1 at the same time they are appended to Table 2?

2007...I use Access to create my queries, then utilize the SQL in the Excel VBA Here in my SQL...I tried using the NZ in Access, but was not able to get the missing year(s) to appear. SELECT [Book Yr], Count([ID]) AS [Instances], Sum([Cost]) AS [Total Cost] FROM [tblName] WHERE [Cost]>0 AND...

I'm using the SQL in an Excel Macro that is connected to the Access db, therefore, my Query results are loaded directly into Excel.

So, I used the following in part of my SQL Code in Excel/ADO Sum(NZ([MISCCost],0))>0 It causes and error that NZ in an undefined function. :confused:

[Book Yr]...currently, if the other results are 0, then that Book Yr does not appear. For example, I am looking for query results for 2000-2009, my results might only show 2000,2001,2002,2004,2005,2008,2009...but I would like 2003 & 2006,2007 to show results of 0 across the board. (if that...

Is it possible to have the result display all the years >2003, even when the results are zero?