Queries [Archive] - Page 72 - Access World Forums

Help ...show list Movement_inventory
Total Working Hours
AnyOne help with this?? Join Query
Odd query problem giving me grey hairs.
Using an APPEND query to move records from one table to another...
Query Help: Grouping like rows
Global Name Query
Query with a Running Total
query with 2 criteria
Use combobox from form in query
Total Hours by Week!?!
Execute Two Statments In Query
Multiple Parameterized Queries Run Together
Running queries using a macro
Referencing Fields from non-current records
IN with LIKE
Help setting criteria within query
Query calculation problem
DateDiff question
Returning a sequential number
Convert Numeric value to text
MMMM:SS conversion to Seconds
Can't Write Data To Local Table
Altering Data Display
IIF syntax
Date Conversion to Weekday and Weekends
Select 20 Random Records In Query
Design suggestions
Need help on Join creation query
Nearly there just one line of code needed...
Add text on the form when the query is "shown"
SQL delete syntax
Finding records 3 months old
Record entered multiple times
Creating A Master Query or Report From Multiple Queries
really simple one
Week No. chronological order problem
rounding duration to an increment of 15
Error 3071 - Expression too complex?
Invalid bracketing in query in split database
Filtering for Lowest Date out of Duplicate records
Edit fields in an outer join query
Querry by primary key? is it possible?
Time Calculations
Avoiding 20 levels of Iif-Then-Else
Is Select Case the correct way to do this
User inputs Table when query runs.
Display Combo Box before running query
Shortcut to SQL Query (View)?
Really need help with this!!!!!!
------->>> Please help on filtering out duplicate records.
How make query criteria come from selected records on a listbox
query function with #error
update query
moving range
Criteria for displaying records for a given week
integrating sql query into vb macro
Sort on Calculated Date field
using like
Multiply Fields, Using The Sum Function.
Filter Fields
Parameters/expressions in queries
Query wont allow data update
Unable to search for critera
Can you query a range of dates with a range of dates
vba query
Search by Drop Down List
saving Query data into table
Keyword search query (example attached)
Show Updated Fields
Show results After Date/Time
Qry: Crosstab Query with a few value's
An Anti-Query?
IIF Statement
Speeding up searches
Very simple yet cant get it working...toggle box switch
Updating one table from another
Dates and bookings
Delete Query not working
Two Option Groups, one won't work
Working with text and dates
Does anyone have any suggestion?
Query Filter with multiple checkboxes
Duplicate tag #
Update query to change number of decimal places
Problem running a query based on date criteria over previous 7 day
Query Subtraction
IIf and Isnull in expression builder
display double digit number
Union Query Datasheet Not Updateable
greater than question
SQL problem within Access
Not In and Append Query
Criteria and IIf in Search Page
Ggrouping and do calculation on number of records
deactivate notification
Count not returning 0
check box - query
LATEST date older than 45 days....
Join Syntax Errors Translating Oracle SQL to Access SQL
Simple Query Question
Help with select query
Retrieve Records for the Past Year
query not delivering unique records
New to Queries - Need Help
Query Criteria a List Box Record
Calculating total prices only for specific records
Calculate percentage
Top N Per Group
Union Query ... Help me
Stipulate Combo Column in SQL
Append query to add data from form to table
dropdown selection
zipcode query
inventory
Using COMBO Box to Query a second combo box.
Expression help
make table query with primary key
Calculate No. weekdays between dates
Calculations Query
Duplicates In Query
Says primarykey is NULL when infact isnt
Select record in split form query result
Would I use a query or what
Avoiding to see Today's data
Time in Access: Keeping "medium time" format
Validating email addresses
Validating phone numbers
Time data in query condition
Searching Between two dates via user inut
difference in field
How To Make Query Run Faster
Change query criteria via Excel macro
Query Question / Caluulation
Help please
reformatting Excel numeric dates or parsing
Duplicates in Query
Counting names
Calculated fields
Finding Unique Data using date field
Pass List box Value to SQL Stored Proc
query difference between tables
Parse Text
query OR syntax
Using date and a value to make a text box true
A Basic Question
how to convert decimal values to octal
Disabled Append Queries - Due Patch Update to Windows
Query Problem
Lookup query - help please
Find First Date Approval
how to call/combine 2 queries in pivot chart
calculation within query using combo
Transferring Query data to Excel
Please have a look at my report. It shows numbers (for lookup fiels) instead of names
ListBox Removing Filter
Help with a query... hard to explain
SQL Query, on-the-fly
Yet another append key violation error....
Query w/selection
Need help splitting string in query
Problem with Query Criteria
Working with large data sets.
Union All
Problem finding duplicate records
Importing alphanumeric data into text field
database query using Dynamic Date period
query oh query
Sum(IIf(????Problems
Functions Error
Calculating Totals
Get String function
repeating a query on query returned data?
Find records with a line break using a query
query results minus query results = new query?
Sort by a calculated date in a query
Use Max() ?
Finding dulicate entries
Finding dulicate entries
Checkbox in query
CDate function in query
On Report Print, Run Query
Summing mutiple items in a query
Record numbers, not data, being shown in Query
Combine Multiple properties lists
Query input question
help in query with timestamp
max/last query problem
Use query generated field as criteria for another query?
convert timestamp to time
Data Type mismatch in criteria expression
Query via Excel
Combo Box to Return Records In 2nd Combo Box!
Sum by month query
Not even sure how to title this one! :)
Combo Criteria if not null or is null
Aggregate Function Error
Query with sub form calculation
Flexi Time Query, Can't get the last Calc to work
update query complications
Faulty Query Logic?
Between Dates Parameter Query - Extra Records Generated??
Number of days
Query 1:n problem with Access and attached field
How To Find Pre-Existing Queries
Combo Box Query Problems
numerical sort
No Greater Than
Copying Data without the header row
Access newbie needs help! with charts and data order
Data not transferring
show message box
Commenting SQL Code In-Line
Help counting records
Date range using IIf help
Error (-1524) in Access 2007
little bit complicated
Comparing start and end dates
Working Out Total Time Spent (In A Query)
average number of sausages over time period
Merging 70 individual dbs into one - without creating 70 queries!!!!
Query based on String value in list
Update and append new data
JOIN DB2 table with Access (or other) table
need to add several different fields.
Critiering for two fields
iif is null
Multi-criteria queries?
Row Numbers In Join Query
Query problems
Multi-table query question
New Table creation using SQL
Convert Month Name to Number
help with search form
Datediff() help
DELETE from table
Division by 0
Ranking
Creating reports using combobox user input
Display text from one memo field and multiple records in a report
Date Query - Subtracting Months
Combine Queries
Mix up few tables data ?
Multi-table, multi-criteria: avoid repeating records
Can Count return a zero?
Update query-multiple fields,1 with data, 1 without
Dealing with #error in query
Error 3163: The field is too small to accept the amount of data you're tryng to add
development plan db
Attendance-Query