SQL With a IIF and a LIKE
Fri, 19 Dec 2008 08:34:01 -0800
I have a combo box that I based on a query. Access is saying the query is to
complex. I am obviously not doing it right.....help???
SELECT MATERIAL.SIZE
FROM MATERIAL
WHERE (((MATERIAL.[MATERIAL TYPE])=IIf([Forms]![SUGGEST DROPS]![MATERIAL]
Like "*" & "BAR" & "*",([MATERIAL].[MATERIAL TYPE])<>"304SS PLATE ...
|
Re: what does this mean?
Fri, 19 Dec 2008 08:28:09 -0800
I have a query that I need to limit the dates from now minus 5 years. The
field is a Date/time with a format short date. I have entered into the
criteria <=Date()-1826 however it has no effect on my selections.
--
Yhanks
Kathy
"John Spencer" wrote:
> It means that the date in the data field must b ...
|
Formula Wizard Anyone?
Fri, 19 Dec 2008 08:27:01 -0800
I have an "ANSWER" table with 4 fields:
Review Date
STD ID
File #
Ans
Here is my current formula:
T2: IIf(DCount("*","Answers","[Ans] IN ('Y','N') AND [Review Date] =#" &
[Confirm Review Date] &
"#")=0,"N/A",FormatPercent((DCount("*","Answers","[Ans] ='Y' and [Review
Date]=#" & [Confirm Review Dat ...
|
MTBI (Mean Time Between Incident) Date Difference Different Record
Fri, 19 Dec 2008 07:49:58 -0800 (PST)
I have a table with Platformscom.StartTime, Platformscom.EndTime,
Platformscom.ImpactSev. I need to find the MTBI from the ending
impact of once incident to the beginning impact of another incident.
For example I have one record with a StartTime of 10/29/2008 11:15:00
PM and an EndTime of 10/30/2008 12:33:49 ...
|
Date Minues Month
Fri, 19 Dec 2008 07:21:01 -0800
I currently have a query that sets the criteria of the records by a date
entered into a control on a form. I would like to create another query that
has the criteria set to the date to the date on the control form Minus 1
month (which could be 28, 29, 30 or 31 days) How do I do that?
--
Thorson ...
|
Query Criteria Question
Fri, 19 Dec 2008 06:45:00 -0800
I have the following query:
SELECT taPROPERTY.PropertyID, taPROPERTY.CLT, taDEFENDANTNAMES.Zip,
taDEFENDANTNAMES.LastName, taDEFENDANTNAMES.FirstName,
taDEFENDANTNAMES.MiddleName, taDEFENDANTNAMES.Suffix,
taDEFENDANTNAMES.Address1, taDEFENDANTNAMES.Address2, taDEFENDANTNAMES.City,
taDEFENDANTNAMES.State
...
|
Calculation to Obtain Compliance % Using Count of Partial Field V
Thu, 18 Dec 2008 19:22:00 -0800
Hi!
I need to create a query that seems a little more complex than what I have
done before. I would greatly appreciate any advice on how I can accomplish
the following.
I have airline invoice detail that I need to compute the compliance % of
travelers booking air travel at least 14 days in advance. This ...
|
|
|
Calculation to Obtain Compliance % Using Count of Partial Field Version: 2003 (
Fri, 19 Dec 2008 03:17:45 GMT
Hi!
I need to create a query that seems a little more complex than what I have
done before. I would greatly appreciate any advice on how I can accomplish
the following.
I have airline invoice detail that I need to compute the compliance % of
travelers booking air travel at least 14 days in advance. This fie ...
|
Syntax Error in From Clause
Thu, 18 Dec 2008 19:13:01 -0800
Following SQL code works fine. However, if I copy this SQL code and paste it
to a new query, when I try to run or save it I get the message: "Syntax error
in From clause".
SELECT T1.VendorID, T1.MagazineID, T2.MinRemit, T1.Remit
FROM MagazineData_appended_Vendors AS T1 INNER JOIN [SELECT
[MagazineData_ap ...
|
sum two columns
Thu, 18 Dec 2008 19:01:01 -0800
I'm trying to get the sum of two columns so I can display it in text box.
Instead of showing the total of both columns it shows the total for each
record. I want the total for both columns for each consignor.
SELECT Credit.[Cash Refund], Credit.[Store Credit], Sum([cash
refund])+Sum([store credit]) AS G ...
|
