Microsoft Access Queries [Archive] - Page 69

Append query for One To Many Relationship
dlookup, mixed number and date
Is was in 97 but not 200 - am I missing something
Leading Asterisks
Interchange Column
OpenSchema
dateadd criteria result is blank
Need a very weird query
What's wrong with DateAdd
Queries
Cannot join on memo, OLE or Hyperlink Object
Joins on compound primary keys
Nested query
saving [enter a value] in update query
Finding matches in an array
Update Queries
Field query expression
Converting Integer Month/Year to Date
'Sanity Check' - combine macro, delete query and make table query
Appending Related Records
select between records
Create A SubQuery
Import text file and update table
Format
SELECT in the Join clause
SUMMING
Formatting a number in an expression
Access 97 Date Time
"Subtract" string Query
Coverting Minutes-Need a remainder function
parameter not working
return partial text string
Parameters work in queries, but only sometimes in the Report
update query/one-to-many relationship tables
Filtering values
Selecting Criteria in Queries
Prompt for mutilple values in a query
Parameter Query
Replace a number with a word in a query
parameter query question
Re: Updating a multiple selection field in a customer record
Stored procedures & pass through queries
Re: Worksheet Function NORMSINV required in MS Access.
How to sum multiple rows of data for a particular part # and work area combination?
SQL Query-1
worksheet function 'NORMSINV' in MS Access
SQL Query
Iif statements
Max Records
Joining two fields from one table to one field in another
Formatting the output of a crosstab query...
Matching records from different tables that contain dissimilarities
Matching records from different tables that contain dissimilarities
How to open records in a form using a query
Query with multiple Exists seems to Hang
Re: Update several records in a table...
Ask for advise
Repost: Membership renewal query
User Fields
Query to create field using first character of another field
Query to create field using first character of another field
column totals
Updating table data
update query/related tables
Update several records in a table using another table
compare/delete query
compare/delete query
Instr/Replace query
selection problem
selection problem
Error msg, "you do not have the necessary permissions..."
Append Querry
Finding Dates
Query
Append with user input
Cross tab query
Sorting: Text with embedded number
alignment
Lost data in memo field
Operation must use an updatable query? Access 2000
Adding values in row to get a total. How to do it??
Calculating School Year
Re: Rank Records within a Group
looking for one selection criteria in multiple fields
Query - Summing dates....
Total Amount to be shown on Report
Re: About =now() function
Self Join 3 X's
Rank Records within a Group
About =now() function
Double Joins
Compile error. in query expression
Mutiple Tables - Append
UPDATE Query Problem - Must be an updateable query
IsNull and IsNotNull
Comparison query year1 to year2 ??
Numeric Field Overflow error
Autofilter in a form using query
Query an external database...
How do I select ranges
Re: Calculating Differences in Rows
Get Money At Home Weekly
Finding missing records.
Parameter Query - Date IIF
multiple criteria in access queries
Re: Run Time Error
opening report by form!
opening report by form!
Calculation wrong
SQL Sum function
Group By Count Where Condition
Linking forms.
Help!
Storing a query in an existing database
a guide/reference to queries via VBA
Re: Suggestion about query
Year Criteria
Suggestion about query
Run in "Quiet" mode
query
Queries with linked criteria
query
Prob in qry please help
DateValue
calculations
Creating a table with a CrossTab Query
Query Criteria
How do users create queries in a secured database?
decimal datatype field not sorting correctly
Record too large
Writing a Query
Memo - Text fields
Crosstab column order
Data Entry in Query
Query not picking all data from tables
Query not picking all data from tables
Query not picking all data from tables
multiusers in queries
Help with IIf statement
Change Case
Help with Access chart export to powerpoint
columnHidden?
Delete Duplicate Records???
make key field
Query for a mailing list
select one record in update query
Time Calculations in Increments
query joints.
Sum of fields/records
Access 97 and subqueries
Check Boxes
Need help with building a formular
Adding Up
Confirm before update
Query database for specific month
recordset question
moving adjacent records to adjacent fields
moving adjacent records to adjacent fields
INSERT INTO and UNION?
Change Query's SQL
Data entry in a query
Exclusive access error message
Exclusive access error message
Eliminating spaces during data entry
Eliminating spaces during data entry
Calculating Differences in Rows
DateDiff function not calculating week days correctly.
Query with Parameter
running total
force query to show month with no data
Update SQL records from Access Table
Drop down menu
Drop down menu
Need the SQL of a Find Duplicates Query please!
Query
Show check box missing
Find the last record in a group?
Aggregate Domain Sum in Upend query
Calculating Cumulative Numbers
Dates (with no year stored) query puzzle
Data transformations
Syntax Problem
Reminder dates
Cascaded delete
query to return records which do not contain an item
Compare amounts form and subform
RE: How to let a query omit the search key sometimes
Query based on Date
Question on queries.
Question on queries.
Performance
acces
import statement for external sql file
How to let a query omit the search key sometimes
Repost: Someone should no how to do this!!
middle bar in form view mode
form/table correspondance problem
Coding file into 4ths
SQL STATEMENT
Running Balance
Re: date Sort
Update problem
Find the minimum value across many columns.
Complicated Query
How can I set a query to give me a count of items averaged?
Access Report based on Query
Queries/Tables open limit
Divide by Zero
Date & Month
Re: I say we should give him what's owed. - was Re: HG9L06
Deleting appended records
Need data from previous record
Zero instead of $0.00???
Mid
Custom Queries for multiple users
Update Part of String
Grouped by Query Access 2000
What is wrong with INSERT INTO IN?
subquery with value from a form
This problem really eludes me
parameter query
Cumulate sums
Getting #ERROR# in subform
Format Function
Query - find a record that is in one table but NOT in another table
How can 8 fields be too many in a query??
Zero values
Sorting Numbers...
Append Query with multiple criteria
Help please
"Refresh"? Query
query parameter
field format
parameters
Re: Creating a blank date field
I want to add several fields in my query
query with changing field name
Parameters
Is It Possible To Have a Default Value When Using [] For Input?
Top ten records
Count distinct with SQL
Criteria from a Listbox In Crosstab query
School Timetable Form
MS ACCESS
Identify the next wednesday
I need to count the digits of a number
Date range search
AutoNumber in a query
If statements
Using the iif function and or operator in an update query
Append Query to Table and Table details
Dates in criteria again
HELP~Query Not pulling all the data
Dates in query criteria
How can I create this report?
Showing $0.00 in Query
passing SQL statement to parameter query
Difference between 2 time fields.
lest joint
Report/Query based on hidden table/query
Is there a way to exclude part of a query?
Dialog box on parameter query
Using query results as criteria
Linking tables
Ranking among only certain records
Use of Nz functions
Extracting a list of records with the latest date and time from a recordset
New to Access (help)
How to make views visible in Access?
CrossTab/Source Relation
query results appearance
Union queries
append query
Query totals for several items
How to open a password-protected Access database with DAO?
Percentage of records
query and Calculate field
All of next month
Display Times as HH:MM in a Crosstab
Combo Box Query: Listing a subset - Revisited
Parameter Query with 2 many prompts in Report
Blank Fields
possible to seperate entries in a field?
Update Query-Passing Max Value
Help with Duplicates Update Query
Increment To Next Order Number Automatically
Max
Need help with a counting query.
Calculate age
No VB runtime error when SQL statement fails
Calculate age
Too many fields defined in query
total clients for the year
Passing values into a query from a form.
prevent duplicate mailing labels
Calculating fields in queries
Price Range
Re: Queries
Is this possible??
why does it have two different results?
User defined Like Parameter
More info
Export to Excel
Membership renewal query
crosstab - sort columns on column value
Re: Like Operator problems
Re: Like Operator problems
View only query
Crosstab Havack
Re: Like Operator problems
Re: Like Operator problems
Like Operator problems
Set Def Value
Expense Report
Totals in queries
Dates in next week
Sum of hours during week
DELETE query
Query by Form
Posting SQL view
Parameter Query
Question on using the LIKE Condition
Crosstab Help
Newbie: Select records in Table A not in Table B
Simple Queries not sorting properly
Sum of a Sum Query
Parameter query with udefined numer of parameters
append records
How to change destination table in VBA
Count function
Multiple field query
update query using left function
Calculating Age
Unmatched Records in 2 Tables
query works differently called from report or ADO
IIF Statement help
Linked To A Read Only SQL View
Re: Query trouble
what happened to my query?
Assigning a value to a date
Precision settings within a query
opening a form when a query is run
Data Type Mismatch in criteria expression
Unchecked show box deletes field
IIF statement
Questions regarding deleting and indexing an access database online.
Custom Query from user response
Passing Query Parameters from form to another VBA subroutine
Appending records
Queries and Shared database
Trim Lead zero
Restructuring Tables
query criteria
Query help needed
Query help needed
I can't get numbers in a special format
Group by min query
Query with both AND OR criteria
How to create a table by code
Crosstab Column Order Problem
update/append query
Re: Anybody Found A Long Lasting Access Contract In Last Two Years?
Calculate Age then Count
Access 2000 Command Buttons
Automatic Field Selection in Query / Report?
Automatic Field Selection in Query / Report?
Queries--Last
dates in query...?
Date Criteria for Open and Closed records
Add data to specific fields within existing records in a table from another table.
Using Group by:Last in Query
RE: Top 100 by Category
multi-select list box
Case sensitive sorting
Update field based on qry results - not sure....
Date Stamp based on Checkmark
Query
trouble closing queries and forms in Design View
Re: Rank Formula
Dates - Week to regulare date
Help with Simple SQL Statement
Query Design
Update query w/subquery has me stumped :s
Append Query with Conversion
TopValues property
finding missing numbers in a sequence
Import Records from and external database
fiscal year query, fredg maybe you can help?
need expression using yearfrac
Compare 2 Fields and report on the accuracy
Compare 2 Fields and report on the accuracy
VBA dating
not enough space on temp disk
queries relationship to form data? 2 Q's
uer
Criteria Problem
Update Query using an imported table
splitting text fild
Like Query Help
Like Query Help
Find Duplcate values in 1 field for each customer
Make Table Query Question
Ingoring Case When Linking to Oracle Via ODBC
Weird: Union query turns number into character
how do I open multiple queries with one criteria from a dialog or form?
Rank formula
Re: Anybody Found A Long Lasting Access Contract In Last Two Years?
update query
Newbie HELP....Counting different responses in a field
import new data no duplicates
Checking for Missing and Extra data on Questionnaires
Make-New-Table
Query for 1st day of month after 60 days
Query date update by one month
Queries and Table Field with Multiple Entries
Undefined function 'left' in expression error
Date Selection Question
Averaging a field excluding zero's
Extract first 30% of records
Comments in Access SQL
limit on records-please help!
parameter query/report
Running Totals
Append Query
switch or chose function?
Table comparison
Could someone explain why?
Re: Anybody Found A Long Lasting Access Contract In Last Two Years?
Max Values Query
Access 2002 Query with No Results
Finding records that contain duplicate values
Querry with Check Box?
Duplicate records in Query/Report
Duplicate records in query/report
how do you change the current db
How to delete records from the original table while randomly selecting the records
Count date/time entries
Simple questions
Calculating Elapsed Minutes
Most Characters Matched query
Join Query Woes
Networkdays function equivalant
Anyone familiar with the RATE operator???
Filtering a Query using the Me.Filter function
IN function in query
Group By Query (Access 97)
SQL help needed!!!
Group by Query plus Static Value
Query Challenge
Apply constraint before left join
Password Pain
Win 2K hard Drive
Union Query
Make tab control transparent?
Format Date in Make Table Query
turn string into numeric using query
Data not showing up in query
Querying for value that shouldn't be in column?
Using IIF statements
searching in a memo field.
auto-populate multiple records in a subform
Earliest Date
Need a Specific Filter On a Combo Box Selection
Dates
Syntax of SQL in VB
Splitting Strings / Integers
How to change font size, in Access 2000 SQL View?
Dates
date data type in RunSQL method
How to make an query and select on wether a memo field is empty or not
Re: Anybody Found A Long Lasting Access Contract In Last Two Years?
Append query losing records when Access exited.
IIf statements
Parameters
Removing spaces from the left of an address
Re: Anybody Found A Long Lasting Access Contract In Last Two Years?
Window Data spreadsheets
year to date month to date
Lookup wizard help
Pedigree help
Lookup values in two table
Partial Parameters
Newbie append querie - Nightmare, please help!
Update query and filter by selection
Make $9000 Just For Sitting On Your Arse..I'll Show You How!
How to rename tables and fields using SQL?
Email Creation: Detect Duplicate & Update
Using Choose function in query
Grouping wages by hour
Query works perfectly on Query screen but Error on VBA ??
Separating a Mailing List
Median / reference to Excel in query?
Help please:-Passing parameters to a query from a module
Check boxes and union queries
count if no record, then return zero value
DON'T READ IF YOUR RICH ENOUGH!!
too few parameters
Multiple selections on list boxes as query criteria
matching on first 4 characters of a field
Field format in make table query
Problem with Query, Help!
the job of your dreams
Query Question
Using DCount() to Display Counts of Zero
highest an dlowest values
No results
Random Record Selection
validation rule error - append query
Librarian Seeks Help Getting Into Database Table
Expressions in a query
"Expression too Complex"
Help with a query
Most Current Date
Query Export To Excel Problem
Using a combo box or list box to select criteria for a query
ADD FIELDS TO TABLES USING QUERY??
join on data ranges
Append Query Assistance
DoCmd.TransferSpreadsheet help
Queries in the same table
Please help!! Top 3 Values by Group
User Maintained Query Criteria
Sorting and Date Order in Crosstab
CODING
"Like" Usage
Dropdown list no longer displays values
Null values
Query using a table as criteria
Remove Records from One Table That Are Unmatched
Calculate a moving average query
How to find the Range.
Like statement returning all values if blank
Cannot append to empty table
PLEASE HELP!!! NULL field ?
Return results in a date range
having a sum value as part of criteria?
importing and updating fields with duplicate records
Query to table
Comparing Calculated Fields and returning the Max Number
Inventory: last stock take qty
Append Query - 18 feilds to external database
Query - counting Yes in Yes/No field
help need for a query that looks a field date and tells if it is one year past
Using queries and mail merge in word
Layout issue in access reports
Re: Another Union Query Question
query that runs two variables
Updating "Bad" Records
Update conflicts on same record
Join or Union Query?
How query NOW() date field?
Spam
Select Query Syntax - Novice question
updating a group query
RE: Another Union Query Question
in a quandary over queries
Updating Databases
Parameter on Two Queries
Parameter Query
Serious Help
Return Top 3 Values for Each Group
Re: Query several fields in one table
Update problem
SubQuery
Parameter query for only the month on the date field.
simple Delete Query not working, (Error 3086)
Please help!
Calculating weekdays
Grouping in Queries
Problems with table fields
today - 1
need help with unmatch query
How do you cleanup dupe rcords in a query.
Time Properties
TRIM
Null and Dates
Localised version and decimal comma
Update an Access query using asp?
Unsorted Query
Select Query from within a Form
Saving query to file
I just want first Initial
RE: Trim
Query several fields in one table
Newbie needs very basic help with query design
Looking for faster group sums
Help with dates
DFirst
'Order by' calculated field (Access 2000)
Access 2000 Multitable query memo field garbage
Help with Simple Sort/Group Query
referencing a form field's value, in a crosstab query?
Column addition in query
Trim Statements
Criteria for qry to show all records for a certain month
Make Table Query - inserting blank column
Query returns zero results, want to launch MsgBox macro, now?
need another alternative for query
reverse concatenate
Removing Duplicates
Re: Outer Joins
Change Text displayed in query result
A Query to update a Table
win32access dined!
Parameter Queries
Interpolation Query...
Running a query on a table based on a form.
Multiple Criteria Query
Oracle's equivalent TRANSLATE command
autonumber/dmax??
How can I set a query base a form on it with sub form view?
Run-time error 3033: You don't have permissions to use the MSysTables object.
Date Query
IIF statement in Union query
design view option under total
Need help adding fields in a query
What is wrong with this syntax?
query criteria
Outer Joins
Splitting Fields
Splitting Text Fields
I think Group By is causing me problems...
Convert Null to Zero
Let me try to explain this again
Query output to text file
Qurey producing empty Excel Export file
get Max larger than zero
Having a problem with a field - please help
Week number function
Query Criteria
Tab Control
need help with if then
Searching all queries for a field name
splitting text fields
Query a Large Database - Form & Sub form
Len function on memo field fails when constrained by Where clause
Update Query -Acting on only changed records
replacement for subquery in join query
Need help with writing a query
Subquery in Access?? Is that possible?
Primary Key
Re: Autonumber in Query
Sum in query
SQL Question
Criteria help
Make a Text file
Cannot add records in query
DLookup hideously slow when used as query criteria
How Can Access Identify & Count Duplicate Entries?
Make Table Query in Access97
checkboxes and update queries
Calculation in a query
Append data using two seperate tables
One Charge, None/One/Many Payments
Median function?
Sorting
a make table union query with a group by, possible??
One graph from two queries?
Challenging Query
Access update query error
Choose function
Correlations function in an Access query
Make Table Query From Pass Through Query Summing Incorrectly
Make Table Query From Pass Through Query Summing Incorrectly
Substring
numbering each reccord in a query?
Calculate a rolling total return in a query.
requery?
Can you autonumber in a query based on sorting order?
APPEND Query - can't get it
losing DSN when moving query from test to production
query displays wrong month name
append query sending primary key error
Date() function returns error
Moving and Deleting Records
Outlook Express
Outlook Express
Outlook Express
Asterix character in string
Move Queries from one DB to another
PLEASE HELP!!! Select records query
update table based on criteria
Slope
Looking up by dates in a range
Like and Wildcards
limit for data exceeded message
Storing a Recordset in a new query
prompts in queries
Requery Lookup based on Datasheet Subform
=> Date Range not working properly
Parameter Queries
parametr qry purely in code
Date query
Query of multiple table lines to one line averaged
action queries
Preventing duplication of records
Adding dummy lines
Query Calculation gives wrong answer
Updating when not supposed to
How would I make a Union Query out of these two simple tables?
Query to calculate quarterly rolling value
Quering date field with two text boxes
Return value based on dates
qurey and printing
Update query won't work
Simple Query
Report on nonconsistent date ranges
Query from multiples table results in multiple records
how to combine two queries?
Dynamic Query from Cascading Combo Boxes
Entering Multiple Criteria in an Access Report
Dcount
Locating MAX records off a query
REmove Text from field using the Make Table Query
Total of all TRUE fields in query
How to calculate a field on a non-existent index
How to query text that start with a "*"
where query is used in database?
Output of Queries
allow the user to customize the logic?
How do I use a Wildcard with a field reference
sorting by categories
Multple Queries
Wild characters in parameter query
Where clause doesn't work
Make table queries and primary keys
default value in column
Query three values into one field for easy search
sql command syntax
Help with MIN function
Can anyone debug my attempt at a DCount
use SQL in Access with date range selection
message box with wrong parameter
Multi-Table Query/Data Access Page--can't edit data
how access listbox recordset for another query??
How do you sort date and time fields properly and permanently?
Problem using updated fields in update expressions
Sum of Yes/No data format in query
Query too complex
Is this possible?
Separating a Name field into First and Last
Word Match Query
Why can't I update two fields at once?
Controlling field names in a Make Table query
Programatically Create/Save a Query...
Unique query
User function in a query?
Trouble with date and time in same field in a query...!
Filtering a Query
show only max date