microsoft.public.access.queries
- Two Queries,
DS
- does windows vista support hotmail and live messenger?,
sb
- Re: problem analysis,
Jeff Boyce
- Re: duplicate telephone numbers in daytime, evening, how do I clear 2n,
Marshall Barton
- Union query changes Memo to Text (256 char limit),
baldwin . kevin
- Re: Using the like operator with input data,
omocaig via AccessMonster.com
- Re: Record Count in Query,
Michel Walsh
- Re: specified field could refer to more than one table,
Michel Walsh
- RE: Round Robin form,
Jeff Kunberger
- execute sql queries for excel,
sendto3283
- Adding fields produces aggregate function error,
Brett
- Re: Crosstab calculating dates to days,
Michel Walsh
- Re: Showing male and female students seperately,
Michel Walsh
- Cannot have aggregate function in JOIN operation,
norrisinc
- Re: appling a calculation to a whole table,
Rick B
- Calculated Field Help Needed,
Jay
- Re: Query for month or week grouping,
Allen Browne
- RE: Total Sum calculation,
scubadiver
- Re: Finding values in one table when I know the field names from anoth,
Allen Browne
- Re: Capturing Query Parameters,
Allen Browne
- Is it possible to combine these?,
James Parham
- Re: How do I make a table that will truncate my data field?,
Allen Browne
- ms access for search marketing data,
outofbounds
- Building iif expression,
Jack
- Compare Addresses,
qkimchi via AccessMonster.com
- Little challenging query,
Dornenhexe
- Re: DMin Function,
George Nicholson
- A Nigtmare!,
131313 via AccessMonster.com
- consolidate queries,
zSplash
- Re: How do you pick out the last two characters of a field in a query,
BMore
- Re: NO DATA - Create Zero Values,
Michel Walsh
- Re: Crosstab query (undefined function "format" in expression),
Michel Walsh
- Re: Query Help Please,
John Spencer
- Re: Update Query Help,
fredg
- Re: #Error In Query Problem,
John Spencer
- Re: Paste from Word 2003 to Excel,
John Spencer
- Re: convert kilometers to miles,
Jeff Boyce
- Message not available
- Message not available
- Quarter Totals,
style45
- Re: DSumExpression,
Marshall Barton
- Re: Query on format of a field,
Rick Brandt
- Re: If there isn't any data...,
Marshall Barton
- Re: Working with Dates,
John Spencer
- Re: Count values in multiple fields,
John Spencer
- Re: A nice quick easy one...,
Michel Walsh
- Re: Dsum update querie,
Michel Walsh
- Re: Creating Static Column Headings in Crosstab Queries,
Michel Walsh
- Why isn't this left join query working,
john . melbourne
- Calculated result in query problem,
bluedragonsbreath
- Re: Report HELP,
Marshall Barton
Column Total,
Angel_G
Filter records not meeting criteria,
DubboPete
Re: SQL SYNTAX ERROR ON JOIN OPERATION,
John Spencer
Re: When I open design view in a query I get "is not a valid name.,
John W . Vinson
IP/Subnet Query Question,
cokparae
Re: declaring variables,
John W . Vinson
Attacments,
David McPartlin
Total Query,
JMS
Re: Calculations,
Rick Brandt
Re: Access SQL question,
George Nicholson
Re: Real Stumper!,
John W . Vinson
Re: How Can I print a Listing of Just My Query Names,
mcescher
RE: Cross tab query, column heading,
KARL DEWEY
Between Expression searching between alpha / #'s - Using Access Form,
atillman
Re: Query from a Combo box for both equal to and not equal to.,
John Spencer
No duplications,
Jeff Klein
Re: Record calculation issue,
Michel Walsh
Re: Trouble With Parameters,
Michel Walsh
Re: FIlter on filed making a calulation,
John Spencer
Re: Changing the format of a field while doing a make table,
Allen Browne
Re: DLookup in Query,
Allen Browne
Re: I need the UNMATCH data,
John W . Vinson
Re: running a "make table" query using VBA,
John W . Vinson
access query trouble-HELP!,
schoenman
Jet database engine does not recognize... ?,
G Lykos
Help with blank records,
mfrisbyuk
RE: How do I keep the position of tables in the Diagram Pane?,
Peter Yang [MSFT]
Re: DSUM Expression,
Ken Snell \(MVP\)
Help creating crosstab query,
DubboPete
RE: Show a zero,
KARL DEWEY
RE: How to calculate work hours between two time/dates,
Ken Sheridan
Re: Query that returns values greater than zero,
John Spencer
Re: Changes Date Format from Date/Time to just Date,
Rick Brandt
Re: Too many IIFs,
Matthias Klaey
RE: Parameters and crosstab queries,
Jerry Whittle
RE: DataSet Question-Please Help,
Nikki
Re: Upper Case Conversion,
fredg
Re: Date field problem,
fredg
RE: Inner Join doesn't work, Help,
elena
Identify Duplicates (Group Records First),
William Horton
RE: Combo Box Value question,
Ofer Cohen
RE: Query to random select top N values,
Len
RE: <> data query,
Ofer Cohen
- Message not available
- Message not available
RE: Show null values in query,
Ofer Cohen
RE: Select query with customized ID,
Duane Hookom
query problem,
bigwillno2 via AccessMonster.com
nested OR in queries,
vgraybeal
Joining 2 Queries,
DS
Proximity,
TDS
Using Access VBA to Format Conditionally in Excel,
laurajayne . cozens
restrict data in combo box,
newkid
Even as I write this I know I've set it up wrong.....,
anthony . carter
Query selecting those players who played under par,
M.T.
Access SQL - date sieve (possible duplicate post),
G Lykos
Not First, Not Last in Crosstab Query,
hongluen via AccessMonster.com
Access SQL - date sieve,
G Lykos
Help w/Query,
Celestrial_d via AccessMonster.com
Has this ever happened to you?,
Laurel
Multi-condition JOIN,
larrynator
Creating Forms,
stromo
Create Table in code,
Brian
using multiple Y/N radio buttons to open a form,
Chuck
Largest value,
Hanksor
UPDATE Query,
laurajayne . cozens
Running Sum - Error,
Jackson via AccessMonster.com
Re: Macro to Run Query Based on ComboBox Selection,
Michel Walsh
Copy data from on table to another ?,
SpookiePower
Switchboard won't cooperate,
anthony . carter
fin access,
anthony . carter
Re: How do I properly call an Access parameterized wildcard query from ASP?,
Dave
Macro trouble,
tcarter
If statement..... Possible Match,
learning_codes@xxxxxxxxxxx
Date Criteria Correct?,
Linda RQ
RE: Mail merge to Word using 1:m relationship,
scubadiver
parse data,
DD
Re: query using combo box value,
Ken Snell \(MVP\)
Query That Pulls Multiple Businesses,
Jill
Re: Update Query To Excel (Error 3113),
Allen Browne
Re: Subquery SQL syntax help,
Ken Snell \(MVP\)
Re: Help Needed With Drop Down List,
John W . Vinson
Re: Return blank if 0,
Allen Browne
Re: Annoying syntax error (missing operator),
Matthias Klaey
Re: Count function in Query,
kingston via AccessMonster.com
Re: Query Help,
John Spencer
Re: Convert Number,
Tom Lake
Complex IIF function,
alex
multiple link criteria in sql statement,
Lori2836 via AccessMonster.com
Getting an update query to run automatically,
anthony . carter
Re: How to 'flatten' a self-referencing table?,
Jason Lepack
Re: Bug,
John Spencer
Re: List records with recent month and previous 2,
John Spencer
Re: Trim text before or after a comma,
duet76
Cumulative Sum using more than one criteria,
Mac
Re: Ms Access Conversion to 2007,
Allen Browne
Count uniq records and assign to a control,
Song Su
Multiple values in once cross-tab,
Jumbo Shrimps, Jr.
Re: Maximize question,
Gary Walter
Limit query without using TOP,
DeDBlanK
RE: Criteria in calculated field - unexpected prompt for input,
Peter
Re: access compact database changes results,
Allen Browne
Re: Finding postcodes from 1 of 2 fields and updating to a 3rd field,
John Nurick
Using Min to Calculate across a table,
OlyOil
Re: Zero returned as results,
Allen Browne
Re: DROP a TABLE sequence,
Allen Browne
Re: Append/Update Query: If fieldname is null then update,
Allen Browne
Re: Help with IIF in Criteria,
tina
Merging text data in cross-tab query,
hongluen via AccessMonster.com
Create table in blank databse,
Alan T
Create Excel Spreadsheet from Access with 1 to many relationship,
alex
A query that shows "deletable" records,
Lasse T
Easy birthdays question...,
Paul
Re: " Charecter,
Douglas J. Steele
Re: help understanding a query,
Michel Walsh
Re: Performing multiple conditions on data...,
Michel Walsh
Re: Query, empty or null field value,
Jason Lepack
Re: delete records and modufy records,
Michel Walsh
Re: Cross Tab Query,
John Spencer
Query for change in Responsibility,
Greg
Re: Query problem (MS SQL and MS Access tables),
John W . Vinson
Re: Date Range,
John Spencer
Re: Crosstab query date field sorted by day instead of month,
John Spencer
Re: navigation question,
John Spencer
Re: Add current Date in running make table query?,
John Spencer
Re: Problem Creating Totals Query,
John Spencer
Real Easy.......,
anthony . carter
Union Query - Invalid use of null,
sunflare98
Re: Find Non-matching fields,
Jeff Boyce
Re: Find Only Blank Records,
Allen Browne
Re: Employment,
Gary Walter
autonumber querry,
brablo
Depreciation Schedule,
Annette
need to change text around,
MES via AccessMonster.com
Value in Crosstab Query,
hongluen via AccessMonster.com
Re: update valeu question,
John W . Vinson
select to compare,
Neillg
Microsoft Access Expression Problem,
j . boswell
- Re: Microsoft Access Expression Problem,
John Spencer
- Re: Microsoft Access Expression Problem,
Gary Walter
- Re: Microsoft Access Expression Problem,
Gary Walter
- Re: Microsoft Access Expression Problem,
Gary Walter
- Re: Microsoft Access Expression Problem,
j . boswell
- Re: Microsoft Access Expression Problem,
j . boswell
- Re: Microsoft Access Expression Problem,
j . boswell
- Re: Microsoft Access Expression Problem,
Gary Walter
- Re: Microsoft Access Expression Problem,
John Spencer
- Re: Microsoft Access Expression Problem,
j . boswell
- Re: Microsoft Access Expression Problem,
j . boswell
- Re: Microsoft Access Expression Problem,
John Spencer
- Re: Microsoft Access Expression Problem,
j . boswell
- Re: Microsoft Access Expression Problem,
John Spencer
- Re: Microsoft Access Expression Problem,
Gary Walter
- Re: Microsoft Access Expression Problem,
John Spencer
- Re: Microsoft Access Expression Problem,
j . boswell
- Re: Microsoft Access Expression Problem,
Gary Walter
- Re: Microsoft Access Expression Problem,
Gary Walter
- Re: Microsoft Access Expression Problem,
j . boswell
- Re: Microsoft Access Expression Problem,
j . boswell
- Re: Microsoft Access Expression Problem,
j . boswell
- Re: Microsoft Access Expression Problem,
John Spencer
- Re: Microsoft Access Expression Problem,
j . boswell
- Re: Microsoft Access Expression Problem,
j . boswell
- Re: Microsoft Access Expression Problem,
Gary Walter
- Re: Microsoft Access Expression Problem,
Gary Walter
- Re: Microsoft Access Expression Problem,
j . boswell
VBA input, add to query,
zSplash
- Message not available
- Re: VBA input, add to query,
zSplash
- Message not available
- Re: VBA input, add to query,
zSplash
- Re: VBA input, add to query,
zSplash
- Re: VBA input, add to query,
KARL DEWEY
- Re: VBA input, add to query,
zSplash
- Re: VBA input, add to query,
KARL DEWEY
- Re: VBA input, add to query,
John W . Vinson
- Re: VBA input, add to query,
zSplash
- Re: VBA input, add to query,
KARL DEWEY
Re: Questions on format of Select statement,
John W . Vinson
Re: selecting a given Day in a list of days under Frequency field(IN?),
Gary Walter
Re: Invalid use of Null explained,
kingston via AccessMonster.com
Re: Date Calculation Problem,
fredg
Not sure of the official name,
Meaghan
Re: Trimming a telephone number....Or replacing,
kingston via AccessMonster.com
Report showing counts of two tables,
ThomasK via AccessMonster.com
Re: Display via an expression,
Jeff Boyce
CONVERT TIME & TRIM DATE,
RENEE705
ignor criteria if null?,
Robert H
Re: sum is incorrect (slightly off),
Michel Walsh
Query Calculation - #Error,
ckloch
Re: DLookup Function in query - pulls wrong values,
Michel Walsh
Re: problem with IIF expression in query criteria containing OR condit,
Michel Walsh
Text Box in Form vs. User-Defined Criteria,
mjbruesch
% query based on dates.,
MurdocUK
Re: Ceosstab Query Date help,
John Spencer
Re: updating table based on another table,
John Spencer
Re: having trouble making a quiery to the closest date to another date,
Jason Lepack
RE: finding every 7th record in a query,
raskew via AccessMonster.com
Re: HELP WITH UPDATE QUERY,
Michel Walsh
Update Several Records with separate table data,
mba . bcis
Delete more than 1 tables in one Query?,
perrycheung221
Re: Schedule,
Diane Walker
filter a table based on a query,
justine
Re: Selection of Yes/No data where data is "Yes",
Allen Browne
Re: How do I run a query on the address with just the street name?,
fredg
Automate Query,
Diane Walker
Re: if statement in query,
kingston via AccessMonster.com
date parameter not accurate...,
perryclisbee via AccessMonster.com
Re: Show column in totals query without grouping,
Michel Walsh
Re: Query/Reports - looking to get averages from data base,
kingston via AccessMonster.com
Combine data in fields within one table,
kevintex
Re: Multiple Field Criteria,
Jason Lepack
Re: Date criteria help needed- i'm stuck :(,
kingston via AccessMonster.com
Function in query or recordsets and arrays?,
Starry
Re: Negative Number when Counting Yes/No,
Jason Lepack
Workday Count between [Startdate] & [Enddate],
Pete
Net Work Days in Access?,
plh
Re: "Overflow" error in an Access 20003 query,
Jason Lepack
How do I Concatenate Multiple rows in one row? Help,
mike_NY
Re: Left Join is excluding data from left table,
John Spencer
Re: appending query for "duplicate" tables,
John Spencer
Re: DROP PRIMARY KEY,
John W . Vinson
how to get several payment dates,
aceavl via AccessMonster.com
Re: iif logic,
kingston via AccessMonster.com
update query based on date difference,
jomara via AccessMonster.com
RE: update statement,
Me
Re: convert minutes to percent of hour,
John Spencer
Re: Agregate FUnctions in Query against Oracle 9i datasource,
John Spencer
Sum the product of two fields,
Enrique Rojas
Updating an Aliased table,
John Kraus
Re: SKUO11.CAB,
Gary Walter
Re: Set a SQL Result as Variable,
Michel Walsh
Right Join query with Between HELP,
Giorgio
Re: UNION ALL question,
Allen Browne
Move Values to Fields in Query?,
kramer31
Re: Between [first day:] and [last day:],
strive4peace
Order By not working under IIS7/Access database,
Steve Bottoms
Re: How to sum in an append query,
John W . Vinson
Count Age Grouping,
Nemesis_uk
Create a Variable from First 4-5 chars of a existing value ??,
kev100 via AccessMonster.com
Comparing records in 2 databases,
JA
Re: sum field from one query to update a field in a table,
fredg
Problem updating a combo Box,
Harry.PharmTouch@xxxxxxxxx
RE: Access Query not functioning completely.,
CCIsland
RE: How do I work with fields with missing data using sumif?,
ewood
Re: Getting rid of ties in Top 5,
Rick Brandt
Re: Need help with the missing piece of this!,
Rick Brandt
runtime error '2001',
michael goodall
This problem just won't go away......,
anthony . carter
Access Query Output to report Summation problems,
Enrique Rojas
Multi expression(different condition) in one queries,
mohsin via AccessMonster.com
Custom Function,
Kerry Purdy
Re: add a date expression on my query,
Allen Browne
Re: referencing Calculated fields in Subqueries..,
Allen Browne
distinct records ....,
jer
Re: Randomizer not being random,
Gary Walter
Re: how did create query on the microsoft access about this question,
John W . Vinson
Re: StopMacro for a failed command?,
Allen Browne
Always round up in a query?,
Mike Green
SQL Problem,
John Kraus
deleting data,
Roy Goldhammer
Re: Showing records with 0 total in a group by/sum query,
Marshall Barton
Re: query will not work,
fredg
Re: forcing blank field,
Philippe Perrault
LIKE in embedded if statement?,
lulugrant_is_a_dog
Re: problem when using related tables or relationships,
Allen Browne
Query a value from a running sum total,
dp724 via AccessMonster.com
- Re: Query a value from a running sum total,
Marshall Barton
- Re: Query a value from a running sum total,
dp724 via AccessMonster.com
- Re: Query a value from a running sum total,
Marshall Barton
- Re: Query a value from a running sum total,
dp724 via AccessMonster.com
- Re: Query a value from a running sum total,
Marshall Barton
- Re: Query a value from a running sum total,
dp724 via AccessMonster.com
- Re: Query a value from a running sum total,
Marshall Barton
- Re: Query a value from a running sum total,
dp724 via AccessMonster.com
- Re: Query a value from a running sum total,
Marshall Barton
- Re: Query a value from a running sum total,
dp724 via AccessMonster.com
- Re: Query a value from a running sum total,
dp724 via AccessMonster.com
- Re: Query a value from a running sum total,
dp724 via AccessMonster.com
- Re: Query a value from a running sum total,
Marshall Barton
Re: Change query criteria by form with wildcards,
Dale Fye
Re: Expression Help,
fredg
Re: Calculate average in a query,
raskew via AccessMonster.com
variables for query criteria,
zSplash
- Message not available
- Message not available
Re: Parameter Query,
Jason Lepack
RE: What is the criteria problem with this expression?,
Ken Sheridan
Re: Combining data - remedial question :),
Allen Browne
How to create a List subset of 10 each,
deefish99 via AccessMonster.com
Re: Simple problem,
Jason Lepack
Re: Date Criteria Question,
Gary Walter
Re: Question about WHERE syntax, errors with "Type Mismatch".,
Gary Walter
Further to.......Surely this must be possible?..,
anthony . carter
Re: How do I total a value of a field from several tables,
Allen Browne
Re: SQL comments,
Allen Browne
convert text to number,
rajesh
Re: Expression to link two tables together not working,
tina
- Message not available
- Message not available
Can I merge two data into one?,
hongluen via AccessMonster.com
Prompt User for Criteria,
easadmin
RE: CrossTab - parameter with a null response,
Duane Hookom
- RE: CrossTab - parameter with a null response,
AFSSkier
- RE: CrossTab - parameter with a null response,
Duane Hookom
- RE: CrossTab - parameter with a null response,
AFSSkier
- RE: CrossTab - parameter with a null response,
Duane Hookom
- RE: CrossTab - parameter with a null response,
AFSSkier
- RE: CrossTab - parameter with a null response,
Duane Hookom
- RE: CrossTab - parameter with a null response,
AFSSkier
- RE: CrossTab - parameter with a null response,
Duane Hookom
- RE: CrossTab - parameter with a null response,
AFSSkier
- RE: CrossTab - parameter with a null response,
Duane Hookom
- RE: CrossTab - parameter with a null response,
AFSSkier
- RE: CrossTab - parameter with a null response,
Duane Hookom
Re: query with date ciriteria..,
Marshall Barton
Sub Query Basics for Newbie...,
Tym
Re: Count and Update,
Michel Walsh
Re: Complex average query,
Michel Walsh
Find Quotes,
mattc66 via AccessMonster.com
2 mult listboxes parameters,
RFrechette
Convertings Months to numeric values,
Angel_G
use count query result in an IF statement,
michael goodall
Re: What's wrong with this SQL?,
Marshall Barton
Re: Help linking tables,
Carl Rapson
Re: What function returns the number of occurences of one string in a.,
Allen Browne
Re: Incrementing text fields,
Michel Walsh
Re: Self-Join Update Query,
Michel Walsh
Re: Anyone know of an easier way to write this formula?,
Michel Walsh
Query to replace text specific Charcters,
Craig Ferrier
Re: Odd date issue where date is between 1 January 1900 and 1 March 19,
Allen Browne
RE: Count the number of people that fall into a 30, 60, 90 day window,
Michael Gramelspacher
Top 10 records of specific field in table,
Chuck
Novice rcv'g error on query - please critique,
mo
Re: remove leading zeros of unequal length,
MH
rtrim using the function a query,
wgreen
Re: using a query to run a report that only selects one answer,
Marshall Barton
Re: Query design problems,
Carl Rapson
Re: Missing Export Wizard,
Gary Walter
Query to combine 2 tables,
Leslie Isaacs
Too many parameters,
Amy Blankenship
Re: Calculations using subquery,
Amy Blankenship
Re: Todays Date in a Query,
Rick B
Dynamic SQL statement too large...,
Brad Pears
Re: Creating a result set based on interval between two dates.,
Allen Browne
Re: What does "Where" mean here?,
Allen Browne
Re: To add new fields,
Allen Browne
query on form close?,
Fuzuy
Re: Is the date between 2 dates?,
Allen Browne
Return the top 10 only.,
rahmad
Re: RAW MATERIAL QUERRIES,
Michel Walsh
Re: Queries or code?,
Michel Walsh
Re: Date expression to show all records from 01/01/2006 and today,
Allen Browne
Re: Create exprn that returns the highest value of 4 fields in a query,
Allen Browne
Can Checkboxes Be Used to Input Text into a Field?,
DoveArrow
RE: Date Parameters not working consistently,
Frustrated in AL
union query?,
Slez via AccessMonster.com
sql date query - date format,
Julian
Re: Syntax error(Comma) in query expression,
Marshall Barton
Surely this must be possible........?,
anthony . carter
Re: Under what conditions will a query work on one machine but not ano,
Allen Browne
Re: Top Values & Grouping,
Gary Walter
query not returning some records,
Slez via AccessMonster.com
RE: Help: Cleaning Messy Table Data,
colin
Re: Calculating new scheduled date in access 97 query,
Allen Browne
RE: find record with max date less than or equal to today,
tanhus
Re: Most current date query,
Allen Browne
remove the first space from the following Postcodes,
Garry
Re: Created Fields Not working on SQL Linked Tables,
Michel Walsh
overflow!,
mohsin via AccessMonster.com
Lookup Query / SQL Help,
Garry
Memo Field with blank first line,
steve