microsoft.public.access.queries
Format Numbers in IIF statement,
alecgreen
Re: Date Parameter,
Rick B
return a list of dates when nothing happens,
news.shaw.net
COUNTING the instances of various values in a Single Field.,
kev100 via AccessMonster.com
Querying a month range...,
KK
Re: Selecting 60 days ago from text date field,
fredg
Year(Now()), before Year(Now(), or null,
jadabug28
Re: show month and year out of current date,
Duane Hookom
Re: SQL table Access combo box,
Jeff L
access,
bob
Re: Update Query Crashes Access -- why?,
AccessVandal via AccessMonster.com
Getting the month name from a date,
David Gartrell
Re: Crosstab or Another Option??,
Duane Hookom
Criteria for Date/Time Field - Cumbersome,
tbl
How to link a Table to a Query?,
jeszejared
Query sorting,
alex
can't determine the syntax error,
Richard
IIF parameter,
Angel_G
"Group By" makes Simple Query Run FOREVER,
saraqpost
Need to pull out every third record,
Brian Langley
Query TIME saved as TEXT to Sort PROPERLY (e.g. 1:36 PM to list after 10:00AM) ?,
kev100 via AccessMonster.com
Last 30 days in Query,
FpwL1399
Efficiency,
Rob
Re: Fulltext search,
Allen Browne
Summing query?,
Tony Williams
- Message not available
- Message not available
Re: Challenging queries query...,
Jamie Collins
Re: ddmmccyy to dd/mm/yyyy format,
Allen Browne
Re: Calculated Field in a Query,
Tom Lake
How to use several joins in one query?,
MIKQ
Re: how do i calculate an age using MS Access? I'm a novice.,
Allen Browne
Re: Calculating percentages,
Michel Walsh
Re: Subquery rewrite from Oracle,
Michel Walsh
Re: Selecting most current value,
Michel Walsh
Re: Return only "Yes" values - multiple fields,
Michel Walsh
Re: Link tables question,
Michel Walsh
not all records being query,
JG
More Query Questions,
JG
General question on writing a complex query,
Damon Heron
Re: capturing the computer id in a access querry,
MGFoster
Append query help,
Daveo
Re: Some sort of "find and replace",
John Nurick
Import Queries to Access Project,
millard . fillmore . 13
Re: Auto calculate sum of multiple fields by record,
Conan Kelly
This one's a challenge: 1.9 not equaling 1.9..... What's going on???,
pwizzle
Data type mismatch in criteria expression.,
NathanJ
Re: Setting Criteria for Fields with Combo Box Lists in Queries,
Jeff Boyce
Re: Excel rows to Access columns?,
fredg
How do I created a query in Access that points to SQL Server 2000?,
woody
Re: Display user-input parameters on a report,
Allen Browne
Re: Summary Query for a Report,
Jeff Boyce
Re: Sort on Multiple Fields, Nulls at End,
Duane Hookom
Re: Multiple Field Search Query,
Duane Hookom
Query: Two Dates in one cell of a field. Need criteria help,
running381
Re: query to leave something out,
Rick B
Query for "last 5 quarters",
ageis
format (order) sql,
VilMarci
Re: Insert into multiiple tables,
[MVP] S.Clark
Re: Year to date values,
Duane Hookom
Re: Saturdays and Sundays,
Duane Hookom
Re: Totals Query Help,
Duane Hookom
Frustration with my query,
In need of assistance
Re: Alter Table pads spaces to 255 characters,
Conan Kelly
Re: Update blanks to zeros,
Jeff Boyce
Re: Reconciling records in the same table,
Jeff Boyce
- Message not available
- Message not available
Re: Administering null returned values,
Jeff Boyce
Re: How do I make a Query ask for more than one parameter?,
Conan Kelly
Help in query calculated field,
Carlos
Re: Message: "Could Not Delete from Specific Tables",
John Spencer
Re: find dates for sunday and saturday of last week,
Gina Whipp
'count' query question,
tlyczko
To change negative to positive in MS Access,
jeszejared
Row Total for each month? Crosstab Query,
david . isaacks
Re: design view does not match datasheet view,
Jeff Boyce
Re: Access Expression,
John Spencer
Re: Tabbed Form - How Can I Have One Field Show On All Tabs,
Allen Browne
Problems with SQL Query Counting Unique Records,
mark . godecke
Query only works part of the time,
dreamsoul620 via AccessMonster.com
Data produced is incorrect,
beaker1167
delete query,
geebee
how to save info with timer,
Miikka Hamalainen
Report with multiple group columns - need count of each column,
DMUM via AccessMonster.com
Unexplained Error "Invalid Argument",
Rita Palazzi
Re: Create List of Queries, Tables & Reports,
Allen Browne
Change name of a field,
Rob
Re: top predicates,
John Spencer
Re: Rounding time x Rate,
Gary Walter
Re: How to group and count results of calculation,
Gary Walter
Eliminate duplicate records,
vincentt via AccessMonster.com
Archive only a selection from a table,
dietmarhannam
update hyperlink through query,
Maria
- Re: update hyperlink through query,
Maria
- Re: update hyperlink through query,
x-rays
- Re: update hyperlink through query,
Maria
- Re: update hyperlink through query,
x-rays
- Re: update hyperlink through query,
Maria
- Re: update hyperlink through query,
Gary Walter
- Re: update hyperlink through query,
Maria
- Re: update hyperlink through query,
x-rays
- Re: update hyperlink through query,
Maria
- Re: update hyperlink through query,
x-rays
- Re: update hyperlink through query,
Maria
- Re: update hyperlink through query,
Maria
- Re: update hyperlink through query,
x-rays
- Re: update hyperlink through query,
x-rays
- Re: update hyperlink through query,
Maria
- Re: update hyperlink through query,
x-rays
- Re: update hyperlink through query,
Maria
- Re: update hyperlink through query,
Gary Walter
- Re: update hyperlink through query,
Maria
- Re: update hyperlink through query,
Gary Walter
- Re: update hyperlink through query,
Gary Walter
- Re: update hyperlink through query,
Maria
- Re: update hyperlink through query,
Gary Walter
- Re: update hyperlink through query,
Maria
- Re: update hyperlink through query,
John Spencer
- Re: update hyperlink through query,
Maria
- Re: update hyperlink through query,
Maria
- Re: update hyperlink through query,
x-rays
- Re: update hyperlink through query,
Maria
What to do when crosstab doesnt produce a result?,
BeruthialsCat
count in a query,
x-rays
Re: How to get Access to read query paramater values from txt file?,
RoyVidar
Setting order in crosstab query,
Ruth Isaacs
Query with two time periods,
Jen
Re: Help with Getting A Range of Cost,
MGFoster
Re: Column Widths and Jet 4.0,
Douglas J. Steele
<Possible follow-ups>
Re: Column Widths and Jet 4.0,
John Nurick
Re: Count number of unique users,
Douglas J. Steele
RE: Append Query not work,
PA
Re: Query in SQL,
Rick Brandt
Can't purge date object into sql string for access dbase,
Chumley Walrus
Not an updatable query???,
JNana
- Message not available
- Message not available
Re: Date Diff,
Steve Schapel
Re: Help Solving Problem,
Marshall Barton
Re: Logging Management Visits,
John Spencer
AutoNumbering,
jesperl3
Re: Access 2003: How to split one (lastname, firstname) field into 2?,
Rick B
Re: Finding partial matched duplicates across two fields,
Gary Walter
How to cut one column data to two?,
Gary
Re: Creating arbitrary relationships?,
John Vinson
crosstab query,
anil
Re: Not getting the correct record from query,
strive4peace
Re: Setting Format in a Union Query?,
mcl
Re: 1-year sum question,
strive4peace
How to group records in a table,
Susan Philip
Running Total not working,
Prufrock
Count records in query by most records,
larpup
Re: Passing Where statement to a query,
Ken Snell \(MVP\)
Re: Display records based on conditions in multiple fields in Access,
MGFoster
Re: Query criteria from a closed form?,
Marshall Barton
Re: Calculated field??,
Ken Snell \(MVP\)
Re: How can I create a list query?,
Gary Walter
Date format,
Tom
Re: Try to use multi "like statements in a quesry",
Ken Snell \(MVP\)
Exclude a field from a query,
jenks1120
Query breaks when adding new restriction,
Jon
Format of Calculated Field in Query,
Bill
Crosstab query will work one way but not the other,
Conan Kelly
Query empty If, then,
mattc66 via AccessMonster.com
Re: Converting Access Data to an Ascii text file,
MGFoster
- Message not available
- Message not available
Return records from one table for both parent and children?,
tunafish62
Re: using form fields in a function,
Jeff L
question: Blank not Zero?,
Phil
Is there a better way?,
Leslie Coover
Is the INSERT INTO Query best to use to Add To (not just append) XLS ??,
kev100 via AccessMonster.com
Help needed,
telukunta . vikas
Re: Prompts and/or reminders?,
Jeff Boyce
Re: Multiple AND criteria,
Allen Browne
Nulls in a query,
Hal2604 via AccessMonster.com
help Restructure query,
Shreyas Pandit
Re: generate report to point out discrepancies in data,
Allen Browne
RE: adding dsum results in a query,
Ofer Cohen
Re: Date format in update query,
jacksonmacd
Covariance Query,
kbarlak
Re: Multiple 'Many' Table Query,
Allen Browne
Re: How do I denormalize data using queries?,
Matt
Re: Data,
Allen Browne
Between Times,
Floyd Forbes
Re: Can't enter records through subform,
Marshall Barton
the 1st transaction,
fishqqq@xxxxxxxxxxx
Re: Calculating certain Days of the week,
MGFoster
Re: SORT BY DAY,
MGFoster
Re: how do I refer to fields on a form in a query in an adp project?,
Jeff L
Re: coping information,
[MVP] S.Clark
date change,
M . McDoom
Re: Shipping Dates Query,
MGFoster
Re: Write an expression to omit blank rows in an Access 2000 query,
MGFoster
Re: grouping "yyyy" in a report where there is also text info,
MGFoster
Re: Duplicate Query Mess II,
Jeff L
Re: query,
MGFoster
Can i use Select Distinct?,
hermanko@xxxxxxxxx
Re: Is there a way to add a footer to a Query?,
Allen Browne
RowSource Query for ComboBox,
ksmith
Re: make parameter query finding like values,
Allen Browne
Handle Blank User Input,
tiger0268 via AccessMonster.com
Re: multiple crosstabs in one query,
Duane Hookom
RE: Advanced Query Criteria?,
MildJoe
Re: Querying most recent dates,
John Spencer
Re: running sum help,
Svetlana
Cross Tab for Data Entry,
mattc66 via AccessMonster.com
Re: help with a query,
Marshall Barton
Re: Nested IIf experssion,
fredg
Re: Select Statement-Group by Question,
[MVP] S.Clark
Re: Filter date,
[MVP] S.Clark
Re: Exporting 2 queries into 1 excel spreadsheet,
[MVP] S.Clark
Calculation Queries,
Franklin Jagdeo
trying to build an expression in a query,
ksmith
Built In Access tools,
EmOXon
Re: update only using last record.,
MGFoster
Re: query addition,
MGFoster
RE: Union Joins,
Linc
Re: How do I find the last business day of previous month in Access 20,
Jeff Boyce
Force query to SaveAs on Closing,
Craig
Update muliple records query,
darkoko
Re: Iif trouble,
fredg
Re: Critiera from an unbound form,
Marshall Barton
Queries across 2 tables,
Al
Re: operation not an updateable query,
John Spencer
Re: calculating a date field,
John Spencer
6 Months or older date query issues,
stickman373
Re: Sort members by age on particular date,
John Vinson
Re: Query to sort number sequential,
BruceM
Re: Query to sort number sequential,
Jamie Collins
Re: create query with sum divided by another number,
Jeff L
Re: Concatenation truncatation,
Allen Browne
Re: HOW TO INPUT AND/OR INTO A SQL WHERE CLAUSE FROM A COMBO BOX,
cjg . groups
Re: Top values in a query,
John Spencer
Re: error 3151,
Gary Walter
How to create a QueryDef object - easy,
cjg . groups
Re: Append query not working,
Allen Browne
Re: Exists clause in crosstab query,
Duane Hookom
Re: Date Queries,
Duane Hookom
Cursors in Access?,
Adamus Turner
Re: Simple Question (?) about code generated PK's,
John Vinson
Help with Mid and Spaces,
mattc66 via AccessMonster.com
Running month sum,
ArthurAccroc
Appending Records from Linked Tables to the *Real* Linked Tables,
tbl
Re: locate the position of a char in a text,
John Spencer
Run multiple append queries?,
SKB
Re: How do I use DCOUNT in an update query?,
John Vinson
Re: Rght Function?,
Jeff Boyce
Re: Duplicate Record Mess,
Jeff Boyce
Re: Inventory counting query.,
Allen Browne
Linked Combos,
ricky
Re: Identify Non-Even Dollar Transactions,
Allen Browne
Re: Comparing Data in Multiple Records?,
Allen Browne
Re: Dividing 1 Field by the 1 above,
Allen Browne
Group By Totals in Regular Query?,
Leslie Coover
Re: add a space into a string,
Tom Lake
Re: create a chart from a query in report,
Duane Hookom
Re: Parameter Query Sql 2000 & Access 2003,
Jeff L
Re: Link old and new databases or Import?,
Jeff L
Delete Duplicate?,
Racer57
Re: Records not in related tables,
Allen Browne
Cross Query Monthly Calc,
Vinnie via AccessMonster.com
CONCAT,
fingermark
Re: complex filter,
Duane Hookom
Add Previous record to Current record,
broogle
Re: copy part of one field to another,
John Vinson
Re: link "make-table" queries and form for data entry,
Douglas J. Steele
Re: Nested IIf statement use,
John Vinson
Re: UNION Truncates Memo Fields,
Duane Hookom
calling a value from Aggregate Recordset?!?!,
T Best
Re: Changing hyperlinks for 1000 records,
Jeff Boyce
Re: Query help,
John Vinson
Re: Make Table Query,
John Vinson
Removing a duplicate,
hitchhiker via AccessMonster.com
Need advice on speeding query up,
Jon
Re: Module with custom function gives "undefined function",
RoyVidar
Using a parameter box to retrieve only one record.,
aarcorcar
Re: Report Addition and Percentages,
Duane Hookom
Re: Concatenation Question,
Duane Hookom
Re: Problem with Aggregate query,
John Spencer
Re: Date Query,
John Spencer
Dynamic "Where Clause" in Access Query ( not in VBA),
MSK
How to change data?,
Gary
Re: SELECT the Duplicate Field,
AccessVandal via AccessMonster.com
Entering Data into a Form,
Scott Reed
Addition and Percentage Formulas,
Scott Reed
Re: Unwanted parameter prompts in select queries,
John Vinson
Re: Counting Tick Boxes.,
John Vinson
This is killing me!,
Liam . M
RE: Count days of a certain month between date fields,
Ken Sheridan
Update Query Corruption causing headache,
Craig McLaughlin
Turn off Auto Fill In???,
Doug in Texas
Re: Query by Form (QBF),
Allen Browne
Re: have either a Calculated Expression or User Input,
John Vinson
Re: How to query on user form,
Steve Schapel
vb to change query criteria,
msmuzila
SQL false Enter Parameter prompt - need help,
G Lykos
Setting the data type of a new filed in a make table query,
Jasonm
How to concatenate two tables via query?,
G Lykos
Re: Share reports and queries,
Duane Hookom
Re: Design and Relationship problem :(,
Michael Gramelspacher
Making zero values not show,
Peter Lawton
Re: splitting tables w an update or append query,
John Welch
Re: make table in access 2003 to keep archived records,
Allen Browne
Re: Query last entry in a field,
[MVP] S.Clark
Re: returning a multi-criteria sum from a table to a query field,
[MVP] S.Clark
Re: Make Table Query based on Pass-Thru Query,
[MVP] S.Clark
Re: Build a query to pull current week data only.,
John Spencer
Re: Query to autocomplete checklist?,
Jeff L
RE: Slow Query,
Ron
Update Query Taking time,
sarath26uk
Re: Expression in Query. Weird sort problem,
Ken Snell \(MVP\)
Re: access 2003 runtime query problem with sub-form criteria,
strive4peace
Re: Help with Max Date,
strive4peace
Re: Slow Query -- use ID not text to link,
strive4peace
Re: DSUM or running total,
Jeff Boyce
Re: Query to set the number of records in a group,
R Alapatt
Access: append query gives me a violation error the first time only.,
celineusa
Re: how do I group by with case sensitivity on,
Gary Walter
Re: Select Qry Range,
John Spencer
RE: A 'simple' date query using iif,
TerryM
Data reformat,
Stephen Cannell
DateAdd Calculation?,
Liam . M
Re: duplicate values in join query,
Marshall Barton
Mysterious problem,
leodippolito
Re: How do I do percentages in access,
Duane Hookom
Re: join type not supported,
Allen Browne
Re: How to view query design after executing without losing results?,
Allen Browne
Re: Union Query Issue,
Phil
4+0 = 2 in Union query. Data lost.,
Phil
QUERY CALCULATION BASED ON DATE RANGE?,
Liam . M
Re: Query with Months as fields,
Duane Hookom
Combo Parameter,
phuser
Re: Passing parameters on to subquries,
Conan Kelly
Re: Delete Query Help,
Lynn Trapp
Re: GET ONLY LAST DATE,
Lynn Trapp
My query is displaying a blank where there should be data,
jessiemacmillan
vba SQL not equalling query in Access,
T Best
Re: is there something to get rid of duplicates,
Jeff L
Re: Delete Query Problem,
MGFoster
query speed,
geebee
Re: French Characters and Hyphens,
Michael Gramelspacher
How to insert a particular coulmn in table.,
arunachalam . arcot
Re: Date criteria in query,
Allen Browne
Re: Append query error,
Jeff L
Between Date Issue,
rollover99 via AccessMonster.com
16th of Last Month to 15th of This Month...,
ABAX
Re: Pivot data by Month. Problem replacing month abreviation,
Duane Hookom
- Re: Pivot data by Month. Problem replacing month abreviation,
x-rays
- Re: Pivot data by Month. Problem replacing month abreviation,
Duane Hookom
- Re: Pivot data by Month. Problem replacing month abreviation,
x-rays
- Re: Pivot data by Month. Problem replacing month abreviation,
Duane Hookom
- Re: Pivot data by Month. Problem replacing month abreviation,
x-rays
- Re: Pivot data by Month. Problem replacing month abreviation,
Duane Hookom
- Re: Pivot data by Month. Problem replacing month abreviation,
x-rays
- Re: Pivot data by Month. Problem replacing month abreviation,
x-rays
- Re: Pivot data by Month. Problem replacing month abreviation,
Duane Hookom
- Re: Pivot data by Month. Problem replacing month abreviation,
x-rays
- Re: Pivot data by Month. Problem replacing month abreviation,
Duane Hookom
- Re: Pivot data by Month. Problem replacing month abreviation,
x-rays
- Re: Pivot data by Month. Problem replacing month abreviation,
Duane Hookom
Re: Unique,
John Spencer
Slope Excel Function in an Access query,
jacky
Selecting all records that match a regular expression (like GREP),
richard . j . whitaker
Re: Existing Database - Create new or Fix existing?,
Allen Browne
Re: start and end dates,
Allen Browne
Re: relaying not allow,
John Vinson
Re: How can I calculate tax for 2 states?,
Rob Parker
Re: creating an access query that returns many fields,
Duane Hookom
Re: Microsoft Access query on limiting data in a field,
MGFoster
Limit Data by Index,
mattc66 via AccessMonster.com
Re: Calculation Help,
John Vinson
delete query on table and reset autonumber,
cporter
Re: group by dates,
MGFoster
Re: Can I create a "Sum" on an expression that is "Counting" in query?,
Jeff L
Date Parameters and Querys,
Kath via AccessMonster.com
Re: Filter with in a Query,
Casey via AccessMonster.com
Re: Query which reverts to a previous (deleted!) version when activate,
Marshall Barton
Separating data.,
Mo Man
Access 2003 truncates code in queries,
DonW