Microsoft Access Queries [Archive] - Page 59

What's the best way to.... (Access Novice)
Calendar Query Changes Problem!!!!
Compacting an Access 97 Database with VB6
Insert into problem
How do you double indent?
Need help comparing two tables
Max Date
Update table from Result of Query
Complex date query
How to determine which queries use a specific table
Numeric Overflow message
Re: any idea? any help would be greatly appreciated
Problem combining SELECT queries
where do i find windows 98 wordpad download
selecting records based on the position in the database
MAX. columns in a query
Problem Deleting
DISTINCTROW
Append Query and function
count months
Error 3709
De-Increment Month Value by 1
query in 1-many relationship
Can a table be used to search for strings in a text field in a que
problem with multiple criteria select query...?
What kind of SQL statement can do this job?
how to structure many queries
Linking two Tables and avoiding having to create an interim Query
Access Query to ODBC
OT: Origin of sudden spate of irrelevent posts?!?
Query
separate the Text from the first two Characters of the post codes
SQL database record locks
Retrieving records in order
clarify display / show query
calendar Reports
Automatically Delete Duplicated Data in Table
How do I set up the dolookup command in access?
customized message
Kilometres Query
Making Queries Faster
Consolidate records in ACCESS
Compare Fields
Retrieve records for the day before
Advanced Math
COMPARE FIELDS
Query management question
Using wildcards in a popup
Undefined function Trim in Expression
Store Criteria Input for Future Use
Query part of string
Addition in a Access 97 query
Collecting the results of many queries
Query Criteria = TODAY
how do i fill down data in access?
Order within Group - possible?
Query about log in and log out of users
query not working-urgent
I've been asked to do something insane
Zero Fill a Field and remove decimal
2 Left Join Queries into 1
Show records for the past 30 days
Datasheet to Update constrained SQL tables
Update HELP
query expression compile error
query expression compile error
query expression compile error
Printing table field names and datatypes
Repeat Records - Please Help?
Last Date
Repeat Records - Nothing Works!!!
Number of rooms
Week not sorted correctly
query results
Managing duplicates when INSERTing.
combining queries
Group by Week
Creating Reports Based Upon Criteria Selection at Runtime
FINDING DUPLICATES
Repeat Records
lookup table for date
Day, month, and current year
IIf statements
Problems with data types
display when true
display features if true value
Select non numeric records
Convert to date
Combine 2 fields into 1 via SQL query
VBA Date Function
setting the record source of a report in the Report_Open function
How do I reinstall Internet Explorer?
Updating a Specific Value in a Table of Values
lost microsoft office
performance: query vs. class module
could you do me a favor to add find phone number in your al softw.
How to list only records that DO NOT match the criteria?
Decimal value in SQL statemen gives error when Regional settings are set to Dutch
Compare value from text field and table field
Max ( ) - use to return latest date - or is there another way?
Multiple Values in Crosstab Query
dddd
data.ms1
how to use Active X calendar in a form
Storing the query result using VBA
Why don't MS Access 2003 string functions work?
Criteria
calculation field in a query and lookup tables?
changing values in a query
is there a query to update a table cell, not add rows
Query Expression to Generate Report
event clash
Week of year
subtotalling query data
Form ref in criteria
auto numbering in query
incremental ID number in a query
Problem showing #s on a form
2-part query
page down
Query Help find match and delete.
a simple query with date
How do I set up Date query in a crosstab query?
Filtering by a calculated field/control
adding null values
Return value of prev record if null in query
Equivalent for EoDate(x,y)
Append Query stops
Update date based on another table's dates
mail merge problems
track rent
Union query duplicates
Access Make Table Query
Number of results
One year from a given date
concatenating EMail addresses
'Un-Crosstab'
Query on 3 tables
microsoft ecces support with using a PDA ?
Option Group Checkboxes - Inbedded
Simple Access 2000 query in VBA doesn't work
Case Sensitive Cross Tab Query
access queries
combining contents of one field
Dates in seperate columns but return latest date
running parameter qry from form...
Running Param Qry from Form; not filtering...
Append querr that only append new record
Query won't work off of identical databases
Appen Query with new records only
Simple count query not so simple...
combining field contents to one field via a query
Updating field for numeric bins
update field based on the contents of three additional fields
working with normalized data set
Bruce
charts using a query
Null criteria in a Query does not work
find last modified record
DateDiff and Access VersionDB
Re: Need to return last record entered by multiple users to mult. reco
Parameters in calculation
Re: repost - 'Undefined function' and 'Too complex' errors
Q: Is there a "this expression" option in a query?
weird query
Simple Comparison Query
Mail Merging a Random Select Query
Excluding certain records from a query
queries to add OLE objects
Comparing two tables in a query
Problem limiting records based on unrelated field
Extracting and Parsing
dates!!!
Grouping a Count of Unique Records - Going Round in Circles :(
Calculating a value between a form and a subform
MakeTable Query -- Field Must be "Double" vs. "Decimal"
Criteria using DateDiff function in SELECT Query.
Help Import / export txt file in VB
Criteria for Append Query?
troubleshoot mail merge using Access query
Criteria in a query
CrossTab query
Query gives wrong Answer - Repost with requested SQL Code
Updating table in datasheet view..2 table query!
Date of Edit
Re: Append Queries
how can i convert a julian date into a date recognised by Access
open form from returned query row
Datasheet Form
using the results of a SQL SELECT(COUNT) statement in VBA
query related to itself
Zero values in query
Sum List
How do I use page view of a query.
grant security access in a macro
sort records by size of items in memo field, or pull those > 255 s
Append Queries
Re: Using Current date information
delete query
sort records by size of items in memo field, or pull those > 255 s
automated entry of parameters?
Re: Using Current date information
Query Filter Sort
Re: Need to return last record entered by multiple users to mult.reco
Re: Query to Count in to columns
Re: COUNT multiple fields
Using Current date information
Need to return last record entered by multiple users to mult. reco
using criteria in field that has a look up table
repost - 'Undefined function' and 'Too complex' errors
Query to Count in to columns
Rounding and calculations
Formatting date query Column by week.
Query gives wrong output
query related to itself
Re: Blank Space to Zero
Blank Space to Zero
Query string to number
Re: IIF Function Question
Append Unique Records only!
Cannot see hidden column in query
parameter query not returning correct results
RE: IIF Function Question
COUNT multiple fields
IIF Function Question
Help!!! sum query
How do I retrieve the median value of a field?
RE: USING AN UNBOUND, MULTISELECT LISTBOX, HOW DO I RETRIVE THE SE
Query over several tables
Calculating Proportions of values within a field or grouped
Sorting complex iif statement queries
Problem with decimals in a combobox in an ACCESS 2002-XP form
Date Range
Total query which concatenates text values
using wild card with criteria
Calculated Query Fields Using DateDif Function
Rounding numbers
In operator question
Re: bypassing some of the parameters in a parameter query
RE: bypassing some of the parameters in a parameter query
Re: How can I open an Excel spreadsheet I got in an email?
RE: USING AN UNBOUND, MULTISELECT LISTBOX, HOW DO I RETRIVE THE SELEC.
Count Unique Records - from a Newbie (Repost)
Re: bypassing some of the parameters in a parameter query
Design Grid not visible
Extracting Part of a Text field in Query
Another Seqence Number Question - But With A Twist
Re: Summing the Top Five problem
Summing the Top Five problem
Croossab Query
Count Unique Records - from a Newbie
Re: USING AN UNBOUND, MULTISELECT LISTBOX, HOW DO I RETRIVE THE SELEC.
RE: bypassing some of the parameters in a parameter query
How can I convert the date/time format in a SQL query on Access insidea ASP script ?
USING AN UNBOUND, MULTISELECT LISTBOX, HOW DO I RETRIVE THE SELEC.
COMBO BOX CHANGE
how to get unique resultset
Go to new record if no results
Number of days in a given month
Order.
Error: Function is not available
Date Format
MS ACCESS
Rounding numbers
MS ACCESS
Re: Check constraints spanning multiple tables
Select query for zero amts
help needed with union query
Sorting Dates in Queries
PivotTableExportToExcel
Using MakeTable and UpDate Queries
loop verifycation...
split table by range on records
Only want update a part of records?
RE: variables in queries
Confirm Action Query
Re: How do I do a case-sensitive query in Access 2003?
table design
Re: How do I do a case-sensitive query in Access 2003?
Check constraints spanning multiple tables
crosstab questions
Re: Need help with dates
Re: Default Value in Parameter Query?
How do I do a case-sensitive query in Access 2003?
variables in queries
Default Value in Parameter Query?
Re: bypassing some of the parameters in a parameter query
how to select only max date
bypassing some of the parameters in a parameter query
Prompt to save query
putting order
replace or substitute
replace or substitute
select query
saved queries based on other saved queries vs. one big query in a form's module using DAO
Add Three CrossTab Queries
Access Project column refresh
Opening Query closes Access
Custom sort
Last Year/Next Year Calculation
Re: Run Query from Windows Task Scheduler
Combine data
Run Query from Windows Task Scheduler
Re: Query problem, trying to make a query run faster? (not as it sound
Query problem, trying to make a query run faster? (not as it sound
Simple Query Question
Upper Case
Re: Query/Dap/html
Creating a Table from a Crosstab Query
Searching records that contain a "#" sign
date queries
Re: Need help with dates
Re: report rounding problem in sum
Re: Bypassing Parameters in a Query?
DH - Query By Form
report rounding problem in sum
Need help with dates
Bypassing Parameters in a Query?
Running Sum in Query
bizarre querie
a query on fields that are in another table that is linked to the main
Re: Access: If FieldA = n then FieldB else FieldC
Access: If FieldA = n then FieldB else FieldC
Field Properties: Decimal Places - DOES NOT WORK!!!
Qeury properties
problem with criteria in query
Last Date
Invalid Query Name
access chart data table number format
Run Udate or Make Table Without prompt
Writing expression which selects last names from field of full nam
Aggregate parts list query
iif in a VBA query
Advanced JOIN query
access query
How to group crosstab query date header weekly? Expr1: Format([.
sum total between two dates
The decimal field's precision is too small--when making query by access
n*Wxt>l5rN Learn how to make $4,000 a month! n*Wxt>l5rN
SQL and Date maniplutation
Change the result format of a true/false column
Re: VB Code help for combo boxes
weekday function help
Grouping data in Access
syntax problem
return true in sql statement
Writing a script
Re: Can't save query!
Re: How do I view multiple "Yes/No" fields in a query?
Help Create query for over due calibration?
Making it More Specific
week by week information
converting text into numbers
How do I view multiple "Yes/No" fields in a query?
counting fields for more than 1 criteria
Crosstab??
ACCESS 2000 PARAMETER QUERY
setting query criteria in an IIf statement
Need to a "x" records for "x" qty shipped
Make table query field needs to be rounded
Two Questions
Re: inserting a NULL value into a Date/Time field
Expression Results in Truncated Fraction
Delete Query
inserting a NULL value into a Date/Time field
Re: Years- Anniversary
Date Match
Sort Expression (ASC Order)
Years- Anniversary
Date Calculations
Referencing a single field in an ADO recordset
Can't save query!
Setting Record Numbers in a query
Union query
Unique Values vs Unique Records
Query/Dap/html
Variable "mid" Criteria
Field Names defined by query using data
List box on Form - Want to use selection in Criteria of query??
VB Code help for combo boxes
Add data to an existing record
Query in VBA
Matching many records
Union query not working properly if no records exist
Setting combo boxes in a form to null
Referencing forms in the Criteria box of a query on .adp
Union Query Problems
express
Convert Access Query to SQL2000 Query
How to convert access query IIf([Time_Enroute] Is Not Null,IIf([P.
How to convet IIf in access query to sQL query
Dividing in access...
Aggregate query
Refering to Linked Databases
date query
how to change the value in a querry column automatically.
Blank text fields,
Re: mdb file took up all disk space
Re: Compare a table and a query to retrieve a NOT IN recordset.
Re: select only 1 of each different number....
Calculate the time interval
select only 1 of each different number....
Can not find SQL table
query returns results from previous query
Querying Todays Date from a text field
Updating a table
Query Auto Refreshing????
Compare a table and a query to retrieve a NOT IN recordset.
Help with an Inner Join?
Re: tricky sql statement error from ado querry
Re: Updateing property of a label
Difference queries
How do I retrieve the median value of a field?
Function is not available
query Join or criteria
Re: Updateing property of a label
Updateing property of a label
create multiple records
Query help please...
mdb file took up all disk space
tricky sql statement error from ado querry
Why Can't I contact you about a regestration glitch with office 2.
query syntax
Error: Not enough space on temporary disk
Why Can't I contact you about a regestration glitch with office 2.
IIf statement in Make-Table Query
Newbie...Date Criteria
Table Function in Query
create multiple records
Or statement returns both values if both are true
Re: Update? query
Need expert help producing totals from a cross tab query
Which is the best way to do this?
Count Consecutive Months - Repost
Undefined function 'xxxx' in expression
I need to divide a word
Re: Reducing nearly many nearly identical queries to one.
Re: Reducing nearly many nearly identical queries to one.
Storing Quantity on Hand
top (latest) record for each group
Re: Getting an error when using an iif on emty timedate fields
Re: replace or substitute
Sequence Number
how big is the pie? what percent of the whole are the slices?
Re: replace or substitute
Re: I need a criteria expression to if from the 26th day of last mont.
Re: Where do I write the expression to calculate serial numbers of we.
Re: Where do I write the expression to calculate serial numbers of we.
Expression too complex - More than 28 parameters
How best to manage links to tables in local Access databases?
Duplicate records in query
Subtotal Row in Query
Number of week
Re: I need a criteria expression to if from the 26th day of last mont.
Matching a query to a query
Re: Can I combine 2 crosstab queries in one report?
DateDiff function to calculate age
Re: Is it possible to combine 2 crosstab queries?
Start up and task bar missing
qd.execute
SQL IIf? union? subqery? query question
Combining expressions
How do I handle errors in value function
Error message (MSN) Server not found
Duplicates
How can I combine data in two separate fields in a table?
Joining 2 Left Join Queries
Count Consecutive Months
Calculate Business Days Only
Number of Records pulled by Query don't match number of records in table
Isolating on a string of characters
Combine multiple records
Re: How can I create a case-sensitive query in Access?
Cross Tab Query
Getting rid of Security Warnings in Access 2003
Converting a Query to a Table
Date query
joining multiple queries
Does anyone know how to round down in access?
A2K Strange Characters in Distinct Query/Form Reference/combo box
date query
Changing Query Layouts
Microsoft XL Spreadsheet
Re: Validation rule problem:
Culling unique records out in a query
COUNTING
subtract two queries
Re: MILES ARE NOT SHOWING
Re: AMOUNTS KEEP CHANGING
Query ResultSet Date
Build a query
Exclude record if meet criteria
Re: Delete Query Help
Re: Datatype Conversion
Re: Update query different values?
Re: Delete Query Help
Re: Removing characters from the beginning of a field
Count characters in a field
query
Date Calculation (next/previous year)
How do i get an aggregate product?
DateAdd and DatePart
Finding Duplicate Values on the Same Record
trunc
Removing quotation marks
General Guidance
Query duplicate values
Join Queries - can you join two tables with similar records, not an exact match?
Re: Removing characters from the beginning of a field
Re: create a query
Re: create a query
Query help
counting functions
business days vs. days
Re: How can I list multiple results (same field) in one field in Acces
Numbering results in a query
Re: Date Function Not Available
type mismatch
Re: If-then-else statement with multpiple arguments
Re: If-then-else statement with multpiple arguments
Re: CurrentUser() does not work in query (Access 2003)
Resolving query parameters
can't delete a query
Re: Data Definition Query Formatting
Update field to uppercase
IIf Question
Imported Excel Tables Cause Error
Please help!!!!
"Query" run on moment next-form button is clicked ???
Append query
SELECT TOP 1000 not working - returns 1173 results with ORDER BY
RE: Alias for field name
Fw:Re: Re: Validation rule problem
Duplicate values in query
Query to contain function to set input mask at run time
How do I format Date in Access so that it shows only Month and ye.
Joins on number (double, fixed, 2) fields produce inconstant results
Query: Advanced Help Needed to "repeat" rows / split months
Re: COUNTING
TOP & "BOTTOM"
An Unbound Textbox Date In A Query
combine two queries to external database
Re: SetFocus on Activate
Re: Unmatched Query not working right?
How to print mailing labels from an Access DB? .
union query overflow
DATA TYPE MISMATCH
Update table from Totals query
Make Table Question
Maximum Sales
Re: Removing excess characters
"NOT" criteria
KB #214183 updated for Word 2002?
How do I create a database that checks out files?
Calculate MEDIAN in queries
Re: Parameter Query
Re: AR ageing 120
Pulling Select Random Records in Access Query
Re: Count the occurences
Ties in access query
date/time dilemma
Totals query as a sub query
Re: round to mearest 5%
Re: Formatting within CDate function
Re: Date Function Not Available
Re: append multiple tables
Re: COUNTING RECORDS
Count?
Re: RECORD COUNT
Re: Excel data directly to queries
2 problems
Re: Reverse-Link a Query To Excel
Query "Expression Problem"
Re: Search Query with Criteria
Re: Ranking
combining two tables
deleting records
Validation rule problem
Re: Automatically add "1" to the last fieldvalue of a table
Re: odd happenings
Re: Group Update query
Calendar Query
TRIM not working with SQL Server?
how to write this in 1 select statement
Named criteria?
Recrodcount on linked tables
How to use make-table parameter value appear in report
Space in field name
Re: How to get rank numbers for Top results
Re: row which has TOTALS of coulmns?
RE: row which has TOTALS of coulmns?
Union Query, forcing order of rows
Re: slow merge Access query into Word
Converting Currency Field to Number
Re: How to get rank numbers for Top results
Decimical - between two dates, YYYY
Re: updatable query. (Error 3073)
Re: SQL Right Join Question
Re: Form data to query
Re: Excel data directly to queries
Re: Remove duplicate records in query based on 2 tables.
Address subform in a query
Where can i find pictures on Singapore history?
Can't change captions in a totals query.
RE: parameter query in SQL Server
Re: Recordset not updatable
Re: Bogus Currency Formatting?
Report created from Query based on 2 Tables - Invoice and Cases
Creating Report Based on 2 Tables (Cases [parent] and Invoice)
Database Could Not Lock Table b/c It Is Already In Use
Convert boolean constant to a number
shuffling a list or random mixing
IIF's Text is Too Long in Query -- Need help w/ creating a module
Re: Excluding the Year
Re: Update query
returned value
Query matches first record
Re: Syntax Error using Filter-by-Form
Re: odd happenings
How do I use the " not like"
Can I download the 'Word' software from the internet?
Query Should run but Data Type Mismatch error
What is a 'place holder'?
Filling out one parameter, selecting multiple queries
Counting time series records
Top 10 rows
127 length limit on text variables
TEMORARILY UNAVAILABLE....MEANS WHAT????
Resume Database - HELP PLEASE!!!!
Re: Need a bit of help
Re: Out of the Office Assistant
Count to 3 and....
Delete from Duplicates Query
Re: "Inclusive" query
Combo Grouping
Re: Crosstab totals question
Select query help!!!
Select Distinct Records
Re: Modifications to Time and Billing database template
Update Query
Re: help with turnover query
btrieve field
Re: Like Criteria
Re: Crosstab totals question
unique count
CrossTab /Calculate
Form Values in query
Querying ODBC Tables
Querying ODBC Tables
Query Problems
Re: how do i copy one access table to another?
a query from 2 related tables
Update a query with new data
Date Query again...
Request for validation of a couple queries (kind of lengthy - sorry)
adding Nulls
Brain Cramp!
Query for numbers (not text)
Business Days
** One Million FREE Visitors **
Re: Re:Query Question
Relationship problems in access ;-)
I am being prompted to enter the same supplier with my query twic.
Query Problem
Query and table problems.
How do I do a query looking for a literal "?" in access
Re: Why is my field shortened when queried?
SQL Confusion
Re: Arithmetic overflow error converting numeric to data type numeric
Beginner
comparing tables
SPEED UP QUERIES
INSERT query inside an error handler?
table from a query
Re: CrossTab Query Output
Re: Turnover Query
Re: how do i copy one access table to another?
How do I sort a date by the month instead of the year?
<date
Query Help
Date Query
query in design mode row source in MS Access 2000
Query and recordsource
pass-through query ODBC connect str error? Version: 2003 (11.0)
Re: Null Value
Re: How do I get dummy values from a UNION statement?
how does Access process ORs? /problem with ranking
stop
Stop promtpting DelQry
Option count into a query
Calculating Time durations with Nul values
Tables/Relationships
Access
SQL Stored Procedure imported data to wrong field
the best affiliate program on the web!!! you get commission in2-tier affiliate program
Duplicate repetetive entries in query
INNER JOIN query
Change tables without rewriting the query
Query Question
Change a numeric field to a date
Lining up multiple field entries in Combo Box
most recent date
Formula question and book recommendation needed.
Parameter in a FROM clause?
Re: An update query doesn't do the updates it says it did.
Query Calculation Doesn't Get Put Into Table
Updating Null Child Fields
Totals in select queries
Query for most recent entry
Stock list
Apostrophe in a text field causes error in query
Text to Column function in Access
Additem Workaround in 97/2000
First of and last of help!
Trouble with Delete Query
DateDiff in SQL
Re: Why I get "Type Mismatch"
mortgage calculation
"If the user enters something, return something, otherwise return everything"
Filter or Query Question
dsum in query
comparing addresses
Finding missing keys
use case or anything else in access
Between two aleatory or fixed dates
Extract data for a date plus tomorrows date
Expression Problems?
Query is forms recordsource
Split info in one field into two fields?
Form that also updates the intermediary table?
ActiveX Calendar & Queries
remove start up features
report generated from different forms
Query when no records
Calculate an expired date
Parameter Query for two different fields
StdDeviation sideways.
Re: Random ID selection
Application object variables
convert query into xml-file
Update Query
request for help with a SQL update query
Re: Linking Tables
picture
Data type mismatch in criteria expression
Invalid Argument
Wildcard problem in joined query
Query 40 days and more: Date()
Removing unwanted records
Validation of query parameters?