microsoft.public.access.queries
- Count as zero when no data,
Mike Green
- Re: Crosstab-force rows,
Phil Smith
- Update Query, updating wrong table,
matt17@xxxxxxxxx
- no zeroes returned,
alphamisanthrope
- Re: Query for a Quartely Report,
John Spencer
- Re: Report Query,
John Spencer
- RE: Problem with my Query,
Jim Johnson
- Null records with Between operator,
alphamisanthrope
- Create a SQL on a calculated filed,
Adrian G Vasile (BDI)
- Re: Merging With Microsoft Word,
John Spencer
- RE: Append Same Records,
cage4000
- RE: Parameter query question,
Duane Hookom
- Re: selection,
John Vinson
- RE: Max Function Help,
Dale Fye
- RE: Count totals for each group/set by how many occurrences they appea,
Dale Fye
- I need help on my formula,
schmidt . margaret
- Re: Record Number automated in Query,
raskew via AccessMonster.com
- RE: How To Find Missing Text Data?,
Lythandra
- Jobcodes!,
DBAmat
- Re: Help - Query for Report,
Gary Walter
- Re: Getting Query to show calculation for all records,
John Spencer
- Re: Plz Help,
Gary Walter
- Re: Incorrect "yyyy" for "ww" when using DatePart,
Gary Walter
- Re: Edit a Querry,
Gary Walter
- Re: Error 3700,
Gary Walter
- Re: I need an SQL expert,
jarl
- Multiple criteria from a single field in a Select Query,
Loggical via AccessMonster.com
- select a crteria for a txt feild,
jon
- Creating a zero return,
Mike Green
- Re: Convert text to number,
fredg
- Re: sequential numbering in a query,
Marshall Barton
- Re: CrossTab quiry with Parameters,
Jason Lepack
- Re: reformatting a name,
Jason Lepack
- Null to Zero in a crosstab,
Bill
- Re: Can I query more than one parameter in a single field?,
Rick B
- Simple requery?,
Mike Green
- date format,
Jean-Paul De Winter
- In([variable]),
undrline via AccessMonster.com
- Re: In([variable]),
John Vinson
- Re: In([variable]),
undrline via AccessMonster.com
- Re: In([variable]),
undrline via AccessMonster.com
- Re: In([variable]),
John Vinson
- Re: In([variable]),
undrline via AccessMonster.com
- Re: In([variable]),
John Vinson
- Re: In([variable]),
raskew via AccessMonster.com
- Re: In([variable]),
John Vinson
- Re: In([variable]),
raskew via AccessMonster.com
- Re: In([variable]),
undrline via AccessMonster.com
- Re: In([variable]),
undrline via AccessMonster.com
- Re: In([variable]),
raskew via AccessMonster.com
- run a series of queries,
guy
- Re: 6 Months Due,
Jeff Boyce
- <Possible follow-ups>
- Re: 6 Months Due,
John Vinson
- Message not available
- Message not available
- Re: How do I ask the user to enter the day of the week to search for?,
John Spencer
- Cross Tab Query Help!,
rguarnieri
- Re: Use a query to find incomplete fulfillment orders,
John Spencer
- Re: Summing across rows in a query,
Marshall Barton
- Re: Running Sum in Union query,
Marshall Barton
- Return just the first record that fits the parameter,
BruceM
- Re: Sum of Time,
Rick B
Divide by zero in Stored procedure (MS Access project),
lemes_m@xxxxxxxxx
Re: Duplicate Field Names,
John Spencer
RE: Last Date,
Scott
Re: Append query problem - "duplicate output destination",
John Spencer
Re: Find a MOnth,
Jason Lepack
Problem on update query,
Franck Fouache
Re: tables merge or math,
John Vinson
GLOBAL OFFLINE DATA ENTRY JOBS,
tinu
GLOBAL ONLINE DATA ENTRY JOBS,
tinu
SQL Query Question (<>),
lexiwynona
Re: Wildcard for non matching records between tables,
Marshall Barton
Re: Unique data from Union Query,
John Vinson
Re: Using parameters in Pass_Through queries,
John Vinson
Re: Query with criteria for long data type but criteria is double,
Allen Browne
Quering on a portion of data in a field,
mrz via AccessMonster.com
Re: Between/And statement,
Smartin
VB 6.0 - Getting Sql View Text,
elliotbusiness
Birthday,
Beth
select distinct and another column...,
tony c
Re: Using Average In Select Query,
John Spencer
Re: Cross Tab Query: "0" in null box,
John Spencer
Eliminate duplicates from query,
Mary M
Re: I want to separate data (text) by the space between the words?,
fredg
Previous Month name,
Kimberley
Rounding problems with query,
jamcompany via AccessMonster.com
Can't update data in query..,
HLCruz via AccessMonster.com
Subquery or not ?,
Nicodemus
Re: [Select] the results of 2 queries,
Baz
Re: SQL query, include all fields except specific fields,
Baz
Re: VBA query syntax error,
Jason Lepack
Re: Concatenating,
Jeff Boyce
quries start with ~,
Roy Goldhammer
Re: Access not accepting functions in queries,
Allen Browne
Sequential Numbering on field in Access,
robertadamharper@xxxxxxxxxxxxxx
Re: Date()-1,
Allen Browne
Re: Query Issue - Error message 3071 (too complex to be evaluated),
Baz
RE: Updateable query error,
Jerry Whittle
Re: No duplicates question,
John Spencer
I don't think this is easy!!!,
Bill
Re: sorting question,
Douglas J. Steele
Re: Why is my Running Total not working?,
Gary Walter
SQL Incremental numbers,
Mike Green
Long-winded question about limiting choices displayed in combo box,
Paul
SQL Syntax help,
Mike Green
RE: Date Add question,
P Mon
Re: Update only one record,
John Spencer
combining Select Query with Summary Query included,
Ray
Return all appointment types,
AccessQuestions via AccessMonster.com
Re: time since last high tide,
Gary Walter
Noob question - Data Type Mismatch,
tokersmurf
Re: Join Memo fields,
Baz
RE: Crosstab Worries,
Duane Hookom
Re: Queries with date fields,
John Spencer
Re: How do I have zero values in a query show as blank,
Jeff Boyce
Re: Suggestions on matching names,
Jeff Boyce
Re: access query,
Smartin
Duplicate Entry in Query Return,
Mary C
OT--database design forgot about twins,
Gary Walter
Help with this quey,
Marco
Re: calculation based on criteria,
Gary Walter
Simple concatenation of fields,
Joanne
Re: Mulitple IIf statements - Too many,
AccessIM
Re: Consecutive months,
Marshall Barton
FORM - after update event,
DiDi
Delete matching records from two tables,
WorldCTZen
Updating a field that is a part of the composite primary key,
sameervalluri
Making list box border disappear when printing,
KK
Only show most recent invoice?,
Jim
Re: NZ function,
BruceM
- Message not available
- Message not available
List box Selection,
bigbore50@xxxxxxxxx
Need help with Expression,
Lori2836 via AccessMonster.com
Re: text data in table gets converted to a number,
Baz
Re: Extracting from a query!,
John Spencer
Re: Cannot format a date in Query- returns a blank,
John Spencer
Decimal places in Calculated Field,
Bill
updating combo box content,
the_dude via AccessMonster.com
Re: Query not working,
strive4peace
Re: query sorting question,
strive4peace
Re: adding Time / time Formats,
Rick Brandt
RE: sql query help,
Peter Yang [MSFT]
Re: Advanced Query question,
Gary Walter
Re: Using two Parameter in one query,
John Vinson
Re: Sum by month query,
Smartin
expression question,
Slez via AccessMonster.com
- Message not available
- Message not available
Re: Query Design Grid IIf Function,
John Spencer
Customer Penetration,
Chris
Re: Like statement,
Jason Lepack
Re: Like statement,
giorgio rancati
Re: How to extract numeric portion of alphanumeric data,
Tom Lake
Re: Combining queries,
Jason Lepack
- Message not available
- Message not available
Re: Still getting #error in the results,
John Spencer
Re: Problems with Data Format,
John Spencer
Seach multiple tables at once,
HekaEnt via AccessMonster.com
Re: Subtraction of 2 (texts) fields.,
Jamie Collins
Invalid alias name,
Jeff
How to display values from the range,
tzmy79@xxxxxxxxx
Re: access 2003 column to row,
Gary Walter
Re: IIF statement in Query Criteria,
John Spencer
Re: Count field values,
Baz
Re: How do I delete characters using a query?,
John Spencer
Re: Not In (Select...) and Outer Join yields diff. result,
giorgio rancati
- Message not available
- Message not available
Re: Append multiple queries into an empty table via code -- code,
strive4peace
RE: parameter query only works with one specific record,
KARL DEWEY
Access/Query Help,
jack
Re: Maturity Date Calculation,
Smartin
Access 2007,
shank
Re: Top Value to obtain Top Child for each Parent,
John Spencer
The Many Flavors of SQL - Can a SQL Server query work in MS Access?,
Damian Carrillo
Re: how do I find employees between 06/10/2006 and 12/31/2006,
Smartin
Re: Append Query Rounding to Nearest Whole Number?,
John Spencer
Re: Append Query - must meet criteria,
Marshall Barton
Re: Remove commas,
Marshall Barton
Re: wildcard search,
Gary Walter
- Re: wildcard search,
Haggr
- Re: wildcard search,
Gary Walter
- Re: wildcard search,
Haggr
- Re: wildcard search,
Gary Walter
- Re: wildcard search,
Haggr
- Re: wildcard search,
Gary Walter
- Re: wildcard search,
Haggr
- Re: wildcard search,
Gary Walter
- Re: wildcard search,
Gary Walter
- Re: wildcard search,
Gary Walter
- Re: wildcard search,
Haggr
- Re: wildcard search,
Gary Walter
- <Possible follow-ups>
- Re: wildcard search,
Marshall Barton
Query with Calculations,
Dos Equis
Question about Time functions,
Coleen
Re: Date Rounding,
John Vinson
Re: Multiple field query,
Smartin
Delete Queries and joins - Where clauses,
DJJ
Select field to query based on Combo box,
jbair via AccessMonster.com
Fill "Month" field from "Date" field,
Astello
Re: How do I combine records in different rows in one row?,
John Vinson
Query Across Multiple Tables,
Neil10365
Re: Query based on Crosstab Qry,
John Spencer
Re: Eliminate Duplicates,
John Spencer
attn: ollie - alluring thumbnail indexes - goj badzu iy oype - (1/1),
haywood
Lookup Query Help,
mattc66 via AccessMonster.com
Re: Query based on a value from Subform,
Gary Walter
Data Comparison Using Query,
Stephen Moeller
Re: Month as Text Parameter,
Gary Walter
Re: HELP - "Operation must be an updateable query",
Gary Walter
Re: Path to field on subform within a tabbed form,
Gary Walter
Re: Find Monday's Date,
Gary Walter
Re: Updating fields in one table to from fields in another table,
Jason Lepack
Re: Only want results with three or more entries...?,
Gary Walter
Query Error - Field too small for data...,
Dos Equis
Delete Queries Question,
News
Re: Lost password,
BigAl
Re: ORDER BY Clause,
Jason Lepack
Problem with query.,
ielmrani via AccessMonster.com
Re: Only 5 results from calculated field,
Rick B
Overflow,
Leslie Isaacs
ora-00936 in Oracle PT/SQL,
CevinMoses
Re: select all fields from source table and hide one in resultant quer,
Baz
Re: "Aggregate" error when running query,
John Vinson
Random non-repeating queries MS Access,
tgassmann
Re: Return all items including letters "bird",
Smartin
Re: Please help! Query and Link Table issue,
Smartin
Re: Query calculations across different records. Is it possible?,
John Vinson
Parameters + Union queries + Order By = Unexpected Result,
wolfnospam
Where function ???,
fiaolle
Query problem..,
Rex
Not Like Wildcard in Module code,
pubdude2003 via AccessMonster.com
Re: I dont't know how to tell what the problem is,
Jason Lepack
Delete record from table using a list box,
bigbore50@xxxxxxxxx
Transforming vertical data to horizontal data,
wooster
Re: Need help using Select Into or Insert Into with Union function,
George Nicholson
Re: Use of "LIKE" in a SQL string,
Michel Walsh
Re: Crosstab total question,
Michel Walsh
Re: Solving problem when hours croos 24h and stating a new day,
Jason Lepack
Re: Append multiple queries into an empty table via code,
Michel Walsh
Re: huge problem in querie,
Michel Walsh
Re: Criteria,
Michel Walsh
RE: Multi Select List Box as Criteria,
Larry
Re: my criteria should work and it's not,
Michel Walsh
Re: Using Functions or form controls as criteria in a select query,
John Vinson
Combo box conditional row source,
BruceM
Re: Using LIKE in a JOIN,
Jason Lepack
Re: Using LIKE in a JOIN,
Jamie Collins
Space Issue,
Chris
Re: Return a list using highest (most recent) date,
Jamie Collins
Re: Find Unmatched Query Wizard (Access 2003),
Tom Lake
move all characters before first comma - help!,
nospam@xxxxxxxxxx
concatenate field in a query,
Slez
Awkward Query Idea / Help!? Percentiles.,
stevensjn
Re: Query criteria on certain date ranges,
Jeff Boyce
Zip Codes Help!,
Chris
VBA and Access - Reference Book Recommendation Please,
Takeadoe
Re: Getting Rows into Columns,
Gary Walter
Re: Unique Counting -- use Group By,
strive4peace
Re: Getting Rows into Columns -- Crosstab Query,
strive4peace
Stuck with GROUP BY query,
F.
Shipping Labels,
klp via AccessMonster.com
Varying Query Performance,
Bill
Query: Remove all but the first occurance,
Noozer
Re: Two Criteria,
Ken Snell \(MVP\)
<Possible follow-ups>
Re: Two Criteria,
Jamie Collins
Re: Two Criteria,
Gary Walter
RE: group by / count question,
KARL DEWEY
First() won't work - subquery question,
Rémi
Need correct order for month names in cross tab,
Bill
Re: Setting row numbers,
John Nurick
Re: Access Querry,
Rick B
Re: parameter query,
Rick B
What Field is Not Matching in Unmatched Query,
Ronster
Re: Gotta be simple. I have a Date field and a Day field...,
Jason Lepack
Re: how can i get all records with the first name i enter in access?,
Rick B
Access Query Help!,
jack
Re: Eliminating Duplicates in a Query,
fredg
Re: Complex Environ question,
MARK
Update table using partial word match,
SQL Learner
Count of query records,
Dsperry101 via AccessMonster.com
Re: Add rows by user specified range,
Jason Lepack
Dynamic query filters, like Excel's Autofilter,
Rob
Re: Finding a non-existant field,
John Spencer
Nest iif - can't get the syntax right!,
Julia Boswell
Current date less 2 months,
Rick Johnston
Listing the Last two results by date (Complicated),
Glenn_H
Append qry only works the second time,
Lori2836 via AccessMonster.com
RE: Query with multiple fields and search combinations,
LTrahan
Can I append to 2 different tables?,
Darrell Childress
Difficulty in downloading Eboot.bin using Jump code,
kracks
Re: Expression Queries,
John Spencer
Re: append query posting data entry line too,
John Spencer
Re: Problems with Date Filter,
Jamie Collins
Re: Date Fields in Queries Access 2000,
Allen Browne
Sum Top n Scores,
Paul W Smith
Tics to minuts,
Rolf Edberg
Re: Selection between dates for computed field,
Marshall Barton
Re: Change Values in a Query,
giorgio rancati
Update Query Problem,
Din Zavery
Update Query using date in text format?,
rstiles
Qry to group & Sum all data but only returning the location of where Max Pts was,
Lor
Querying for postcodes within an address against another masters t,
efandango
combine multiple rows in same field,
David
Re: Eternally Functional Criteria,
Ken Snell \(MVP\)
RE: Enter Parameter Value Issue when running query with 2 tables,
Duane Hookom
Re: Controlling Query Output with Checkbox on Form,
John Spencer
how to create a function w/in a query?,
ash
DoCmd.OpenQuery vs CurrentDb.Execute,
Andreas
Query help, date criteria,
androide016
Input parameter for append query,
Andreas
office outlook,
pamwp
RE: Query by Numeric Value Range,
MValentine
RE: runtime error record is deleted,
Duane Hookom
Re: Build Query Based Upon The Current Record,
Smartin
Re: Queries,
Smartin
Re: Calculating averages of dates,
George Nicholson
Re: Enter Dates into Table with SQL,
Jeff Boyce
Re: accumulating total,
Smartin
Re: Update SQL,
Smartin
RE: calculate average of records selectively counted,
Giz
Re: Delete query criteria,
Gary Walter
Re: convert to multiple columns,
Gary Walter
Re: crosstab query the date columns are not in order,
Gary Walter
Re: DateDiff Expression,
John Spencer
RE: How to retrieve all or patial records,
LOU
- RE: How to retrieve all or patial records,
Klatuu
- RE: How to retrieve all or patial records,
LOU
- RE: How to retrieve all or patial records,
Klatuu
- RE: How to retrieve all or patial records,
LOU
- RE: How to retrieve all or patial records,
LOU
- RE: How to retrieve all or patial records,
Klatuu
- RE: How to retrieve all or patial records,
LOU
- RE: How to retrieve all or patial records,
Klatuu
- RE: How to retrieve all or patial records,
LOU
- RE: How to retrieve all or patial records,
LOU
- RE: How to retrieve all or patial records,
Klatuu
- RE: How to retrieve all or patial records,
LOU
- RE: How to retrieve all or patial records,
Klatuu
concatenate based on 3 tables (many-to-many) relationship,
Jeremy Ellison
how to clear a parameter in a Crosstab query,
RS.travelgroup
Can you Open a form from a query?,
Aj
IIf Statement in a query,
NevilleT
RE: Sort by Last unless Null then Sort by Company and intermingle,
Dale Fye
difference between hours problem,
Marco
- Message not available
- Message not available
RE: find record with max date less than or equal to today,
Lucas Kartawidjaja
Union query (I thinK),
msnews
Automatic append from form to tables,
Andreas
Re: Storing binary images in Access,
todd . kovalsky
Re: Update Query???,
Tylee23
Generate a new table,
Tylee23
Counting number of events per month...?,
thebigpahoot
Total Query,
Greg
Newbie Query Question,
GraVeDiGGer
Re: A case sensitive version of "SELECT DISTINCT" for Jet SQL,
Jason Lepack
Search 2 fields for ANY word in TextBox criteria,
CompleteNewb
Re: Delete X characters from end of string,
Smartin
Re: interesting query issue...,
Jason Lepack
Re: content of the listbox to merge a result in a textbox,
pietlinden
Re: Criteria in Yes/No Field,
Van T. Dinh
Re: Track and save changes to records,
Van T. Dinh
Re: Grouping by Date,
Van T. Dinh
restricting records in a combo field in a datasheet,
Shumboom
Help with Date Query and Report,
PenC
Timestamp Criteria in Query,
jfredel via AccessMonster.com
Re: Update Query Replacing text within HTML code Conversion Failure ER,
Gary Walter
Re: Problems with Duplicate info.,
Jason Lepack
Re: How to make a parameter query give a drop down list,
Jeff Boyce
Runtime Error '3075',
DiDi
Label Count,
klp via AccessMonster.com