Queries [Archive] - Page 68 - Access World Forums

Help with Query for report
Using a calulated field for a call back date, any help on this would be appreciated.
date breakdown problem
Help with developing a calculated field
SQL Statement Quotation Marks
Counting month fields for the current year?
Running Sum in Query Problem
Multiple field query
Update query - getting rid of duplicates.
Qry on 2 tables using ~15 check boxes in each table
Using Table data in Criteria of Query
Duplicating records
Search Records
Magic query needed to isolate non-matches
Make-table resetting table field value?
count working days between 2 dates
Crosstab IIf function - Need query between dates
cross tab query?
Averaging in Queries
Transferring 4 queries to 4 tabs of the same spreadsheet
Can some1 help me?
Linked Tables - Cannot add new record
sql for insert into join tables
Text to Numberic help
Query Criteria
ODBC Error in query (client/server SQLServer)
Query pulling a column not existing in the table
Query to pull most recent account balance
Multiple Insert Into - Some Don't Work
Can I use a query to show only one of each repeated data
Using quey criteria from a combo box?
Criteria Question
Access 2003 Expression Operators
Records not displaying in query
Multiplying Currency times elapsed time
Null Columns
Appending Values From Form To Table
select for update
Another Access query to Excel
Finding position of second space
Column(1) in query
Time/Decimal convert
Adding a date parameter to a query
Round integer division .5 to 1
Bypass the no edit restrictionin "Total queries"
Results of past 7 days
Making A Search Form and sending values to a query
Access Query to Accept multiple check box parameters
Create Un-aggregated Records Table
Consolidating Fields
Editing information from a Query
Query returns WRONG FIELD!!!
Update Query problem/question
Update Query to change Display Value part of Hyperlink Field
Sum/Product in Query
Date Query
Calculated field based on the value of the next record
Please help me, New with access 2007.
Having trouble with OR operator in query
calculating the difference between 2 'Time' values
calculating the difference between 2 'Time' values
running balance / subtotal
Matching "Similar" records
Indentify a page index (tab)
Query By Form
Calculating time difference from the record above
Need Help About Query
Subtracting 12 hours from a date-time field
Two Fields Using OR In Both Not Giving Me Results
Entries with Date This Week
Double return into a Memo field
the query didn't execute ..... why?
Passing Form Value to Append Query
How do you do a sumif in Access, similar to excel?
Len, Char, instr Not sure what to use or how to use it
Append Query Question
Selecting only the best three
Multiple condition IIF
Formating Date field in query grid
Keyword Search Query
Sum Query
mean mode help required
return weekend results on Monday, yesterday's results otherwise
Values in certain columns
Create Query that removes any entries with more then 5 digits?
Is it possible to do Make Table Query from Union Query ?
Query / Relationship Issue
Crosstab Query with TEXT values?
Queries That Extract Repeated Item
Left Join
total excluding duplicate
IIF function as query criteria
Parameter Queries
Query formula
multiple table query
Query Customers that havent purchased in the last six months
Updating values when importing data
Help with a date range query problem
A tale of two tables
SELECT DISTINCT help...Please
Sample Records
Select Open a record from a query
Newbe Question - Single and all selection
identifying words spelt incorrectly with numbers instead of letters
Its me again - SUM Function
Using a Calculated field in another Query
How to compare time values?
new to db, cant figure query critera for between dates
Delete Query
Simple query
Using Last in Query
Query Expression Help
Can't figure out expr needed
Field criteria: Is Null; there are Null values in that field; no records are returned
Duplicate that flags Case Change
DLOOKUP help
Telephone field help
Problem with filtering in query table
Top n Query
subtracting info using data from another table
default access messages on query run
DLookUp Problem in Query
Making some specific records with different font style
Linking Queries (I think)
Time Calculation
First 12 digits from one field into another
How to use a date range
Filemaker Lookup equivalent
Beginner Update Query
Get the number out of a string
Query showing all the dates within a range
Max function
Join Properties to include all Records
Calculated Query with user "margin" input
simple up-date querry
up-date querry?
Using record number and total coount in a calculation
function args in a query
Date Range Expression Needed
Query error
Removing Duplicate
Crosstab Query sometimes loses fields
Adding a string to the end of a field
Values comparison query
Using text boxes in a Between Statment
Query for Chart
Check to see if 72 hours
Crosstab query and between
easy fix for >< issue
Access 2007 Query Help
Very slow update query
Update problem
dlookup
stock control update query
Audit Trail using Queries
Selecting every 4th record
query to merge two databases into one
how do i validate data that is already in the database
Rounding problem
MS Access SQL Query Question?
Amount of time between 2 dates
IIF statement not working
Query calculation incorrect
Queries wont work on the net?
update field automatic !!!!!!
IIf or an alternative function.
Join Question
How do I add an unbound control to a query
Capturing Updates in Tables - Part 2
Queried Reports
Repetitive Records
Nz() function does not work with Excel
Joining results from multiple queries.
Deleting all data from B_E database tables. (AC2003)
Crosstab help
COUNTING Yes Values in Checkbox in a Query
Median in a cross tab query
Problem with query criteria
Enter Parameter Value message - after sorting
"Advanced" querying in a listbox
Beginners question - Auto update fields based on fields in another table
Make Table query
Date calculation
Query Doubling Results
Changing a text value in an expr:
Filter Query by multiple fields, one value
Count and filter.
Check to see if a record exist
Query Multiplication Problem.
A simple query check
Delete two tables
Do I need a query or not?
Query Help
Queries - Where Used Query?
SQL help
Problem in Nested IIF
Please check my Insert Query (avoid inserting duplicates)
Crosstab values
Using Like operator to link tables
Max Columns/Fields in a Query
.ldb file write admission problem for our users
Baffled: Gosh! I hope someone will understand and be able to help me!
Append Query, multiple tables to multiple tables in another database
Counting dates and Null values in Charts
select not returning any value
Crosstab Query Contains <> Column
How to find result "Total" - Expressions?!
How to find Total Results - Expressions or Visual?
I am trying to run a pass-through query in access with a variable that a user enters
Selecting records with a prompt for date
concatenate not giving needed result
adding in query does not work
beginner access 2000 query question
Field Selection in SQL from form.
"If" statement on Qery?
Iif In Query
Join Twice???
dlookup two values
Null/empty field count
Count query as well as select query
New User, Need help with Count Query
Min Max Dates and Values
null/zero calculation
conditional query?
Noobie question about Dates and Between or >= And <=
If Not Null
Convert number to text in query
noob needs help
about period calculating
Ms Access Query troubles.. sum(case...)
Noob Insert/update/delete queries
Query advice
Searching for records between a certain date
Appending Tables - Attachments
Search Form Appearence
Grouping by Year then by Months
Find and Replace Query or Macro
excel if on query
excel if on query
Export Query Help
DLookup function
Adding value in table based on values in two other fields
Running total
Query for Calculating a Rating depending on Multiple Criteria
Query takes dashes out of SSN
Calculating Fiscal Years
export a field with varying space
Total Noobie Question here.
Really basic sql question
Edit Result of IIF Query Calculation