Search results

I need to calculate a way to count the number of days a deal takes to close. The problem being we only want to count days that it is actually being worked on. So I have four date fields: Open Date, Inactive Date, Reactive Date, and Close Date. I wanted to create an expression that counted the...

I have a query with 4 date fields, and with two expressions that use datediff with those fields. Then I take an IIF statement and create an expression of datediff 1 - datediff 2. the problem is some of my date fields will be null. Here is my SQL: SELECT [Customer List].[Company Name], [Loan...

So I guess this is my final attempt to see if I can create certain results with a query without having to actually program. My query basically has a large amount of data. Each quarter we have to submit information from the data within six different date ranges: Less than 3 M 3M - 1 Y 1 Y - 3...

I am sorry to keep bothering the smart gurus of this forum. I solved my date issue. So let me do a little explaining. I have probably 12 plus queries that have a various amount of criteria within each query. The differing factor between the queries are the date ranges. less than 3 months, more...

Hi, So I have two date fields that i need to pull information from. I do not need duplicate data. However i can not figure out how to set up the expression. I need date1 to show up if it falls in this 1/31/2010 - 3/31/2010 If date2's date falls within 1/31/201 -3/31/2010 then i need it to show...

Hello So I have created an IIF Statement that states: Description3: IIf([State]="UT" And [Balance]>=1000000,[Description],"Other-In Utah") The statement works fine. The problem is I need to field to return if the data is above 1000000 and within Utah I need the Table Description to show. If...

So my query is set up as so. Broker_Descrp (Table Field) Balance (Sum of a Table Field) Tier 1 % (Expression) Description (Expression - IIF Statement) Well my Description expression basically is showing the actual broker description of the balance is over 1,000,000 but if it is below it...

Is there a way to take the column total and have it display for each group in a query?

Is there a select Inverse function in MS Access? I have a query that generates a list of sales people, some of the sales people do not show up on the list because they do not have any current deals. I want a function or query of some sort that will connect the the original query and generate...

So I have a query I have created that has terms and a balance connected to each row of data. I wanted to know the total for each category, therefore I created and aggregate function and named it balance. Then I needed to limit all balances lower than 1,000,000 and have them combined into one...