Queries [Archive] - Page 94 - Access World Forums

Pull Specific Date Between Range from One of Several Fields
Query results based on current month to 3 months out
Simple Year to Date question
Linked Table Query Help
Find the Month from Week Number and Day of week
DATA Type ERR0R
Grabbing more than one related value
Create A Query That Uses Multiple Criteria
Help with multiple criteria query
Sorting of Date and Time in Query
Crosstab Query Help, I think...
Inster or update in one query
Simple Query Question
First Dynamic Query
On Duplicate with two keys...
DateDiff with parameters
How do I query all the records showing in the datasheet view of split form
Access 2007 query not working
Multiplying grouped data
Need help with query to find duplicates
Security in Queries
Need select SQL syntax
Staffs monthly time sheet query calculation
crosstab query or VBA solution
Alphabetical order
Data into columns
SQL - WHERE syntax
Update with multiple records
Between Dates??
Another Date ?
Field merge in a query
DateAdd Minutes
Query Process Time?
Stock management problems
using pass-through query to update table
Update Query
Previous Month
How to report on inclusive dates
DB2 PAss Thru Querying
showing several queires results running from 1 command button
Query (Parameter? Criteria?)
Invalid procedure call
Need help about a query
How to combine the two?...
Prioritse a queries return value
List Box results to feed a query
Query command run order
Can you do an If Then expresion in query criteria"? If so How can I do what I need?
iif datediff is X then dateadd and range help
blank query results convert to 0
Set font name / size in Access Table?
How can I centre-align a field using VBA?
Change IF Statement
Replace null value with zero in MSAcces
Query and VB
Creating a Query from multiple tables (same key)
Cross Tab Query as a subform
Creating a query WHERE Date>1/1/[current year]
Username in query??
Building a search function in access
Need Query to display a Zero when no rows are present
Deleting rows with no records in a join table
Error when grouping with time
Query and report building?
UPDATE using CASE
Query brainteaser
parameter selection in crosstab query
count query
Calculation based on prior record
Help: Update query using ResetCounter() function
Update qry - keep the smallest number
Query Giving Unexpected Results
Delete query
sql query help
Grouping affiliated stores listed in EDI Flat File
Split data from column
A query that shows records from now until the end of the month...
Doesn't exist instead of Is Null??
UPDATE sub-query
Mutiple columns into one column
help with Criteria in query
Calculations with query or vba.
Help with SQL
help, i'm doing something wrong: multiple textboxes as query criteria
To build total/avg/max days per month
Simple Group By ?
Postcode Manipulation
reports
Sql Expression Field
Syntax Query
Unique Count
Create table based on criteria
Entries
Distinct Count
Append vs. No append
pass variables from form into a query
Date for pass thru query
Delete Duplicate Records
Putting multiple query results into one table.
Julian Date
DateDiff() to only show weekdays?
Ok, this is a strange one
Timing a Query
Return Yes Value if Text has a value
Numeric Error only sometimes
Using Fields as Multiple Search Values in a Query
Help me with a JOIN Query with null values
Join table query
Delete query not working
Update/Replace Query
In Backend or Frondend
error
How to add another query
NZ Function
Just one more stock levels thread
Specific FILTER
Error trying to execute SQL
Time and Date query
Please help me to solve this problem.
Sql Record Select with multiple fields
Query Help
separate table
Sum problem
UNION query error - number of columns do not match
converting dates with different formats to numbers
SQL problem
Filtering problem with listbox
Distinct of two fields (combination of both values)
Numeric Field Overflow
Criteria Question
"enter Parameter Value" form instead of custom form trouble
Combining daily counts into a monthly total
Access 2003, sql error 3144. Please help
Date Format
Copy excel paste Access
fFilter query based on one specific character in field
Update Query not Updating all records
Prompt for Date then inserting date into multiple fields
delete duplicates
UPDATE query using SQL WHERE, COUNT
Ordinal numbers
CDate function
DateSerial function
help w/ datediff function please...
only display one date record in a query
How to make a query that returns different criteria.
How to calculate the yes percent
Custom field in a query
Instability in access queries
ALTER TABLE statement
combining two existing queries
Parameter error for joined tables
Cleaning up old data (removing unwanted characters, etc.)
Creating new field in table with linked info
help with counting duplicate
Comparing queries
Trim data to a new column
Extracting Multiple Text Strings From Text Field
Error in Calculated Field
Slow query save...
Querying a string contained within a larger string
Help dealing with duplicate query results
Year to date/ End Date Form
Query "Show box"
Odd query - cant figure this out!
Select the specific data from database.
Query getting info from Field on Form
Calculating travel times between jobs
Data Results by Quarter
I need to switch values on a field; values 0 thru 5.
Extending a Query to find additional data
Calculate "Hours" from start time and finish time
Another Query Issue
Perform a BETWEEN 2 dates from a form query
delete query query
Date Range query
Query: How many times does a value exist?
Update query-If criteria true,value true else false in same query
How can I create an update querry
Parametre Querry Error Please Help
Query to filter for Customers
Query based on partial matches between fields
MS 2007 moving a query to a custom list
ranking in a query
Query problem
Query in Acess or SQL?
Stop Access 2003 validating subqueries
DateDiff Help
Query to count contacts but no duplicates?
List Box problem
help need it with self join query
DB2 Dates... Again
need more data boxes?
Query speed question
Problem using parameter and IIF in criteria
Query cannot display available recordset
Use same field multiple times in query
local variables in access sql query
Query only records that are missing entries
Split Comments In A Field
Simple Query Multiple Linked Tables
SELECT returns more than one row
How to display data on my query?
Code connect to database and query select data from database in Ms Access 2007
How do I take information from one drop down box to filter for another box?
Make table based on range
Play sound file in Ms Access 2007.
Merge Date
Query related to 2 tables,how to group
How to have query display in one cell the true values of many check boxes
Copying Query Initiates Parameter Prompt
Query Bound to Form
query help
Add text to records found
Display last column in which row contained data
Query outer joins from same table
Rowsource query syntax
Query Help
return top 3 fields for each row in another table
Help on a query
importing data
How to get Totals in Access Queries
Finding second to last value
Adding Minutes second and Tenths of seconds
Combining Columns into one long
General cross-tab ?
multiple selection query
Query error, too few parameters
Count based on query results?
Querie Help
parameter in crosstab
Is possible to use crosstab query as subquery?
Is selected does not work on a Query
Using AND in criteria of a query
Find MAX number within a row
Iif statement with OR in true,false
Counting P.K
Using Multiple List Boxes To Query The Database
Need help with complex query
Query dates before last week not working
DSUM Missing Operator Help
Subtracting dates in query
Parsing text and special characters before calculating?
Slooow query
Query Help - Puzzled - Possible CrossTab
SELECT Help FROM Access World Forums!
Query not returning all records
Compile Error - Please verify my code
Problem to import all from textfile
Query acting funny *