Search results
-
E
Searching Between two dates via user inut
SELECT Applicant_Loan_Info.Submission FROM Applicant_Loan_Info WHERE Applicant_Loan_Info.Submission Between [Starting Submission] And [Ending Submission] ^ -
E
Top N Per Group
Please attach your database, preferably in Access 2000 format. ^ -
E
New to Queries - Need Help
The Dam of the 7th record is not in the Registration list. ^ -
E
IIf and Isnull in expression builder
See Jon K's basic criteria format and his note #1 in this thread: http://www.access-programmers.co.uk/forums/showthread.php?t=103312 ^ -
E
Duplicate tag #
Try this query. SELECT * FROM [TableName] WHERE [Device] & " " & [Tag#] in (Select [Device] & " " & [Tag#] from [TableName] group by [Device],[Tag#] having Count("*")>1); ^ -
E
Working with text and dates
Try this: CDate(Left(Mid([si_narr_t],Instr([si_narr_t]," ")+1), Instr(Mid([si_narr_t],Instr([si_narr_t]," ")+1)," ")-1)) ^ -
E
saving Query data into table
You can change the query into a Make-Table Query to create a temporary table: SELECT Shift.Shift_ID, Shift.Shift_Type, Sum(Main.Shift) AS SumOfShift, Format([Date],"mmmm") AS Expr3, Year([Date]) AS Expr4 INTO tblTemp FROM Shift INNER JOIN Main ON Shift.Shift_ID = Main.Shift WHERE... -
E
a simple one! please help! :D
You can use a form for the user to fill in only the criteria needed. See Jon K's query criteria in this example: http://www.access-programmers.co.uk/forums/showthread.php?t=103312 ^ -
E
"Not Exists" problem
SELECT Rep.FixtureID FROM tbl_Reports AS Rep WHERE (Exists (SELECT fix.FixtureID FROM tbl_Fixtures AS fix)=true); I believe your query returned every record from the tbl_Reports table because the subquery will always be true when there are records in the tbl_Fixtures table. Try the Find... -
E
List Box linked to a Search Query
To use a list box in the query criteria for multiple selections, you have to use VBA code. See Jon K's another sample database in this thread:- http://www.access-programmers.co.uk/forums/showthread.php?t=143670 ^ -
E
Parameterised/Unparameterised Query
See Jon K's method in this thread:- http://www.access-programmers.co.uk/forums/showthread.php?t=103312 You can replace his [Forms]![FormName]![ControlName] with your parameter. ^ -
E
Query Criteria Expression
Try setting the criteria for the RenDate field in a new column in the query grid like the following. -------------------------- Field: [RenDate] Between Date() And Date()+[Forms]![F Search]![days for renewal] Or [Forms]![F Search]![days for renewal] Is Null Show: uncheck Criteria: True... -
E
How can I select only the rows I need?
Jane, To combine two queries into one invariably involves the use of a correlated subquery (that is a SQL statement in a pair of brackets that refers back to the field(s) in the main query.) In Access, an inner join is considered more efficient than a correlated subquery. So my answer to your... -
E
Multiple condition query
It's rather confusing and not clear. When it's one, it can't be all. ^ -
E
Multiple query fields of a form
See the query in the attached sample database, which is based on Jon K's thread: http://www.access-programmers.co.uk/forums/showthread.php?t=103312 ^ -
E
Replace function in a query
In a query, you don't need the = sign and you have left out a comma and a double-quote. Replace(Format([SITELATSEC],"00.0"),".",",") ^ -
E
Returning null records?
Try using the Find Unmatched Query Wizard. (Click on the New button in the Query tab." ^ -
E
Qbf Date Field Help
Sorry, should have mentioned that you have to use your correct field name, form name and text box names in the expressions. See the query and form in the attached sample database. ^ -
E
Qbf Date Field Help
You can easily resolve the problem by following Jon K's method in the thread Adam has linked to. Just put two criteria in the query grid like these:- --------------------- Field: [DateField] >= [Forms]![FormName]![txtStartDate] Or [Forms]![FormName]![txtStartDate] Is Null Show: uncheck...