microsoft.public.access.queries
- Re: How to count number of Wednesdays between two dates,
fredg
- Removing NEAR duplicate results,
sharpie23
- Re: return a "0" instead of a blank field,
John Spencer
- Re: Query - How can I show duplicate rows?,
Ken Snell \(MVP\)
- Re: Query sometimes creates its own [useless] expression??!!,
Gary Walter
- Re: Update Query SQL Help,
Gary Walter
- Re: reports: # of documents in many bundles,
Gary Walter
- Cant figure this out,
SFCSCOTT
- Re: Return a blank feild,
Jeff Boyce
- Re: Date expression,
Jeff Boyce
- Re: find oldest person living at an address,
Jeff Boyce
- Re: What is the IN CLAUSE for an access database with password?,
Marshall Barton
- Re: IIf statements with AND criteria,
Ken Snell \(MVP\)
- Concatenating two sets of records,
Bob Howard
- Re: Can query messages be suppressed ro turned off,
fredg
- Re: Cross-Tab Query,
John Spencer
- Re: Blank Values,
John Spencer
- Goup query,
HLCruz via AccessMonster.com
- Re: How to create this query. Not easy,
Michel Walsh
- Re: update a sequence of records to seperate fields in new table,
Jeff Boyce
- Form Based Parameter Query,
Bill
- Finding duplicates accross two fields,
aine_canby
- RE: date / time question,
Jerry Whittle
- Re: Changing the format of data,
Pieter Wijnen
- Re: Ignore duplicate records,
John Spencer
- Re: Changing numbers,
John Spencer
- Re: Criteria Between,
Allen Browne
- Query/Table question,
Beto1967
- Re: query expression too complex,
Marshall Barton
- Re: Data entered twice,
Douglas J. Steele
- Re: Need Query Help,
Douglas J. Steele
- Re: HOW TO USE NOT LIKE EXPRESSION,
Michel Walsh
- Re: Calculated Date,
Ken Snell \(MVP\)
- Re: Unmatched query not working,
Ken Snell \(MVP\)
- Select first(...)...Group BY... = useless?,
Mark Burns
- Re: Filtered query question,
Allen Browne
- RE: Apply curve to results of query,
Dale Fye
- Query from an SQL table that has XML info in one field,
SmartCookie
- Re: Fields filled with ########,
Ken Snell \(MVP\)
- Converting Text to Date,
KimTong via AccessMonster.com
- Contenate & Right Justify,
idmnstr via AccessMonster.com
- Re: use a result of a query as input criteria for another query,
Jamie Collins
- Bytes Per Row,
bhipwell via AccessMonster.com
- Re: SQL Error,
Ken Snell \(MVP\)
- report with 3 sections need a query???,
Dan
- RE: When I open design view in a query I get "is not a valid name.,
DougM
- duplicate records,
emailcad
- How do I sort records in Runtime ?????,
deaconj999
- IN SELECT Query Criteria,
Cydney
- Parameters,
turny
- Retriving the last date,
Todd
- need to take out an INNER JOIN to a user table,
Janis
- RE: query calculator like excel,
S.Clark
- Re: Convert Numeric to Text Fields, Help!!!,
Ken Snell \(MVP\)
- Re: Execute Existing Query Programattically,
fredg
- Re: Help Needed with query,
John Spencer
- Re: Date not within range query,
John Spencer
- Re: choose quantaty by lot using FIFO,
Jamie Collins
- Re: Date Filter,
Ken Snell \(MVP\)
- RE: Crosstab with multiple columns?,
KARL DEWEY
- Query to eliminate blank fields,
Mary M
- RE: Query not Returning Results,
Dale Fye
- RE: Access 2003: Extra row in duplicates query,
Bill Downs
- Re: Getting query to look up the values of combo boxes then display da,
John Spencer
- Re: "Short time" format and duration,
Pieter Wijnen
- Date and hour arrangement,
mohsin via AccessMonster.com
- RE: Hyperlink Syntax,
mattc66 via AccessMonster.com
- Error Message,
Gary Sharp
- Re: combining multiple entries into one result,
John W . Vinson
- Sort multiple query results,
Opal
- Re: Sort multiple query results,
Michel Walsh
- Re: Sort multiple query results,
Jamie Collins
- Re: Sort multiple query results,
Opal
- Re: Sort multiple query results,
Michel Walsh
- Re: Sort multiple query results,
Opal
- Re: Sort multiple query results,
Opal
- Re: Sort multiple query results,
Jamie Collins
- Re: Sort multiple query results,
Opal
- Re: Sort multiple query results,
Jamie Collins
- Re: Sort multiple query results,
Jamie Collins
- Re: Sort multiple query results,
Opal
- Re: Sort multiple query results,
Opal
- Re: Sort multiple query results,
Opal
- Re: Sort multiple query results,
Opal
- Re: Sort multiple query results,
Opal
- Re: Sort multiple query results,
Jamie Collins
- Re: Adding Date to the table name in a Make Table Query,
fredg
- Re: Checkbox column in a table,
John W . Vinson
- Re: Drop down list inside a query,
John W . Vinson
- Combo Box in Queries,
CharlesCount via AccessMonster.com
- Re: Pass through query giving an invalid column error,
John Spencer
- Re: Query to Count Consecutive days?,
Michel Walsh
Re: Criteria for totals query,
Michel Walsh
Re: Max and 2nd Highest for two identifiers,
Michel Walsh
Re: Beginner question,
J_Goddard via AccessMonster.com
Re: REPOST: Error 2329 (To create a crosstab query ...),
Gary Walter
Re: ROUNDUP to 9s,
Gary Walter
RE: IIF NULL = ALL,
Dale Fye
Re: What is wrong with my sql?,
Allen Browne
RE: Query to get sum of a field if two fields match,
Newbie_Sashi
Re: Delete fields,
Allen Browne
Re: Max Function,
Allen Browne
Export using a DTD - HELP!,
rmorrison
using parameters,
c8tz
SQL Functions Help,
vjp2 . at
Re: Passing DB path as IN SQL clause,
Marshall Barton
Re: help ... similiar to parameter query; complex query,
John W . Vinson
Re: Without Matching Query Limit ?,
Marshall Barton
- <Possible follow-ups>
- Re: Without Matching Query Limit ?,
Jeff Boyce
- Message not available
- Re: Without Matching Query Limit ?,
John Spencer
- Re: Without Matching Query Limit ?,
Stuart
- Re: Without Matching Query Limit ?,
Jamie Collins
- Re: Without Matching Query Limit ?,
Stuart
- Re: Without Matching Query Limit ?,
Jamie Collins
- Re: Without Matching Query Limit ?,
John Spencer
- Re: Without Matching Query Limit ?,
Stuart
- Re: Without Matching Query Limit ?,
Jamie Collins
- Re: Without Matching Query Limit ?,
John Spencer
- Re: Without Matching Query Limit ?,
Jamie Collins
- Re: Without Matching Query Limit ?,
Stuart
- Re: Without Matching Query Limit ?,
Jamie Collins
- Re: Without Matching Query Limit ?,
Stuart
using parameters for calculations,
c8tz
Query Help,
Andy Paris
<Possible follow-ups>
Query Help,
Mary M
Query help,
blazzzercat via AccessMonster.com
Using Multislect on feilsd with null value,
cwby1966
Re: Search Function,
Ken Snell \(MVP\)
Re: parameter query - return all or part,
John Spencer
Normalization woes - how do I reproduce a query?,
Frank
What is wrong with this query?,
nlburgess via AccessMonster.com
Re: Appending new master rows to an existing master table,
John Spencer
Re: I use the same parameter in 2 queries - how do I only enter once?,
Michel Walsh
Auto add a new record on specified date.,
wesley.allen@xxxxxxxxx
Re: Find a text string and compare it against a field in a different t,
Michel Walsh
Parameter box, complex query,
floyd33
Re: Transpose data from rows to columns,
Roger Carlson
Query for UK Financial period,
DaveTheRave.NET
Re: Diplaying the first event by date for each ContactID,
Allen Browne
Query Problem,
Dudy
Q. re: Vista Home Basic,
Lenora
Re: Problem: query from two tables connected to a third table,
Wolfgang Kais
Re: Time based query - records within 10 minute intervals,
Allen Browne
Re: Date Restrictor for last week's sales,
Wolfgang Kais
Re: Display records based on count value of one field,
Wolfgang Kais
Auto Add new records on a specified date,
wesley.allen@xxxxxxxxx
RE: Please help with Update Query,
rich
Error 3075 ...IIf statement,
Don Garry
Different queries but the same?,
Linda RQ
Re: DELETE QUERY PROBLEM,
Douglas J. Steele
labour report,
Bill M.
Re: Parameter Query Dates,
Allen Browne
RE: checkbox conditional math,
KARL DEWEY
Re: unique only,
Jeff Boyce
Re: long if function,
Conan Kelly
Re: problem making an query?,
Jeff Boyce
Only showing after @ duplicates,
sanderijken
Re: How do you query using information from 2 different tables?,
Conan Kelly
Parameter In Operator,
Ronald Dodge
Re: Convert numeric dates to text?,
Jeff Boyce
Re: count the number of days,
Michel Walsh
Repeat Data,
tbotkin via AccessMonster.com
RE: Row to Querie,
Jerry Whittle
RE: Expression Troubles,
Novice2000
Counting records and Where criteria,
Tony Williams
Re: How do I consider price of purchase combined with date of order?,
jon
slow append query from a pass through query,
Aivars
Break up a field,
vjp2 . at
Re: Escape Key,
Allen Browne
Re: To preserve records.,
Marshall Barton
Getting 'validation rule violation' when I don't have any validation rules?,
S Davis
Super Function II,
Steve Dassin
Data entry Query,
Angel G
Re: Separate Name field,
fredg
Re: date serial,
Michel Walsh
Re: Moving data into a new table once selected from a form,
Michel Walsh
RE: Attempting to clean up a db --- need some help...,
jamesfreddyc
update data from aggregate query,
mbr96 via AccessMonster.com
Re: Query to count records in a table,
Michel Walsh
Re: Sharper Focus On Query Question,
John W . Vinson
Re: How to find any character within a field?,
Jeff Boyce
Re: DCount Function - #Error,
Marshall Barton
Re: Sum question,
John W . Vinson
Re: concatenate,
Marshall Barton
help,
misschanda via AccessMonster.com
how to "flatten" a list,
asc4john
- Message not available
- Message not available
RE: Error 3075,
Dan @BCBS
Query Criteria Like,
CharlesCount via AccessMonster.com
Re: eliminate message from append query to eliminate duplicate record.,
Allen Browne
RE: query using 2 tables and a query,
Andy Hull
make new table,
Garry
Rounding errors,
Bongard
Re: Probably A Stupid Query Question,
Bongard
RE: Number of days,
Tommy2326
Count Duplication Help,
Andy Paris
Combining feilds,
Syed Zeeshan Haider
Re: Update,
John W . Vinson
Re: convert text column to date.,
John W . Vinson
RE: Excluding records,
KARL DEWEY
RE: Averaging Scores,
smeldawg
Re: Update qry removing ONLY Alpha,
Jeff Boyce
Re: compare date field in 1 table to start & end date fields in 2nd ta,
John W . Vinson
Help counting occurences of duplicates.,
rhaazy
Re: automate a make table query,
Jeff Boyce
SQL statement format for readability and making adjustments purposes,
Ronald Dodge
Re: Queries that have specific time frames,
John Spencer
right string problem,
mbc04
RE: Run-time error 3061,
S.Clark
Separate By Comma,
Beagle1927
RE: format date,
JohnLute
Parameter Queries,
Ronald Dodge
"like" works as query, but not in code (Access 2003),
javaguy
RE: Time bound column,
Dale Fye
Comparing 'matched' data,
Leslie Isaacs
Query problems,
Daniel . Ran . XU
Re: Calculate yield,
Conan Kelly
Transfer a reports result to a query,
Garry
Dropping duplicate records based on content,
Chip
Re: need 1 query pulling 3 different count(totals),
Jeff Boyce
RE: Delete query with list box for parms modifies FIRST record,
Dale Fye
Can we create multiple pivot tabel views for a single access query?,
preeti p
Re: random sampling,
Marshall Barton
Re: Select from List of Choices In Query,
Marshall Barton
RE: Adding a new record with a reference to another table,
Dale Fye
Re: How do I exclude values from my combo box?!?!?! HELP!!!,
Ken Snell \(MVP\)
Re: Query Expression,
John Spencer
Re: add time to a field - MINUTES,
fredg
Re: Can a parameter query display a date plus 5 days ahead?,
John Spencer
Date() frustration within query builder - please assist,
pilch74@xxxxxxxxx
Re: No Recipients When Using a Query to Mail Merge in Word,
John Spencer
Dcount: referencing a saved query field in a mathematical expression,
joeyrhyu
Table loading?,
shaunismms
RE: Poor performance running queries with tables linked to Oracle,
Jerry Whittle
Re: Crosstab Where Clause Problem,
Michel Walsh
Re: Design Quert tool is making tables with an *, how do I stop it? .,
Michel Walsh
Re: adding a field using a query,
John Spencer
Query that returns 0 instead of null,
aine_canby
RE: Summing a field obtained via a stored procedure,
Syvers
Pulling identical numbers if "text" found,
tekari
Union query drawing from another query,
John D
Re: Update Query Syntax,
George Nicholson
how to get unrepresented categories to show up in an xtab query,
starlingseven via AccessMonster.com
Re: Beginning and Ending dates for groups of events,
Michel Walsh
Re: Multiple Criteria and return only one match,
John Spencer
ip numbers overflow,
scott
Join same field on two tables,
wilsoch
Crosstab Query - More Than Two Values?,
Leviathan via AccessMonster.com
Re: Using a query to create a count...,
Jeff Boyce
Re: Blanks incorrect,
John Spencer
Re: Query Design Help Needed,
John Spencer
Numeric Field Overflow problem (TOP URGENT),
Samer
Reference a Date and Time in Query,
tmm786
Unique identifier,
Chris
VBA DoCmd.RunSQL,
Karen Boyer
Re: data type mismatch in critera,
John Spencer
Re: Total Expression Help,
John Spencer
Re: Comparing two tables,
John Spencer
Re: SQL Query between 2 dates,
Allen Browne
Re: how to base a form on a query,
tina
Complex query,
Jeff
Deleting Values From a Query's Results,
mcl
Re: create a query to output to Excel,
Gary Walter
Help with query criteria,
Opal
Re: How do I determine calendar quarters in Access ?,
Allen Browne
plz help !! Undefined function 'Date' in expression,
MrCC via AccessMonster.com
Re: I need to query the field name of "true" value out of 3 fields,
Marshall Barton
Sub-grouping Inventory Data,
Senexis
I need to delete oldest record so that table only contains latest record,
d . barson
Re: Problem with between date function,
Rick Brandt
Duplication of records in query?,
Tony Williams
Re: #name?,
Allen Browne
Re: Who can take on this challenge,
Marshall Barton
Re: SubQuery - Return value from table x based on value in table y,
John W . Vinson
Re: Extract partial string,
fredg
Re: total all records in a query,
John W . Vinson
Criteria and instructions in an expression,
Linda RQ
Strange dlookup behaviour,
Ceebaby via AccessMonster.com
Re: DateSerial not working,
Ken Snell \(MVP\)
Re: 3 Months from January of this year,
Amy Blankenship
Re: syntax error in error of Total of field,
Michel Walsh
Re: "Totals" button in query - what is it used for?,
George Nicholson
Re: Statement no working,
George Nicholson
Re: Using Left to extract info,
Steve
Syntax for a static GUID in Jet SQL,
misfit815
Combining multiple columns into single column based one another field,
aine_canby
Re: dividing currency with inaccurate results,
Michel Walsh
Re: INSERT INTO Via Cross Tab,
Michel Walsh
Aged Customer balances,
q
RE: date format/sort problem,
JohnLute
Re: Adding table fields per Record,
Jeff Boyce
Duplicate Returns,
misschanda via AccessMonster.com
Re: how to combine two queries in access stored procedure,
Michel Walsh
Re: Todays date minus 6 days before (Shows all records in 6 days),
Stefan Hoffmann
Re: returning multiple records on a single line,
Dale Fye
Re: Making a Parameter Query for Date and timestamp, with input mask.,
Douglas J. Steele
RE: Date ranges,
AFSSkier
RE: Expression Help,
Novice2000
Re: Append Query,
Michel Walsh
- <Possible follow-ups>
- Append Query,
CharlesCount via AccessMonster.com
- Message not available
- Message not available
Re: Update SQL Statement Help,
John Spencer
Re: Create Initials,
John Spencer
Re: Subtracting Q over Q,
Jeff Boyce
RE: Calculating Work Dates,
Dale Fye
Re: Parameter Criteria,
fredg
Re: Date Function,
Michael Gramelspacher
Re: Working out ages from DOB.,
Allen Browne
RE: current month / year WHERE,
JohnLute
checking queries between programs,
Garry
Re: How to list all tables in a database that are NOT empty?,
John Spencer
"Stacking" Identical Tables,
Keith & Dayna
Re: print selected columns in query,
John Spencer
Field as column name.,
Michel Pauwels
monthly report problem??,
MrCC
iif(isnull( in Query,
grubbyr
Update Fields If FROM Table Fields Are NOT NULL,
Handyman
RE: How to make this cross tab query,
Hell-fire
Re: multiple query parameters on a single field,
Ken Snell \(MVP\)
Re: Need join with count of matching records in 2nd table,
Jeff Boyce
Combo query,
Budd
Re: Changing "Firstweekofyear" within a query,
Douglas J. Steele
Re: How do I delete a return address that appears as a deafult addres,
John W . Vinson
MS ACCESS Jet SQL: Update statements that utilize saved queries/dmax,
joeyrhyulz
Re: Setting variables in VB for use in queries,
Michel Walsh
Re: calculated field rounding down,
George Nicholson
Access 2003 query help please,
Sid Price
- Message not available
- Message not available
Re: HELP Query via ADO never return but in access takes less millisecs,
Michel Walsh
Re: Multipy time?,
John Spencer
Re: QA,
John Spencer
- Message not available
- <Possible follow-ups>
- QA,
Duane Hookom
rownum update sql,
marfi95
Re: How can we convert a crosstab query to a table?,
John Spencer
Re: Getting Criteria from Optionbuttons,
John Spencer
Re: Combine field from several records,
John Spencer
Re: Working with Null Values,
John Spencer
Re: Time Calculations,
John Spencer
Developing queries in two or more parts.,
Bill
count null record in fileds dao,
sal21
Top 5 by a GROUPing?,
Jay
problem with update query,
Tim
Adding fields into exisiting table,
tekari
Re: Calcutlating a DueDate with a working days function,
Michael Gramelspacher
Append Non-Duplicate & Updated Records,
owp^3
RE: How to set up Query?,
teelee
Is It Possible To Pass Parameters to A Pass Through Query,
mcl
count query and negative numbers question,
David
Re: count decimal place,
Douglas J. Steele
RE: join on two firelds,
KARL DEWEY
Re: how do I search dates using the "between and" function,
John W . Vinson
Re: Double dates,
John W . Vinson
Data type mismatch,
injanib via AccessMonster.com
Calculating percentage of Total?,
Jay
Re: $ and decimals in calculation,
Jeff Boyce
Re: Is there a limit on Union query unions?,
John Spencer
Multiple Update Set Statements or Multiple DML Statements in one,
thedudeminds
Re: update a table based upon another table,
Steve
Re: Calculating the sum of a field,
Marshall Barton
Re: Sorting non alphabetically,
Jamie Collins
Re: Current Month Last,
Ken Snell \(MVP\)
Re: Date() in XP/Access 2003,
John Spencer
Combining two queries into a single query,
aine_canby
Re: Access Date() & DateAdd functions apparent error in Vista,
Allen Browne
Re: MS Access Error 3700,
Stefan Hoffmann
Re: conditional update query returning empty field,
John W . Vinson
Re: Relational,
John W . Vinson
RE: Sum Last 4 Quarters,
NetworkTrade
Re: In Access, Where do I find SQL Query Builder for forms; unbound co,
John W . Vinson
Re: Updateable Query,
John W . Vinson
Query that returns nothing,
Keith
Re: how to write the query criteria,
Jeff Boyce
Re: does not include the specified exp as part of an aggregate,
John Spencer
Re: Finding wrong values for keyfield,
John Spencer
RE: Performing Loop query ( for parts replaced),
Mercadogs
DSum Ineffective,
Intui_Sol
Expression,
CharlesCount via AccessMonster.com
RE: Extracting Partial Text from Field - INSTR and INSTRREV,
Ken Sheridan
Re: Last record on a table,
John Spencer
Form parameter Query,
ad
August is a problem,
SaskGuy
Re: Percentage question,
Jase4now
Re: Extracting golf score data,
Mark Senibaldi