microsoft.public.access.queries
- Re: convert AS400 date 1071101 to date 11/01/2007 mm/dd/yyy,
Douglas J. Steele
- Query in date range,
wesley.allen@xxxxxxxxx
- RE: Count of Students in Class,
Duane Hookom
- sums on a quary,
matjcb
- Re: Help with Date Parameter,
fredg
- Help Using APPEND Query,
DanielWalters6
- Re: Question on comments in queries,
Michel Walsh
- Re: Filtering out duplicate data point?,
Michel Walsh
- Re: Paramater query in a crosstab query in access 2003,
Michel Walsh
- First value below zero in a column,
JVMartin
- Re: saved words in created template move,
John Spencer
- pass-through query to Oracle,
JoanneB
- RE: Criteria is not working,
Marco
- Re: DSum function,
John Spencer
- Re: Multi-Value Field Query,
Allen Browne
- I want to create a search box in access,
Dethra
- Hour stated in Daily max query,
mohsin via AccessMonster.com
- Re: Using Option Group for Criteria of query,
Marshall Barton
- Re: How can I set up a Query with a variable number of input paramtrs,
pietlinden@xxxxxxxxxxx
- Re: HELP!!!!!,
pietlinden@xxxxxxxxxxx
- Re: Which way is better?,
Jeff Boyce
- RE: Dynamic selection of fielsd in a query.,
Steve S
- QUery results from lookup wizard,
ingalla
- RE: indicator,
Ofer Cohen
- Re: Regarding Select Case,
Jeff Boyce
- RE: Crosstab Placeholder,
cunger28
- Re: Union query is bringing fewer results that each individual query,
John Spencer
- Assign leads by percentage,
jbiggs via AccessMonster.com
- How do I change the title of a column in a datasheet?,
Donal P
- Re: NESTED SUBFORMS, QUERIES,
John Spencer
Concatenate and commas,
GMartin
Query filter problem!,
Carma via AccessMonster.com
- Re: Query filter problem!,
Michel Walsh
- Re: Query filter problem!,
Carma via AccessMonster.com
- Re: Query filter problem!,
Carma via AccessMonster.com
- Re: Query filter problem!,
Michel Walsh
- Re: Query filter problem!,
Carma via AccessMonster.com
- Re: Query filter problem!,
Carma via AccessMonster.com
- Re: Query filter problem!,
Michel Walsh
- Re: Query filter problem!,
Carma via AccessMonster.com
- Re: Query filter problem!,
Carma via AccessMonster.com
- Re: Query filter problem!,
Carma via AccessMonster.com
- Re: Query filter problem!,
Michel Walsh
- Re: Query filter problem!,
Carma via AccessMonster.com
RE: Using a Lookup Table,
Jerry Whittle
Re: Query's,
Jeff Boyce
Re: Iff & Not Equal to criteria,
John Spencer
Re: Query Expression help,
John Spencer
Re: duplicate records,
John Spencer
Creating a macro to search for a wildcard entry,
duncanjx
Formatting date to week,
shiro
Query Last Balance in Given Entity in Linked ODBC Table,
Karl Burrows
Re: Null Return on Count Function,
J_Goddard via AccessMonster.com
make +ve number -ve and -ve number stay same in same column,
Tamm Fox
wrong answer returned in querry (IIf . . > . . ),
Rick Stahl
Re: Append Query,
John W . Vinson
delete query question,
Opal
Re: how can I restore my computer to initial programme set up?,
fredg
Re: Retrieve the second most recent date data,
fredg
Re: Product Calculation in an Access Query,
Michel Walsh
Crosstab Query and Zero Values,
H0MELY
Cumulative number in query,
Garry
Re: Extra ) in query expression problem,
Jeff Boyce
Re: Odd Numeric OverFlow Error with MakeTable Query,
John Spencer
Re: conditional string conversion to mixed case,
Michel Walsh
Re: Create table in office 2007,
Michel Walsh
Re: lost table relationships,
Jason Lepack
RE: SQL: Select a column name "Short Name",
Dale Fye
Re: Select a column name "Short Name",
John Spencer
SQL: Selecting "Latest Transaction" & "Sum" them up,
ali
Re: Keeping data distinct,
John Spencer
Re: Replace Function Access 2003,
John Spencer
RE: "Sum" according to products,
Andy Hull
Showing data that does not match Querie,
Gareth - Network analyst.
About clipboard memory,
Meenatchy
Change text to number,
mohsin via AccessMonster.com
Update Query Fails due to Source table not being Updatable,
WAstarita
Re: Help with formula,
Marshall Barton
Re: Date Time Group Math,
Michael Gramelspacher
Appended field in query,
Carl
Query with hours,
Peter D
conditional math,
Smokeyhavoc
RE: query returns records that don't match criteria,
Jerry Whittle
Re: How can I merge two pairs of fields into 1 pair of fields,
pietlinden@xxxxxxxxxxx
Re: count number,
pietlinden@xxxxxxxxxxx
Re: A little harder thing i need help with,
pietlinden@xxxxxxxxxxx
Pop up Form to set parameter of query to generate a report,
Carl
Re: querying records with no corresponding value in related table,
Douglas J. Steele
Time calculations not sorting properly,
CraigJ
Re: Forecast Query,
pietlinden@xxxxxxxxxxx
Q for Stephen LeBans or Allen Browne re: Row NumberVer2,
Opal
Append query with addtional fields,
Opal
Re: Limit average to 1st 4 Scores,
Gary Walter
Query is too Complex error message when trying to run query.,
Jean-Francois Gauthier
Re: Query by current date using month & year,
Douglas J. Steele
Re: Code for Criteria in a Pass Through Query,
Rick Brandt
RE: Crosstab w/ no Null Return,
KARL DEWEY
RE: count records with like fields by query.,
FL
Re: I need to cut, strip out and rearrange a text string into 2 fields,
Jeff Boyce
RE: Duplicates - Query Joining,
KARL DEWEY
SQL for Multiple Parameters,
EoinC
Access Invoice Query to export to excel and import into Quickbooks .IIF Format,
Rich DeGray
Force a Query to Insert "Placeholders" (?),
croy
Query returns empty columns,
Amy
SubQuery or SubReport??,
petdominic via AccessMonster.com
- Re: SubQuery or SubReport??,
Michel Walsh
- Re: SubQuery or SubReport??,
petdominic via AccessMonster.com
- Re: SubQuery or SubReport??,
Michel Walsh
- Re: SubQuery or SubReport??,
petdominic via AccessMonster.com
- Re: SubQuery or SubReport??,
petdominic via AccessMonster.com
- Re: SubQuery or SubReport??,
Michel Walsh
- Re: SubQuery or SubReport??,
petdominic via AccessMonster.com
- Re: SubQuery or SubReport??,
Michel Walsh
- Re: SubQuery or SubReport??,
petdominic via AccessMonster.com
- Re: SubQuery or SubReport??,
Michel Walsh
- Re: SubQuery or SubReport??,
petdominic via AccessMonster.com
- Re: SubQuery or SubReport??,
Michel Walsh
- Re: SubQuery or SubReport??,
petdominic via AccessMonster.com
RE: Data from Table to Populate Query,
Darren Bartrup
How to implement a query that return data with no match,
eclypz
Re: Update Query basic,
Michel Walsh
RE: parameter promt question,
Dale Fye
RE: one combobox, one query, 2 combined fields,
Duane Hookom
Re: I need help with syntax for Nz function in query,
ehorde
Re: Field criteria happens to be a wildcard - "*", what to do?,
Douglas J. Steele
create one table from six queries,
F0zziebear
Identifying most recent entries to include in a report,
Leonard Priestley
Re: I've a series of dates i want grouped 2 use for averaging totals,
Marshall Barton
unmatched query,
c8tz
Multiple lines in an address field,
duncanjx
Re: Dropping duplicate records based on content,
Chip
Re: How convert GMT to LocalTime in Access 2003,
Al Campagna
Missing entries,
c8tz
Re: How to avoid excel warning message,
Opal
Re: Columns based on Date,
Wolfgang Kais
Re: Overflow error when performing calculations,
Wolfgang Kais
Re: Pass Through query with criteria on a form,
Wolfgang Kais
COunting patients visits,
Nir N
concatenating fields for links in queries,
Ted
Re: Crosstab Query to return all columns,
John Spencer
Re: Append Query Error,
John Spencer
Cross Tab Query to be used for calculations,
Pulley.Matt
Re: New to Queries,
Anna
RE: Increment Sequence Count Within a Query,
CT25
Multiple Queries Question,
angelinarose via AccessMonster.com
CONVERT in WHERE statement,
SReed via AccessMonster.com
Re: REPORT FROM QUERY,
Michel Walsh
Re: Help with update balance,
Michel Walsh
Re: Adding result from a query to a coloun?,
Roger Carlson
Line up text,
petdominic
Running total,
Beagle1927
Remove duplicate information in different fields,
Garry
Delete Query Message disappeared,
Steve Stad
Re: Problem in negative value when convertin to hours,
John Spencer
Re: Query Parameters,
John Spencer
Re: Query table using criteria from an Excel document,
Jeff Boyce
Re: <>0 criteria in query does not work,
Wolfgang Kais
Len and left function- result #Error.,
mohsin via AccessMonster.com
Re: top 3 from subtable,
Allen Browne
RE: How to change data type when importing from Excel to Acess?,
"Peter Yang[MSFT]"
Re: Is Null vs. "",
Marshall Barton
Delete query help,
Opal
Re: How to divide a column,
fredg
Cumulative calculation,
DanielS via AccessMonster.com
Re: I need help,
fredg
<Possible follow-ups>
RE: I need help,
KARL DEWEY
Fields not showing up in design view,
Eric D. Braden
Re: what does this mean?,
John Spencer
MS Access Query Help,
Jordan M.
RE: How can I split this data (GRM219E41H104MA01D+C01) at the + si,
Angel
Re: Multiple Keyword Search,
John Spencer
Re: Weekly crosstab query,
John Spencer
Re: One query returns two different recordsets,
John Spencer
RE: Calculations on selected records from one field,
Jerry Whittle
Re: How can I split this data (GRM219E41H104MA01D+C01) at the + sign?,
John Spencer
How to remove row gaps in report ?,
Andy
Multiple Records 1 Field,
Ripper
Run Query using Multiple Parameters,
eoin . corrigan
Deriving Client Code as Default Value,
p2p
Filling in the gaps,
anniegetyourgun
Nested Queries,
John Ortt
RE: Retrieve Selected Dates from Query,
Duane Hookom
Formula in Query,
Myke
Re: Criteria to search any part of the field,
John Spencer
Running average of yearly ave and monthly data,
btvs6
Re: Change Query Object Criteria via code?,
Allen Browne
Locking on Update Query,
Tom Brown
Update query,
ppc
<Possible follow-ups>
Update Query,
KimTong via AccessMonster.com
Re: Query/Report combination,
John Spencer
Re: Query or Macro???,
Michel Walsh
Re: max no group,
Michel Walsh
Updatable SQL 2000 partitioned view not updatable in Access,
Monty
RE: count decimal places in text string,
Duane Hookom
Extracting one out of multiple query advise,
John
Re: Query Based on Weekdays vs Weekend,
Douglas J. Steele
Employees Pay Rate,
PhilT via AccessMonster.com
Null Value,
CharlesCount via AccessMonster.com
RE: Selecting whole records while using a MaxOf function.,
KARL DEWEY
RE: VBA verbal as a criteria,
Joel
Re: change query's table,
John Spencer
Filling in null data for Pivotchart,
lottaviano@xxxxxxxxxxx
Update query with blank fields,
Mary M
Re: calculations,
Michel Walsh
Aggregate returning 4 "non-aggregate" records.,
Bob Barnes
Running a Parameter Query off more than one Multi-Select list box,
Barkley via AccessMonster.com
Finding a Median,
Eric D. Braden
Re: Two Different Queries used in Report?,
Michel Walsh
Count Within a Range,
Danu
Re: How to format this 206,5 into 206:30h,
Michel Walsh
Re: URGENT - How to convert this decimal values into hours?,
Michel Walsh
Re: NEXT,
Michel Walsh
Selecting part of a filed,
CharlesCount via AccessMonster.com
Access 2002 queries,
Ted H
Re: Multy function field,
Jeff Boyce
Re: Query on a calculated field,
Jeff Boyce
smoothing,
Olivier
Re: Query w/Date & Time in Same Field,
John W . Vinson
RE: Cross Tab Query...Help,
KARL DEWEY
non updatable recorset problem,
Alan B. Densky
Select query problems Access 2003,
Neville MADDEN
24 hour time format conversion,
JAV
Re: Convert yyyymmdd format to dd-mm-yyyy,
Douglas J. Steele
Trouble with autonumber field in a query,
Opal
Re: How to get the historic data from a linked table?,
Michel Walsh
Re: Need Query to Yield Results of Latest Record Input in Each Group,
Jeff Boyce
Re: Counting by groups,
Michel Walsh
Help,
Lisa
Re: IIF function question,
John W . Vinson
Re: Null value question,
Jason Lepack
Re: how to transform 23,1875 into 556:30h,
John Spencer
Need query in hours not days,
Linda RQ
Re: Criteria using values from a table,
Michel Walsh
Re: Create Records,
Carl Rapson
Re: Renumbering a list,
Rob Parker
Re: How to remove seconds (ss) in decimals time,
Stefan Hoffmann
Number of Students Completing a Qualification for a Date Range,
unhinged
Re: Building Expressions,
John W . Vinson
Re: External Database,
Douglas J. Steele
Re: question on combining 2 querries,
Marshall Barton
Re: Hello, I have multiple products, in a query I want to condense to,
John W . Vinson
How to avoid looping?,
timeOday
RE: Error Message When entering data in parameter query (Access 2003),
Help w/Parameter Query
Re: Dlookup with where conditions,
Wolfgang Kais
help date and sum,
e . hermogenes
Re: Finding records with overlapping times,
Allen Browne
Combining an update query with a parameter query,
jenster84
Help with selecting data,
Etta
Finding the top categories in a query,
weazer via AccessMonster.com
Re: delete all queries from a database so I can start fresh?,
Douglas J. Steele
Re: Query Time from Date/Time Field,
Marshall Barton
Parameter Query with List Box,
Barkley
Re: Null,
Marshall Barton
Re: how query multiple fields into one field?,
Marshall Barton
Re: Concatenate numeric and text fields,
Michel Walsh
Re: Linked MS SQL Server Tables,
Michel Walsh
Re: Duplicates in query,
John Spencer
Re: > AVG,
John Spencer
Scoring a complicated validated tool for outcomes research,
Sydneyej
Re: Query not returning results for a text field,
Jeff Boyce
Memo Parameter Field,
Jones
Calculating a QTY discount,
ChuckW
Applicable price on the right date,
Elielson via AccessMonster.com
RE: Date Query,
Scottie
Re: Add a sequential number to records returned by a query,
John Nurick
Export number without decimals,
Bruce
RE: Not showing the & if no Foster Father is present,
Ofer Cohen
Selecting columns containing spaces,
Laurel
Re: Querry Multiple tables,
pietlinden@xxxxxxxxxxx
Re: Query assistance,
John Spencer
Help with query...,
Andrew Meador
Re: Asterisk is automatically added to the end of the query in SQL vie,
Ken Snell \(MVP\)
Re: New Field Data Type Question,
Jeff Boyce
Re: Left Join causes invalid operation,
Marshall Barton
Re: Display a count of unique records in a query in Access 2007,
Jeff Boyce
RE: How does one calculate a percentage on the total in a query?,
Ofer Cohen
IIF Statement Help,
Mike
Re: query to find missing links,
John Spencer
Re: Upsizing to sql 2003,
Michel Walsh
Re: Parameter problem with Report using Crosstab Query.,
John Spencer
Re: Please help - returning strings,
Carl Rapson
Problem with converting Text to Number,
Lance
RE: criteria,
KARL DEWEY
Problem using a crosstab query as a sub query,
Robin9876
Results on Combo Box selection or last update,
SMT
- Re: Results on Combo Box selection or last update,
Marshall Barton
- Message not available
- Re: Results on Combo Box selection or last update,
Marshall Barton
- Re: Results on Combo Box selection or last update,
SMT
- Re: Results on Combo Box selection or last update,
Marshall Barton
- Re: Results on Combo Box selection or last update,
SMT
- Re: Results on Combo Box selection or last update,
Marshall Barton
- Re: Results on Combo Box selection or last update,
SMT
- Re: Results on Combo Box selection or last update,
Marshall Barton
- Message not available
- Re- HELP: Results on Combo Box selection or last update,
SMT
- Re: Re- HELP: Results on Combo Box selection or last update,
Marshall Barton
- Re: Re- HELP: Results on Combo Box selection or last update,
SMT
Re: MS Access Filter question,
Allen Browne
Re: How to return records based on a calculated field,
John Spencer
RE: Monthly transactions in query,
Wahab
Re: Request between week ending date,
Allen Browne
Re: IIF Statement,
pietlinden@xxxxxxxxxxx
<Possible follow-ups>
IIF Statement,
pon
Re: IIF Statement with a twist,
Marshall Barton
Re: match middle initial with middle name field,
John W . Vinson
Re: Passing > or < from a form,
Allen Browne
Re: Calculate Start/End from just Start,
Allen Browne
Re: like,
John Spencer
- Re: like,
sierralightfoot
- Message not available
Re: Filters within Queries,
John Spencer
Crosstab - column names,
jliu1971
Access 2002 Query Question,
Bowtie63
RE: total points then print those that are over a threshold,
Sue
Re: Export Query to Excel,
George Nicholson
Calculate,
Rose
Re: Change Query Field Name,
Ken Snell \(MVP\)
Re: Parse String within Query,
Ken Snell \(MVP\)
cells,
Chi
Re: Removing duplicate rows in a query,
John Spencer
RE: Reference Previous Record,
Whitney
Re: Join Properties,
Michel Walsh
Re: Join 2 tables with unrelated records,
Michel Walsh
Update Table - One field - two expressions?,
bluesky
Re: Passing a Date to a passthrough query,
Michel Walsh
Re: Problem with dates as a parameter,
Allen Browne
Re: "Smart querying" to speed up?,
Rick Brandt
Re: Using a Query to Get Heads of Households,
John W . Vinson
Re: Query to return 4 records per table record,
John W . Vinson
Move Column data to row data,
TSG
Random Selection with a Twist,
Craig
Re: Overflow,
George Nicholson
Re: Access 2003 Query design,
John Spencer
Re: Concatenate Date,
Michel Walsh
Re: Count of Affected Records,
Michel Walsh
Re: Query too large,
Michel Walsh
Re: duplicate in 2 locations,
Michel Walsh
RE: Expression to identify the greatest dates for a one-to-many relati,
Steve McLeod
Formula,
David F
Nested Iif,
mbr96 via AccessMonster.com
Help Please - Update Query,
TotallyConfused
DateDiff function,
ironwood9 via AccessMonster.com
Using the random function,
Aaron
Re: upsizing to sql 2005,
Michel Walsh
- Message not available
- Re: upsizing to sql 2005,
Michel Walsh
- Re: upsizing to sql 2005,
Dee
- Re: upsizing to sql 2005,
Michel Walsh
- Re: upsizing to sql 2005,
Dee
- Re: upsizing to sql 2005,
Michel Walsh
- Re: upsizing to sql 2005,
Dee
- Re: upsizing to sql 2005,
Michel Walsh
- Re: upsizing to sql 2005,
Dee
- Re: upsizing to sql 2005,
Michel Walsh
- Re: upsizing to sql 2005,
Dee
- Re: upsizing to sql 2005,
Michel Walsh
- Re: upsizing to sql 2005,
Dee
- Re: upsizing to sql 2005,
Michel Walsh
- Re: upsizing to sql 2005,
Dee
- Re: upsizing to sql 2005,
Michel Walsh
- Re: upsizing to sql 2005,
Dee
- Re: upsizing to sql 2005,
Dee
- Re: upsizing to sql 2005,
Michel Walsh
- Re: upsizing to sql 2005,
Michel Walsh
- Re: upsizing to sql 2005,
Dee
- Re: upsizing to sql 2005,
Dee
- Re: upsizing to sql 2005,
Michel Walsh
- Re: upsizing to sql 2005,
Dee
- Re: upsizing to sql 2005,
Michel Walsh
Complex query, do I use union?,
Julia Boswell
Re: Add a digit in a number,
Pieter Wijnen
Re: How to copy multiple queries between .mdb files?,
Pieter Wijnen
Re: What criteria to use to extract #Error messages in a query,
Pieter Wijnen
RE: When I open design view in a query I get "is not a valid name.,
Ben M
Re: Parameter query syntax error,
John Spencer
Access Databases merging when syncing PDAs with Handbase,
JonJCurry
Column Number as parameter in Query to select data,
Max
Referencing a "calculated" column,
Bob Howard
Re: Percentage Calculation,
Dale Fye
Re: PIVOT table query ?,
Dale Fye
Re: Design Updateable Query,
John W . Vinson
Re: Count date only one time per occurance,
John Spencer
user parameter - user to enter one or more values,
Mitchell_Collen
Re: Nested Conditional Statement Using Nulls,
Michel Walsh
Re: Limiting results from one side of a join conditionally,
Michel Walsh
Re: Nested Conditional Statements,
Michel Walsh
Data Changing Issue,
Karen
Re: Could not delete from specified tables problem,
John Spencer
query to extract the portion of text of fields in a Table,
Fuzuy
Re: Group by for quartiles,
Michel Walsh
Re: Using a list box inside a query,
Ken Snell \(MVP\)
Re: Query condition,
Ken Snell \(MVP\)
Re: Query condition,
John Spencer
SQL help please,
Visitor
Re: strange query sort behaviour,
Allen Browne
Re: Query Design Grid doesn't show.,
Marshall Barton
Re: Run-Time Query Parameters,
Ken Snell \(MVP\)
Re: Bringing Multiple Queries Together in One Query,
Ken Snell \(MVP\)
Re: SQL syntax for query items to delete,
John Spencer
Re: duplicates,
Wolfgang Kais
Problem with date format??,
Proko
RE: Running sum,
Ken Sheridan