Search results

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'?

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!

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

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?

I'm not getting my Query to work right, please help. :confused: I'm using 3 Fields [Book Yr], [Costs] and [Name]...what I'm looking to get is a breakdown/Group by Book Yr of the Count of Name and the Sum of Costs where [Costs] > 0. I am able to group by the year and and get the correct sum of...

I have a database and I want to create a query (using SQL) that just gives me the Sum of 1 field for the records in question. For Instance, I want my query to sum the total of [Amount] for all records that [DateYr1] = 2008 and [DateYr2] = 2010 and [Amount] > 0. Is that possible? I'm not...

On a form, the user has the ability to pick and entry from a related table...which has an associated location/city. I would like there to be an combobox that would give the user the option to select the associated location or 1 or 2 other fixed locations. How can I incorporate that? Thanks!

Hello, I have Access/Excel 2007 and am using excel macros with ADO to create an .accdb file and loading a table from excel. I am then running my queries via the macro. I'm not real fluent with this process and the problem that I am running into is that when the .accdb file is created the...

I have an access 2007 database that has a handful of queries that are date range driven. Currently, I have to open the db and put the dates in a form...then the queries provide me the data for that data range. Is it possible to use excel to connect to the access db and set those dates via a...

This is probably a REALLY stupid question, but... I have several queries that I would like to have the total number of records and the sum of the $ amounts of those records/queries appear on a report...being new to Access, how is that done? :confused:

Not sure if the is the right area, but here's my situation. I have a huge table that I import into my 2007 Access db. Then within access, I have multiple queries that I utilize on a weekly, monthly, quarterly basis. Would it be possible to somehow change/indicate the start/end dates that are...

I have a query that I am working on which the table includes Date1 and Date2. I want to create a query that will return all instances Date2 is either = Date1 or is upto 3 days after Date1. I've tried using this type of coding, but I suspect the "+1" isn't correct for a date. [Date1] +1 =...

Of the several fields that I have on a report, I have 2 that I am concentrating on...1 is "Quarter" and the other is "Month1". I am trying to have the Month1 label appear as "January" if the rightmost character in "Quarter" is a 1. I suspect this is fairly easy, but I haven't had any luck...

Hello, I'm VERY new to working in Access 2007, so this might be a stupid question. :) Is it possible to merge the FirstName and LastName fields from 1 table when using a multi-value lookup in a different table? If so, how?