microsoft.public.access.queries

• Thread Index

---

• Re: How to count number of Wednesdays between two dates
  • From: fredg
• Re: Removing NEAR duplicate results
  • From: raskew via AccessMonster.com
• Removing NEAR duplicate results
  • From: sharpie23
• Re: Query sometimes creates its own [useless] expression??!!
  • From: KT Huggs
• Re: return a "0" instead of a blank field
  • From: John Spencer
• Re: Query - How can I show duplicate rows?
  • From: Ken Snell \(MVP\)
• Re: What is the IN CLAUSE for an access database with password?
  • From: Gary Walter
• Re: Query sometimes creates its own [useless] expression??!!
  • From: Gary Walter
• Re: Update Query SQL Help
  • From: Gary Walter
• Re: reports: # of documents in many bundles
  • From: Gary Walter
• Re: find oldest person living at an address
  • From: Gary Walter
• Re: Cant figure this out
  • From: Allen Browne
• Cant figure this out
  • From: SFCSCOTT
• RE: Cross-Tab Query
  • From: Duane Hookom
• Re: Return a blank feild
  • From: Jeff Boyce
• Re: Date expression
  • From: Jeff Boyce
• Re: find oldest person living at an address
  • From: Jeff Boyce
• Re: update a sequence of records to seperate fields in new table
  • From: Jeff Boyce
• Re: What is the IN CLAUSE for an access database with password?
  • From: Marshall Barton
• Query help
  • From: blazzzercat via AccessMonster.com
• Re: IIf statements with AND criteria
  • From: Ken Snell \(MVP\)
• Re: update a sequence of records to seperate fields in new table
  • From: efandango
• Re: Concatenating two sets of records
  • From: Bob Howard
• Concatenating two sets of records
  • From: Bob Howard
• Re: Goup query
  • From: Jeff Boyce
• Re: update a sequence of records to seperate fields in new table
  • From: Jeff Boyce
• Re: update a sequence of records to seperate fields in new table
  • From: efandango
• Re: Goup query
  • From: HLCruz via AccessMonster.com
• Re: Can query messages be suppressed ro turned off
  • From: fredg
• Re: Extracting golf score data
  • From: Barry
• Re: update a sequence of records to seperate fields in new table
  • From: Jeff Boyce
• Re: Goup query
  • From: Jeff Boyce
• Re: update a sequence of records to seperate fields in new table
  • From: efandango
• Re: Cross-Tab Query
  • From: John Spencer
• Re: Unmatched query not working
  • From: Ken Sheridan
• Re: How to create this query. Not easy
  • From: Michel Walsh
• Re: Blank Values
  • From: John Spencer
• Goup query
  • From: HLCruz via AccessMonster.com
• Re: How to create this query. Not easy
  • From: Marco
• Re: How to create this query. Not easy
  • From: Michel Walsh
• Re: Converting Text to Date
  • From: KimTong via AccessMonster.com
• Re: IN SELECT Query Criteria
  • From: Michel Walsh
• Re: update a sequence of records to seperate fields in new table
  • From: Jeff Boyce
• Re: Ignore duplicate records
  • From: John Spencer
• Re: Converting Text to Date
  • From: John Spencer
• Re: Converting Text to Date
  • From: John Spencer
• Re: IN SELECT Query Criteria
  • From: Cydney
• Re: IN SELECT Query Criteria
  • From: Jamie Collins
• Re: Converting Text to Date
  • From: KimTong via AccessMonster.com
• Re: Converting Text to Date
  • From: KimTong via AccessMonster.com
• Re: Finding duplicates accross two fields
  • From: Michel Walsh
• Re: query expression too complex
  • From: JohnLute
• Re: Ignore duplicate records
  • From: Keith Woollacott
• Form Based Parameter Query
  • From: Bill
• RE: date / time question
  • From: scubadiver
• Finding duplicates accross two fields
  • From: aine_canby
• Re: Ignore duplicate records
  • From: John Spencer
• Re: Query to Count Consecutive days?
  • From: Michel Walsh
• RE: date / time question
  • From: Jerry Whittle
• Re: Changing the format of data
  • From: Pieter Wijnen
• Re: HOW TO USE NOT LIKE EXPRESSION
  • From: Pieter Wijnen
• Re: query expression too complex
  • From: JohnLute
• Re: Ignore duplicate records
  • From: John Spencer
• Re: Changing numbers
  • From: John Spencer
• Re: IN SELECT Query Criteria
  • From: Dale Fye
• Re: Criteria Between
  • From: Allen Browne
• Re: Sort multiple query results
  • From: Jamie Collins
• Re: IN SELECT Query Criteria
  • From: Jamie Collins
• Query/Table question
  • From: Beto1967
• Re: Sort multiple query results
  • From: Opal
• Re: Sort multiple query results
  • From: Opal
• Re: Sort multiple query results
  • From: Opal
• Re: query expression too complex
  • From: Ken Snell \(MVP\)
• Re: HOW TO USE NOT LIKE EXPRESSION
  • From: Jeff Boyce
• Re: Data entered twice
  • From: Jeff Boyce
• Re: query expression too complex
  • From: Pieter Wijnen
• Re: Sort multiple query results
  • From: Opal
• Re: Sort multiple query results
  • From: Opal
• Re: query expression too complex
  • From: Ken Snell \(MVP\)
• Re: query expression too complex
  • From: Marshall Barton
• Re: Data entered twice
  • From: Douglas J. Steele
• Re: Need Query Help
  • From: Douglas J. Steele
• Re: Calculated Date
  • From: Ken Snell \(MVP\)
• Re: Select first(...)...Group BY... = useless?
  • From: Mark Burns
• Re: Calculated Date
  • From: bluesky
• Re: HOW TO USE NOT LIKE EXPRESSION
  • From: John W . Vinson
• Re: HOW TO USE NOT LIKE EXPRESSION
  • From: Michel Walsh
• Re: Select first(...)...Group BY... = useless?
  • From: Michel Walsh
• Re: Calculated Date
  • From: Ken Snell \(MVP\)
• Re: Unmatched query not working
  • From: Ken Snell \(MVP\)
• Re: Expression Help
  • From: Novice2000
• Re: Unmatched query not working
  • From: Ann Scharpf
• Re: Unmatched query not working
  • From: Ken Snell \(MVP\)
• Select first(...)...Group BY... = useless?
  • From: Mark Burns
• Re: Filtered query question
  • From: Allen Browne
• Re: IN SELECT Query Criteria
  • From: Dale Fye
• Re: Contenate & Right Justify
  • From: idmnstr via AccessMonster.com
• RE: Apply curve to results of query
  • From: Dale Fye
• Re: Converting Text to Date
  • From: John Spencer
• Re: Converting Text to Date
  • From: fredg
• Re: Extracting golf score data
  • From: Mark Senibaldi
• Re: Contenate & Right Justify
  • From: fredg
• Query from an SQL table that has XML info in one field
  • From: SmartCookie
• Re: Fields filled with ########
  • From: Ken Snell \(MVP\)
• Re: Date not within range query
  • From: John Spencer
• Re: report with 3 sections need a query???
  • From: Allen Browne
• Re: Run-time error 3061
  • From: John Spencer
• Re: report with 3 sections need a query???
  • From: Dan
• Re: Query to eliminate blank fields
  • From: Mary M
• Re: Sort multiple query results
  • From: Jamie Collins
• Re: Sort multiple query results
  • From: Jamie Collins
• Converting Text to Date
  • From: KimTong via AccessMonster.com
• Contenate & Right Justify
  • From: idmnstr via AccessMonster.com
• Re: Without Matching Query Limit ?
  • From: Stuart
• Re: Date not within range query
  • From: Cory
• Re: Run-time error 3061
  • From: JIM
• Re: use a result of a query as input criteria for another query
  • From: Jamie Collins
• RE: Retriving the last date
  • From: Todd
• Re: Bytes Per Row
  • From: Allen Browne
• RE: When I open design view in a query I get "is not a valid name.
  • From: choosetolaugh
• Re: Sort multiple query results
  • From: Opal
• Bytes Per Row
  • From: bhipwell via AccessMonster.com
• Re: IN SELECT Query Criteria
  • From: Jamie Collins
• Re: duplicate records
  • From: John Spencer
• Re: Without Matching Query Limit ?
  • From: Jamie Collins
• Re: Sort multiple query results
  • From: Jamie Collins
• Re: Getting query to look up the values of combo boxes then displa
  • From: bUncE
• Re: IN SELECT Query Criteria
  • From: Allen Browne
• Re: report with 3 sections need a query???
  • From: Allen Browne
• Re: SQL Error
  • From: Steve S
• Re: How do I sort records in Runtime ?????
  • From: Ken Snell \(MVP\)
• Re: SQL Error
  • From: Ken Snell \(MVP\)
• Re: Query to Count Consecutive days?
  • From: John Spencer
• Re: Extracting golf score data
  • From: Barry
• report with 3 sections need a query???
  • From: Dan
• RE: When I open design view in a query I get "is not a valid name.
  • From: DougM
• duplicate records
  • From: emailcad
• How do I sort records in Runtime ?????
  • From: deaconj999
• Re: Sort multiple query results
  • From: Opal
• RE: Parameters
  • From: KARL DEWEY
• IN SELECT Query Criteria
  • From: Cydney
• RE: need to take out an INNER JOIN to a user table
  • From: KARL DEWEY
• Re: Query to Count Consecutive days?
  • From: Ann in CA
• RE: need to take out an INNER JOIN to a user table
  • From: Janis
• RE: need to take out an INNER JOIN to a user table
  • From: Janis
• RE: need to take out an INNER JOIN to a user table
  • From: Janis
• RE: need to take out an INNER JOIN to a user table
  • From: Janis
• Parameters
  • From: turny
• Re: Query not Returning Results
  • From: Dale Fye
• RE: need to take out an INNER JOIN to a user table
  • From: KARL DEWEY
• RE: Retriving the last date
  • From: KARL DEWEY
• Query
  • From: PJ
• Re: Query to eliminate blank fields
  • From: KARL DEWEY
• Retriving the last date
  • From: Todd
• Re: Sort multiple query results
  • From: Opal
• Re: Sort multiple query results
  • From: Michel Walsh
• need to take out an INNER JOIN to a user table
  • From: Janis
• Re: Sort multiple query results
  • From: Opal
• Re: Max and 2nd Highest for two identifiers
  • From: Hammer Rockwell
• Re: How do I determine calendar quarters in Access ?
  • From: owp^3
• Re: Query to eliminate blank fields
  • From: Mary M
• Re: Convert Numeric to Text Fields, Help!!!
  • From: John Spencer
• Re: How do I determine calendar quarters in Access ?
  • From: Marshall Barton
• Re: Convert Numeric to Text Fields, Help!!!
  • From: KARL DEWEY
• RE: query calculator like excel
  • From: S.Clark
• Re: How do I determine calendar quarters in Access ?
  • From: Michel Walsh
• Re: Convert Numeric to Text Fields, Help!!!
  • From: MJ
• Re: Convert Numeric to Text Fields, Help!!!
  • From: Ken Snell \(MVP\)
• Re: where to place the code
  • From: John Spencer
• Re: Run-time error 3061
  • From: John Spencer
• Re: where to place the code
  • From: swjunkie
• Re: Run-time error 3061
  • From: JIM
• Re: Execute Existing Query Programattically
  • From: fredg
• Re: Help Needed with query
  • From: John Spencer
• Re: Date not within range query
  • From: John Spencer
• RE: Query not Returning Results
  • From: Drodway
• Re: Getting query to look up the values of combo boxes then displa
  • From: John Spencer
• Re: where to place the code
  • From: John Spencer
• RE: IIF NULL = ALL
  • From: Octet32
• Re: choose quantaty by lot using FIFO
  • From: Jamie Collins
• Re: Date Filter
  • From: Ken Snell \(MVP\)
• RE: Crosstab with multiple columns?
  • From: KARL DEWEY
• Re: Getting query to look up the values of combo boxes then displa
  • From: bUncE
• Re: Parameter box, complex query
  • From: floyd33 via AccessMonster.com
• Re: Sort multiple query results
  • From: Jamie Collins
• Query to eliminate blank fields
  • From: Mary M
• Re: Getting query to look up the values of combo boxes then displa
  • From: John Spencer
• Re: Without Matching Query Limit ?
  • From: Stuart
• RE: Query not Returning Results
  • From: Dale Fye
• RE: IIF NULL = ALL
  • From: Dale Fye
• Re: Using Multislect on feilsd with null value
  • From: Allen Browne
• Query Help
  • From: Mary M
• RE: Access 2003: Extra row in duplicates query
  • From: Bill Downs
• Re: Error message
  • From: Michel Walsh
• Re: Sort multiple query results
  • From: Michel Walsh
• RE: IIF NULL = ALL
  • From: Octet32
• Re: Getting query to look up the values of combo boxes then displa
  • From: bUncE
• Re: Max and 2nd Highest for two identifiers
  • From: John Spencer
• Re: Getting query to look up the values of combo boxes then display da
  • From: John Spencer
• Re: "Short time" format and duration
  • From: John Spencer
• Re: Date and hour arrangement
  • From: John Spencer
• Re: Max and 2nd Highest for two identifiers
  • From: Hammer Rockwell
• Re: Query to Count Consecutive days?
  • From: John Spencer
• Re: Without Matching Query Limit ?
  • From: Jamie Collins
• Re: Without Matching Query Limit ?
  • From: John Spencer
• Re: Query Help
  • From: Andy Paris
• Re: "Short time" format and duration
  • From: Pieter Wijnen
• Re: Date and hour arrangement
  • From: mohsin via AccessMonster.com
• Date and hour arrangement
  • From: mohsin via AccessMonster.com
• Re: Without Matching Query Limit ?
  • From: Jamie Collins
• Re: Without Matching Query Limit ?
  • From: Jamie Collins
• RE: Hyperlink Syntax
  • From: mattc66 via AccessMonster.com
• Re: Error Message
  • From: Gina Whipp
• Error message
  • From: Gary Sharp
• Error Message
  • From: Gary Sharp
• Re: Sub-grouping Inventory Data
  • From: Senexis
• Re: combining multiple entries into one result
  • From: John W . Vinson
• Sort multiple query results
  • From: Opal
• Re: Adding Date to the table name in a Make Table Query
  • From: fredg
• Re: using parameters
  • From: c8tz
• Re: Checkbox column in a table
  • From: John W . Vinson
• Re: Drop down list inside a query
  • From: John W . Vinson
• Re: Beginner question
  • From: John W . Vinson
• Re: How do I consider price of purchase combined with date of orde
  • From: Tiago
• Re: Without Matching Query Limit ?
  • From: Stuart
• Re: Without Matching Query Limit ?
  • From: Stuart
• RE: IIF NULL = ALL
  • From: KARL DEWEY
• Re: ROUNDUP to 9s
  • From: AFSSkier
• RE: IIF NULL = ALL
  • From: Dale Fye
• Re: Combo Box in Queries
  • From: Ken Snell \(MVP\)
• Re: Query to Count Consecutive days?
  • From: Ann in CA
• Combo Box in Queries
  • From: CharlesCount via AccessMonster.com
• Re: Pass through query giving an invalid column error
  • From: John Spencer
• Re: SubQuery - Return value from table x based on value in table y
  • From: K8
• Re: Query to Count Consecutive days?
  • From: Ann in CA
• Re: Parameter box, complex query
  • From: John Spencer
• Re: Parameter box, complex query
  • From: floyd33 via AccessMonster.com
• Re: Max and 2nd Highest for two identifiers
  • From: Michel Walsh
• Re: Max and 2nd Highest for two identifiers
  • From: John Spencer
• Re: Max and 2nd Highest for two identifiers
  • From: Michel Walsh
• Re: Query to Count Consecutive days?
  • From: Michel Walsh
• Re: Max and 2nd Highest for two identifiers
  • From: Hammer Rockwell
• Re: ROUNDUP to 9s
  • From: John Spencer
• Re: Criteria for totals query
  • From: Michel Walsh
• Re: Max and 2nd Highest for two identifiers
  • From: Michel Walsh
• Re: Display records based on count value of one field
  • From: mabond
• Re: Beginner question
  • From: J_Goddard via AccessMonster.com
• Re: Without Matching Query Limit ?
  • From: John Spencer
• RE: IIF NULL = ALL
  • From: Octet32
• RE: Query to get sum of a field if two fields match
  • From: Jerry Whittle
• Re: Using Multislect on feilsd with null value
  • From: cwby1966 via AccessMonster.com
• Re: REPOST: Error 2329 (To create a crosstab query ...)
  • From: John Spencer
• Re: Without Matching Query Limit ?
  • From: Jamie Collins
• Re: How do I consider price of purchase combined with date of orde
  • From: Michel Walsh
• Re: REPOST: Error 2329 (To create a crosstab query ...)
  • From: Gary Walter
• Re: What is wrong with my sql?
  • From: Jamie Collins
• Re: Without Matching Query Limit ?
  • From: Stuart
• Re: ROUNDUP to 9s
  • From: Gary Walter
• RE: IIF NULL = ALL
  • From: Dale Fye
• Re: What is wrong with my sql?
  • From: Allen Browne
• Re: SQL Functions Help
  • From: Jamie Collins
• Re: How do I consider price of purchase combined with date of orde
  • From: Michel Walsh
• RE: Query to get sum of a field if two fields match
  • From: Newbie_Sashi
• Re: Appending new master rows to an existing master table
  • From: PatK
• Re: Max Function
  • From: Allen Browne
• Re: Max Function
  • From: John Spencer
• Re: Without Matching Query Limit ?
  • From: John Spencer
• Re: Using Multislect on feilsd with null value
  • From: Allen Browne
• Re: Delete fields
  • From: Allen Browne
• Re: Max Function
  • From: Allen Browne
• Re: How to find any character within a field?
  • From: Jamie Collins
• Re: Query Help
  • From: Andy Paris
• Export using a DTD - HELP!
  • From: rmorrison
• using parameters
  • From: c8tz
• Re: SQL Functions Help
  • From: John W . Vinson
• SQL Functions Help
  • From: vjp2 . at
• Re: Passing DB path as IN SQL clause
  • From: Marshall Barton
• Re: help ... similiar to parameter query; complex query
  • From: John W . Vinson
• Re: Appending new master rows to an existing master table
  • From: John Spencer
• Re: Normalization woes - how do I reproduce a query?
  • From: Frank
• Re: Without Matching Query Limit ?
  • From: Jeff Boyce
• Re: Without Matching Query Limit ?
  • From: Marshall Barton
• Re: using parameters for calculations
  • From: Jeff Boyce
• using parameters for calculations
  • From: c8tz
• Query Help
  • From: Andy Paris
• Re: Appending new master rows to an existing master table
  • From: PatK
• Re: Appending new master rows to an existing master table
  • From: PatK
• Re: Appending new master rows to an existing master table
  • From: PatK
• Re: Appending new master rows to an existing master table
  • From: PatK
• Re: parameter query - return all or part
  • From: Linda
• Re: Appending new master rows to an existing master table
  • From: PatK
• Re: parameter query - return all or part
  • From: John Spencer
• RE: Normalization woes - how do I reproduce a query?
  • From: Duane Hookom
• Using Multislect on feilsd with null value
  • From: cwby1966
• Re: Search Function
  • From: Ken Snell \(MVP\)
• Re: parameter query - return all or part
  • From: John Spencer
• Re: Appending new master rows to an existing master table
  • From: John Spencer
• Re: How do I consider price of purchase combined with date of orde
  • From: Tiago
• Re: Parameter box, complex query
  • From: John Spencer
• Normalization woes - how do I reproduce a query?
  • From: Frank
• Re: Appending new master rows to an existing master table
  • From: PatK
• Re: Parameter box, complex query
  • From: floyd33 via AccessMonster.com
• What is wrong with this query?
  • From: nlburgess via AccessMonster.com
• Re: Appending new master rows to an existing master table
  • From: John Spencer
• Re: Query
  • From: John Spencer
• Re: How to find any character within a field?
  • From: Jeff Boyce
• Re: Extracting golf score data
  • From: Mark Senibaldi
• Re: Parameter box, complex query
  • From: John Spencer
• Re: Transpose data from rows to columns
  • From: Eddy
• Re: How do I consider price of purchase combined with date of orde
  • From: Jamie Collins
• Re: Query for UK Financial period
  • From: Jamie Collins
• Re: I use the same parameter in 2 queries - how do I only enter once?
  • From: Allen Browne
• Re: I use the same parameter in 2 queries - how do I only enter once?
  • From: Michel Walsh
• Auto add a new record on specified date.
  • From: wesley.allen@xxxxxxxxx
• Re: Find a text string and compare it against a field in a different t
  • From: Michel Walsh
• Re: Parameter In Operator
  • From: Michel Walsh
• Parameter box, complex query
  • From: floyd33
• Re: How do I consider price of purchase combined with date of orde
  • From: Michel Walsh
• Re: Transpose data from rows to columns
  • From: Roger Carlson
• Query for UK Financial period
  • From: DaveTheRave.NET
• Re: Diplaying the first event by date for each ContactID
  • From: Allen Browne
• Re: Query Problem
  • From: John W . Vinson
• Re: How do I consider price of purchase combined with date of orde
  • From: Tiago
• Query Problem
  • From: Dudy
• Q. re: Vista Home Basic
  • From: Lenora
• Re: Q. re: Vista Home Basic
  • From: tina
• Re: Problem: query from two tables connected to a third table
  • From: Wolfgang Kais
• Re: Display records based on count value of one field
  • From: Wolfgang Kais
• Re: Time based query - records within 10 minute intervals
  • From: Allen Browne
• Re: How to find any character within a field?
  • From: Jamie Collins
• Re: Display records based on count value of one field
  • From: mabond
• RE: Please help with Update Query
  • From: KARL DEWEY
• Re: Date Restrictor for last week's sales
  • From: Wolfgang Kais
• Re: Display records based on count value of one field
  • From: Wolfgang Kais
• Error 3075
  • From: Don Garry
• Re: Different queries but the same?
  • From: tina
• Auto Add new records on a specified date
  • From: wesley.allen@xxxxxxxxx
• RE: Please help with Update Query
  • From: rich
• Re: DELETE QUERY PROBLEM
  • From: sdg8481
• Error 3075 ...IIf statement
  • From: Don Garry
• Re: DELETE QUERY PROBLEM
  • From: Douglas J. Steele
• Re: Extracting golf score data
  • From: Barry
• Re: Different queries but the same?
  • From: Linda RQ
• Re: DELETE QUERY PROBLEM
  • From: sdg8481
• Re: Different queries but the same?
  • From: tina
• Different queries but the same?
  • From: Linda RQ
• Re: DELETE QUERY PROBLEM
  • From: Douglas J. Steele
• Re: slow append query from a pass through query
  • From: Aivars
• RE: checkbox conditional math
  • From: Smokeyhavoc
• RE: checkbox conditional math
  • From: Smokeyhavoc
• RE: labour report
  • From: Duane Hookom
• labour report
  • From: Bill M.
• Re: Parameter Query Dates
  • From: Allen Browne
• RE: checkbox conditional math
  • From: KARL DEWEY
• Re: slow append query from a pass through query
  • From: Rick Brandt
• Re: unique only
  • From: Jeff Boyce
• Re: long if function
  • From: Conan Kelly
• Re: problem making an query?
  • From: Jeff Boyce
• Only showing after @ duplicates
  • From: sanderijken
• Re: How do you query using information from 2 different tables?
  • From: Conan Kelly
• Re: Parameter In Operator
  • From: Ronald Dodge
• Re: Parameter In Operator
  • From: Michel Walsh
• Parameter In Operator
  • From: Ronald Dodge
• Re: Convert numeric dates to text?
  • From: Jeff Boyce
• Re: Repeat Data
  • From: Michel Walsh
• Re: I need to delete oldest record so that table only contains lat
  • From: DarrenNotts
• Re: Convert numeric dates to text?
  • From: Jeff Boyce
• Re: count the number of days
  • From: Michel Walsh
• Re: date serial
  • From: Michel Walsh
• RE: Row to Querie
  • From: KARL DEWEY
• RE: Row to Querie
  • From: Dale Fye
• RE: Expression Troubles
  • From: Dale Fye
• Repeat Data
  • From: tbotkin via AccessMonster.com
• Re: How to find any character within a field?
  • From: Jeff Boyce
• RE: Row to Querie
  • From: Jerry Whittle
• RE: Expression Troubles
  • From: Novice2000
• Re: date serial
  • From: Michel Walsh
• Re: Counting records and Where criteria
  • From: Allen Browne
• Counting records and Where criteria
  • From: Tony Williams
• Re: How to find any character within a field?
  • From: Jamie Collins
• RE: Excluding records
  • From: tdabel
• Re: date serial
  • From: JohnLute
• Re: Rounding errors
  • From: Jamie Collins
• Re: How do I consider price of purchase combined with date of order?
  • From: Michel Walsh
• Re: date serial
  • From: Michel Walsh
• Re: How do I consider price of purchase combined with date of order?
  • From: jon
• Re: date serial
  • From: JohnLute
• Re: Count Duplication Help
  • From: Andy Paris
• slow append query from a pass through query
  • From: Aivars
• Re: Break up a field
  • From: Allen Browne
• Break up a field
  • From: vjp2 . at
• Re: Escape Key
  • From: Allen Browne
• Re: Update Query
  • From: Jeff Boyce
• Re: Is It Possible To Pass Parameters to A Pass Through Query
  • From: mcl
• Re: To preserve records.
  • From: Marshall Barton
• Re: Getting 'validation rule violation' when I don't have any validation rules?
  • From: Marshall Barton
• Re: Getting 'validation rule violation' when I don't have any validation rules?
  • From: Jeff Boyce
• Re: Comparing 'matched' data
  • From: Jack Isaacs
• Getting 'validation rule violation' when I don't have any validation rules?
  • From: S Davis
• Super Function II
  • From: Steve Dassin
• Data entry Query
  • From: Angel G
• Re: Update Query
  • From: Rod
• Re: Separate Name field
  • From: fredg
• RE: Attempting to clean up a db --- need some help...
  • From: KARL DEWEY
• RE: query using 2 tables and a query
  • From: Andy Hull
• RE: update data from aggregate query
  • From: mbr96 via AccessMonster.com
• Re: date serial
  • From: Michel Walsh
• Re: update data from aggregate query
  • From: Michel Walsh
• Re: Moving data into a new table once selected from a form
  • From: Michel Walsh
• RE: Attempting to clean up a db --- need some help...
  • From: jamesfreddyc
• Re: how to "flatten" a list
  • From: asc4john
• update data from aggregate query
  • From: mbr96 via AccessMonster.com
• Re: how to "flatten" a list
  • From: BruceM
• Re: Query to count records in a table
  • From: Michel Walsh
• Re: Sharper Focus On Query Question
  • From: John W . Vinson
• Re: Rounding errors
  • From: Bongard
• RE: help
  • From: misschanda via AccessMonster.com
• Re: How to find any character within a field?
  • From: CharlesCount via AccessMonster.com
• Re: How to find any character within a field?
  • From: Jeff Boyce
• Re: Rounding errors
  • From: Bongard
• Re: DCount Function - #Error
  • From: Marshall Barton
• RE: help
  • From: Dale Fye
• Re: Sum question
  • From: John W . Vinson
• Re: Number of days
  • From: John W . Vinson
• Re: concatenate
  • From: Marshall Barton
• help
  • From: misschanda via AccessMonster.com
• RE: Number of days
  • From: Tommy2326
• Re: Query Criteria Like
  • From: CharlesCount via AccessMonster.com
• how to "flatten" a list
  • From: asc4john
• RE: Error 3075
  • From: Dan @BCBS
• Re: Query Criteria Like
  • From: Allen Browne
• Re: Calculating Work Dates
  • From: Tommy2326
• Query Criteria Like
  • From: CharlesCount via AccessMonster.com
• Re: eliminate message from append query to eliminate duplicate record.
  • From: Allen Browne
• RE: Append Query
  • From: CharlesCount via AccessMonster.com
• RE: Append Query
  • From: CharlesCount via AccessMonster.com
• RE: Number of days
  • From: Tommy2326
• Re: Probably A Stupid Query Question
  • From: Jamie Collins
• Append Query
  • From: CharlesCount via AccessMonster.com
• Re: make new table
  • From: Allen Browne
• RE: Number of days
  • From: scubadiver
• RE: query using 2 tables and a query
  • From: deb
• RE: query using 2 tables and a query
  • From: Andy Hull
• RE: Number of days
  • From: Tommy2326
• make new table
  • From: Garry
• Re: Rounding errors
  • From: Michel Walsh
• RE: Time bound column
  • From: senkurion
• Re: Update Query
  • From: Jeff Boyce
• Rounding errors
  • From: Bongard
• Re: Probably A Stupid Query Question
  • From: Bongard
• Re: Count Duplication Help
  • From: Andy Paris
• RE: Number of days
  • From: scubadiver
• RE: Number of days
  • From: scubadiver
• Re: Count Duplication Help
  • From: scubadiver
• Re: Count Duplication Help
  • From: Andy Paris
• RE: Number of days
  • From: Tommy2326
• Re: Count Duplication Help
  • From: Michel Walsh
• Re: Field as column name.
  • From: Michel Pauwels
• Count Duplication Help
  • From: Andy Paris
• Re: "like" works as query, but not in code (Access 2003)
  • From: Jamie Collins
• Combining feilds
  • From: Syed Zeeshan Haider
• Re: Update
  • From: John W . Vinson
• Re: convert text column to date.
  • From: John W . Vinson
• Re: automate a make table query
  • From: Jeff Boyce
• RE: Excluding records
  • From: KARL DEWEY
• Re: Transfer a reports result to a query
  • From: Garry
• RE: Averaging Scores
  • From: smeldawg
• Re: Transfer a reports result to a query
  • From: Garry
• Re: Update Query
  • From: Rod
• Re: Update qry removing ONLY Alpha
  • From: John Spencer
• Re: Update qry removing ONLY Alpha
  • From: Michel Walsh
• Re: Update qry removing ONLY Alpha
  • From: Jeff Boyce
• Re: Update Query
  • From: Jeff Boyce
• Re: Separate By Comma
  • From: Michel Walsh
• Re: compare date field in 1 table to start & end date fields in 2nd ta
  • From: John W . Vinson
• Re: Separate By Comma
  • From: Beagle1927
• Re: SQL statement format for readability and making adjustments purposes
  • From: Ronald Dodge
• Re: Help counting occurences of duplicates.
  • From: John Spencer
• Re: Queries that have specific time frames
  • From: John Spencer
• Help counting occurences of duplicates.
  • From: rhaazy
• Re: Run-time error 3061
  • From: John Spencer
• Re: automate a make table query
  • From: Jeff Boyce
• Re: SQL statement format for readability and making adjustments purposes
  • From: Allen Browne
• SQL statement format for readability and making adjustments purposes
  • From: Ronald Dodge
• RE: format date
  • From: Duane Hookom
• Re: Calculating Work Dates
  • From: Dale Fye
• RE: Run-time error 3061
  • From: JIM
• RE: format date
  • From: JohnLute
• Re: Queries that have specific time frames
  • From: John Spencer
• Re: right string problem
  • From: mbc04
• Re: Duplicate Returns
  • From: misschanda via AccessMonster.com
• Re: "like" works as query, but not in code (Access 2003)
  • From: John Spencer
• Re: right string problem
  • From: mbc04
• Re: Comparing 'matched' data
  • From: John Spencer
• Re: Query Expression
  • From: Karen
• Re: Beginning and Ending dates for groups of events
  • From: Jamie Collins
• Re: Transfer a reports result to a query
  • From: Duane Hookom
• right string problem
  • From: mbc04
• RE: Run-time error 3061
  • From: S.Clark
• Re: Parameter Queries
  • From: Ronald Dodge
• RE: Poor performance running queries with tables linked to Oracle
  • From: stara
• Re: Transfer a reports result to a query
  • From: Garry
• RE: Delete query with list box for parms modifies FIRST record
  • From: Tim
• Re: Update Query Syntax
  • From: Jamie Collins
• Re: "like" works as query, but not in code (Access 2003)
  • From: javaguy
• Separate By Comma
  • From: Beagle1927
• Re: "like" works as query, but not in code (Access 2003)
  • From: Jamie Collins
• Re: Parameter Queries
  • From: Jamie Collins
• RE: format date
  • From: Duane Hookom
• Re: Transfer a reports result to a query
  • From: Duane Hookom
• RE: format date
  • From: JohnLute
• RE: Time bound column
  • From: Dale Fye
• Re: Parameter Queries
  • From: John Spencer
• RE: Time bound column
  • From: senkurion
• Re: "like" works as query, but not in code (Access 2003)
  • From: John Spencer
• Re: Query Design Help Needed
  • From: John Spencer
• Parameter Queries
  • From: Ronald Dodge
• RE: Adding a new record with a reference to another table
  • From: TishyMouse
• "like" works as query, but not in code (Access 2003)
  • From: javaguy
• Re: Calculate yield
  • From: John Spencer
• RE: Time bound column
  • From: Dale Fye
• Re: Query Expression
  • From: John Spencer
• Re: Transfer a reports result to a query
  • From: Garry
• Re: I need to delete oldest record so that table only contains lat
  • From: DarrenNotts
• Re: Comparing 'matched' data
  • From: Leslie Isaacs
• Comparing 'matched' data
  • From: Leslie Isaacs
• Re: Date() frustration within query builder - please assist
  • From: pilch74@xxxxxxxxx
• Re: Date() frustration within query builder - please assist
  • From: pilch74@xxxxxxxxx
• Re: Calculating Work Dates
  • From: Tommy2326
• Query problems
  • From: Daniel . Ran . XU
• Re: Query Design Help Needed
  • From: Phonon
• Re: Query Design Help Needed
  • From: Phonon
• Re: Update Query
  • From: Rod
• Re: Calculate yield
  • From: Conan Kelly
• Re: Help with query criteria
  • From: Opal
• Re: Update Query
  • From: Jeff Boyce
• RE: Dropping duplicate records based on content
  • From: KARL DEWEY
• Transfer a reports result to a query
  • From: Garry
• Re: Query Design Help Needed
  • From: John Spencer
• Dropping duplicate records based on content
  • From: Chip
• Re: Select from List of Choices In Query
  • From: Marshall Barton
• Re: How do I remove leading Zeros?
  • From: Frank Martin
• Re: need 1 query pulling 3 different count(totals)
  • From: Jeff Boyce
• RE: Adding a new record with a reference to another table
  • From: Dale Fye
• Re: Pulling identical numbers if "text" found
  • From: tekari
• Re: Query Design Help Needed
  • From: Phonon
• RE: Delete query with list box for parms modifies FIRST record
  • From: Dale Fye
• Re: Union query drawing from another query
  • From: Douglas J. Steele
• RE: Adding a new record with a reference to another table
  • From: TishyMouse
• RE: Dcount: referencing a saved query field in a mathematical expressi
  • From: S.Clark
• Re: add time to a field - MINUTES
  • From: fredg
• Re: Update Query Syntax
  • From: David
• Re: How do I exclude values from my combo box?!?!?! HELP!!!
  • From: Ken Snell \(MVP\)
• Re: random sampling
  • From: John W . Vinson
• Re: Query Expression
  • From: Karen
• Can we create multiple pivot tabel views for a single access query?
  • From: preeti p
• Re: random sampling
  • From: Marshall Barton
• Re: Select from List of Choices In Query
  • From: Marshall Barton
• Re: How do I exclude values from my combo box?!?!?! HELP!!!
  • From: J. Keggerlord
• RE: Adding a new record with a reference to another table
  • From: Dale Fye
• Re: How do I exclude values from my combo box?!?!?! HELP!!!
  • From: Ken Snell \(MVP\)
• Re: How do I exclude values from my combo box?!?!?! HELP!!!
  • From: Ken Snell \(MVP\)
• Re: Query Expression
  • From: John Spencer
• Re: No Recipients When Using a Query to Mail Merge in Word
  • From: John Spencer
• Re: Date() frustration within query builder - please assist
  • From: George Nicholson
• Re: add time to a field - MINUTES
  • From: fredg
• Re: Can a parameter query display a date plus 5 days ahead?
  • From: Marshall Barton
• Re: Can a parameter query display a date plus 5 days ahead?
  • From: John Spencer
• Re: adding a field using a query
  • From: John Spencer
• Date() frustration within query builder - please assist
  • From: pilch74@xxxxxxxxx
• Re: No Recipients When Using a Query to Mail Merge in Word
  • From: John Spencer
• Dcount: referencing a saved query field in a mathematical expression
  • From: joeyrhyu
• Table loading?
  • From: shaunismms
• Re: Crosstab Where Clause Problem
  • From: Michel Walsh
• RE: Poor performance running queries with tables linked to Oracle
  • From: Jerry Whittle
• Re: Crosstab Where Clause Problem
  • From: Biggles
• Re: Crosstab Where Clause Problem
  • From: Michel Walsh
• Re: Design Quert tool is making tables with an *, how do I stop it? .
  • From: Michel Walsh
• Re: how to get unrepresented categories to show up in an xtab quer
  • From: Michel Walsh
• Re: Strange dlookup behaviour
  • From: Michel Walsh
• Re: Query Design Help Needed
  • From: John Spencer
• Re: adding a field using a query
  • From: Josie
• Re: adding a field using a query
  • From: John Spencer
• Re: adding a field using a query
  • From: Josie
• Re: adding a field using a query
  • From: John Spencer
• Re: Query that returns 0 instead of null
  • From: John Spencer
• Re: Pulling identical numbers if "text" found
  • From: John Spencer
• RE: Pulling identical numbers if "text" found
  • From: Dale Fye
• RE: Date Function
  • From: Chris
• Query that returns 0 instead of null
  • From: aine_canby
• RE: Summing a field obtained via a stored procedure
  • From: Syvers
• Pulling identical numbers if "text" found
  • From: tekari
• Re: DateSerial not working
  • From: Ken Snell \(MVP\)
• Re: Strange dlookup behaviour
  • From: Ken Snell \(MVP\)
• Re: Union query drawing from another query
  • From: Douglas J. Steele
• Union query drawing from another query
  • From: John D
• Re: how to get unrepresented categories to show up in an xtab quer
  • From: starlingseven via AccessMonster.com
• Re: Query Design Help Needed
  • From: Phonon
• Re: how to get unrepresented categories to show up in an xtab quer
  • From: KARL DEWEY
• Re: how to get unrepresented categories to show up in an xtab query
  • From: George Nicholson
• Re: Update Query Syntax
  • From: George Nicholson
• Re: I need to delete oldest record so that table only contains latest record
  • From: DarrenNotts
• Re: Problem with between date function
  • From: tlove258
• how to get unrepresented categories to show up in an xtab query
  • From: starlingseven via AccessMonster.com
• Re: I need to delete oldest record so that table only contains latest
  • From: DarrenNotts
• Re: ip numbers overflow
  • From: Michel Walsh
• Re: ip numbers overflow
  • From: scott
• Re: Multiple Criteria and return only one match
  • From: Michel Walsh
• Re: Beginning and Ending dates for groups of events
  • From: Michel Walsh
• Re: Multiple Criteria and return only one match
  • From: John Spencer
• Re: ip numbers overflow
  • From: John Spencer
• Re: ip numbers overflow
  • From: Michel Walsh
• Re: Numeric Field Overflow problem (TOP URGENT)
  • From: Michel Walsh
• Re: Join same field on two tables
  • From: wilsoch
• Re: Complex query
  • From: Michel Walsh
• Re: Sub-grouping Inventory Data
  • From: Michel Walsh
• Re: ip numbers overflow
  • From: scott
• Re: Reference a Date and Time in Query
  • From: tmm786
• Re: Join same field on two tables
  • From: John Spencer
• ip numbers overflow
  • From: scott
• Re: Strange dlookup behaviour
  • From: Michel Walsh
• Join same field on two tables
  • From: wilsoch
• Re: Using a query to create a count...
  • From: Jeff Boyce
• Re: Using a query to create a count...
  • From: John W . Vinson
• Re: Crosstab Query - More Than Two Values?
  • From: Leviathan via AccessMonster.com
• Crosstab Query - More Than Two Values?
  • From: Leviathan via AccessMonster.com
• Re: Using a query to create a count...
  • From: John Spencer
• Re: Using a query to create a count...
  • From: Jeff Boyce
• Re: Blanks incorrect
  • From: John Spencer
• Re: Query Design Help Needed
  • From: John Spencer
• Re: Total Expression Help
  • From: Charles
• Numeric Field Overflow problem (TOP URGENT)
  • From: Samer
• Reference a Date and Time in Query
  • From: tmm786
• Unique identifier
  • From: Chris
• Re: VBA DoCmd.RunSQL
  • From: fredg
• Re: VBA DoCmd.RunSQL
  • From: Tom Lake
• Re: total all records in a query
  • From: dplove
• VBA DoCmd.RunSQL
  • From: Karen Boyer
• Re: Total Expression Help
  • From: John Spencer
• Re: total all records in a query
  • From: John Spencer
• Re: SQL Query between 2 dates
  • From: Allen Browne
• Re: SQL Query between 2 dates
  • From: Maver1ck666
• Re: SQL Query between 2 dates
  • From: Allen Browne
• Re: Extracting golf score data
  • From: Mark Senibaldi
• Re: data type mismatch in critera
  • From: John Spencer
• Re: Total Expression Help
  • From: John Spencer
• Re: Help with query criteria
  • From: John Spencer
• Re: syntax error in Total of field - I need help ASAP, PLease
  • From: John Spencer
• Re: syntax error in error of Total of field
  • From: dplove
• Re: Comparing two tables
  • From: John Spencer
• Re: SQL Query between 2 dates
  • From: Maver1ck666
• Re: SQL Query between 2 dates
  • From: Allen Browne
• Re: Extracting golf score data
  • From: Jason Lepack
• Re: DateSerial not working
  • From: JohnLute
• Re: syntax error in Total of field - I need help ASAP, PLease
  • From: dplove
• Re: Adding table fields per Record
  • From: Charles
• Re: I need to delete oldest record so that table only contains latest record
  • From: John W . Vinson
• Re: Help with query criteria
  • From: Opal
• Re: How do I determine calendar quarters in Access ?
  • From: Allen Browne
• Re: how to base a form on a query
  • From: tina
• Re: Help with query criteria
  • From: John Spencer
• Re: SubQuery - Return value from table x based on value in table y
  • From: John W . Vinson
• I need to delete oldest record so that table only contains latest record
  • From: DarrenNotts
• Complex query
  • From: Jeff
• Re: Help with query criteria
  • From: Opal
• Re: Help with query criteria
  • From: John Spencer
• Re: Help with query criteria
  • From: Opal
• Deleting Values From a Query's Results
  • From: mcl
• Re: Adding table fields per Record
  • From: Jeff Boyce
• Re: Help with query criteria
  • From: John Spencer
• Re: How do I determine calendar quarters in Access ?
  • From: Allen Browne
• Re: create a query to output to Excel
  • From: Gary Walter
• Re: How do I determine calendar quarters in Access ?
  • From: Michael Gramelspacher
• Help with query criteria
  • From: Opal
• Re: plz help !! Undefined function 'Date' in expression
  • From: MrCC via AccessMonster.com
• Re: plz help !! Undefined function 'Date' in expression
  • From: Allen Browne
• Re: How do I determine calendar quarters in Access ?
  • From: Allen Browne
• plz help !! Undefined function 'Date' in expression
  • From: MrCC via AccessMonster.com
• Re: I need to query the field name of "true" value out of 3 fields
  • From: Marshall Barton
• Sub-grouping Inventory Data
  • From: Senexis
• Re: Duplication of records in query?
  • From: Tony Williams
• I need to delete oldest record so that table only contains latest record
  • From: d . barson
• Re: Duplication of records in query?
  • From: Marshall Barton
• Re: Problem with between date function
  • From: Rick Brandt
• Duplication of records in query?
  • From: Tony Williams
• Re: #name?
  • From: Allen Browne
• Re: Criteria and instructions in an expression
  • From: John Spencer
• Re: syntax error in error of Total of field
  • From: John Spencer
• Re: total all records in a query
  • From: John Spencer
• Re: dividing currency with inaccurate results
  • From: John Spencer
• Re: Who can take on this challenge
  • From: Marshall Barton
• Re: SubQuery - Return value from table x based on value in table y
  • From: John W . Vinson
• Re: Extract partial string
  • From: fredg
• Re: total all records in a query
  • From: John W . Vinson
• Criteria and instructions in an expression
  • From: Linda RQ
• Re: Strange dlookup behaviour
  • From: cesima via AccessMonster.com
• Re: Calculating Work Dates
  • From: Dale Fye
• Re: DateSerial not working
  • From: Douglas J. Steele
• Re: Strange dlookup behaviour
  • From: Ken Snell \(MVP\)
• Re: DateSerial not working
  • From: Ken Snell \(MVP\)
• Strange dlookup behaviour
  • From: Ceebaby via AccessMonster.com
• Re: Expression Help
  • From: Novice2000
• Re: DateSerial not working
  • From: JohnLute
• Re: DateSerial not working
  • From: Ken Snell \(MVP\)
• Re: Expression Help
  • From: John Spencer
• Re: 3 Months from January of this year
  • From: Ken Snell \(MVP\)
• Re: 3 Months from January of this year
  • From: Amy Blankenship
• Re: Extracting golf score data
  • From: Mark Senibaldi
• Re: syntax error in error of Total of field
  • From: Michel Walsh
• Re: Extracting golf score data
  • From: Jason Lepack
• RE: Date Function
  • From: Klatuu
• Re: "Totals" button in query - what is it used for?
  • From: Ken Snell \(MVP\)
• Re: "Totals" button in query - what is it used for?
  • From: George Nicholson
• Re: Extracting golf score data
  • From: Mark Senibaldi
• Re: Query against dates
  • From: Ken Snell \(MVP\)
• Re: Extracting golf score data
  • From: Jason Lepack
• Re: Statement no working
  • From: George Nicholson
• Re: Syntax for a static GUID in Jet SQL
  • From: Sylvain Lafontaine
• RE: Calculating Work Dates
  • From: Tommy2326
• Re: Query against dates
  • From: Robert_L_Ross
• Re: Query against dates
  • From: Robert_L_Ross
• RE: date format/sort problem
  • From: JohnLute
• Re: Using Left to extract info
  • From: Steve
• Syntax for a static GUID in Jet SQL
  • From: misfit815
• Re: Combining multiple columns into single column based one another field
  • From: Gina Whipp
• Combining multiple columns into single column based one another field
  • From: aine_canby
• RE: date format/sort problem
  • From: Dale Fye
• Re: LRe: Combo query
  • From: Jeff Boyce
• Re: Expression Help
  • From: Novice2000
• Re: dividing currency with inaccurate results
  • From: Michel Walsh
• Re: Aged Customer balances
  • From: Michel Walsh
• Re: INSERT INTO Via Cross Tab
  • From: Michel Walsh
• Re: LRe: Combo query
  • From: Budd via AccessMonster.com
• Re: Duplicate Returns
  • From: Michel Walsh
• Aged Customer balances
  • From: q
• Re: Duplicate Returns
  • From: Michel Walsh
• RE: date format/sort problem
  • From: JohnLute
• Re: Adding table fields per Record
  • From: Charles
• Re: Duplicate Returns
  • From: misschanda via AccessMonster.com
• Re: Adding table fields per Record
  • From: Jeff Boyce
• Duplicate Returns
  • From: misschanda via AccessMonster.com
• Re: Combining Crosstab Queries
  • From: dp724 via AccessMonster.com
• Re: how to combine two queries in access stored procedure
  • From: Michel Walsh
• RE: Date Function
  • From: Chris
• Re: HELP Query via ADO never return but in access takes less milli
  • From: Jamie Collins
• Re: Todays date minus 6 days before (Shows all records in 6 days)
  • From: Stefan Hoffmann
• RE: How to set up Query?
  • From: Duane Hookom
• Re: Expression Help
  • From: Dale Fye
• Re: update issue with SQL
  • From: Jeff Boyce
• Re: returning multiple records on a single line
  • From: Dale Fye
• Re: Query against dates
  • From: Ken Snell \(MVP\)
• RE: How to set up Query?
  • From: teelee
• Re: Expression Help
  • From: John Spencer
• Re: Making a Parameter Query for Date and timestamp, with input mask.
  • From: Douglas J. Steele
• Re: monthly report problem??
  • From: MrCC via AccessMonster.com
• RE: Date ranges
  • From: AFSSkier
• RE: Expression Help
  • From: Novice2000
• Re: Append Query
  • From: Michel Walsh
• Re: Append Non-Duplicate & Updated Records
  • From: Marshall Barton
• Re: Update SQL Statement Help
  • From: jamesfreddyc
• Re: Append Non-Duplicate & Updated Records
  • From: owp^3
• Re: Update SQL Statement Help
  • From: John Spencer
• Re: Access Date() & DateAdd functions apparent error in Vista
  • From: David W. Fenton
• Re: Create Initials
  • From: fredg
• Re: Create Initials
  • From: John Spencer
• Re: multiple query parameters on a single field
  • From: Ken Snell \(MVP\)
• Re: "Stacking" Identical Tables
  • From: Keith & Dayna
• Re: Subtracting Q over Q
  • From: John Spencer
• RE: current month / year WHERE
  • From: JohnLute
• RE: current month / year WHERE
  • From: KARL DEWEY
• RE: Calculating Work Dates
  • From: Dale Fye
• Re: Subtracting Q over Q
  • From: Jeff Boyce
• RE: Calculating Work Dates
  • From: Klatuu
• Re: Parameter Criteria
  • From: Jeff Boyce
• RE: current month / year WHERE
  • From: JohnLute
• RE: Calculating Work Dates
  • From: Dale Fye
• RE: current month / year WHERE
  • From: KARL DEWEY
• Re: Append Non-Duplicate & Updated Records
  • From: Marshall Barton
• Re: Parameter Criteria
  • From: fredg
• RE: Field as column name.
  • From: KARL DEWEY
• RE: Date Function
  • From: Klatuu
• Re: "Stacking" Identical Tables
  • From: Klatuu
• RE: current month / year WHERE
  • From: JohnLute
• RE: current month / year WHERE
  • From: KARL DEWEY
• Re: Date Function
  • From: Michael Gramelspacher
• RE: Append Non-Duplicate & Updated Records
  • From: owp^3
• RE: Append Non-Duplicate & Updated Records
  • From: owp^3
• LRe: Combo query
  • From: Jeff Boyce
• Re: Extracting golf score data
  • From: Mark Senibaldi
• RE: Append Non-Duplicate & Updated Records
  • From: owp^3
• Re: Extracting golf score data
  • From: Jason Lepack
• Re: Extracting golf score data
  • From: Mark Senibaldi
• Re: Working out ages from DOB.
  • From: Allen Browne
• RE: How to set up Query?
  • From: Duane Hookom
• Re: Extracting golf score data
  • From: Barry
• Re: "Stacking" Identical Tables
  • From: scubadiver
• Re: Combo query
  • From: Budd via AccessMonster.com
• Re: "Stacking" Identical Tables
  • From: Keith & Dayna
• RE: current month / year WHERE
  • From: JohnLute
• checking queries between programs
  • From: Garry
• RE: How to set up Query?
  • From: teelee
• Re: "Stacking" Identical Tables
  • From: Keith & Dayna
• Re: How to list all tables in a database that are NOT empty?
  • From: John Spencer
• RE: "Stacking" Identical Tables
  • From: scubadiver
• "Stacking" Identical Tables
  • From: Keith & Dayna
• Re: monthly report problem??
  • From: John Spencer
• Re: iif(isnull( in Query
  • From: grubbyr
• Re: print selected columns in query
  • From: John Spencer
• Re: Calculating percentage of Total?
  • From: John Spencer
• Field as column name.
  • From: Michel Pauwels
• Re: Developing queries in two or more parts.
  • From: Bill
• Re: Calculating percentage of Total?
  • From: Jay
• RE: monthly report problem??
  • From: MrCC
• Re: iif(isnull( in Query
  • From: Rob Parker
• monthly report problem??
  • From: MrCC
• monthly report problem??
  • From: MrCC
• iif(isnull( in Query
  • From: grubbyr
• Re: count decimal place
  • From: Jamie Collins
• Re: Update Fields If FROM Table Fields Are NOT NULL
  • From: Handyman
• RE: multiple query parameters on a single field
  • From: KARL DEWEY
• Re: multiple query parameters on a single field
  • From: Joseph Atie
• RE: How to make this cross tab query
  • From: Duane Hookom
• RE: How to set up Query?
  • From: Duane Hookom
• Re: MS ACCESS Jet SQL: Update statements that utilize saved queries/dmax
  • From: John Spencer
• Re: Update Fields If FROM Table Fields Are NOT NULL
  • From: John Spencer
• Re: multiple query parameters on a single field
  • From: Ken Snell \(MVP\)
• Update Fields If FROM Table Fields Are NOT NULL
  • From: Handyman
• Re: Access 2003 query help please
  • From: Dale Fye
• RE: multiple query parameters on a single field
  • From: Joseph Atie
• RE: How to make this cross tab query
  • From: Hell-fire
• Re: Combo query
  • From: Jeff Boyce
• RE: multiple query parameters on a single field
  • From: KARL DEWEY
• RE: multiple query parameters on a single field
  • From: Joseph Atie
• RE: How to set up Query?
  • From: teelee
• Re: Combo query
  • From: Budd
• Re: multiple query parameters on a single field
  • From: Ken Snell \(MVP\)
• Re: Query against dates
  • From: Ken Snell \(MVP\)
• Re: Need join with count of matching records in 2nd table
  • From: Jeff Boyce
• Re: Combo query
  • From: Jeff Boyce
• RE: Query against dates
  • From: Robert_L_Ross
• Combo query
  • From: Budd
• RE: How to set up Query?
  • From: Duane Hookom
• Re: Query against dates
  • From: Ken Sheridan
• Re: Changing "Firstweekofyear" within a query
  • From: Douglas J. Steele
• RE: Append Non-Duplicate & Updated Records
  • From: S.Clark
• Re: Access 2003 query help please
  • From: Sid Price
• Re: Access 2003 query help please
  • From: Sid Price
• RE: How to set up Query?
  • From: teelee
• Re: QA
  • From: John Spencer
• Re: MS ACCESS Jet SQL: Update statements that utilize saved queries/dmax
  • From: joeyrhyu
• Re: MS ACCESS Jet SQL: Update statements that utilize saved queries/dmax
  • From: Michel Walsh
• Re: How do I delete a return address that appears as a deafult addres
  • From: John W . Vinson
• MS ACCESS Jet SQL: Update statements that utilize saved queries/dmax
  • From: joeyrhyulz
• Re: Access 2003 query help please
  • From: mscertified
• Re: Setting variables in VB for use in queries
  • From: Michel Walsh
• Re: HELP Query via ADO never return but in access takes less milli
  • From: Michel Walsh
• Re: QA
  • From: BillyRogers
• Re: Access 2003 query help please
  • From: Sid Price
• Re: calculated field rounding down
  • From: George Nicholson
• QA
  • From: Duane Hookom
• Re: Query against dates
  • From: John Spencer
• RE: Query against dates
  • From: KARL DEWEY
• Re: DSum Ineffective
  • From: Intui_Sol
• QA
  • From: BillyRogers
• Re: count query and negative numbers question
  • From: David
• QA
  • From: Duane Hookom
• Re: Query against dates
  • From: Robert_L_Ross
• Access 2003 query help please
  • From: Sid Price
• Re: QA
  • From: John Spencer
• Re: HELP Query via ADO never return but in access takes less millisecs
  • From: Michel Walsh
• Re: count null record in fileds dao
  • From: Michel Walsh
• Re: Multipy time?
  • From: John Spencer
• Re: Getting Criteria from Optionbuttons
  • From: Mike
• Re: QA
  • From: John Spencer
• Re: problem with update query
  • From: John Spencer
• Re: Getting Criteria from Optionbuttons
  • From: John Spencer
• Re: Access Date() & DateAdd functions apparent error in Vista
  • From: Allen Browne
• Re: Data type mismatch
  • From: injanib via AccessMonster.com
• Re: Getting Criteria from Optionbuttons
  • From: Mike
• RE: Adding fields into exisiting table
  • From: Duane Hookom
• rownum update sql
  • From: marfi95
• rownum update sql
  • From: marfi95
• RE: How to set up Query?
  • From: Duane Hookom
• Re: Access Date() & DateAdd functions apparent error in Vista
  • From: David W. Fenton
• Re: problem with update query
  • From: Tim
• Re: Data type mismatch
  • From: injanib via AccessMonster.com
• RE: How to set up Query?
  • From: teelee
• Re: Getting Criteria from Optionbuttons
  • From: John Spencer
• Re: How can we convert a crosstab query to a table?
  • From: John Spencer
• Re: problem with update query
  • From: John Spencer
• Re: Getting Criteria from Optionbuttons
  • From: John Spencer
• Re: count query and negative numbers question
  • From: John Spencer
• Re: Combine field from several records
  • From: John Spencer
• Re: Working with Null Values
  • From: John Spencer
• Re: Time Calculations
  • From: John Spencer
• Developing queries in two or more parts.
  • From: Bill
• count null record in fileds dao
  • From: sal21
• Top 5 by a GROUPing?
  • From: Jay
• problem with update query
  • From: Tim
• Adding fields into exisiting table
  • From: tekari
• RE: How to set up Query?
  • From: Duane Hookom
• Re: Data type mismatch
  • From: John W . Vinson
• Re: Calcutlating a DueDate with a working days function
  • From: Michael Gramelspacher
• Re: Access Date() & DateAdd functions apparent error in Vista
  • From: Allen Browne
• Re: Is It Possible To Pass Parameters to A Pass Through Query
  • From: Rick Brandt
• Re: Query that returns nothing
  • From: Keith
• RE: join on two firelds
  • From: KARL DEWEY
• Re: count decimal place
  • From: KARL DEWEY
• Append Non-Duplicate & Updated Records
  • From: owp^3
• RE: How to set up Query?
  • From: teelee
• Is It Possible To Pass Parameters to A Pass Through Query
  • From: mcl
• Re: Date() in XP/Access 2003
  • From: Steven B.
• count query and negative numbers question
  • From: David
• RE: join on two firelds
  • From: margaret
• Re: count decimal place
  • From: Douglas J. Steele
• RE: join on two firelds
  • From: KARL DEWEY
• Re: Access Date() & DateAdd functions apparent error in Vista
  • From: David W. Fenton
• Re: DSum Ineffective
  • From: Michel Walsh
• Re: how do I search dates using the "between and" function
  • From: John W . Vinson
• Re: Double dates
  • From: John W . Vinson
• Re: Data type mismatch
  • From: injanib via AccessMonster.com
• Data type mismatch
  • From: injanib via AccessMonster.com
• Re: Is there a limit on Union query unions?
  • From: John W . Vinson
• Re: Access Date() & DateAdd functions apparent error in Vista
  • From: ColinG
• Re: Expression
  • From: John Spencer
• Re: Calculating percentage of Total?
  • From: John Spencer
• Re: Multiple Update Set Statements or Multiple DML Statements in one
  • From: John Spencer
• Re: Expression
  • From: John Spencer
• Re: Current Month Last
  • From: Ken Snell \(MVP\)
• Re: Expression
  • From: CharlesCount via AccessMonster.com
• Re: Is there a limit on Union query unions?
  • From: George Nicholson
• RE: Sum Last 4 Quarters
  • From: jas580
• Re: Multiple Update Set Statements or Multiple DML Statements in one
  • From: thedudeminds
• Re: Multiple Update Set Statements or Multiple DML Statements in one
  • From: John Spencer
• Re: Current Month Last
  • From: JohnLute
• Calculating percentage of Total?
  • From: Jay
• RE: Multiple Update Set Statements or Multiple DML Statements in one
  • From: S.Clark
• Re: Extracting Partial Text from Field - INSTR and INSTRREV
  • From: Anita Taylor
• Re: $ and decimals in calculation
  • From: Jeff Boyce
• Re: Is there a limit on Union query unions?
  • From: John Spencer
• Multiple Update Set Statements or Multiple DML Statements in one
  • From: thedudeminds
• Re: Sorting non alphabetically
  • From: Jamie Collins
• Re: update a table based upon another table
  • From: John Spencer
• Re: Last record on a table
  • From: Jamie Collins
• Re: Current Month Last
  • From: John Spencer
• Re: update a table based upon another table
  • From: Steve
• Re: Access Date() & DateAdd functions apparent error in Vista
  • From: Allen Browne
• Re: Sorting non alphabetically
  • From: Marshall Barton
• Re: Calculating the sum of a field
  • From: Marshall Barton
• Re: Sorting non alphabetically
  • From: Jamie Collins
• Re: Current Month Last
  • From: Ken Snell \(MVP\)
• Re: Combining two queries into a single query
  • From: aine_canby
• Re: Access Date() & DateAdd functions apparent error in Vista
  • From: ColinG
• Re: Date() in XP/Access 2003
  • From: John Spencer
• Re: Combining two queries into a single query
  • From: John Spencer
• Re: Need help with a combobox query
  • From: John Spencer
• Re: Expression
  • From: John Spencer
• Combining two queries into a single query
  • From: aine_canby
• Re: Access Date() & DateAdd functions apparent error in Vista
  • From: Allen Browne
• Re: MS Access Error 3700
  • From: Stefan Hoffmann
• Re: MS Access Error 3700
  • From: RoyVidar
• Re: MS Access Error 3700
  • From: Stefan Hoffmann
• Re: conditional update query returning empty field
  • From: John W . Vinson
• Re: Relational
  • From: John W . Vinson
• Re: Query that returns nothing
  • From: UpRider
• RE: Sum Last 4 Quarters
  • From: NetworkTrade
• Re: In Access, Where do I find SQL Query Builder for forms; unbound co
  • From: John W . Vinson
• Re: Updateable Query
  • From: John W . Vinson
• Re: Need expression for next month's expirations??
  • From: SilverTip 147
• Re: Extracting Partial Text from Field - INSTR and INSTRREV
  • From: fredg
• Query that returns nothing
  • From: Keith
• Query that returns nothing
  • From: Keith
• RE: Expression
  • From: NetworkTrade
• Re: how to write the query criteria
  • From: Marshall Barton
• Re: how to write the query criteria
  • From: Jeff Boyce
• Re: does not include the specified exp as part of an aggregate
  • From: JohnLute
• RE: Expression
  • From: CharlesCount via AccessMonster.com
• Re: Need help with a combobox query
  • From: Ronald Marchand
• Re: does not include the specified exp as part of an aggregate
  • From: John Spencer
• Re: Finding wrong values for keyfield
  • From: John Spencer
• Re: query to split data in a column into two separate columns
  • From: John Spencer
• Re: Need help with a combobox query
  • From: John Spencer
• RE: Performing Loop query ( for parts replaced)
  • From: Mercadogs
• Re: Form parameter Query
  • From: Anthony
• DSum Ineffective
  • From: Intui_Sol
• Re: Need help with a combobox query
  • From: Ronald Marchand
• Expression
  • From: CharlesCount via AccessMonster.com
• RE: Extracting Partial Text from Field - INSTR and INSTRREV
  • From: Ken Sheridan
• Re: Last record on a table
  • From: John Spencer
• Re: query to split data in a column into two separate columns
  • From: bearprecioso
• Re: query to split data in a column into two separate columns
  • From: John Spencer
• Re: Comma in query expression
  • From: injanib via AccessMonster.com
• RE: August is a problem
  • From: Ken Sheridan
• RE: query to split data in a column into two separate columns
  • From: bearprecioso
• RE: August is a problem
  • From: KARL DEWEY
• RE: Append Query to a different field name
  • From: Ricoy-Chicago
• Re: Percentage question
  • From: Jase4now
• Form parameter Query
  • From: ad
• August is a problem
  • From: SaskGuy
• Re: Percentage question
  • From: samuel
• Re: Percentage question
  • From: Jase4now
• Re: Extracting golf score data
  • From: Mark Senibaldi
• RE: Dynamic fields
  • From: Al
• Combining Crosstab Queries
  • From: dp724 via AccessMonster.com
• Re: Bug with SELECT TOP when ordering
  • From: John Spencer
• RE: SQL expressions in MS Access: What do they mean ?
  • From: Maurice
• Comma in query expression
  • From: injanib via AccessMonster.com
• Re: Dynamic fields
  • From: John Spencer
• RE: Dynamic fields
  • From: KARL DEWEY
• RE: Append Query to a different field name
  • From: KARL DEWEY
• Re: Accessing active directory from MS Access
  • From: Michel Walsh
• Re: can i use sum function along with union operation?
  • From: Michel Walsh
• Re: Two Key fields
  • From: Michel Walsh
• RE: Date Query: Select all items before 5/Sep/2007
  • From: Duane Hookom
• Re: Need expression for next month's expirations??
  • From: Michel Walsh
• Re: Parameter query
  • From: Jeff Boyce
• Re: SQL expressions in MS Access: What do they mean ?
  • From: John Spencer
• RE: Right Truncation warning
  • From: Charles Wang[MSFT]
• Re: Mapping Companies and thier Codes (2 tables)
  • From: John Spencer
• Re: Criteria of query
  • From: John Spencer
• Re: How to prevent duplicates
  • From: John Spencer
• RE: SQL expressions in MS Access: What do they mean ?
  • From: ali
• Re: Subtracting "Settle_Date" from "Deal_Date", how many days ?
  • From: Stefan Hoffmann
• RE: queries and parm
  • From: scubadiver
• Re: Replacing null values in text fields
  • From: Rob Parker
• Re: How do I concatenate a text field from a form to a "Where" string ?
  • From: mthornblad
• How do I concatenate a text field from a form to a "Where" string ?
  • From: mthornblad
• RE: Running date queries and disregards years
  • From: Sin
• Re: retrieving unique record from identical tables
  • From: tolis
• Re: dd/MM/YYYY in SQL & Ctrl Panel but access read it as MM/dd/YYYY
  • From: John W . Vinson
• Re: Date Query: Select all items before 5/Sep/2007
  • From: John W . Vinson
• RE: Date Query: Select all items before 5/Sep/2007
  • From: ali
• Re: Access maybe, Sql no/ Understanding tables as variables
  • From: Steve Dassin
• RE: Date Query: Select all items before 5/Sep/2007
  • From: Duane Hookom
• RE: Date Query: Select all items before 5/Sep/2007
  • From: ali
• Re: Need expression for next month's expirations??
  • From: fredg
• Re: dd/MM/YYYY in SQL & Ctrl Panel but access read it as MM/dd/YYYY
  • From: Marshall Barton
• Re: Need expression for next month's expirations??
  • From: SilverTip 147
• Re: showing only certain records
  • From: pietlinden@xxxxxxxxxxx
• load query results into ado recordset
  • From: spleve
• Re: Access 2007 Lock Violation
  • From: JudeD
• Re: Parameter query
  • From: trawets
• Re: Need expression for next month's expirations??
  • From: fredg
• RE: Two Key fields
  • From: Ken Sheridan
• Re: Filter Duplicate Entries
  • From: George
• Re: Need expression for next month's expirations??
  • From: SilverTip 147
• Re: retrieving unique record from identical tables
  • From: John Spencer
• Re: Cross Tab Query with Different Column Headings
  • From: John Spencer
• Re: Filter Duplicate Entries
  • From: Gina Whipp
• Re: Need expression for next month's expirations??
  • From: fredg
• Re: Two Key fields
  • From: Michael Gramelspacher
• Re: Filter Duplicate Entries
  • From: George
• Re: Cross Tab Query with Different Column Headings
  • From: Lisa
• Re: Filter Duplicate Entries
  • From: Gina Whipp
• Re: Parameter query
  • From: Jeff Boyce
• Re: retrieving unique record from identical tables
  • From: tolis
• Parameter query
  • From: trawets
• Re: Record time report, macro or query runs
  • From: Allen Browne
• Re: Filter Duplicate Entries
  • From: Gina Whipp
• Re: access expressions
  • From: toml_12953
• Re: retrieving unique record from identical tables
  • From: StopThisAdvertising
• Record time report, macro or query runs
  • From: argniw
• Re: retrieving unique record from identical tables
  • From: Steve
• Re: retrieving unique record from identical tables
  • From: Douglas J. Steele
• Re: Query against dates
  • From: Marshall Barton
• Re: Capturing parameter input
  • From: Allen Browne
• Re: Capturing parameter input
  • From: Rick Brandt
• Capturing parameter input
  • From: Hugh
• Re: How to prevent duplicates
  • From: tina
• Re: Need expression for next month's expirations??
  • From: fredg
• How to prevent duplicates
  • From: Hell-fire
• Re: update issue with SQL
  • From: smk23
• Re: Query against dates
  • From: Gary Walter
• Re: How do I remove leading Zeros?
  • From: Jeff Boyce
• Re: update issue with SQL
  • From: Jeff Boyce
• Re: Apply condition on Outer join table, Not at WHERE Statement
  • From: Gary Walter
• Re: Date selection query
  • From: Gary Walter
• Re: How do I remove leading Zeros?
  • From: tina
• Re: How do I remove leading Zeros?
  • From: fredg
• How do I remove leading Zeros?
  • From: Frank Martin
• Bank Reconciliation question.
  • From: Frank Martin
• Re: Very limited number of lines for criteria in query designer
  • From: Rick Brandt
• Re: Very limited number of lines for criteria in query designer
  • From: Allen Browne
• Very limited number of lines for criteria in query designer
  • From: pschrader
• RE: queries and parm
  • From: Les
• Re: Query against dates
  • From: Marshall Barton
• Re: Query against dates
  • From: Ken Snell \(MVP\)
• Re: VBA?
  • From: fredg
• Re: return text given criteria
  • From: fredg
• Re: have query based from a left join, now need to exclude records....
  • From: andrewg
• Re: IIF date statement
  • From: John Spencer
• Re: IIF date statement
  • From: Ken Snell \(MVP\)
• RE: query to split data in a column into two separate columns
  • From: Jerry Whittle
• Re: query to split data in a column into two separate columns
  • From: John Spencer
• Re: update query
  • From: John Spencer
• Re: Cross Tab Query with Different Column Headings
  • From: Michel Walsh
• Re: Inserting code to obtain first day of workweek.
  • From: Ken Snell \(MVP\)
• Re: Union Query and Where Clause
  • From: Ken Snell \(MVP\)
• Union Query and Where Clause
  • From: alexander199
• Re: Line Numbering
  • From: Database girl
• RE:dates
  • From: Ken Sheridan
• Re: Today's date less 4 months
  • From: Michel Walsh
• Re: Line Numbering
  • From: Michel Walsh
• Re: Rediculous query run tim
  • From: Michel Walsh
• Re: Line Numbering
  • From: Database girl
• RE: query to split data in a column into two separate columns
  • From: bearprecioso
• Re: Viewing all data entered for the week
  • From: Michael Gramelspacher
• Re: Calculating last year
  • From: Al
• Re: Criteria for current month, current year
  • From: CW
• Re: Line Numbering
  • From: Database girl
• Re: update query
  • From: Jeff Boyce
• RE: IIf Function
  • From: CharlesCount via AccessMonster.com
• Re: Criteria for current month, current year
  • From: Ken Snell \(MVP\)
• Re: Criteria for current month, current year
  • From: Ken Snell \(MVP\)
• Re: Calculating last year
  • From: John Spencer
• Re: Calculating last year
  • From: John Spencer
• The 101 ROMANTIC SECRETS and TECHNICS
  • From: The 101 ROMANTIC SECRETS and TECHNICS
• Re: Rediculous query run tim
  • From: Basil
• Re: Today's date less 4 months
  • From: Jamie Collins
• Re: Parameter query in which you can search for any word
  • From: Jamie Collins
• Re: Today's date less 4 months
  • From: Michel Walsh
• Re: Criteria for current month, current year
  • From: Marshall Barton
• Re: Criteria for current month, current year
  • From: Ken Snell \(MVP\)
• Re: IIf Function
  • From: Ken Snell \(MVP\)
• Re: Creating a complicated query
  • From: Jamie Collins
• Re: Line Numbering
  • From: Michel Walsh
• Re: Rediculous query run tim
  • From: Michel Walsh
• Re: Today's date less 4 months
  • From: Jamie Collins
• IIf Function
  • From: CharlesCount via AccessMonster.com
• Re: Line Numbering
  • From: Jeff Boyce
• Re: Rediculous query run tim
  • From: Basil
• Re: If... Else Statement in SQL
  • From: Jamie Collins
• Re: Rediculous query run tim
  • From: Michel Walsh
• Re: have query based from a left join, now need to exclude records....
  • From: Jamie Collins
• Re: how would I write this criteria for a query?
  • From: Jamie Collins
• Re: Sort Last 4 Numbers of SSN
  • From: Jamie Collins
• Re: Need to identify an empty field
  • From: John Spencer
• Re: have query based from a left join, now need to exclude records....
  • From: John Spencer
• Re: What function will return the most recent entry date for a record?
  • From: Jamie Collins
• Re: Replacing unicode characters in text field
  • From: david
• Re: CONCATENATE/TRIM WITH WHITE SPACE (RETURN KEY)
  • From: John Spencer
• Re: Query Enhancement Request
  • From: John Spencer
• Re: I need help with syntax for Nz function in query
  • From: Jamie Collins
• Re: CONCATENATE/TRIM WITH WHITE SPACE (RETURN KEY)
  • From: ant1983
• Re: I need help with syntax for Nz function in query
  • From: Allen Browne
• Re: I need help with syntax for Nz function in query
  • From: mthornblad
• RE: queries and parm
  • From: scubadiver
• Re: I need help with syntax for Nz function in query
  • From: mthornblad
• Re: Is there a keyboard shortcut to Run a Query?
  • From: RoyVidar
• Re: I need help with syntax for Nz function in query
  • From: Allen Browne
• I need help with syntax for Nz function in query
  • From: mthornblad
• Re: transpose columns into rows
  • From: Ken Snell \(MVP\)
• have query based from a left join, now need to exclude records....
  • From: andrewg
• Re: My apologies
  • From: Douglas J. Steele
• Re: What function will return the most recent entry date for a record?
  • From: Ken Snell \(MVP\)
• Re: MULTIPLE CHANGES TO ONE FIELD
  • From: John W . Vinson
• Re: Need help with a combobox query
  • From: Ronald Marchand
• Re: How get rid of time portion of dates?
  • From: John W . Vinson
• Re: How to ID a table source being used in a Union Query
  • From: Barb H
• Re: Union Query to append table?
  • From: John Spencer
• Re: Compare and display non dups
  • From: John Spencer
• Re: Union query
  • From: John Spencer
• Re: Union Query to append table?
  • From: Michel Walsh
• Re: How to ID a table source being used in a Union Query
  • From: John Spencer
• Re: How to ID a table source being used in a Union Query
  • From: Barb H
• RE: searching entire database
  • From: misschanda via AccessMonster.com
• RE: searching entire database
  • From: misschanda via AccessMonster.com
• Union Query to append table?
  • From: hawornk via AccessMonster.com
• Re: Help...Want to make integer down to hundreth in qry.
  • From: Jeff Boyce
• Re: How to ID a table source being used in a Union Query
  • From: Jeff Boyce
• Re: My apologies
  • From: Ken Snell \(MVP\)
• Re: How to ID a table source being used in a Union Query
  • From: Ken Snell \(MVP\)
• Re: Matching records for an update query
  • From: Tracy
• Re: Message box pop up when no reults
  • From: Klatuu
• Re: CONCATENATE/TRIM WITH WHITE SPACE (RETURN KEY)
  • From: John Spencer
• Re: Trying to select data range for date/time column
  • From: John Spencer
• Re: Why does this not work (selecting a date) ?
  • From: John Spencer
• Re: searching entire database
  • From: John Spencer
• Re: Query Enhancement Request
  • From: John Spencer
• Re: Query Enhancement Request
  • From: Michel Walsh
• Re: sql within sql referencing a value from a form
  • From: John Spencer
• RE: queries and parm
  • From: Les
• Re: How get rid of time portion of dates?
  • From: John Spencer
• searching entire database
  • From: misschanda via AccessMonster.com
• Re: Writing numbers as alpha
  • From: Stefan Hoffmann
• RE: queries and parm
  • From: scubadiver
• Re: Search Multiple Queries w/ One Search parameter
  • From: misschanda via AccessMonster.com
• Re: Query broken link error
  • From: Michel Walsh
• Re: sql within sql referencing a value from a form
  • From: John Spencer
• RE: Using results from a Sub Query in a Crosstab Query
  • From: Adrian Jones
• Re: Group dates
  • From: John Spencer
• Re: Currency Convertion
  • From: John Spencer
• Re: Subtracting "Settle_Date" from "Deal_Date", how many days ?
  • From: Stefan Hoffmann
• Re: transpose columns into rows
  • From: Ken Snell \(MVP\)
• Re: performance question
  • From: Allen Browne
• Re: How get rid of time portion of dates?
  • From: John W . Vinson
• Re: viewing all records with duplicate field values
  • From: John W . Vinson
• Re: How get rid of time portion of dates?
  • From: John Spencer
• Re: viewing all records with duplicate field values
  • From: John Spencer
• Re: viewing all records with duplicate field values
  • From: shadowsong
• Re: Viewing all data entered for the week
  • From: Michael Gramelspacher
• viewing all records with duplicate field values
  • From: shadowsong
• Re: Message box pop up when no reults
  • From: Ronald Marchand
• Re: Message box pop up when no reults
  • From: Klatuu
• Re: Message box pop up when no reults
  • From: Ronald Marchand
• Re: DateDiff
  • From: John W . Vinson
• Re: DateDiff
  • From: John W . Vinson
• Re: Message box pop up when no reults
  • From: Ronald Marchand
• Re: Query
  • From: james_keegan via AccessMonster.com
• Re: Viewing all data entered for the week
  • From: Michael Gramelspacher
• Re: Advanced Sorting
  • From: Dispatcher Scott
• Re: Advanced Sorting
  • From: james_keegan via AccessMonster.com
• Re: DateDiff
  • From: Jeff Boyce
• performance question
  • From: james_keegan via AccessMonster.com
• Re: How to multiplicate?
  • From: Michel Walsh
• Re: Advanced Sorting
  • From: Michel Walsh
• Re: Lookup one table to another.
  • From: Michel Walsh
• Re: Advanced Sorting
  • From: Dispatcher Scott
• Re: How to multiplicate?
  • From: Henderson
• Re: Acumulated Value
  • From: Michel Walsh
• Re: Lookup one table to another.
  • From: Michel Walsh
• Re: Advanced Sorting
  • From: Michel Walsh
• Re: How to multiplicate?
  • From: Michel Walsh
• Re: Transferring Queries Question
  • From: Tom
• Re: Format Conversion
  • From: Michel Walsh
• Re: Acumulated
  • From: Marshall Barton
• Re: How best to verify a successful update to a table
  • From: Marshall Barton
• Format Conversion
  • From: NeonSky via AccessMonster.com
• Re: DateDiff
  • From: Jeff Boyce
• Re: Query
  • From: Jeff Boyce
• How to multiplicate?
  • From: Marcelo Henderson via AccessMonster.com
• Re: show percentage display without rounding?
  • From: John W . Vinson
• Re: Calculating on Query
  • From: John Spencer
• RE: Using results from a Sub Query in a Crosstab Query
  • From: Duane Hookom
• Calculating on Query
  • From: Henderson
• Acumulated
  • From: marcelohenderson
• Re: How best to verify a successful update to a table
  • From: rich
• Re: Need selective count within grouping, how?
  • From: Marshall Barton
• Re: How best to verify a successful update to a table
  • From: Marshall Barton
• Re: Make a table from a Query?
  • From: John W . Vinson
• Re: Transferring Queries Question
  • From: Tom
• RE: Using results from a Sub Query in a Crosstab Query
  • From: Adrian Jones
• Re: Transferring Queries Question
  • From: Tom
• Re: Transferring Queries Question
  • From: Roger Carlson
• Re: Transferring Queries Question
  • From: Tom
• RE: Using results from a Sub Query in a Crosstab Query
  • From: Duane Hookom
• Re: Today's date less 4 months
  • From: Les
• Re: Today's date less 4 months
  • From: Michel Walsh
• Re: Query broken link error
  • From: Michel Walsh
• Re: Search Multiple Queries w/ One Search parameter
  • From: misschanda via AccessMonster.com
• Re: Transferring Queries Question
  • From: Roger Carlson
• Re: Problem creating a query with calculated value
  • From: George Nicholson
• Transferring Queries Question
  • From: Tom
• Re: Male Female Count
  • From: AshParr
• Re: Male Female Count
  • From: Michel Walsh
• Re: Today's date less 4 months
  • From: Michel Walsh
• Re: VB.net - UPDATE query with binary data
  • From: Michel Walsh
• Re: Need help in Dates Calculations.
  • From: Allen Browne
• Re: Grouping on a date field
  • From: Alexey
• Re: Need help in Dates Calculations.
  • From: khaksar
• Re: Concatenating 3 fileds into a new field
  • From: Stefan Hoffmann
• Re: Show Last Weeks Data
  • From: AshParr
• Re: Help with specific expression
  • From: John Spencer
• Re: Subtracting "Settle_Date" from "Deal_Date", how many days ?
  • From: Stefan Hoffmann
• Re: Subtracting "Settle_Date" from "Deal_Date", how many days ?
  • From: John Spencer
• Re: why does my parameter query repeat the prompt?
  • From: John Spencer
• Re: Search Multiple Queries w/ One Search parameter
  • From: John Spencer
• Re: transpose columns into rows
  • From: Ra
• Re: Need help in Dates Calculations.
  • From: Allen Browne
• Re: Show Last Weeks Data
  • From: Allen Browne
• Re: Need help in Dates Calculations.
  • From: khaksar
• Using results from a Sub Query in a Crosstab Query
  • From: Adrian Jones
• Grouping on a date field
  • From: Alexey
• Re: VB.net - UPDATE query with binary data
  • From: SiD`
• Re: Show Last Weeks Data
  • From: AshParr
• Re: Subtracting "Settle_Date" from "Deal_Date", how many days ?
  • From: Stefan Hoffmann
• Re: Creating a complicated query
  • From: John W . Vinson
• Re: why does my parameter query repeat the prompt?
  • From: Ken Snell \(MVP\)
• Re: Access 2007 Lock Violation
  • From: JudeD
• Re: Acumulated Value
  • From: Marshall Barton
• Re: Access 2007 Lock Violation
  • From: John Spencer
• Re: Count months not days
  • From: Scott
• Re: Please Help with Query to Return a Balance Column
  • From: Ken Snell \(MVP\)
• Re: Please Help with Query to Return a Balance Column
  • From: Ken Snell \(MVP\)
• Re: Please Help with Query to Return a Balance Column
  • From: Ken Snell \(MVP\)
• Re: How do I list the column names only in a combo box
  • From: Douglas J. Steele
• Re: Data Conversion Question
  • From: Gina Whipp
• Re: Please Help with Query to Return a Balance Column
  • From: LuvToGlass@xxxxxxxxx
• Re: transpose columns into rows
  • From: Ken Snell \(MVP\)
• Re: Please Help with Query to Return a Balance Column
  • From: Ken Snell \(MVP\)
• Re: dateadd on month
  • From: Ken Snell \(MVP\)
• Re: Data Conversion Question
  • From: Gary Dolliver
• Re: Data Conversion Question
  • From: Gary Dolliver
• Re: Filter from Form
  • From: John Spencer
• Re: Acumulated Value
  • From: Marcelo Henderson via AccessMonster.com
• Re: Deleting "Rogue" sub-table entries
  • From: Marshall Barton
• Re: Deleting "Rogue" sub-table entries
  • From: mosleyn
• Re: Search Multiple Queries w/ One Search parameter
  • From: misschanda via AccessMonster.com
• Please Help with Query to Return a Balance Column
  • From: LuvToGlass@xxxxxxxxx
• Re: Trying to pull same names from 2 tables
  • From: Jeff Boyce
• RE: tallying occurrences independently in a query?
  • From: starlingseven via AccessMonster.com
• Re: VB.net - UPDATE query with binary data
  • From: Michel Walsh
• transpose columns into rows
  • From: bzh2md
• Re: Acumulated Value
  • From: Marcelo Henderson via AccessMonster.com
• Re: Multiple tables in a query
  • From: Roger Carlson
• Re: Formating Post Import
  • From: Jeff Boyce
• Re: Trying to pull same names from 2 tables
  • From: Jeff Boyce
• Re: Calculation problem
  • From: Jeff Boyce
• Re: Summing data in QueryDef
  • From: John W . Vinson
• Formating Post Import
  • From: NeonSky via AccessMonster.com
• Re: need query to show additional records
  • From: CEV
• Re: Compare records in a query then write equation??
  • From: John Spencer
• Re: Search Multiple Queries w/ One Search parameter
  • From: John Spencer
• Re: VB.net - UPDATE query with binary data
  • From: SiD`
• Re: dateadd on month
  • From: Allen Browne
• Re: Show Last Weeks Data
  • From: Ken Snell \(MVP\)
• Re: dateadd on month
  • From: Ken Snell \(MVP\)
• Re: Show Last Weeks Data
  • From: Allen Browne
• Re: dateadd on month
  • From: Allen Browne
• Show Last Weeks Data
  • From: AshParr
• Re: Need help in Dates Calculations.
  • From: Allen Browne
• Re: How can I reference a subform record set in a combo rowsource quer
  • From: Michel Walsh
• Re: VB.net - UPDATE query with binary data
  • From: Michel Walsh
• Re: Problem with Calculated Date
  • From: Wolfgang Kais
• Re: Query - Force non-existant "Group by" values
  • From: Michel Walsh
• Re: Compare records in a query then write equation??
  • From: Samer
• RE: Search Multiple Queries w/ One Search parameter
  • From: misschanda via AccessMonster.com
• Re: Need help in Dates Calculations.
  • From: Douglas J. Steele
• RE: Right Truncation warning
  • From: Charles Wang[MSFT]
• Re: conversion number into text format
  • From: John Spencer
• Re: Compare records in a query then write equation??
  • From: John Spencer
• Re: Acumulated Value
  • From: John Spencer
• Re: conversion number into text format
  • From: Tom Lake
• Re: Need help in Dates Calculations.
  • From: Allen Browne
• Re: Leading Zereos
  • From: Nigel1969 via AccessMonster.com
• Compare records in a query then write equation??
  • From: Samer
• Re: Count months not days
  • From: John W . Vinson
• Re: Summing data in QueryDef
  • From: John W . Vinson
• Re: Count months not days
  • From: Marshall Barton
• Count months not days
  • From: Scott
• Re: Acumulated Value
  • From: Marcelo Henderson via AccessMonster.com
• Re: Access 2007 Lock Violation
  • From: John Spencer
• Re: duplicate names in field
  • From: John Spencer
• Re: duplicate names in field
  • From: John W . Vinson
• Re: Acumulated Value
  • From: John Spencer
• Re: Problem with Calculated Date
  • From: John W . Vinson
• Re: Problem with Calculated Date
  • From: John Spencer
• Re: creating queries
  • From: John W . Vinson
• Re: Problem with Calculated Date
  • From: knitter via AccessMonster.com
• Re: How do I add rows related to value
  • From: tina
• Re: duplicate names in field
  • From: Rob Parker
• Acumulated Value
  • From: Marcelo Henderson via AccessMonster.com
• Re: Report on 3 Queries by Date
  • From: naigy via AccessMonster.com
• Re: Problem with Calculated Date
  • From: Wolfgang Kais
• Re: Need help with a combobox query
  • From: Ronald Marchand
• Re: Leading Zereos
  • From: Marshall Barton
• Re: Field Created by Query won't be anything but "Binary"
  • From: jgraves
• Re: Problem with Calculated Date
  • From: knitter via AccessMonster.com
• Re: How do I update multiple queries simultaneously?
  • From: Allen Browne
• Re: Report on 3 Queries by Date
  • From: Jeff Boyce
• Leading Zereos
  • From: Nigel1969
• Re: Parameter query in which you can search for any word
  • From: Wolfgang Kais
• Re: Problem with Calculated Date
  • From: Wolfgang Kais
• Re: Field Created by Query won't be anything but "Binary"
  • From: John Spencer
• Re: How to multiply percentages in a CROSSTAB-action (instead of e.g. SUM)
  • From: hans . chys
• Re: Count Query
  • From: John Spencer
• Re: Parameter query in which you can search for any word
  • From: Rick Brandt
• Exporting data from access to excel based on certain criteria??
  • From: Samer
• Re: Writing numbers as alpha
  • From: Stefan Hoffmann
• Problem with Calculated Date
  • From: knitter via AccessMonster.com
• RE: Need Help please...!!!
  • From: scubadiver
• Re: Report on 3 Queries by Date
  • From: naigy via AccessMonster.com
• Count Query
  • From: Bill
• Re: Access fails to find refered experient
  • From: oliaccount via AccessMonster.com
• Re: How do I update multiple queries simultaneously?
  • From: Allen Browne
• RE: Need help with a combobox query
  • From: Ken Sheridan
• Re: Lowest value
  • From: Marshall Barton
• RE: Ranking Question
  • From: KARL DEWEY
• Re: Querys based on Querys
  • From: tina
• Re: Ranking Question
  • From: Gary Walter
• Re: Report on 3 Queries by Date
  • From: Jeff Boyce
• Re: Querying Against Foxpro DB Yields Different Results
  • From: Gary Walter
• Re: Querys based on Querys
  • From: Gill
• Re: Problem with left join.
  • From: Ken Snell \(MVP\)
• Ranking Question
  • From: Bob
• Re: Querys based on Querys
  • From: tina
• Re: Querying Against Foxpro DB Yields Different Results
  • From: Allen Browne
• Re: query is turning my results into text
  • From: Ed Metcalfe
• query is turning my results into text
  • From: tbmarlie
• Report on 3 Queries by Date
  • From: naigy via AccessMonster.com
• Re: Problem with left join.
  • From: Laurel
• Re: Problem with left join.
  • From: Ken Snell \(MVP\)
• Problem with left join.
  • From: Laurel
• Re: Recursive(?) Query
  • From: Gary Walter
• Re: Recursive(?) Query
  • From: Gary Walter
• Re: String Query
  • From: Gary Walter
• Re: How to run a Query in a query...
  • From: Allen Browne
• Re: Help needed in Criteria Field Please.
  • From: Allen Browne
• Re: String Query
  • From: Gary Walter
• Re: Help needed in Criteria Field Please.
  • From: Allen Browne
• Re: Warn me Not
  • From: '69 Camaro
• Re: Warn me Not
  • From: Allen Browne
• Recursive(?) Query
  • From: MikeC
• RE: tallying occurrences independently in a query?
  • From: starlingseven via AccessMonster.com
• Re: Data Conversion Question
  • From: Gina Whipp
• Re: Data Conversion Question
  • From: Gary Dolliver
• Re: Data Conversion Question
  • From: Gina Whipp
• Re: Data Conversion Question
  • From: Gary Dolliver
• Re: Data Conversion Question
  • From: Gina Whipp
• Re: Data Conversion Question
  • From: Gary Dolliver
• Re: Data Conversion Question
  • From: Gina Whipp