microsoft.public.access.queries
- Appointments in the past,
lillylazer666
- Re: Reference A Query Column,
John Vinson
- Re: Autocomplete,
John Vinson
- Re: query not populating,
Allen Browne
- Re: Query that returns applicants over age 18,
Allen Browne
- [ Autofill datatable columns with increasing numbers ],
remember_it
- using OR in IIF("",condition True,""),
anil
- Only show data for dates found in several tables,
Jen
- RE: copy a value from one record into other records.,
Duane Hookom
- Re: Need to break down the data into 3 different fields examples below,
Kc-Mass
- DateAdd problem,
mbynoe via AccessMonster.com
- Re: Whats your favorite animal?,
Anthony
- Re: making a query,
Anthony
- Re: forms are not writing to database.,
Anthony
- Re: Yet another query question...,
John Vinson
- About qdf.execute,
zixingw
- Re: Extracting part of a field in a query,
Brendan Reynolds
- Re: Select Yes or All (yes and no),
Amy Blankenship
- Re: DateTime Query,
fredg
- Help create query,
Carlos
- Multiple Independent Criteria Query,
Jason G
- Re: Designing Queries using SQL,
David F Cox
- Combine 2 count queries into one query,
gmann425
- Re: Excluding duplicate records in query,
John Spencer
- problems with a summary query,
Dos Equis
- advanced top 100 list query,
WB
- Query based on 3 querys,
SMA007
- Re: Calculating Dates,
Jeff Boyce
- Aging Invoice Report,
LiquorGuy via AccessMonster.com
- Left Join,
mustish1 via AccessMonster.com
- RE: CrossTab Challenge,
MJatAflac
- Re: date expression to bring up a weeks worth of records,
kingston via AccessMonster.com
- Occurances happening at the same time query,
james . szumigata
- <Possible follow-ups>
- Occurances happening at the same time query,
james . szumigata
Re: Boolean for idiots,
kingston via AccessMonster.com
Query A Table For The "latest workdate".,
jbesr1230
Re: Query with Form as a parameter,
John Spencer
Re: Top Ten Records Displayed by a value,
myriam
Re: Listing dates greater than 6 months from today,
Allen Browne
Re: Appending column with different data type,
kingston via AccessMonster.com
Re: Include additional fields in or from a totals qry,
kingston via AccessMonster.com
Re: Removing extra spacing in imported text,
Roger Carlson
Re: False results using <>,
kingston via AccessMonster.com
Re: ???Takes very long to do make table query,
David F Cox
Prompt User For Table Name,
vivek . vbansal
comparing adjacent records - looking for dup/missing customer orders,
Jesse
Calculations in form object,
FredVN
Problem accessing the LIST property of a listbox,
John T Ingato
Re: CurrentProject.Connection.CommandTimeout - need pro's assistance,
Sylvain Lafontaine
Re: display even if no entry,
John Vinson
access hell!,
Carrie
Re: Parameter query on expression field,
Allen Browne
Help With Expression Query,
CS
Re: Help to find unmatched data,
Allen Browne
Help to Exclude Records SQL,
rebelscum0000
Birthday Querie (For multiple Birthdates in each record,
naigy via AccessMonster.com
Re: Calculated field, sum/avg results of qry?,
David F Cox
Re: iif,
tina
Re: output query changes font color,
Douglas J. Steele
RUNTIME ERROR 3190 - too many fields defined...??,
WebDude
Re: Change title (?),
Ken Snell \(MVP\)
Simple Syntax Q for You,
Amanda V
Re: Finding alphabetic only in a text field,
John Vinson
Summing Checkboxes,
Jeff
Re: Can I do simple arithmetics with fields in Access ?,
John Vinson
Re: Insert one of two fields into a new table,
John Spencer
Multiple Query Counts,
Jeff
- Re: Multiple Query Counts,
John Spencer
- Re: Multiple Query Counts,
raskew via AccessMonster.com
- Re: Multiple Query Counts,
Jeff
- Re: Multiple Query Counts,
raskew via AccessMonster.com
- Re: Multiple Query Counts,
Jeff
- Re: Multiple Query Counts,
raskew via AccessMonster.com
- Re: Multiple Query Counts,
Jeff
- Re: Multiple Query Counts,
Jeff
- Re: Multiple Query Counts,
raskew via AccessMonster.com
- Re: Multiple Query Counts,
Jeff
- Re: Multiple Query Counts,
raskew via AccessMonster.com
- Re: Multiple Query Counts,
Jeff
- Re: Multiple Query Counts,
raskew via AccessMonster.com
Re: Why add when you can concatenate?,
tina
Re: Excluding Data in a Query,
Rick Brandt
sub for parameter,
knowzero
Re: Problems with date query,
Rick Brandt
like [parameter]*,
knowzero
Re: Multiple criteria to filter Query records,
Jeff Boyce
Re: count problem,
tina
how to construct this query? software count by room,
Song Su
Re: Simple query - why having problems?,
Gary Walter
Re: Change Query column labels?,
Allen Browne
Multiple Categories in a query - Part 2,
Paid The Umpire
Tricky query,
DaveP
Re: ???Invalid argument when doing make table query,
John Vinson
Match Query,
accessuser via AccessMonster.com
How do I get Min and Max to work with international date format?,
ocb
Re: Why would this query give #Error values,
Ken Snell \(MVP\)
update data on query,
Roy Goldhammer
Re: Problem is sum hours, because when cross 24h start in zero,
Rick Brandt
Message not available
Re: Weird Query Results.,
Allen Browne
Need help with query and aggregate function,
Tomas Eklund
primary key changing to 0,
lissahoo
Re: filling records for missing dates of price series.,
Jeff Boyce
Re: Query template,
Jeff Boyce
need help for this query,
Song Su
Re: Date and Time calculation,
Allen Browne
Re: Joining a Budget and Actual Table,
rtiste
Complicated Cross Tab,
Jeff
Re: Mulitple IIf statements - Too many,
John Vinson
Re: "Modulas" Function,
Rick Brandt
- Message not available
- Message not available
Query query ...,
Jon Rowlan
Re: Functions,
Rick Brandt
Re: symbol " ",
Anthony
Re: finding two substring and replace only one,
Allen Browne
Re: Duplication of information on some information,
John Spencer
Re: Count,
John Spencer
convert records to fields,
twentyone6
Counting occurrances in a chart,
hotplate
Date record,
Jeff
Mulitple Categories in a query,
Paid The Umpire
Re: Cumulative total problems,
Gary Walter
Re: Age Distribution based on Birthdate field,
John Vinson
Re: different value formats in crosstab,
Allen Browne
Re: Day and night patrol hours by day,
Michel Walsh
COMBO BOX - IF/THEN STATEMENTS,
childe51
Re: Strange Situation,
Anthony
Re: web,
Anthony
Re: Append Query not working due to Validation Rule Violations,
Anthony
Number to Text Where the number size may change,
Julie Alley
Req Help with Crosstab query,
pottymouthed
Customer Query,
LiquorGuy via AccessMonster.com
Pivot question,
PEJO
Re: Multiple look up criteria,
Roger
Breaking ties in a Top n Query,
S Davis
Access 97 Correlated Updates,
Roger
Re: Cannot execute data definition statements on linked data sources,
Allen Browne
Re: Return parent based on child,
Marshall Barton
Re: Time Calculation,
Allen Browne
Re: Use Date as Query Criteria,
Allen Browne
Update Query Problem,
Nick Bradbury
Making query to bring in an actual name,
Ray Murphy
Re: Missing Birth Dates,
Duane Hookom
Re: Help on Consolidating data,
John Vinson
Re: Bonus 10% of Salary,
John Vinson
Re: Help on Consolidation,
John Vinson
Re: Type Mismatch in Expression Error,
John Vinson
Re: 1st Of Every Month,
Jeff Boyce
Re: Fiscal Months Query,
Douglas J. Steele
Query that seems impossible,
Gaetanm via AccessMonster.com
Show ontly the information that's not in table A,
Laputa
Type of Query Needed to Get this report...,
Sean Massey
Re: Criteria that allows to Query Upper Case,
John Spencer
Create a table with an autogen field using SQL,
kramer31
Re: Date/Time in a query,
Jeff Boyce
Re: Diference in hours between to hours,
John Spencer
Re: Northwind,
Jamie Collins
bloomberg functions,
ragtopcaddy via AccessMonster.com
Re: Exclude records in qry1 if the same record ID is found in qry2 ..,
David F Cox
Re: default values in a field,
Rick Brandt
Re: Secret to getting a response?,
Rick Brandt
Month to date query,
hotplate
strange things with select queries,
Aivars
SQL Query to copy Data from One Table to another Table having same names but from different databases,
apurv . agarwal
Re: If two fields are equal select only the highest value,
Allen Browne
Distinct Count in Crosstab Query,
kittyfool via AccessMonster.com
Use List Box to select a paramter for a query,
jeh
Re: Use combo box to set parameter for query,
John Vinson
Re: Access Can't Append Message,
jlepack
Protecting queries,
C Tate
Re: Query For Multiple Criteria Related to 1 Or More Unique Elements,
David F Cox
Calculations within a query,
botuco via AccessMonster.com
Re: Combine Related Queries ???,
John Vinson
Re: Automatically Delete Duplicated Entries Error,
John Spencer
Need Help with Counting of Sequence for worked hours,
ettekcor
Re: Iif coding seemingly not working,
David F Cox
DCount on multiple tables,
botuco via AccessMonster.com
RE: A select query that compares 2 tables,
Craig
Outer join adds calculated value to all records,
JimJ
Re: Append Query.....,
John Spencer
How Many Employees Were At Work At 10:00am?,
tbl
Re: Size of Query result,
Allen Browne
Re: Create Index autonumber,
Allen Browne
#Error in select query,
Aivars
Multiple columns sort,
muskie
Problems with IIF,
mattc66 via AccessMonster.com
formatting text field to show numbers only,
Russ via AccessMonster.com
How to sort months in combo box?,
KK
Re: How to sort months in combo box?,
Granny Spitz via AccessMonster.com
Microsoft Access Queries to an Oracle DB run 4 times slower in XP than Win98,
Sly
Nested IIF help,
Incolor
RE: Parementer Queries,
SusanP via AccessMonster.com
Re: append new data and update changed data,
kingston via AccessMonster.com
update based on column name dynamic,
Brian
Conditional Sum Problem...,
killjoy966
Top 12 values?,
S Davis
A select query that compares two table,
Craig_B
Why is my subquery running multiple times?,
Billy Smith
Re: multiple criteria statements,
kingston via AccessMonster.com
Re: Concatenating values from a many relation,
kingston via AccessMonster.com
Need help sorting months,
KK
Re: Combining 2 tables,
Allen Browne
Re: I'm all out of OR...,
Allen Browne
MATCHING RECORDS BASED ON A RANGE OF DATA,
Ian W.
Re: Error 3070 Invalid field name w/ crosstab,
Duane Hookom
Re: Funtion to count characters in strings,
Duane Hookom
Re: List record by sum condition!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!,
Duane Hookom
Re: Cumulative Query,
Allen Browne
Re: Parameter qry and forms,
Allen Browne
Re: IIF Query,
BruceM
- Message not available
- <Possible follow-ups>
- Re: IIF Query,
David F Cox
Re: SUM CONDITION VERY DIFFICULT!!!Please help me,
David F Cox
- Message not available
- Message not available
- Message not available
Re: Percentage of Defects by Shift,
David F Cox
Re: Interesting Crosstab,
David F Cox
Query Sum Returning total times 3,
Regan via AccessMonster.com
Re: Cut Query?,
fredg
Append to table but ensure no duplicates,
Russ via AccessMonster.com
- Re: Append to table but ensure no duplicates,
Marshall Barton
- Re: Append to table but ensure no duplicates,
Russ via AccessMonster.com
- Re: Append to table but ensure no duplicates,
Russ via AccessMonster.com
- Re: Append to table but ensure no duplicates,
Gary Walter
- Re: Append to table but ensure no duplicates,
Russ via AccessMonster.com
- Re: Append to table but ensure no duplicates,
Gary Walter
- Re: Append to table but ensure no duplicates,
Russ via AccessMonster.com
- Re: Append to table but ensure no duplicates,
Marshall Barton
- Re: Append to table but ensure no duplicates,
Russ via AccessMonster.com
- Re: Append to table but ensure no duplicates,
Gary Walter
- Re: Append to table but ensure no duplicates,
Russ via AccessMonster.com
- Re: Append to table but ensure no duplicates,
Gary Walter
- Re: Append to table but ensure no duplicates,
Russ via AccessMonster.com
- Re: Append to table but ensure no duplicates,
Gary Walter
- Re: Append to table but ensure no duplicates,
Russ via AccessMonster.com
- Re: Append to table but ensure no duplicates,
John Spencer
Re: Add error handling to parameter query?,
Van T. Dinh
place holder, blank record, message,
BrightIdeas
Re: Calculation in Query,
kingston via AccessMonster.com
RE: Those tricky Crosstab Queries,
KARL DEWEY
Retrieve the Record ID Just Inserted,
Samuel Shulman
Multiple date math,
pmelk6
Re: Critical Help needed please on query date,
David F Cox
Average Days,
Charles Phillips
Crosstab query help please,
K. L. Collins
Re: if function error in a Querie,
John Spencer
Re: Matching Data,
kingston via AccessMonster.com
Re: Replace a single character at the end of a string,
Rick Brandt
Re: Keeping the "First" Duplicate Record, Delete Subsequent,
John Spencer
Re: Week Days,
John Spencer
Access 97 Sub Query Error,
steve
How do i check against each value of a list box,
Hotshots
Query imported into MS-Excel gives empty result,
mogens
Re: Criteria using part date,
Rick Brandt
Split the names by space,
learning_codes@xxxxxxxxxxx
Re: why do I get just the sum with Avg([column1]+[column2]...),
David F Cox
Re: Perameter Query... I'm completely annoyed,
Rick Brandt
sql query,
ruomingxu
macro transfer text,
Pamela Creighton
Re: Passing Criteria from a Form to underlyng Qry of Report,
fredg
Re: Another Pass Parameter question,
Duane Hookom
Automatic Databases Link (Link Tables),
BluesPhone via AccessMonster.com
Using IIF to count the is not null records in a table,
KFox via AccessMonster.com
copying results of query to excel,
jomara via AccessMonster.com
Re: Using a Lookup Table in a Query,
Duane Hookom
Append, Update, Both?!?!?,
bastraker via AccessMonster.com
Re: INSTR,
kingston via AccessMonster.com
- Message not available
- Message not available
Re: 'Must be an updatable query' problem,
Amy Blankenship
Re: Mact query from a list,
John Vinson
Re: Append query/ make-table query has suddenly quit working,
AC
Query and time,
Gaetanm via AccessMonster.com
Re: Subquery Question,
kingston via AccessMonster.com
Queries Dont Allow Edits,
FIECA
Re: How do I get a spreadsheet to print fullsize?,
Rick B
Re: Max Len of all fields in table,
John Spencer
Re: Truncate phone extension,
John Spencer
RE: add records to a table from a recordset,
Klatuu
Re: Take out SumOFMyFieldName from Query,
John Spencer
Re: Query in Multiple Fields,
kingston via AccessMonster.com
Join Query Problem for matching criteria, PLEASE help,
Ian W.
Re: Data Type mismatch Criteria Expression,
marc
- Re: Data Type mismatch Criteria Expression,
Ken Snell \(MVP\)
- Re: Data Type mismatch Criteria Expression,
marc
- Re: Data Type mismatch Criteria Expression,
Ken Snell \(MVP\)
- Re: Data Type mismatch Criteria Expression,
marc
- Re: Data Type mismatch Criteria Expression,
Ken Snell \(MVP\)
- Re: Data Type mismatch Criteria Expression,
marc
- Re: Data Type mismatch Criteria Expression,
Ken Snell \(MVP\)
- Re: Data Type mismatch Criteria Expression,
marc
- Re: Data Type mismatch Criteria Expression,
Ken Snell \(MVP\)
- Re: Data Type mismatch Criteria Expression,
marc
- Re: Data Type mismatch Criteria Expression,
Ken Snell \(MVP\)
- Re: Data Type mismatch Criteria Expression,
marc
- Re: Data Type mismatch Criteria Expression,
Ken Snell \(MVP\)
RE: Query for string within an embedded OLE object,
td
Re: FormatDate,
Allen Browne
Re: Change field type from VB,
Allen Browne
IE7 still sux - Firefox 2 RuLeZ,
Soundchaser
adding product qty fields from multiple records to transaction record,
Jesse
Select Query,
Greg
Query stops working when based on a temporary query,
BrightIdeas
Re: losing trailing spaces,
Van T. Dinh
ie7 stinks stay with v6,
Soundchaser
How to compare two simple fields ?,
nrgz28
Re: Query or Form for criteria between . . .,
John Vinson
Concatenate text,
mdavis via AccessMonster.com
Re: Query Expression Error,
John Vinson
Re: After Access2002 SP3, I lost functions like Format, Left, Right,,
fredg
Re: How the #@!! do I do this?,
Ken Snell \(MVP\)
Re: Months,
John Spencer
- <Possible follow-ups>
- Re: Months,
Ken Snell \(MVP\)
CrossTab Query,
Brian
Re: Need to total many of one relationship,
kingston via AccessMonster.com
Re: Elegant solution to query problem,
kingston via AccessMonster.com
Re: Need several totals - Don't where to start,
John Vinson
Re: Add "ALL" to Combo Box,
fredg
Re: Dsum Multiple Criteria,
kingston via AccessMonster.com
Update Query in a Subform with Sums,
mjtan
Re: Idebtify Dates Within A Date Range,
kingston via AccessMonster.com
Re: Obtaining a Unique Record,
kingston via AccessMonster.com
RE: Query to combine records based on matching criteria. PLEASE he,
Ian W.
RE: Repeating parameter queries and counting,
Jakki
Re: Count Query - returning Null values,
John Spencer
Consumption during time window,
GillesScouvart
Re: Querie problem,
John Vinson
Re: Random Record Selection,
Van T. Dinh
Re: problem with WHERE clause when using Microsoft.Jet.OLEDB.4.0,
Van T. Dinh
Re: Using DISTINCT and TOP,
Van T. Dinh
How to set up IN(list) as a parameter,
Steve Marshall
Re: Using Query With No Results in Another Query,
Jeff Boyce
Re: Only one parameter,
Jeff Boyce
Re: Compare tables,
John Spencer
Re: Counting miss matches,
Jeff L
Create a delete query macro?,
Jason
Re: Dynamic Counter,
Marshall Barton
Re: Concatenate function,
fredg
Run Query in VBA By Query Name,
Ronster
Re: Run Query in VBA By Query Name,
Van T. Dinh
cast order by,
Jeff
ORDER BY question,
cdolphin88
Re: Nested parameter query,
Amy Blankenship
Re: Exporting to flat text file,
John Spencer
Query to retrieve records that don't match criteria,
SusanP via AccessMonster.com
Re: dupliacte query,
kingston via AccessMonster.com
RANK,
Maqza via AccessMonster.com
Sum the column in query result,
imtmub
Link two table in one query,
imtmub
Re: Switch Function,
David F Cox
Query help,
Julie Smith
Date,
antonov
check query exists else msgbox "query missing",
BrightIdeas
refresh or close query,
BrightIdeas
RE: total Query,
Ken Sheridan
Re: #ERROR,
tina
- Message not available
- Message not available
Re: Query or what?,
Douglas J. Steele
[Ender Date]+1 Query Problem,
Don
Update is deleting current data from field...,
bcp1961
Re: Daily Price Variation Causes Profit Integrity Issues,
Duane Hookom
Total Queries,
Jeff
Re: I am really starting to hate access, its inconsistencies and its b,
Rick Brandt
Re: Return Sum in one field for all records with another field in comm,
Allen Browne
Ranking on SQL,
Maqza via AccessMonster.com
Re: Append to Table with Indexed Field,
Allen Browne
Re: Password question,
Smartin
Re: data type mismatch,
Brendan Reynolds
Re: Counting in Access,
John Spencer
Re: Date Query Question,
kingston via AccessMonster.com
Re: Length Limits on MS Access Filters,
kingston via AccessMonster.com
Re: How to find expired/missing data?,
John Vinson
Calculating Material Usage,
Nick Bradbury
Re: Sorting based on dates,
kingston via AccessMonster.com
RE: Multiple conditions in an IIF statement,
Victoria1366
Use of email,
DSmith
Calculating a median,
Marco Shaw