microsoft.public.access.queries
Re: syntax error at or near "{" at character 86(#-1),
David Lloyd
Re: Goofy Query behavior,
Michel Walsh
Re: Organize queries into folders.,
Rick B
Re: count how many records are true,
Chaim
Formatting Phone Numbers,
Dale
Re: query with many criteria,
Tom Ellison
Re: Query databased Result,
Van T. Dinh
Re: dlookup syntax problem,
Van T. Dinh
RE: Problem with a query that concatenates field values,
'69 Camaro
Re: How do I query the same field from different tables,
Tom Ellison
UPPER CASE to Proper Case,
Dale
Duplicates Query... Help Wanted,
Dale
Re: Formatting Phone Number,
Dale
Time Stamp Records,
Dale
Query not returning all the records I need.,
upsman via AccessMonster.com
Re: Sort error in query - record is deleted,
MGFoster
Re: Need a query to find all records with ONE keyword,
Phil
Update and insert a increment number,
gv
Append Query to Create Repeated Records in Table,
bmsc
getdate conversion,
gv
Re: How CDate() determines century,
MGFoster
Re: Updating Table,
MGFoster
Another variation,
Chris Smith
Parameter default value,
peregenem
Re: Using an AND for the same record,
John W. Vinson/MVP
backdoor,
val via AccessMonster.com
- Message not available
- Message not available
Re: Delete duplicate values,
Rick B
Cancelling long query?,
Bill
Query very slow with UNION,
Alfred Malleier
Re: Desperately need help with a Query,
PC Datasheet
Re: Nesting IIf Statements,
Duane Hookom
Need help designing a query,
dorr
Re: Adding times past midnight,
Marshall Barton
Re: Problem with Pass Through query and subform,
[MVP] S.Clark
Re: Averaging Time,
[MVP] S.Clark
Re: Criteria,
John Spencer (MVP)
Re: Append Quary tables,
[MVP] S.Clark
Re: "Best Fit" table windows?,
[MVP] S.Clark
Re: Add 3 months for next quarterly statement,
Tom Ellison
Re: Varible in query,
John Vinson
format result of an update query,
Helen
Summary totals in query,
FJB
Re: TRANSFORM and Avg(),
Gwen H
new to msaccess,
trinity13
Re: Dynamic subdatasheets?,
John Vinson
Re: Format this as fixed with a decimal space of 0 - 3,
Chaim
Parameter Query,
Alec Green
Query Popup,
Wanda via AccessMonster.com
new to access,
trinity13
Re: help me plzzz,
Chaim
RE: removal of spaces,
stuart
Re: Skew and other statistics in Access,
Douglas J. Steele
Re: Passing SQL to MSDE/SQL server,
Bill Sturdevant
Extract records with a specific field appearing more than once in the DB,
markx
select case function on date/time,
Lindsey M
Re: need random number routine,
John Vinson
Re: Not equal,
mike via AccessMonster.com
Re: Archive Acess Report Data,
John Vinson
Re: Creating an Access query that searches multiple tables,
John Vinson
Re: How do I save an access query to a floppy?,
Dave Patrick
Query to send e-mail,
Glenn
Re: Change attributes from "read-only on CD-RW,
PC Datasheet
Re: My parameter queries fail, whereas my select queries work fine,
Jeff Boyce
Append query with different field names,
FJB
Re: Averages,
John Spencer (MVP)
RE: How to get count of unique records in one-to-many query,
Randall Arnold
Select query driving me mad (using *),
TheSingingCat
Re: Text To Columns in Access,
Rick B
RE: Interesting Question,
MChrist
Re: Using Select Distinct with *,
Michel Walsh
Re: Query with more than one table,
Chaim
Re: Displaying a Zip Code (5 or more digits),
Chaim
Re: format a NZ field in a query to 0 decimal places,
Jeff Boyce
Re: Vague match/match partial information,
John Vinson
Re: Use of global variables in Queries,
Amy Blankenship
Re: help with sql,
John
Using Access to try SQL codes,
J_J
Re: IF THEN query in SQL,
Douglas J. Steele
Re: keyboard letters,
Allen Browne
RE: Properties change in VBA,
'69 Camaro
RE: filtering a query,
'69 Camaro
Re: #Error in date field,
Duane Hookom
Adding Records in a query,
ijakings
RE: Data Entry on condition basis,
'69 Camaro
Re: Reusing a subquery,
John Spencer (MVP)
Re: Append Query & Linked Tables,
Jeff Boyce
Re: how to query a street in an address,
Marshall Barton
Re: Adopting and developing an existing popular and efficient PIM,
Marshall Barton
Re: Select latest recorded record in Access crosstab query,
MGFoster
Re: Date/Time Fields criteria,
Simon
Re: numeric data,
John Spencer (MVP)
Re: SQL For Next,
Brendan Reynolds
Find a record AND the one immediately above it for bad GL postings,
M.M.
Counting ONE field with date parameters,
FJB
Re: Updating a memo field,
John Vinson
Re: Fromdate todate syntax error,
Kevin W. via AccessMonster.com
Re: pull first record,
Amy Blankenship
Re: how can I have access total the number of yes's in a yes/no col.?,
Amy Blankenship
find if the coumn exists in a number of tables,
dtonse via AccessMonster.com
Re: Query Pulling from 3 Tables,
oozyscab via AccessMonster.com
top values,
newgroup
Re: Crosstab queries and SQL problems,
Duane Hookom
Counting in a query,
MyVi
Re: Force Binary String Comparison,
david epsom dot com dot au
Re: Update Query Counting occurrences in a field and Sequential numbering the occurs,
Duane Hookom
DSUM problem,
SF
Re: Pull down menus for queries.,
Duane Hookom
Re: join fields containing null values,
John B via AccessMonster.com
Ordering using Max?,
Mike
Re: Query with field in a form,
Lasse T
Re: Query Problem, Show only records from previous Qtr,
Amy Blankenship
Re: Those two 'Testing' posts,
Ken Snell [MVP]
Re: Creating a counter,
Chaim
RE: using memory variables in a query criteria,
'69 Camaro
Re: Updating Multiple Fields in a Query,
Chaim
Help! Calculate Average using Queries,
Alex_Firenze
Re: How to group and count results of calculation,
shep
- Message not available
- Message not available
Re: Names query,
Duane Hookom
Re: Query using > and dates,
Duane Hookom
Re: Converting a Date Rage into a simple format,
Allen Browne
Re: execute a query from VBA,
Darryl
Re: Query in a loop,
JohnFol
How to arrange names to create pairs of names,
aeronav
Re: splitting data from one column into multiple columns,
peregenem
Re: Include only first part of a field in a query,
David S via AccessMonster.com
Re: Update Quarterly Statement Sent Date,
David S via AccessMonster.com
Re: Merging 2 Tables,
Doug Fete
Make count = 0 where no row is returned.,
Roger Hembury
Re: Update Several records,
John Spencer (MVP)
Re: Testing 2,
Douglas J. Steele
Re: Dlookup function,
John Spencer (MVP)
Re: Summary Report,
John Spencer (MVP)
Re: all columns not always present in query - report won't run,
Duane Hookom
Combination of Field not empty,
YDN
Re: how to write an expression,
OfficeDev18 via AccessMonster.com
Re: Time Format,
Duane Hookom
Re: Count does not give me 0,
OfficeDev18 via AccessMonster.com
Re: Query getting stuck,
ChrisBat via AccessMonster.com
Re: postcode search, lookup, finder,
agnieuwe
Trim Spaces,
Garry
Cross table Query,
Paramasivan
Change data name,
Alex Martinez
Re: Populate one table with values from another,
Amy Blankenship
Re: Microsoft DA0 3.x Object Library - sql, vba,
PC Datasheet
Re: Dup Entry Query,
John Spencer (MVP)
Combo Box Query,
Oopesh
Re: Minimum Date,
John Spencer (MVP)
Query producing 522 copies of same record,
FJB
Re: Running a query against it's own base table,
David S via AccessMonster.com
Re: Problem with Nested IIF,
David S via AccessMonster.com
Re: How do I fix Access Error undefined function "CStr$" in expressio,
Douglas J. Steele
generate a temporary table,
Darryl
Re: Return Latest Quarterly and Monthly info.,
spartanmba
Text to Int,
Peter Carlson
Re: date parameter,
Chaim
Re: Searching for records that do not exist yet,
Chaim
Re: name query,
Chaim
Re: How to add just one field,
Rick B
Re: Date restrictor for this week,
John Vinson
Re: Make table query with derived fields,
Marshall Barton
Re: What does RWOP stand for?,
Rick B
Re: Format Yes/No fields after Union,
Marshall Barton
Re: Variable Table name,
Rick B
Payroll Dates,
johnnya@xxxxxxxxxxxxxxxxxxx
Re: Simple Expression Question,
Rick B
Re: Keep Count of Query Output Records,
JohnFol
Re: Query with a twist %%,
Roger Carlson
RE: query to display only most recent version.,
R.Douthwaite
Concatenating not working with primary key as text field,
annysjunkmail
delete records help,
Bob
Re: Time/Date,
Marshall Barton
Re: How do I number the entries in a query?,
[MVP] S.Clark
Re: help with an update query from form data...,
[MVP] S.Clark
Re: Regular Expressions in Access,
Douglas J. Steele
Re: Does Access Not Support INSERT ... SET Syntax?,
Douglas J. Steele
Cannot Delete From Specified Tables,
Dave
Re: Access almost freeses aftera pass-through query,
[MVP] S.Clark
Re: Records not displaying,
Chaim
Re: Subtracting a fixed date from a date field,
Chaim
RE: Date Summary Report,
Rod
Re: Excluding row based on trailing text,
Marshall Barton
Re: Simple Query or not?,
Marshall Barton
- Message not available
- Message not available
Re: Update query using Sum function,
John Vinson
Re: Doesn't work Like "*" [Forms]![SearchCriteria]![StrAddress] "*",
John Vinson
Update Query,
Brianna W
Re: Switch and IIF both give me an extra data Line.,
rhoisy
Re: HEEEELP!! Less Hair then B4!,
SusanV
More Help withthe WHERE Clause,
tamxwell
Crosstab query - odd field,
SusanV
Re: attetching a Macro to a action Queries,
Allen Browne
Re: Please Help!!!? Select * From,
Jeff Boyce
Append Query from Unbound Textbox to subform,
Denis Bisson via AccessMonster.com
Rows to columns - can it be done?,
annysjunkmail
Concatinating query results of one field,
Kathy Webster
RE: Sync Columns,
'69 Camaro
Re: Query with minimum field value,
Duane Hookom
Re: New Totals Query,
Duane Hookom
Re: How do I combine data from two fields into one using a query?,
Marshall Barton
Using SQL format function in Access 2003,
smashing_austin
Apostrephes Make Query Upset,
mcwhirt3
Re: Select Data,
Duane Hookom
Query showing Inspections not performed,
Chris
Re: Days, Weeks, And Months,
Duane Hookom
How to combine multiple row values into one column,
Bill Murphy
Re: Multiple Criteria to run Parameter Query for a report,
questionnaire database analyst
Re: Access query,
Vincent Johns
Re: Return records where field duplicates,
Allen Browne
Programs alphabetized, how?,
cilorentson
Re: Names in an Expression,
Duane Hookom
Can't find last order with data fields in a query,
Rolf Rosenquist
Adding missing records to a table,
Petterq
Re: Running a query from a form,
Rick Brandt
Re: Having trouble joining a table and query,
Jeff Boyce
Query fails,
Petterq
duplicate query within an If statement,
Alan
Please Help ! Queries for Dates, if statement...,
Bill
MORE THEN ONE QUERIES-- HELP--,
TYE
Re: How do I join data from 2 fields in same query?,
Allen Browne
Re: Help with append query for one-to-many relationship tables,
SteveS
Re: Formatting for a Weekly Report,
Duane Hookom
Re: how do i create multiple tables from a master table automatically?,
John Vinson
Re: Using Calculated Fields to Calculate other fields,
[MVP] S.Clark
import flat file into a table,
gv
Add records if do not exist?,
SusanV
Re: Please Help!? Multiple Check Boxes in Query!,
[MVP] S.Clark
Help to append flat file table to two tables,
Victoriya F via AccessMonster.com
Re: SQL Aggregate AVG function and GROUP BY Clause,
Chaim
Re: Breaking down a weekly rolling total in a sales table,
Chaim
Report from Query - Select Max value,
Gil Lopes via AccessMonster.com
Re: Translating values from a form into a JET query,
Ogelema
Help: create query,
Angelo
Re: SELECT from two tables (not same number of fields),
Allen Browne
Prompting for the same parameter three times when opening a report.,
Lee B via AccessMonster.com
Re: Doing an 'AND' query on the same field,
Amy Blankenship
show jobs not completed within a time frame,
GMan
Re: Datatype conversion,
Randy Harris
Re: Primary Key re-setting to "0",
John Vinson
Re: Imported query from another access db has strange syntax error.,
David S via AccessMonster.com
How to Query Overdue Dates,
jchollo
Re: Why can't I do an Append Update Query,
tina
Queries in Access - Overdue Dates,
jchollo
Re: Need help with updating with value from another database,
MGFoster
Re: How to get rid of characters in a string,
PC Datasheet
Re: Union query for different fields,
Duane Hookom
Re: Concatenate the records with same ID,
Michel Walsh
Full OUter Join Help Needed,
walemly
Re: A query that joins 2 tables,
John Vinson
Re: Duplicated records,
Jeff Boyce
Re: Don't Display queries with Zero Results,
Graham R Seach
Re: Join Properties Problem,
Baz
Count on a yes/no field,
Alex Martinez
Re: Copying a record,
Marshall Barton
Re: Append new record,
Douglas J. Steele
Re: duplicate records,
John Spencer (MVP)
Re: tables,
John Spencer (MVP)
Re: Count Query not showing all records,
MGFoster
Re: How to query or SP to insert/upate a table from another DB's table,
MGFoster
Re: Add autonumber key while creating a new table thru MakeTable Query,
MGFoster
Re: HELP WITH "WHERE" clause,
MGFoster
Re: Make a table query with no duplicates,
John Spencer (MVP)
Re: Records missing in a query,
Teri
Re: Query to add Foreign Key constraint to existing tables?,
peregenem
CHOOSE function not behaving as expected,
mikes
Re: Comparing 2 tables,
Duane Hookom
Last Record,
Keith
Re: Force Row Headings in Crosstab?,
Duane Hookom
Re: Non-cents query,
John Vinson
Re: Last, Group By, unique results,
Marshall Barton
IIf and parameter query,
Amy Blankenship
Re: SQL Join statement,
Amy Blankenship
Re: Adding data in fields together,
Amy Blankenship
Re: Removing common fields,
Baz
Re: ADD MONTH -1,
Michel Walsh
unique values,
wimsan
Re: Why does a database close when I open design of a make table q,
tdcarm
Select field name,
Gil Lopes via AccessMonster.com
Re: Select Count Random,
JohnFol
Crosstab Query?,
bassplayer
Re: Sort Order of Queries,
Allen Browne
Not able to edit / update query,
purushotham k via AccessMonster.com
Re: can you specifie criteria for a parameter query in an Auto Num,
Van T. Dinh
Re: Date/Time,
Van T. Dinh
Re: ODBC call failed,
Van T. Dinh
Re: Sorting records in a form,
John Vinson
Runs on Theirs, Not on Mine,
Christopher Weaver
Re: Why is the "copy" command disabled when viewing a query in Access?,
John Vinson
Re: can you specifie criteria for a parameter query in an Auto Number.,
John Vinson
Query Puzzle,
Bradley
criteria and dates,
kryszystof via AccessMonster.com
Expr1002,
aak
HELP With DATA and Make Table Query,
Doc
Re: how to feed result from P_T query to combo box?,
Duane Hookom
Re: Query performance,
MGFoster
Re: Computing Median,
mcl
Expressions,
Pompey_Boy
Previous Results,
Bakr Z via AccessMonster.com
Re: a Query that collected parameters from a form just stopped working,
JohnFol
Invalid operation - error 3219 - iterative select query,
Mark Wickett
Why is access filling in fields in query results,
Robbie via AccessMonster.com
too few parameters - Sub Query,
Dianna
Group by,
neeraj
help w/ access 2k3 query criteria -user prompt for last name &/or,
sj
select records on yes/no fields,
Bob Brannon
calculation help,
Carlee
Using Unbound Form to Enter Query Criteria,
cainentm
Create records using defaults,
Alex
Creating a Pivot table or Crosstab query with specific data.,
Andy
Queries with Expressions cause a Compile Error,
Dr Rubick
Parameter from Form,
Melinda
Working with linked (MySQL) data,
Mike
UNION returns unique values?,
Stef
How to create an expression,
Jenn Civello
DISTINCT vs GROUPBY ?,
Stef
Removing Nulls and displaying data together,
Bradley
Order by rownum or order that data was entered into table,
Cindy H
criteria, checkboxes, and/or,
bicyclops
Need a date query hero,
John G
Message not availableRe: Need a date query hero,
John G
Re: Need a date query hero,
John G
Selecting records with email addresses,
Melih
Calculation for tiered discounting,
Carlee
Subtract days from Left(Date(),5),
consjoe
Re: How do I change the default year setting from Jan-Dec to Oct-S,
Cyberwolf
Query to find list of persons whose age is below/above input age,
leo pradeep
Trouble with "*" wildcard,
Leroy
Query rolling dates?,
pvdalen
Change date format in Query,
Rhonda
Working with Dates in Access,
Nora
Store Procedure,
Arne
How to compare fields,
Luther
Syntax ^'(ctrl + '),
michael
Count distinct in pivot table,
Kanga
Repeating an empty query,
EliotF
what does 'inconsistent updates' really mean?,
bicyclops
Why is this not an updatable query?,
cvegas
how do i get help with querying a database,
lloyd8156
Lookup field abilities,
Rich
Time Schedule Query,
Debbie D.
Put a total at the bottom a column,
edward keith
Challenging?,
Jay
Challenging Thinking,
Jay
Date format in crosstab query,
Matt
vba Query for column name,
ismail
date and time,
Jay
How to usa ALTER COLUMN to change a column name,
Robson_Brasil
Count Unique Records,
BBTMAMA
Multiple phone numbers (home, business, mobile) in one list,
Russ via AccessMonster.com
- Re: Multiple phone numbers (home, business, mobile) in one list,
Russ via AccessMonster.com
- Re: Multiple phone numbers (home, business, mobile) in one list,
Russ via AccessMonster.com
- Re: Multiple phone numbers (home, business, mobile) in one list,
Jeff Boyce
- Re: Multiple phone numbers (home, business, mobile) in one list,
Russ via AccessMonster.com
- Re: Multiple phone numbers (home, business, mobile) in one list,
Jeff Boyce
- Re: Multiple phone numbers (home, business, mobile) in one list,
Russ via AccessMonster.com
- Re: Multiple phone numbers (home, business, mobile) in one list,
Jeff Boyce
- Re: Multiple phone numbers (home, business, mobile) in one list,
Russ via AccessMonster.com
- Re: Multiple phone numbers (home, business, mobile) in one list,
Jeff Boyce
- Re: Multiple phone numbers (home, business, mobile) in one list,
Russ via AccessMonster.com
calculating data from multiple fields,
David
on line help regarding individual record's calculation not to fie.,
Quadeer Ahmed
Dealing with "almost" duplicate records,
Cheese
SQL Union Query - include table name as field?,
Titian
Problem with displaying all records in a query,
ukpicker
extract digits from addresses,
shank
Accessing functions from an external library,
dp
Current Expenditure,
Alylia
"Find Unmatched Query" help for Football pool,
Lucky Louie
Read me,
casey
Find anniversary of a date,
Rli
Re: Find anniversary of a date,
Dale Fye
field not equal,
neeraj
Just the month please,
KAnoe
concatenate records,
db
Two Columns of same fields in query,
Randy
Append query problem,
BabyATX13 via AccessMonster.com
Spliting one field into three,
Snake
Fiscal Year query,
Cyberwolf
Union query- count records,
Stephanie
Validation Rule Problem,
Martin
Counting Records,
Rick Deemer
Delete Multiple Items in one Table,
Sparky Arbuckle
returning all records,
Jason
how do I query values in a single column,
Rashar Sharro via AccessMonster.com
Null Value in Table,
mcgj
Complex queries & reports,
Darryl
Modify Format of Date Query,
Leroy
multiple sortings,
dlb1228
How to setup an expression,
Jenn Civello
RE: moving data,
Ofer
How do I count the values in a column?,
Rashar Sharro via AccessMonster.com