microsoft.public.access.queries
- RE: so lost,
Lost
- Query between dates not using >= correctly,
Mike
- RE: Using a New Function in a Query,
Duane Hookom
- Message not available
- Message not available
- RE: Using a New Function in a Query,
Tom
- RE: Using a New Function in a Query,
Klatuu
- RE: Using a New Function in a Query,
Tom
- RE: Using a New Function in a Query,
Klatuu
- RE: Using a New Function in a Query,
Tom
- RE: Using a New Function in a Query,
Klatuu
- RE: Using a New Function in a Query,
Tom
- RE: Using a New Function in a Query,
Klatuu
- RE: Using a New Function in a Query,
Tom
- RE: Using a New Function in a Query,
Klatuu
- RE: Using a New Function in a Query,
Tom
- RE: Using a New Function in a Query,
Klatuu
- RE: Using a New Function in a Query,
Tom
- RE: Using a New Function in a Query,
Klatuu
query results,
jomara via AccessMonster.com
need to concatenate field,
johnboy7676
LEFT JOIN and WHERE clause,
Ian Chappel
Re: LEFT JOIN and WHERE clause,
John Spencer
Re: LEFT JOIN and WHERE clause,
John W . Vinson
Re: Need help creating a counter,
Michel Walsh
Re: Update-DateField to 2nd Thursday,
John Spencer
Re: Left Join & Inner Join,
Jeff Boyce
A2000: group detail records by customer,
A Man
Re: Inner Join with SQL,
John Spencer
Re: Without attachments,
Allen Browne
Re: grouping by using a word contained in field,
Marshall Barton
RE: Globally change part of a field,
KARL DEWEY
Re: Invalid use of null,
Conan Kelly
Append Query problem,
Jeff
Re: Dlookup problem with date..,
Jeanette Cunningham
RE: Using text in a Form to run a Query,
Jerry Whittle
Re: MS Access 2003 Query error,
rkb
query problem,
richaluft
RE: Date Conversion,
KARL DEWEY
random incomplete query results,
FM
Re: query date,
Conan Kelly
Re: Looking for LATEST DATE,
Michael Gramelspacher
Re: Select Query,
Conan Kelly
#Error Help Needed,
mattc66 via AccessMonster.com
RE: Selsct Query Problem,
KARL DEWEY
Re: part of string,
Marshall Barton
Find duplicates query not working.....,
HughMcMenamin via AccessMonster.com
Re: Replacement Query,
John Spencer
Re: Rounding errors,
Allen Browne
Re: Dates without weekends,
Michael Gramelspacher
Re: lost joins in frontend,
Jeanette Cunningham
Re: Grouping by Time,
Stefan Hoffmann
Re: Change column headings in crosstab querry,
Conan Kelly
Running total in query,
dje
Selecting records using GROUP BY,
Jason
calculating running total of a field in a query,
SMT
Max value in Query,
Ted
Unique record,
Cam Evenson
Adding two days of data on one row,
Nick Anderson
SELECT statement syntax confusion,
noe1818 via AccessMonster.com
Case Statement with the Between Date function,
Mitchell_Collen via AccessMonster.com
Re: Help with query searching within a string,
Jeff Boyce
Re: Date issue,
Jeff Boyce
dlookup with 3 criteria,
noe1818 via AccessMonster.com
RE: 6 Month Rolling Average in Query,
Natalia
Zero length String?,
Bongard
If Then. Maybe?,
RedHeadedMonster via AccessMonster.com
DLookUp with 2 criteria problem,
noe1818 via AccessMonster.com
Re: TOTAL column in query,
Michel Walsh
Re: split data problems,
Michel Walsh
Re: Running sum running by date order,
Michel Walsh
Is Not Null?,
Tony Williams
Re: Select records based upon date,
Jeff Boyce
Date -Data Type,
D
Re: Getting ALike instead of Like,
Gary Walter
Re: DatePart Function in Reverse!...,
John Spencer
Query calculated field based on another query,
gmcco
Re: question about multiplying,
John W . Vinson
Re: calling function as part of criteria,
Marshall Barton
Re: Time Averages/ Time of Day and Minutes,
John W . Vinson
Need help in some queries code,
nicpkh via AccessMonster.com
Re: IIf function for 3 possible outcomes?,
Rick Brandt
Query Left Command Help,
mattc66 via AccessMonster.com
text field to date field field,
andyb
Strange query results/Wild characters???,
Marco
Re: Record is deleted error,
Gary Walter
Re: Left function in Access,
fredg
Re: Numbering Records with sort,
Marshall Barton
Re: Convert Unix timestamp to Access 2003 data field,
Marshall Barton
Re: Query Text in the Mid of a memo,
Marshall Barton
Re: Looking for date field that is empty,
Jeff Boyce
converting text to %,
Ted
Re: multiple criteria selection,
John W . Vinson
DateAdd Working Day Query,
hobbit2612 via AccessMonster.com
Re: How to query data on monthly basis,
John W . Vinson
Len([field])<9 return records with values of 10,
Mike
Multiple records for one parameter,
MNJoe
RE: Query sorting help,
Darren
Re: Order by ignored after upgrade from SQL Server 2000 to 2005,
Stefan Hoffmann
Re: Numbering Records,
Michel Walsh
Re: Link new records to old ones,
Michel Walsh
Re: numbering records according to date and ID,
Allen Browne
Re: Updating a field's data to another field in same table???,
Allen Browne
Re: Cascading delete reports?,
Allen Browne
Re: Budgets v/s actuals,
John W . Vinson
Many to Many Headaches,
TonyT
Delete based on another table,
Song Su
Re: "like" and "*" problem,
Rick Brandt
Re: Query to get everyone not in table,
Marshall Barton
crosstab query question,
Alan B. Densky
AND on 2 fields along with other criteria in query,
William R. Hess
RE: Append to Append Query,
Duane Hookom
Re: Averaging values taken every 30 seconds into 5 minute intervals,
Amy Blankenship
Re: Quesry criteria,
Ken Snell \(MVP\)
Re: Pull Specific Data by Previous Month's Date (Date Entered via prom,
Conan Kelly
Re: Query is too complex,
AlwaysFroosh!
<Possible follow-ups>
Re: Query is too complex,
AlwaysFroosh!
Re: Counting,
John Spencer
Re: String Manipulation help needed,
John Spencer
Re: Help with query,
John Spencer
Re: Another Check Box Question,
John Spencer
- Re: Another Check Box Question,
Teresa Anderson
- Re: Another Check Box Question,
John Spencer
- Re: Another Check Box Question,
Teresa Anderson
- Re: Another Check Box Question,
John Spencer
- Re: Another Check Box Question,
Teresa Anderson
- Re: Another Check Box Question,
KARL DEWEY
- Re: Another Check Box Question,
Teresa Anderson
- Re: Another Check Box Question,
KARL DEWEY
- Re: Another Check Box Question,
John Spencer
- Re: Another Check Box Question,
Teresa Anderson
- Re: Another Check Box Question,
John Spencer
- Re: Another Check Box Question,
Teresa Anderson
Re: delete duplicate record,
Allen Browne
Re: Records in a query between a one-many rel. not allowing data entry,
MGFoster
Calculations based on varying number,
Ann
RE: 2-step Inventory List Generator,
wwojtale
change a zero's to null in a table ?,
Haggis
RE: syntax for query to bring only one result per AccountNo,
KARL DEWEY
Query is making a nuts,
Craig
Re: return all records, regardless of fields matching,
Rob Parker
- Message not available
- Message not available
RE: Group by & Sum,
Duane Hookom
RE: query on multiple tables,
harleyken
RE: Query Problem - Relationship?,
rolaaus
Re: Calculating diff btwn two dates how to count only business days,
raskew via AccessMonster.com
another fieldname problem,
richaluft
RE: Adding record number to existing table,
argear
changing an ID to a user friendly name,
Harold Good
Re: Duplicate records based on Multiple Fields,
John Spencer
Return Day of week,
Mo
Query Not Updating,
Ryan
Re: Is there a Date Time Conversion from text?,
John Spencer
Re: confused about LEFT JOIN and RIGHT JOIN,
Jeff Boyce
Re: Combos and text boxes,
John W . Vinson
RE: update ... grouping ... replace ????,
Ron
Trying to round up,
carlo
Re: maximum record,
Conan Kelly
invalid parsing,
richaluft
Re: Criteria for 'Pairs',
MGFoster
Re: Vlookup,
Allen Browne
RE: UNION query and Data type mismatch in criteria expression,
KARL DEWEY
RE: Another tricky selection query,
DKS
a tricky selection query,
Howard
Re: How to detect the same substring,
John Spencer
Re: Running a query that totals my Columns,
John Spencer
Re: Return comination of Current record and next record fields,
John Spencer
RE: Use of normalised information,
Ulto
Riddle me this you wizards,
knowshowrosegrows
Convert From Column to Row (Record),
banker123
Re: Null like "*" [Perameter] "*",
Amy Blankenship
Alias Circular Reference Problem,
Gribley
Re: Highlight keywords in result of perameter query,
John Spencer
RE: Displaying query from a form,
Duane Hookom
RE: Replace null value with the previous value?,
Klatuu
Beginner's Append Query Problem,
p . numminen
DateDiff partly failing,
Robbin
Append Query Baffling Me!,
croy
IIF statement run amuck,
RedHeadedMonster via AccessMonster.com
Re: transaction and rollback,
Allen Browne
NOT...IN subqueries returning no records,
Trimtrom
Re: looking for help with a time clock query,
John Spencer
Re: Help Please! Need to set up query,
John Spencer
Re: dsum in query,
Gary Walter
Re: Delete Old Duplicate Record,
Jeanette Cunningham
Re: DateDiff question,
Marshall Barton
Re: Need help writing an update query,
John W . Vinson
Re: Auto update query,
John W . Vinson
Re: Display Query from form in Foreground,
fredg
Is my query too complex?,
Roses'' HelpDesk
RE: Complex Query,
Ron
RE: Compile error in Query Expression,
NetworkTrade
Re: Acc2002: Crosstabs: Column header length limit?,
George Nicholson
Question,
Joan Tunick
Using parameter in query to specify null/not null records,
Amy Blankenship
Passing the output of a query to a table,
Mark
Re: Dislaying data from top to bottom to left to right?,
Michel Walsh
Calculate a daily rate,
nybaseball22@xxxxxxxxx
Total unique fields,
Cathy C
How to obtain a spreadsheet-like table - Rookie,
Marcus
Re: Calculating Problem,
MGFoster
Re: Update table,
John W . Vinson
Do you MoveNext after Delete,
Robert
Need helps on my union query,
henry
RE: Compare to tables and add recordsmissing in main table,
RoBo
Re: Delete Queries from an Unmatched query,
John W . Vinson
Re: concatenate while grouping,
KaCee
Re: Trouble with union qry,
Marshall Barton
Re: How do I insert a coloured symbol in an Access field please?,
fredg
Re: Strconv function,
fredg
Concatenating or embedding wildcards in SQL LIKE,
vjp2 . at
updating a query with data from a table,
wendy
Re: More understanding of the Join type,
Allen Browne
RE: Mutliple Complex Queries - How to Combine into One Result/Report?,
Ron
Re: SQL string longer than 255 characters,
Rick Brandt
Problem with .addnew,
LaurieTuff via AccessMonster.com
RE: nested query hell,
Ian
Re: Total clients ages by year,
John W . Vinson
Re: Retrieve,
John W . Vinson
RE: PAYROLL PUZZLE - LOOKUP WITHHOLDING TAXES,
Ron
Need to get result of a select query in code,
Robert
- Re: Need to get result of a select query in code,
John W . Vinson
- Re: Need to get result of a select query in code,
Robert
- Re: Need to get result of a select query in code,
John W . Vinson
- Re: Need to get result of a select query in code,
Robert
- Re: Need to get result of a select query in code,
John W . Vinson
- Re: Need to get result of a select query in code,
Robert
- Re: Need to get result of a select query in code,
John W . Vinson
- Re: Need to get result of a select query in code,
Robert
- Re: Need to get result of a select query in code,
John W . Vinson
- Re: Need to get result of a select query in code,
Robert
- Re: Need to get result of a select query in code,
John W . Vinson
- Re: Need to get result of a select query in code,
Robert
Re: Crosstab query,
Stefan Hoffmann
Using different form strings to filter,
nybaseball22@xxxxxxxxx
Re: Monthly Totals with a Subquery,
Robert
Running Total in Queries,
dje
Copying using recordsets to new records,
Robert
Works with runsql but not with .Execute,
Robert
Re: Duplicate date records,
Allen Browne
Re: Mark Records in a Table,
fredg
Re: Due date query,
John W . Vinson
Re: DSUM(),
Allen Browne
Re: Any date Last Year,
Rick Brandt
Re: Average (),
John W . Vinson
Denormalizing question response data,
Amy Blankenship
RE: Custom sort order,
Billy Rogers
Re: Combo Box executing query, issues,
John Spencer
Re: counting problem,
John Spencer
Re: Specific Age Query for a Date Range,
Douglas J. Steele
Re: How do I generate an e-mail list from Access 2007?,
John W . Vinson
Re: Append/Update Query,
John Spencer
Re: Looking for Non-records...?,
Jeff Boyce
Re: Pass Through Query / Make Table,
excel/access-chump
Error: Cannot use the crosstab of a non-fixed column as a subquery,
ChuckW
Re: Different response times...,
MGFoster
Re: Retrieve a list outside the subset list,
MGFoster
Count numbers of logins - with names,
SpookiePower
Re: Max across columns?,
Allen Browne
Re: Creating an End of Year total Query.,
Arvin Meyer [MVP]
Re: My query works, but won't open in design view - any ideas?,
Kamikaze
showing only unique records,
namsilat
Re: query returns no records, need to convert to "0",
Allen Browne
Repost : Mission to populate record through a make table query,
rahmad
Re: Custom Function? Another Method?,
John W . Vinson
Re: INDIVIDUAL INQUIRES,
John W . Vinson
Re: 20080105,
John W . Vinson
Re: Access querry,
John W . Vinson
Re: Query for Parent containing only ONE type of child,
Douglas J. Steele
Message not available
Message not available
New to Access, need some help with a query,
Soupguy
Re: Using different data types in a query equation,
John W . Vinson
Re: How do I find organizations with no members?,
John W . Vinson
RE: Strange results,
Jerry Whittle
Re: Rows and Columns,
John W . Vinson
Re: SQL needed for tricky query,
Marshall Barton
Re: round a date,
raskew via AccessMonster.com
Re: Return a value from another table,
John Spencer
Query Help Needed,
ipower2 via AccessMonster.com
One to Many Lookup,
rollvoer99
Re: Return Uniques,
John Spencer
Re: Need to remove all punctuation,
raskew via AccessMonster.com
Re: sub query,
Allen Browne
Re: "Subtracting" from query?,
Armen Stein
Query on Blank Date,
yonggie
Re: How do I query companies not having members w/certain level of mgm,
Jeanette Cunningham
Date Issues - Help!,
Samantha
Re: Rerun an open query in Access 2007,
Allen Browne
User input Criteria,
mattc66 via AccessMonster.com
Re: Event Management Database Template,
Jeff Boyce
How can I time long running queries?,
Conan Kelly
RE: using IIF to determine form state,
Dale Fye
Re: relates to previous question regarding memberships cards and intia,
John W . Vinson
Re: Query Filter using Not In,
Michel Walsh
Re: Query,
John Spencer
RE: Rank Order Exceptions,
KARL DEWEY
Update oldest first,
jbiggs via AccessMonster.com
RE: Count Null Values Per Field,
Jerry Whittle
Trying to pull the top number of vists AND the assocaited user's name by client,
adamctaylor
Re: Postal Code,
Roger Carlson
- Message not available
- Message not available
RE: Look up field in a table is not showing first row,
Jerry Whittle
Re: Excel statement that I want to replicate in MS Access as a Query,
Lotto
Invalid data on Left Join query,
Nunya
Running Sum,
Lotto
Re: Count,
Chris Anderson [MVP-VB]
RE: How do I add decimals to crosstabs in Access?,
Dale Fye
IIF Statement Definition,
NeonSky via AccessMonster.com
dica,
Suporte Metanet
Re: Need to see everything in field except the last two characters,
John Spencer
Re: More understanding on linking table and make a grid query,
John W . Vinson
Re: Changing format on calculated field in a query,
John Spencer
Re: query to find difference in record sets,
Michel Walsh
Filtering out a time range,
KK
- Message not available
- Message not available
DISTINCT ROW help needed,
magmike
Consecutive Query,
NeonSky via AccessMonster.com
Re: Crosstab subcolumn query/report heading pblm,
Gary Walter
Re: SQL "IN" operator,
John Spencer
Re: Union Query Truncates Results?,
Rob Parker
Mission impossible....????,
rahmad
Re: Calculate work days and not weekends,
raskew via AccessMonster.com
Re: Report Query Subreport Queries,
Allen Browne
I need a xtab query to show zero months.,
Frank Martin
Re: lookup all values against all values only gives me one value back?,
Michel Walsh
Re: Changing a formula,
Marshall Barton
Operators and Drop Down,
misschanda via AccessMonster.com
Left join query produces invalid results,
Nunya
Re: need help with calculating fields,
Marshall Barton
Re: Create new table with current date part of the name using sql,
Jeff Boyce
COUNT DISTINCT problem,
PatdeLux
Re: Crosstab dual columns?,
Michel Walsh
Query - Exclude Time,
Sean
RE: insert, append from form to table,
Steve Sanford
RE: Difficult query?,
scubadiver
Re: query by date,
Jeanette Cunningham
Re: query from combo,
Jeanette Cunningham
Re: Limiting Query Results (to only certain days of the week),
John Spencer
Joining Multiple Queries,
dje
Re: How to selectively insert data in fields,
Stefan Hoffmann
Re: Show all fields from table in select query ?,
Allen Browne
Re: Query with alphabet,
Douglas J. Steele
Re: Boolean in Query,
Jeanette Cunningham
syntax for WHERE NOT IN?? to locate orphaned records,
pgcn
Getting Multiple Queries to work,
Ron
Key Violations My Wits End,
tbrogdon
Adding data in Queries,
Quinto via AccessMonster.com
Re: Discussion Threads - Sorting,
Jeanette Cunningham
Re: Searching using an address String,
John Spencer