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
two variables,
margaret
Deleting emails,
Chrissy
Reporting an Average,
pushrodengine via AccessMonster.com
Sorting a query with a twist,
Opal
Re: Sequential numbering in Access 2007,
Rick Brandt
Re: Query help,
Douglas J. Steele
Caculating the Difference in Time in a Query,
pushrodengine via AccessMonster.com
Re: MS Access and expression web,
Douglas J. Steele
Re: Most recent record,
Jeff Boyce
Query help please,
steveinbeloit via AccessMonster.com
- Message not available
- Message not available
How can I reference a value from a previous record?,
Access''03_NewUser
Re: Query Formatting Data on export,
Ken Snell \(MVP\)
Question about some criteria language,
chesneydevine@xxxxxxxxx
RE: Make Table Query, Question....,
T Miller
Combining 3 queries,
Lissa
records in current month,
alecgreen
Re: Union Query Help,
Jeff Boyce
Average within Query,
pushrodengine via AccessMonster.com
RE: Creating Multiple Entries from Numeric Field,
Gary Dolliver
Month on Report,
Ray via AccessMonster.com
Re: How to join two fields by filling in Null values???,
Marshall Barton
Re: Stupid Inner Join...,
John Spencer
Re: list of numbers between range,
fredg
Re: Formatting issue,
Carl Rapson
- Message not available
- Re: Formatting issue,
Carl Rapson
- Re: Formatting issue,
John Spencer
- Re: Formatting issue,
Sue
- Re: Formatting issue,
John Spencer
- Re: Formatting issue,
Sue
- Re: Formatting issue,
John Spencer
- Re: Formatting issue,
Sue
- Re: Formatting issue,
John Spencer
- Re: Formatting issue,
Sue
- Re: Formatting issue,
John Spencer
- Re: Formatting issue,
Sue
- Re: Formatting issue,
John Spencer
- Re: Formatting issue,
Sue
- Re: Formatting issue,
John Spencer
- Re: Formatting issue,
Sue
How to join two fields by filling in Null values??,
JohnnieWalkerESP
Re: what is the escape char to be used in access queries ?,
John Nurick
Calculating the Difference in a Query,
pushrodengine via AccessMonster.com
Re: Queries not retrieving the required data,
Jeff Boyce
Re: Create a new table each time...,
Jeff Boyce
- Message not available
- Message not available
Calculated Field in Not Recognized in Function,
TR
Re: Converting concactenated fields to date,
John Spencer
Re: Date Question,
Marshall Barton
Re: Extracting Month and day from Date field,
Marshall Barton
Grouping query help,
Bdavis
Re: excluding certain values from a query,
Michel Walsh
Re: Queries,
Michel Walsh
Re: Grouping & Filter Data With Queries,
John Spencer
Grouping Data in a Query,
Curtis Stevens
Re: yet another remove duplicates question,
Michel Walsh
Re: Update SQL,
Allen Browne
Re: Selecting criteria in a Query,
John Spencer
dates in queries,
agrillot via AccessMonster.com
Re: Similar / Fuzzy "Match" Logic,
John Nurick
Query,
Beto1967 via AccessMonster.com
Maximum but one less,
GRIFFO
Re: Union Query,
Rob Parker
Re: #Error - possible Reference Library omission?,
Allen Browne
Creating a Query in code.,
Thomas
Re: Multiplying in a Query,
pietlinden@xxxxxxxxxxx
Re: Query - Randomly Selecting Records from Table,
John Spencer
Re: Make Table Query,
John W . Vinson
Balance Comparison Query,
Natalie
Re: Running a query on items selected from a list box.,
Ken Snell \(MVP\)
select statement results msgbox,
ToniS
calculations not coming out right... ASAP!,
stephendeloach via AccessMonster.com
Re: Using a Public Function as Criteria?,
Michel Walsh
Grouped query - last function , how is working ?,
Imre
Re: How to exclude certain records,
John W . Vinson
Re: 3 conditions in a select query thats populating a newly created fi,
John Spencer
Re: Query question,
Michel Walsh
Re: "Invalid scale" error during Crosstab,
Michel Walsh
how to match null values in JOIN ON,
jliu1971
Query Help Request,
jcrouse1
Re: New column on redundant field,
Allen Browne
adding empty spaces to fields?,
Jerome
criteria default value?,
Poida3934
Re: IIF Query?,
pietlinden@xxxxxxxxxxx
Tracking missing records,
c8tz
Dynamic query problem,
maceslin
RE: % of total,
KARL DEWEY
Re: How do I make each column UCase in a query,
Marshall Barton
Does an Update query do this?,
Zoomiest
Re: IIF in Query,
Marshall Barton
Re: Simple SELECT problem,
Ken Snell \(MVP\)
Re: dlookup,
Michel Walsh
Re: Query speed that changes,
Ken Snell \(MVP\)
Re: Query design,
John Spencer
Re: Replace in the middle of a string,
John Spencer
Re: Add multiple records to one field,
Michel Walsh
Networking,
stephc1959@xxxxxxxxxxxxxx
Re: right string problem,
mbc04
Re: UPDATE QUERY HELP REQUIRED,
Michel Walsh
Re: Extract data within past 2 years of todays date,
Allen Browne
query construction,
klp via AccessMonster.com
Re: How to combine summed fields,
Michel Walsh
Re: Query to Find the "last play date",
Stefan Hoffmann
Re: Finding a Missing Date,
Jeff Boyce
Re: Update Query and record lock violations,
John Spencer
Select criteria based on the field name the user selects,
Raj
Cann't update the value in table,
Dou
Re: How to automate running and outputting query results,
John W . Vinson
Query works-Export fails "...you and another user are attempting to change the same data...",
jeff
Query with two Tables with date filed for Date Range,
Rag742
Re: Query non-updateable when composite key field used.,
Van T. Dinh
complex query? how to ONLY display the set of data,
~ angel ~ via AccessMonster.com
Re: Wrap SQL for VBA,
Roger Carlson
Re: How to delete records from a querie,
John Spencer
RE: Using Checkbox as Multi-Selection in Form Query,
Fizzlesquirt
Re: Query problem,
Ken Snell \(MVP\)
Re: How do I delete out part of a field in Access?,
Ken Snell \(MVP\)
Re: Nz Function,
Ken Snell \(MVP\)
- Message not available
- <Possible follow-ups>
- Re: Nz Function,
fredg
- Message not available
- Message not available
use of autonumber,
Jesse
Re: Thumbnail in Photogallery not working,
John W . Vinson
Re: Null fields,
Allen Browne
Re: Update conected MSSQL Table with DATESERIAL(DATEPART .. crashes AC,
John Spencer
Re: Multiple Entires in a record,
John Spencer
Search by date,
wesley.allen@xxxxxxxxx
RE: Using field list as criteria to select records,
Klatuu
data type mismatch in criteria expression,
scubadiver
Re: Replacing a value in a field which exists in more than one table,
Jeff Boyce
Re: Comparing 7 tables ?,
John Spencer
Re: negative values to be returned as zero,
Van T. Dinh
Top 5 records per group,
Jay
Profiling Members - please read.,
pilch74@xxxxxxxxx
Re: Adding currency fields together,
John Spencer
Re: Iif expressions,
John Spencer
Re: My update query will not update. How do I trust it?,
tina
- Message not available
- Message not available
Re: Days from Today calculation in query,
raskew via AccessMonster.com
RE: Table fields of type MEMO are chunked 'cause of DISTINCT,
Peter
Re: How to remove 0 from the text,
Marshall Barton
Date calcualation,
Scott
Eliminating Duplicate Fields,
FJ Questioner
Need help to create a query,
Marco Silva
SQL that returns every record twice,
Aino
Re: Top 3 Query Help,
Allen Browne
Re: select query not null,
Allen Browne
Re: "OR" trouble.,
John Spencer
Re: Dlookup syntax in a subform,
Ken Snell \(MVP\)
Re: Version Difference,
Jeff Boyce
Re: Problem with a field for a combobox,
Jeff Boyce
Date manipulation,
NetworkTrade
RE: querying partial text in a field,
KARL DEWEY
Exporting Data From Query Into Excel,
Ronald Dodge
Re: Change Rows into Columns,
Michel Walsh
Table and Query,
reysmommy
Adding Records to a table with append query,
wesley.allen@xxxxxxxxx
Query with two date field for Date range,
Rag742
Re: Medium Time format showing seconds,
John Spencer
Re: Null result,
Michel Walsh
Re: Initials From Single Field,
John Spencer
- Message not available
- Message not available
Re: greater than certain date,
John Spencer
Re: Query to Count Consecutive days?,
Michel Walsh
Re: add criteria to field that is based on named field,
Gary Walter
Re: Anything beginning with "aim",
Jeff Boyce
Queries Help Please,
germ-X
A simpler way to do a pseudo-autonumber in a query,
Conan Kelly
Re: Multiple lines in a field,
John W . Vinson
Re: Criteria for selecting a string,
John W . Vinson
Re: validation rule in query?,
J_Goddard via AccessMonster.com
RE: relationship,
KARL DEWEY
Re: Combo Box Help,
Jeff Boyce
Multiple values in criteria field,
colettelamm@xxxxxxxxx
Re: VBA code in query for new field?,
John Spencer
Re: Totaling a query,
John Spencer
I need to make shift entry optional,
bhrosey via AccessMonster.com
how to format date to have a specific format,
Marco
Re: Moving data into a new table once selected from a form,
vandy
how to create item numbers column in a Query Options,
mezzanine1974
prompted twice for parameters when running query,
Dom Sturges
Re: Update query and using two tables in dcount statement,
Ken Snell \(MVP\)
Create union query,
shiro
Re: Change data in a query, locked?,
John Spencer
order with strings and numbers,
Lars
Duplicated date,
mohsin via AccessMonster.com
changing the decimal to hex,
mohsin via AccessMonster.com
Re: Access 2002 Query,
Marshall Barton
- Message not available
- Message not available
vb variables,
jnewl
Re: Database that has field that contains multiple values,
Jeff Boyce
Re: Carrying Out Decimals,
Jeff Boyce
Help with query,
alecgreen
Re: Update Query w/user input, Need to add a formula.,
George Nicholson
RE: please help with a query,
Alex
Re: Multiple tables with same fields,
Michel Walsh
Re: Data Fields the same, but not giving any results,
Ken Snell \(MVP\)
Ambiguous outer join,
Laurel
Query based on field in form, not working in 2007,
Martin Edwards
Cannot join on Social Security Num,
Flick Olmsford
Re: IIf Statements,
Michel Walsh
UNION QUERY (Sorting),
DS
UNION SELECT Problem,
DS
Re: Use of "In" in parameter queries,
Jamie Collins
Re: Most Recent Date,
Gary Walter
Re: Trimming a cell, remove "space character",
Gary Walter
Converting some fields to columns,
aine_canby
Joining fields into one field dependent on value of another field,
c8tz
How to Create a Dynamic Query,
Beto1967 via AccessMonster.com
Need help with quote marks in a query,
rich
RE: Sorting by Distinct Month,
KARL DEWEY
Whay does an update CRASH Access?,
OceanView
RE: #Name? What does this mean?,
Jerry Whittle
Re: Add Column to a Table,
Michel Walsh
Elapsed time between two dates,
KBJ
Problem with update query, values come from Master & sub-form,
rich
CDate and gloabal date settings,
Sierras
RE: Duplicates in Queries,
Klatuu
Re: Find most recent date,
Marshall Barton
Re: Insert query with null column and null value,
John Spencer
RE: how do i list values within a given range?,
S.Clark
RE: Replacing special characters,
Klatuu
Query to get the last record,
DaranVector
Re: MORE SQL Insert in VBA,
Allen Browne
RE: Data mismatches between tables not being identified,
Nuno Bento
Re: Counting Workdays Function,
Michel Walsh
RE: Count Work Days,
Octet32
Re: Text To Columns in Access,
MacNut2004
RE: I am having trouble creating a report,
Jerry Whittle
Count(*) with different period,
Tschuß
RE: Query and Duplicate Rows,
Jerry Whittle
query for printing,
RogerTE
query multiple tables with identical column names,
Dsperry101 via AccessMonster.com
Re: countif Access 2000 - counting the number of values above 0,
Allen Browne
Re: Query Results Next to Each Other :),
ant1983
Re: Subtracting Dates,
John W . Vinson
how is "FIRST" supposed to work,
Jesse
Re: Graphical Union-Query Builder?,
Rob Parker
RE: Update a single record,
Dan
Re: What is Subscript out of range in MSACCESS?,
George Nicholson
Re: Filtering Queries,
Marshall Barton
Re: Assign the result of this simple query to a variable,
fredg
RE: SUBSTR in query,
KARL DEWEY
RE: Subtracting 2 query fields in another query,
KARL DEWEY
Help with DOB formula.,
Debbie
The need for speed,
Jonathan
Query Formula error. Help!,
Debbie
RE: Conditional update of field based on the same field in previous re,
KARL DEWEY
Re: SUM IN QUERY PRODUCES 2.273737E-13,
John Spencer
Re: Elapsed Time Module Question,
Marshall Barton
Using the Like operator with a perameter query,
RaFranklin
Re: SQL Insert in VBA,
Ken Snell \(MVP\)
Dynamic "IN" criteria in query,
ITistic
Not enough space on temporary disk,
Robin9876
Re: Search for string anywhere in string,
fredg
Re: find oldest person living at an address,
Jeff Boyce
Re: IIf statements with AND criteria,
Gary Walter
Re: Problem with Concatenate Function,
BruceM
Re: Form Based Parameter Query,
Bill
Re: HOW TO USE NOT LIKE EXPRESSION,
Jamie Collins
Grouping and Aggregating Data in Jet SQL,
Ronald Dodge
Re: Snapshot is not "Read Only",
John Spencer
Re: changing only the year in date field,
Jamie Collins
Re: Query sometimes creates its own [useless] expression??!!,
Gary Walter
RE: nested select/union select without referenced table-without quote-,
Andy Hull
Re: nested select/union select without referenced table,
AccessVandal via AccessMonster.com
Select Part of field,
SR
Duane Hookom Concantenate error,
jeff
- Re: Duane Hookom Concantenate error,
Marshall Barton
- Re: Duane Hookom Concantenate error,
jeff
- Re: Duane Hookom Concantenate error,
John Spencer
- Re: Duane Hookom Concantenate error,
jeff
- Re: Duane Hookom Concantenate error,
John Spencer
- Re: Duane Hookom Concantenate error,
jeff
- Re: Duane Hookom Concantenate error,
John Spencer
- Re: Duane Hookom Concantenate error,
jeff
- Re: Duane Hookom Concantenate error,
John Spencer
- Re: Duane Hookom Concantenate error,
jeff
- Re: Duane Hookom Concantenate error,
John Spencer
- Re: Duane Hookom Concantenate error,
jeff
- Re: Duane Hookom Concantenate error,
John Spencer
- Re: Duane Hookom Concantenate error,
jeff
Combining two tables and separating duplicates,
susanohkwon
Re: How to count number of Wednesdays between two dates,
Michael Gramelspacher
Re: Removing NEAR duplicate results,
sharpie23
select distinct id with other data,
Mario Krsnic
