Queries [Archive] - Page 33 - Access World Forums

between two dates or for one date
Compare multiple tables with unlike fields
Union query to remove duplicates
Combining two Queries
A simple date query
requery subform onclick
Merging Query Results
Query Help (WHERE Statement?)
Using BETWEEN with Dates
Using SQL to delete all records from a specific row
Average Query
Sorting numbers from a combo
Updating New Data From One Table to Duplicate Records in Another
# of Days bewteen two dates
autonumber field?
Counting # of Records
Unmatch Query Question
query with dlookup
Faulty filtering
Dcount
Counting
Trouble with Dates
Merge Records in Query
Criteria syntax in parameter query
Selective query
Property Record Query
Finding combinations of records
Format Calculation
Week Query
# of months and years between 2 dates
Rank / Position query
Total Number in Time
What is wrong with it????
Cross-tab query dilemma..
Querying more than 1 field in a table?
Date expire alert
User Select fields for query
Update Query or Multiselect function??
Current: Day, Month, Year,
insert query peoblem
Simple Select: 2 tables - Inner Join
Creating List from Select Queries
Avoiding Empty Records
Help with basic queries - PLZ HELP
Update Query - Simple
Two date ranges, one query?
Left Join Query Problem
Insert fields into a Union query
Finding Difference between values of same field
How to pick the largest ID#?
Can I put msgbox statement in the query?
Birthday query
retrieving new value after insert
Max record for a group of recs
1st Activity Query - Not what I expected - Help?
Expression
Update Query - Adding a count field
Pass parameter to query, query is Record Source
Crosstab query - date problem
Microsoft JET Database Engine error
a new amount due per month
compare 2 fields from 2 tables
Difference between time in and time out... but
Stuck on an append query
RecordSet Not Updatable?
Queries saving on close even if I don't want to
how do I do this?
Can't edit query data with more than one table source
Adding a zero to a field
Pass query to MySQL
exclude records from a find duplicates query
Query data to Form ?
Passing a value from a table to a criteia
combining name fields
Column prefix-no match in query error
Query syntax question
Maintaining formats in a query
Parameter Query help needed
Use same query for different forms at the same time?
Adding 1 to a text record
Joining Two Tables
Single Field into Multiple Fields
SELECT dates BETWEEN problem??
ID query
date query
Search for value between form parameters
how to query for items inactive for 3 months in a row?
How to export query results to dbase III
How can i display all culumn names of a table by a query?
SQL in a Control Source Property
query by month (how to input text or integer?)
Date Query Question
Help with Query
how to use the "*" function in a query
Cannot Add Record to Form?
Eliminating specific people in a database
Or in Where SQL is not working.
Adding query records
Sorting Problem in a query!
Query to run automatically at midnight
Create Record in a Linked table
Parameter Query
dynamic table referencing
Crosstab column issues
Crosstab / left join combo
A Query with a "Contains" Expression - What Do I Use?
Extracting data for pivot table
How would i go by creating this query?
Pay Scale Increase
Query in SQL view. How to save the formatting/layout?
Stopping temporary query from displaying
Looping through values in a table
VBA query (EXPERT help needed!!)
creating x number of new records (partially duplicated) based on a query
compare and update
Wildcard Search??
Specifying lookup column to use in a query
Add current date with update query
Selecting Bottom Records?
logins by time of day
FINDING DUPLICATES(from user input)
How can I use * in query
Excluding records with no data for specific fields
Excel cell data
formatting an expression
Combining data on a single table
Union Statement Help
simple problem, i think
simple problem, i think
SQL Union query to average results
getting query value from a form, how?
Problem Exporting data as fixed width
Month number to Month name
This must be so easy, number ranges
Top 20 query
Parameterize Comparison Operators?
compare the amount diff in records
help please
Problem with update query
Query help
Perform an "AND" search in a query?
How can I do a combination of 2 fields?
Dumbass needs help again
Update query
update table according to employee id
Validation Rule with Query
Beginner's query question
how to select....i get the wrong results
It works one way but not the other – that’s Trim queries for you!
Error: Not enough Space on Temporary Disk
Select after Union?
Generating index in a select
Return first occurrance of a query
access query
count unique records for report
Query by choosing from a List Box?
I thought SUM() only had 1 output?
Can anybody help ??
Search IP range query by IP address, URGENT!!!
Counting records
how to replace parts of the date with a variable
need subquery help
Some SQL query issues.
Update from one table to another
Union Statement Question?
Field Length Qry (finding records with X amout of characters or more)
Find all records where provided date is 1 year ago
Sorting based on a date range
Finding Invalid Phone Numbers Query?
Some more assistance please..
Append Query Key Violation
Why can't I update a query in one-to-one relationship
Current Date
More date stuff!
date problem more than one days worth of data
Outer join help please!
Need to create an error message!
Find data not found in another table
Query to look up tables
Counting records in query
Easy query question ( I think!)
Manipulating data by selecting parts of record & Manipulating Fields
Calculate first response in business hours.
Random Generator
Data Validation for Parameter Query...
Query dumps memo text
MS Access merge records help
How to calculate Balance brought forward in a form and store in a table?
total of totals in a query
Check timing for previous record
Emailing a Form?
Chellenging Schedule Pre-empting Query...impossible?
How do I query or filter for the ampersand (&) in a text field?
Problem running a query
Inserting Records?
Newbie to querries, grouping results
Query not picking up NULLS
Using Wildcard in IIf Statement
Simple Tote program
IIF statement in query criteria.
Confusing query - Criteria to only display current bookinds.
Query Help
Need help in making a query to sort out information
I need help with an update query (I think…)
Simple Query Lookup?
Determining if a value is only 1 character long?
Adding number fields together in a pass-through query?
please help -- inserting with autonumber key
use formfield value in a query
Query to Create Data Access Page
Memo fields being truncated
Total of 2 fields in a query
Derived colomns, how do you do them?
IIf Statement
Expression Builder question...
Linguistic query
How to tie together multiple delete queries with the same selection criteria
Help - Not sure how to state the problem
Query with date into future
random rows from a query
japanese string comparison
If result of query is nill
QueryDef Parameters problem
Query Design Problem
query to associate data
Handling dates in sql and Access
How to link 2 queries
Combining Queries?
Result format
update query problem
Reducing one record with the content of another record of the same table
Split, Trim, Separate Names
Sum (Sub-Total) QRY Help
Summing Totals?
Is a day in a period
queries and command buttons
Query question
Totals Query Question...
Employee Data
1 field into 2 fields
undefined function '[function]' in expression
Previous & Current Record
Adding value of two fields in two tables
Grouping items together to maintain one total on a query
Help with Access Query
Does this look okay
query SQL dropping spaces around hyphen in field name
queryDefs Coding problem
Parameter Query in FrontPage
Overall count from two text fields