microsoft.public.access.queries

• Thread Index

---

• Re: delete oldest dates
  • From: MGFoster
• Re: Junkmail
  • From: John Vinson
• Re: Ignore other records but first (highest) record
  • From: Marshall Barton
• Re: Need help with complicated if statement
  • From: annysjunkmail
• delete oldest dates
  • From: Bart
• Re: Return last record
  • From: Shanin
• Filter duplicate Query Results
  • From: hotrod1952 via AccessMonster.com
• RE: eval function
  • From: Mark Burns
• Re: Need help with complicated if statement
  • From: Gina via AccessMonster.com
• Re: Delete Query
  • From: Bart
• Re: Junkmail
  • From: Rick B
• Junkmail
  • From: Sara Rishworth
• Re: Need help with complicated if statement
  • From: annysjunkmail
• Re: Union and variable
  • From: George Nicholson
• Re: Conditional test to combine multiple records
  • From: Joe
• Re: Ignore other records but first (highest) record
  • From: annysjunkmail
• Dsum grouped by
  • From: John
• Re: Manually Add a record to a query.
  • From: John Spencer
• Re: Manually Add a record to a query.
  • From: Michel Walsh
• Re: Need help with complicated if statement
  • From: Gina via AccessMonster.com
• Re: Union and variable
  • From: Michel Walsh
• Re: select * from mytable except ...
  • From: Michel Walsh
• Re: Query to Count, but return items that are null
  • From: Sandy
• Re: Need help with complicated if statement
  • From: annysjunkmail
• Re: INSERT INTO "record single"
  • From: John Nurick
• RE: query criteria entered via a form
  • From: Ofer
• Re: add selected records
  • From: Brian via AccessMonster.com
• How do I prevent PivotTable Query from Being Saved
  • From: Craig M . Bobchin
• Re: Conditional test to combine multiple records
  • From: Joe
• Re: add selected records
  • From: OfficeDev18 via AccessMonster.com
• Re: using the IIF function in access
  • From: OfficeDev18 via AccessMonster.com
• Re: Conditional test to combine multiple records
  • From: John Spencer
• Re: And Using a query to select data in one field compared to anot
  • From: Rick B
• Re: Combining Query Outputs
  • From: Lucy
• Re: Ignore other records but first (highest) record
  • From: Marshall Barton
• Re: And Using a query to select data in one field compared to another
  • From: Rick B
• Re: Conditional test to combine multiple records
  • From: Joe
• Re: Query to Count, but return items that are null
  • From: Marshall Barton
• Re: Need help with complicated if statement
  • From: Gina via AccessMonster.com
• Ignore other records but first (highest) record
  • From: annysjunkmail
• Re: how do I embed a line feed in a memo field via Query
  • From: John Spencer
• Re: Conditional test to combine multiple records
  • From: John Spencer
• Re: Return last record
  • From: John Spencer
• Re: Queries hurting my head!
  • From: John Spencer
• Need help with complicated if statement
  • From: annysjunkmail
• Re: Problem with Delete query
  • From: Allen Browne
• add selected records
  • From: Brian via AccessMonster.com
• Re: INNER JOINS in Access
  • From: John Spencer
• Re: Filter Report based on Selection from Form
  • From: Su
• Re: Query to Count, but return items that are null
  • From: John Spencer
• Problem with Delete query
  • From: Jim Devenish
• Re: how do I embed a line feed in a memo field via Query
  • From: Rick B
• Re: Query does not show all data
  • From: RJS76 via AccessMonster.com
• Conditional test to combine multiple records
  • From: Joe
• Re: Filter Report based on Selection from Form
  • From: Su
• INSERT INTO "record single"
  • From: MS
• Queries hurting my head!
  • From: Richard Horne
• Re: Formatting number fields in Make Table query
  • From: JohnFol
• Daily & Weekly Table - Query for weekending
  • From: Kevin Labore
• RE: SQL statement question?
  • From: fox
• Re: Subselect Query Problem
  • From: Michel Walsh
• Re: Query does not show all data
  • From: Jeff Boyce
• Re: Using a fieldname as parameter value
  • From: Jeff Boyce
• Re: Calcuations in queries
  • From: John Spencer
• Re: Combining tables from two copies of DB
  • From: BruceM
• Re: INNER JOINS in Access
  • From: John Spencer
• Re: fees
  • From: Rick B
• Re: Calcuations in queries
  • From: emc
• Re: creating custom parameter form
  • From: John Spencer
• RE: query criteria entered via a form
  • From: Lori
• INNER JOINS in Access
  • From: Rick
• Re: how to add consecutive numbers?
  • From: Michael
• Query does not show all data
  • From: RJS76 via AccessMonster.com
• how to add consecutive numbers?
  • From: darkdelusion
• how to add consecutive numbers?
  • From: darkdelusion
• Re: Combining Query Outputs
  • From: Vincent Johns
• Re: Problem trying to do an update query in VBA
  • From: Chuck Arbogast
• Re: Delete record in a join query
  • From: michael
• Re-posting information as I still cant figure out problem....
  • From: red skelton via AccessMonster.com
• Delete record in a join query
  • From: michael
• Re: Union query and two Totals queries
  • From: Bill Fischer via AccessMonster.com
• Re: SQL Query from 3 linked tables is ignoring the WHERE clause
  • From: John Vinson
• Re: Group Table Data by Week
  • From: Duane Hookom
• Re: Query to Count, but return items that are null
  • From: Marshall Barton
• Subselect Query Problem
  • From: robert d via AccessMonster.com
• Re: Name order streamlining
  • From: Tom Ellison
• Re: IIF question getting #ERROR Message
  • From: John Vinson
• Re: Show Invoices Greater Than One Year
  • From: John Spencer
• Re: Combining tables from two copies of DB
  • From: [MVP] S.Clark
• Re: How do I combine these queries?
  • From: [MVP] S.Clark
• Re: Show Invoices Greater Than One Year
  • From: Lirva S via AccessMonster.com
• Re: crosstab query in access does not display last results
  • From: Duane Hookom
• Re: Update table using Total Query
  • From: Rick B
• Link 2 queries from 2 different databases
  • From: ibeetb
• Re: Best solution for this problem
  • From: MGFoster
• RE: query criteria entered via a form
  • From: KARL DEWEY
• Re: Cross-tab with multiple values
  • From: Michel Walsh
• Re: Problem trying to do an update query in VBA
  • From: guido via AccessMonster.com
• Re: crosstab query in access does not display last results
  • From: Duane Hookom
• Re: Cross-tab with multiple values
  • From: Duane Hookom
• Re: SQL erases after the query is ran
  • From: OfficeDev18 via AccessMonster.com
• Re: Complex issue with queries
  • From: Michel Walsh
• RE: query criteria entered via a form
  • From: Ofer
• Re: Problem with LIKE operator
  • From: Michel Walsh
• RE: query criteria entered via a form
  • From: Lori
• Re: extract only hour and minutes from date and time field
  • From: John Spencer
• Re: Show Invoices Greater Than One Year
  • From: John Spencer
• Cross-tab with multiple values
  • From: Chris A via AccessMonster.com
• Filter Report based on Selection from Form
  • From: Su
• Re: extract only hour and minutes from date and time field
  • From: fredg
• Re: How to delete a few characters in a field in Access
  • From: fredg
• Show Invoices Greater Than One Year
  • From: Lirva S via AccessMonster.com
• Re: How to delete a few characters in a field in Access
  • From: Rick B
• Re: SQL erases after the query is ran
  • From: OfficeDev18 via AccessMonster.com
• Union query and two Totals queries
  • From: Bill Fischer via AccessMonster.com
• Re: grouping items based on last three digits
  • From: fredg
• Re: "Like In" query operation...?
  • From: John Spencer
• Re: Name order streamlining
  • From: Stephanie
• Re: Count by month by group
  • From: argear
• grouping items based on last three digits
  • From: johnk
• Re: Group Table Data by Week
  • From: Timothy . Rybak
• Re: Group Table Data by Week
  • From: Timothy . Rybak
• Re: Group Table Data by Week
  • From: Timothy . Rybak
• Sort Query Results
  • From: vladimir . mcbadger
• Re: Truncate a result
  • From: Bob Miller
• Re: Merge data into database
  • From: Darhl Thomason
• How to query a list of values in a List Box?
  • From: PH
• Monthly Select
  • From: Peter Carlson
• Re: INSERT INTO VALIDATION RULE VIOLATION How to identify specific records?
  • From: [MVP] S.Clark
• Re: domain functions in report with parameter prompt
  • From: [MVP] S.Clark
• Consecutive days count as one event
  • From: Michael Mac
• Combining tables from two copies of DB
  • From: BruceM
• Re: Access shuts down, when i try to save this query
  • From: Gary Walter
• Re: DCount() criteria
  • From: John Spencer
• Re: Counting Text Entries In Query
  • From: John Spencer
• Re: SQL? Pulling only the FIRST OCCURRENCE of a set of duplicate reco
  • From: John Spencer
• Re: Truncate a result
  • From: Van T. Dinh
• Re: Time calc.
  • From: SteveS
• Re: Truncate a result
  • From: Warrio
• Re: Truncate a result
  • From: Warrio
• Re: Access shuts down, when i try to save this query
  • From: Dann
• Re: Filter on a form's recordsource
  • From: Warrio
• Re: Change Control Calculation to Query
  • From: Paddler
• Re: Combining Query Outputs
  • From: Vincent Johns
• Re: Like to see an example of a "runningsum" being used in a query
  • From: Vincent Johns
• Re: Multiple criteria in a query problem
  • From: Tom Ellison
• Re: Change Control Calculation to Query
  • From: Tom Ellison
• Re: AfterUpdate Code Help
  • From: Brian Bastl
• Re: AfterUpdate Code Help
  • From: Brian Bastl
• Re: Count only if condition matches
  • From: Ken Snell \(MVP\)
• Multiple criteria in a query problem
  • From: Erynn013
• Re: Queries are driving me nuts!
  • From: Frogfreak55
• Re: AfterUpdate Code Help
  • From: BardsSweetie
• Re: AfterUpdate Code Help
  • From: Brian Bastl
• Re: query records by numbers column with blank records showing last
  • From: John Spencer
• Re: Field Formats
  • From: John Spencer
• Re: query records by numbers column with blank records showing last
  • From: Marshall Barton
• Re: Error 6 Overflow
  • From: Douglas J. Steele
• Re: AfterUpdate Code Help
  • From: Brian Bastl
• Re: AfterUpdate Code Help
  • From: Brian Bastl
• Re: Queries are driving me nuts!
  • From: Duane Hookom
• Re: What is the query distributors definition
  • From: Duane Hookom
• Re: Field Formats
  • From: Lucy
• Re: Field Formats
  • From: Lucy
• Re: Queries are driving me nuts!
  • From: Frogfreak55
• Re: Count only if condition matches
  • From: Peter Carlson
• Re: Count only if condition matches
  • From: John Spencer
• Re: Count only if condition matches
  • From: Ken Snell \(MVP\)
• Count only if condition matches
  • From: Peter Carlson
• Re: Queries are driving me nuts!
  • From: Duane Hookom
• Re: Filter on a form's recordsource
  • From: Marshall Barton
• Re: query with datetime values
  • From: John Spencer
• Re: Error 6 Overflow
  • From: Frankie via AccessMonster.com
• Filter on a form's recordsource
  • From: Warrio
• Re: AfterUpdate Code Help
  • From: Brian Bastl
• Re: Queries are driving me nuts!
  • From: Frogfreak55
• RE: Run DOS Prompt
  • From: Ofer
• RE: Multiple Queries Merged
  • From: Rod
• Re: Error 6 Overflow
  • From: Frankie via AccessMonster.com
• Re: Error 6 Overflow
  • From: RoyVidar
• Re: Error 6 Overflow
  • From: Frankie via AccessMonster.com
• RE: Multiple Queries Merged
  • From: Ofer
• RE: Multiple Queries Merged
  • From: Rod
• Re: Queries are driving me nuts!
  • From: Duane Hookom
• AfterUpdate Code Help
  • From: BardsSweetie
• Problem trying to do an update query in VBA
  • From: Chuck Arbogast
• Re: Name order streamlining
  • From: Tom Ellison
• Re: Query
  • From: MGFoster
• Re: Expr 1001 in Field List
  • From: JamesJ
• Re: Expr 1001 in Field List
  • From: RoyVidar
• Expr 1001 in Field List
  • From: JamesJ
• Re: query with datetime values
  • From: sewkar
• Re: query with datetime values
  • From: sewkar
• RE: Run a query or report with calculations in it?
  • From: George King
• Re: Find the 3 largest entry's per customer
  • From: John Spencer
• Re: is it possible to update this
  • From: John Spencer
• RE: is it possible to update this
  • From: Ofer
• Re: is it possible to update this
  • From: Douglas J. Steele
• RE: is it possible to update this
  • From: Ofer
• Run a query or report with calculations in it?
  • From: CherylDetrick
• RE: if in a query
  • From: Jerry Whittle
• if in a query
  • From: St@cy
• Re: Find the 3 largest entry's per customer
  • From: Mads L
• Re: Find the 3 largest entry's per customer
  • From: Mads L
• Re: Count, Group By Q
  • From: KAnoe
• Re: Count, Group By Q
  • From: KAnoe
• Re: Count, Group By Q
  • From: John Spencer
• Re: Count, Group By Q
  • From: Marshall Barton
• Re: Find the 3 largest entry's per customer
  • From: John Spencer
• Query
  • From: Ralph
• Re: Get SQL of query and any it's based on
  • From: John Spencer
• RE: 2 ID's 1 Name
  • From: Jerry Whittle
• Count, Group By Q
  • From: KAnoe
• Re: Need Help Assigning File Name
  • From: Stryker22150
• Find the 3 largest entry's per customer
  • From: Mads L
• Re: Joining data from 6 tables so I can produce a report.
  • From: Jeff Boyce
• Joining data from 6 tables so I can produce a report.
  • From: Adam Armstrong
• Re: Access shuts down, when i try to save this query
  • From: Gary Walter
• Re: Error 6 Overflow
  • From: RoyVidar
• Re: Error 6 Overflow
  • From: Frankie via AccessMonster.com
• Re: Error 6 Overflow
  • From: RoyVidar
• Error 6 Overflow
  • From: Frankie via AccessMonster.com
• Re: Count by month by group
  • From: Allen Browne
• Re: Get SQL of query and any it's based on
  • From: LarryJ
• Re: Dear Microsoft: re: Error 3090...
  • From: Duane Hookom
• Re: Get SQL of query and any it's based on
  • From: Duane Hookom
• How do I combine these queries?
  • From: BardsSweetie
• Re: Merge data into database
  • From: Darhl Thomason
• Re: Need help with BETWEEN/AND Parameters
  • From: Allen Browne
• Get SQL of query and any it's based on
  • From: LarryJ
• Re: SQL gets erased/deleted when ran from a form
  • From: John Vinson
• Re: Dear Microsoft: re: Error 3090...
  • From: John Vinson
• RE: 2 ID's 1 Name
  • From: KARL DEWEY
• Re: help with query design
  • From: Duane Hookom
• RE: 2 ID's 1 Product Name
  • From: Brad
• RE: 2 ID's 1 Product Name
  • From: Brad
• RE: 2 ID's 1 Product Name
  • From: Brad
• RE: 2 ID's 1 Product Name
  • From: Brad
• 2 ID's 1 Product Name
  • From: Brad
• 2 ID's 1 Name
  • From: Brad
• SQL gets erased/deleted when ran from a form
  • From: WannaChevy03
• Re: NESTED JOINS
  • From: Rick
• Re: Pivot Table Strangeness
  • From: Craig M . Bobchin
• Re: NESTED JOINS
  • From: Amy Blankenship
• Re: Pivot Table Strangeness
  • From: MGFoster
• Re: Pivot Table Strangeness
  • From: Douglas J. Steele
• Pivot Table Strangeness
  • From: Craig M . Bobchin
• RE: SQL? Pulling only the FIRST OCCURRENCE of a set of duplicate reco
  • From: Carol
• Re: Append new records
  • From: John Spencer
• Re: help with query design
  • From: franky
• Re: Prompt Query Error
  • From: MGFoster
• Re: Append new records
  • From: D
• Re: Append new records
  • From: D
• SQL? Pulling only the FIRST OCCURRENCE of a set of duplicate reco
  • From: Carol
• Re: Append new records
  • From: John Spencer
• Re: Append new records
  • From: Lynn Trapp
• Re: Append new records
  • From: Rick B
• Re: Append new records
  • From: D
• Re: Append new records
  • From: Lynn Trapp
• Re: Append new records
  • From: Rick B
• Append new records
  • From: D
• Re: Merge data into database
  • From: Jeff Boyce
• Prompt Query Error
  • From: bthiessen
• Re: Dear Microsoft: re: Error 3090...
  • From: Duane Hookom
• Re: help with query design
  • From: Duane Hookom
• INSERT INTO VALIDATION RULE VIOLATION How to identify specific records?
  • From: user
• Re: Name order streamlining
  • From: Stephanie
• Re: Access shuts down, when i try to save this query
  • From: Mark Burns
• Re: Year Only as Query Parameter
  • From: Kathy Webster
• Re: NESTED JOINS
  • From: Amy Blankenship
• Re: split a field in two
  • From: fredg
• Re: Formula will not work
  • From: Tom Ellison
• Re: Search or Find
  • From: joni
• Re: Odd result with Min of Date Range
  • From: John Spencer
• Re: Access shuts down, when i try to save this query
  • From: Mark Burns
• Re: Odd result with Min of Date Range
  • From: OfficeDev18 via AccessMonster.com
• Re: Delete Query
  • From: OfficeDev18 via AccessMonster.com
• Re: MAX Function problem
  • From: John Spencer
• Re: Help please with Update Query
  • From: OfficeDev18 via AccessMonster.com
• Re: Need help with BETWEEN/AND Parameters
  • From: Allen Browne
• Re: query with datetime values
  • From: John Spencer
• Re: Need help with BETWEEN/AND Parameters
  • From: John Spencer
• Re: Dear Microsoft: re: Error 3090...
  • From: BruceM
• Re: Problem with LIKE operator
  • From: James Houston
• Re: Search or Find
  • From: Michel Walsh
• Re: search for a (any) word in a memo field of a record
  • From: rigby
• Re: DATE SERIAL
  • From: Akrt48
• Delete Query
  • From: Bart Bailey
• Re: CREATE PROCEDURE
  • From: Gary Walter
• Re: search for a (any) word in a memo field of a record
  • From: John Spencer
• Re: Projected Business Days
  • From: Bob Miller
• Re: Need help with BETWEEN/AND Parameters
  • From: John Spencer
• query with datetime values
  • From: MobielPlezier.com --> Fun with your mobile
• Re: Access shuts down, when i try to save this query
  • From: Gary Walter
• Re: Formula will not work
  • From: Lincoln Beachy
• Re: CREATE PROCEDURE
  • From: [MVP] S.Clark
• Re: Need Help Assigning File Name
  • From: [MVP] S.Clark
• Re: Access Cross-tab query should allow fields variable in sub-queries
  • From: [MVP] S.Clark
• Re: acExportDelim +Saving File Name
  • From: [MVP] S.Clark
• Re: How can I add the XML Values in an Access field
  • From: [MVP] S.Clark
• Re: Need help with BETWEEN/AND Parameters
  • From: BardsSweetie
• Re: Finding the 70th percentile
  • From: Tom Ellison
• Re: Formula will not work
  • From: Tom Ellison
• Re: search for a (any) word in a memo field of a record
  • From: John Spencer
• Re: Access shuts down, when i try to save this query
  • From: Dann
• Re: Return exact term only
  • From: John Spencer
• Re: Use count function to ignore duplicate entries and create new vari
  • From: John Spencer
• Re: Problem with LIKE operator
  • From: John Spencer
• Re: Access shuts down, when i try to save this query
  • From: Allen Browne
• Re: query unique count for field
  • From: Lancslad
• Need Help Assigning File Name
  • From: Stryker22150
• Re: Formula will not work
  • From: Lincoln Beachy
• Re: Finding the 70th percentile
  • From: Basil
• Re: How do I use access queries to select records which appears 3 time
  • From: Tom Ellison
• Re: Re-attack
  • From: red skelton via AccessMonster.com
• Re: Name order streamlining
  • From: Tom Ellison
• Re: Need help with BETWEEN/AND Parameters
  • From: Allen Browne
• Re: Complex issue with queries
  • From: david
• Re: Formula will not work
  • From: Tom Ellison
• Complex issue with queries
  • From: mav100
• Re: Using a fieldname as parameter value
  • From: Jeff Boyce
• Assign File Name Based on Parameter Value
  • From: Stryker22150
• Re: DATE SERIAL
  • From: Allen Browne
• Re: Query input must contain at least one table or query
  • From: robboll
• Re: Help please with Update Query
  • From: jwr
• Re: date Field
  • From: Rick Brandt
• Re: set criteria for several fields
  • From: Rick Brandt
• acExportDelim +Saving File Name
  • From: Stryker22150
• Re: Merge data into database
  • From: Darhl Thomason
• Re: update query random number
  • From: Vincent Johns
• Re: Query Does not return all matching results **49
  • From: Douglas J. Steele
• Re: Query input must contain at least one table or query
  • From: John Vinson
• Re: Group Table Data by Week
  • From: Duane Hookom
• Re: Query input must contain at least one table or query
  • From: MGFoster
• Re: SUM DATE into months
  • From: MGFoster
• Query input must contain at least one table or query
  • From: robboll
• Re: Problem with LIKE operator
  • From: MGFoster
• Re: Compress query display
  • From: Michel Walsh
• Re: Creating a query from multiple identical tables
  • From: Michel Walsh
• Re: Creating a query from multiple identical tables
  • From: Rick B
• Re: Formula will not work
  • From: Lincoln Beachy
• Re: Problem with LIKE operator
  • From: John Nurick
• Re: Field Formats
  • From: John Nurick
• Re: Use count function to ignore duplicate entries and create new vari
  • From: dhurwyn
• Re: Search or Find
  • From: Michel Walsh
• Re: Problem with LIKE operator
  • From: Michel Walsh
• Re: Query always pulls ALL fields from tables
  • From: Michel Walsh
• Re: Field Formats
  • From: John Spencer
• Re: Frustrating Error: "Data type mismatch" with Subquery
  • From: John Spencer
• Re: Problem with LIKE operator
  • From: John Spencer
• Re: Field Formats
  • From: John Spencer
• Re: Projected Business Days
  • From: Michel Walsh
• Re: SELECT TOP N - Can N be variable?
  • From: Michel Walsh
• Re: datediff
  • From: Brent
• Re: Re-attack
  • From: Michel Walsh
• Re: Looping through Parameter Query
  • From: Michel Walsh
• Problem with LIKE operator
  • From: James Houston
• Re: name field
  • From: jb ellis
• Re: update query random number
  • From: Kenny G
• Re: update query random number
  • From: Kenny G
• before append test for existance.
  • From: dhurwyn
• Re: Consolidating field values
  • From: John Spencer
• Re: nested If
  • From: fredg
• Re: Consolidating field values
  • From: Marshall Barton
• Re: name field
  • From: John Spencer
• Re: Consolidating field values
  • From: Duane Hookom
• Re: Date Field problem
  • From: John Spencer
• Re: nested If
  • From: OfficeDev18 via AccessMonster.com
• Re: nested If
  • From: Duane Hookom
• Re: set criteria for several fields
  • From: Pat
• Re: Group Table Data by Week
  • From: Timothy . Rybak
• Re: Help please with Update Query
  • From: OfficeDev18 via AccessMonster.com
• Re: set criteria for several fields
  • From: Rick B
• Re: set criteria for several fields
  • From: Rick B
• Re: Date Field problem
  • From: Lucien
• Re: Count by month by group
  • From: Allen Browne
• Re: set criteria for several fields
  • From: Pat
• Consolidating field values
  • From: StevieD via AccessMonster.com
• Re: Name order streamlining
  • From: Stephanie
• Re: set criteria for several fields
  • From: Rick B
• Re: Group Table Data by Week
  • From: Duane Hookom
• Re: Combine multiple rows into one record
  • From: Allen Browne
• Re: SELECT TOP N - Can N be variable?
  • From: Allen Browne
• Re: set criteria for several fields
  • From: Jeff Boyce
• Re: set criteria for several fields
  • From: Rick B
• Re: Combine multiple rows into one record
  • From: Joe
• Re: name field
  • From: jb ellis
• Projected Business Days
  • From: umm_ism
• Re: Combine multiple rows into one record
  • From: Allen Browne
• Re: Group Table Data by Week
  • From: Timothy . Rybak
• Re: Group Table Data by Week
  • From: Timothy . Rybak
• Re: Combine multiple rows into one record
  • From: Joe
• Re: Combine multiple rows into one record
  • From: Joe
• Re: Combine multiple rows into one record
  • From: Joe
• Re: Combine multiple rows into one record
  • From: Allen Browne
• Re: Combine multiple rows into one record
  • From: Joe
• Re: running total issue
  • From: Allen Browne
• Re: Combine multiple rows into one record
  • From: Allen Browne
• Re: Combine multiple rows into one record
  • From: John Spencer
• Re: Re-attack
  • From: red skelton via AccessMonster.com
• Re: Access Query Expression - Extremely Urgent!!!
  • From: Keith
• Combine multiple rows into one record
  • From: Joe
• Re: update query random number
  • From: Vincent Johns
• Re: update query random number
  • From: Vincent Johns
• Re: Re-attack
  • From: Tom Ellison
• Re-attack
  • From: red skelton via AccessMonster.com
• Re: update query random number
  • From: david
• Re: I changed from Windows 2000 to XP. Keyboard repeat will not work.
  • From: Vincent Johns
• Re: ENTER MULTIPLE Items in a Query Pop-Up PROMPT e.g. [Name:]
  • From: Duane Hookom
• Re: Crosstab query on the fly
  • From: Duane Hookom
• Re: Group Table Data by Week
  • From: Duane Hookom
• Re: CrossTab Query with 2 values per month
  • From: LarryJ
• Re: CrossTab Query with 2 values per month
  • From: Tom Ellison
• Re: CrossTab Query with 2 values per month
  • From: Allen Browne
• CrossTab Query with 2 values per month
  • From: LarryJ
• Re: Truncated memo fields from queries within queries
  • From: Allen Browne
• Re: Need help in Monthly Query Showing Months Name in Columns
  • From: Allen Browne
• Re: DATE SERIAL
  • From: Allen Browne
• Re: Formula will not work
  • From: Tom Ellison
• Re: Formula will not work
  • From: Lincoln Beachy
• Group Table Data by Week
  • From: Timothy . Rybak
• Re: How to use NETWORKDAYS in MS Access
  • From: Douglas J. Steele
• Re: Year Only as Query Parameter
  • From: fredg
• Re: Year Only as Query Parameter
  • From: MGFoster
• Re: name field
  • From: MGFoster
• Year Only as Query Parameter
  • From: Kathy Webster
• Re: Date Field problem
  • From: John Spencer
• Re: Query too complex? Access 2003
  • From: Vincent Johns
• Re: Formula will not work
  • From: Tom Ellison
• Re: Help please with Update Query
  • From: jwr
• Re: Merge data into database
  • From: Jeff Boyce
• Re: Parameter Query Using a Date Field
  • From: Jeff Boyce
• Re: Concantenating 1 field to produce list of email addresses
  • From: Brian Bastl
• Merge data into database
  • From: Darhl Thomason
• Re: Date Field problem
  • From: Lucien
• Re: Query Drop Down
  • From: John Vinson
• Re: Criteria
  • From: John Vinson
• RE: Need to apply an IF statement to a sined field
  • From: Ofer
• Re: Looping through Parameter Query
  • From: John Vinson
• Re: Help - Mental block - can't get this query right
  • From: John Vinson
• Re: Query Drop Down
  • From: MGFoster
• Re: Date Field problem
  • From: John Spencer
• Re: DateAdd Function
  • From: John Vinson
• Re: name field
  • From: MGFoster
• Re: Totals Queries
  • From: John Vinson
• Re: Access Query Expression - Extremely Urgent!!!
  • From: MGFoster
• Re: Make Table Query
  • From: John Vinson
• Re: Date Field problem
  • From: Lucien
• Re: Access Query Expression - Extremely Urgent!!!
  • From: John Spencer
• Re: Date Field problem
  • From: John Spencer
• Re: Create autonumber in a query
  • From: MGFoster
• Crosstab query on the fly
  • From: cquinn
• Re: Pass-Through Query w/o Record Locking
  • From: Chrisf
• Re: Create autonumber in a query
  • From: Michel Walsh
• Re: Looping through Parameter Query
  • From: Michel Walsh
• Re: DateAdd Function
  • From: RTimberlake
• Re: Formula will not work
  • From: Lincoln Beachy
• Re: Count Unique Fields Only
  • From: Michel Walsh
• Re: Using the Small Function from Excel in Access 2002
  • From: LeAnne
• Re: Make Table Query
  • From: AllenKarns
• Make Table Query
  • From: AllenKarns
• Re: Runtime error 3021
  • From: Redsoxnation
• Re: help woith syntax..
  • From: John Vinson
• Re: DateAdd Function
  • From: John Vinson
• Re: UpdateQuery only on the record specified by a form
  • From: BT
• Re: using ms access to convert ms access & sql server date time to unix time stamp
  • From: John Spencer
• Re: help woith syntax..
  • From: John Spencer
• Access Query Expression - Extremely Urgent!!!
  • From: Keith
• Count Unique Fields Only
  • From: Joe
• Re: UpdateQuery only on the record specified by a form
  • From: Keith Leslein
• Re: using ms access to convert ms access & sql server date time to unix time stamp
  • From: jjj0923
• Re: Date Field problem
  • From: John Vinson
• UpdateQuery only on the record specified by a form
  • From: BT
• UpdateQuery only on the record specified by a form
  • From: BT
• Re: Totals Queries
  • From: John Vinson
• Re: Create Field Names based on values in another field
  • From: John Vinson
• Re: Query too complex? Access 2003
  • From: John Vinson
• Re: Truncated memo fields from queries within queries
  • From: Richard Reinertson
• Re: ENTER MULTIPLE Items in a Query Pop-Up PROMPT e.g. [Name:]
  • From: kev100 via AccessMonster.com
• Create autonumber in a query
  • From: Esperanza
• Re: using ms access to convert ms access & sql server date time to unix time stamp
  • From: Marshall Barton
• Re: Need help in Monthly Query Showing Months Name in Columns
  • From: FA
• Re: Need help in Monthly Query Showing Months Name in Columns
  • From: Allen Browne
• using ms access to convert ms access & sql server date time to unix time stamp
  • From: jjj0923
• Re: Need help in Monthly Query Showing Months Name in Columns
  • From: FA
• Re: DATE SERIAL
  • From: Allen Browne
• Re: Combining variable number of fields
  • From: Allen Browne
• Re: datediff
  • From: Brent
• Re: Runtime error 3021
  • From: Allen Browne
• Re: Need help in Monthly Query Showing Months Name in Columns
  • From: Allen Browne
• Re: Need help in Monthly Query Showing Months Name in Columns
  • From: Rick Brandt
• Re: Create Field Names based on values in another field
  • From: Allen Browne
• Re: Create Field Names based on values in another field
  • From: Dane Cooper
• Re: Query too complex? Access 2003
  • From: John Vinson
• Re: Create Field Names based on values in another field
  • From: Dane Cooper
• Re: Create Field Names based on values in another field
  • From: John Vinson
• Need help in Monthly Query Showing Months Name in Columns
  • From: FA
• Re: Runtime error 3021
  • From: Redsoxnation
• Re: Birth Month Query
  • From: Rick B
• Re: what templent can be used for menu making
  • From: Rick B
• Re: Totals Queries
  • From: OfficeDev18 via AccessMonster.com
• Re: Help please with Update Query
  • From: OfficeDev18 via AccessMonster.com
• RE: Need to apply an IF statement to a sined field
  • From: dbguy11
• Re: Query too complex? Access 2003
  • From: Paul (ESI)
• Re: Create Field Names based on values in another field
  • From: Allen Browne
• Re: Dates driving me to drink.
  • From: NC_Sue
• Re: Dates driving me to drink.
  • From: NC_Sue
• Re: Create Field Names based on values in another field
  • From: Rick B
• Re: Runtime error 3021
  • From: Allen Browne
• Re: Dates driving me to drink.
  • From: NC_Sue
• Create Field Names based on values in another field
  • From: Dane Cooper
• Re: Dates driving me to drink.
  • From: Jerry Whittle
• Re: A query from two queries
  • From: John Spencer
• Re: How to create an append query that appends to more than one table?
  • From: Bob Miller
• Re: Dates driving me to drink.
  • From: Rick B
• Re: Runtime error 3021
  • From: Redsoxnation
• Re: ERROR TRAP IN VBA
  • From: Michel Walsh
• Re: How to create an append query that appends to more than one ta
  • From: Allen Browne
• RE: Why doesn't my query omit criteria not asked for?
  • From: todd
• Re: Runtime error 3021
  • From: Allen Browne
• Re: Dates driving me to drink.
  • From: NC_Sue
• Re: Runtime error 3021
  • From: Redsoxnation
• Re: Like operator with accented character
  • From: Michel Walsh
• Re: downsize a chart in Excel
  • From: Rick B
• Re: Dates driving me to drink.
  • From: Rick B
• Re: Dates driving me to drink.
  • From: BruceM
• Re: Dates driving me to drink.
  • From: Rick B
• Re: How to create an append query that appends to more than one table?
  • From: LeAnne
• Re: Why doesn't my query omit criteria not asked for?
  • From: LeAnne
• Re: How to create an append query that appends to more than one table?
  • From: Allen Browne
• Re: Number sequencing
  • From: LeAnne
• Re: A query from two queries
  • From: John Spencer
• Re: Selecting correct records for parameter update query
  • From: Tracey
• Re: Time calc.
  • From: Dan @BCBS
• Re: How to include "/"
  • From: Wind54Surfer
• Re: Combining records from two queries
  • From: JohnB
• Re: How to include "/"
  • From: John Spencer
• Re: Formula will not work
  • From: John Spencer
• Re: create a query that will pull data from last week information
  • From: John Spencer
• Re: Combining records from two queries
  • From: Vincent Johns
• Re: criteria to pull alpha info. only?
  • From: Vincent Johns
• Re: using a field from a querry in some VBA code on a form
  • From: FatMan
• Re: Form based on query crashes
  • From: lmv
• Re: Combining records from two queries
  • From: JohnB
• Re: Combining records from two queries
  • From: JohnB
• Re: How to use NETWORKDAYS in MS Access
  • From: Vincent Johns
• Re: Combining records from two queries
  • From: Vincent Johns
• Re: Combining records from two queries
  • From: JohnB
• Re: Combining records from two queries
  • From: Vincent Johns
• Re: advanced query
  • From: Vincent Johns
• Re: Time calc.
  • From: SteveS
• Re: Combining records from two queries
  • From: JohnB
• Re: How to include "/"
  • From: Van T. Dinh
• Re: Add Num of Appointments for Week
  • From: Vincent Johns
• Re: Why is my query acting like this
  • From: Vincent Johns
• Re: insert/append query in vba..
  • From: Tom Ellison
• Re: Number sequencing
  • From: Tom Ellison
• Re: Reference a text box in a parameter query
  • From: Shaun Beane
• Re: Form based on query crashes
  • From: Jerry Whittle
• Re: Form based on query crashes
  • From: Duane Hookom
• Re: Runtime error 3021
  • From: Allen Browne
• RE: Form based on query crashes
  • From: lmv
• Re: Formula will not work
  • From: Tom Ellison
• Re: Formula will not work
  • From: Lincoln Beachy
• RE: Form based on query crashes
  • From: Jerry Whittle
• Re: Help please with Update Query
  • From: jwr
• Re: Formula will not work
  • From: Tom Ellison
• Re: Truncated memo fields from queries within queries
  • From: Allen Browne
• Re: using a field from a querry in some VBA code on a form
  • From: Allen Browne
• Re: Default values in queries
  • From: Allen Browne
• Formula will not work
  • From: Lincoln Beachy
• Re: create a query that will pull data from last week information only
  • From: John Vinson
• Re: Query too complex? Access 2003
  • From: Vincent Johns
• Re: Formula not working in a Query
  • From: Duane Hookom
• Re: multiple queries in Access 2003 Reports
  • From: tina
• Re: Sort Problem
  • From: Douglas J. Steele
• Re: Formula not working in a Query
  • From: Lincoln Beachy
• Re: Calculate 7 day high lows
  • From: Kelley
• Sort Problem
  • From: Michael
• Re: Formula not working in a Query
  • From: Duane Hookom
• Re: Quick Question - Query Help
  • From: Marshall Barton
• Re: DATE DIF EXPRESSION
  • From: MGFoster
• Re: Formula not working in a Query
  • From: Lincoln Beachy
• Re: Query returning a blank result?
  • From: Duane Hookom
• Re: DATE DIF EXPRESSION
  • From: Duane Hookom
• Re: Sum by group
  • From: Duane Hookom
• Re: Date Format
  • From: Marshall Barton
• Re: datediff
  • From: OfficeDev18 via AccessMonster.com
• Re: Query using both aggregate sum and count
  • From: MGFoster
• Re: Seconds as DD:HH:MM:SS
  • From: OfficeDev18 via AccessMonster.com
• Re: datediff
  • From: Brent
• Re: datediff
  • From: MGFoster
• Re: datediff
  • From: OfficeDev18 via AccessMonster.com
• Re: Selecting correct records for parameter update query
  • From: MGFoster
• Re: Date calculation
  • From: OfficeDev18 via AccessMonster.com
• Re: Multiple Totals in one Query
  • From: MGFoster
• Re: Name order streamlining
  • From: Tom Ellison
• Re: ERROR TRAP IN VBA
  • From: George Nicholson
• Re: MS Access 2003 CrossTab Query Question using VBA--Item not fou
  • From: MGFoster
• Query using both aggregate sum and count
  • From: dlawner
• Re: Like operator with accented character
  • From: John Nurick
• datediff
  • From: Brent
• RE: Need top record for each contract
  • From: KARL DEWEY
• Re: Printing Blank instead of Zero or 0
  • From: FA
• Printing Blank instead of Zero or 0
  • From: FA
• Re: Combining records from two queries
  • From: John Vinson
• Re: Update Query
  • From: John Vinson
• Re: DDE Link to chart in excel
  • From: LeAnne
• RE: Form based on query crashes
  • From: lmv
• Re: Show remaining balance in same query
  • From: annysjunkmail
• Re: Append data queries
  • From: tina
• Re: Show remaining balance in same query
  • From: annysjunkmail
• Re: multiple queries in Access 2003 Reports
  • From: tina
• Re: Calculate 7 day high lows
  • From: John Spencer
• Re: Why can't I copy/paste criteria into parameter query box?
  • From: tina
• Re: Update Query
  • From: John Spencer
• Re: Cross-tab Criteria not evaluating
  • From: Juan Schwartz
• Re: Union ALL with Count
  • From: Juan Schwartz
• Re: Name order streamlining
  • From: Stephanie
• Re: non table values
  • From: John Vinson
• Re: Matching data
  • From: John Vinson
• Re: Update Query
  • From: John Vinson
• Re: I am a Information Management student
  • From: Rick B
• Re: ERROR TRAP IN VBA
  • From: Mike S. S.
• Re: Calculate 7 day high lows
  • From: Kelley
• Re: Update Query
  • From: Michel Walsh
• Re: Default values in queries
  • From: George Nicholson
• Re: Help please with Update Query
  • From: OfficeDev18 via AccessMonster.com
• Re: Using a new table with old query
  • From: LeAnne
• Re: ERROR TRAP IN VBA
  • From: Mike S. S.
• Re: Date calculation
  • From: OfficeDev18 via AccessMonster.com
• Re: ERROR TRAP IN VBA
  • From: George Nicholson
• Re: Holding a query date
  • From: Rick B
• Re: Update query to populate a column
  • From: John Spencer
• Re: Query returning a blank result?
  • From: Rashar S via AccessMonster.com
• Re: Access and Word Merge
  • From: DSmith
• Re: Quick Question - Query Help
  • From: Marshall Barton
• Re: Date Format
  • From: Marshall Barton
• Re: Update query to populate a column
  • From: Byteguy
• Re: Sum by group
  • From: Duane Hookom
• Re: Crosstab query problem.
  • From: Duane Hookom
• Re: MS Access 2003 CrossTab Query Question using VBA--Item not fou
  • From: Mike S. S.
• Re: Query returning a blank result?
  • From: Duane Hookom
• Re: Truncated memo fields from queries within queries
  • From: Richard Reinertson
• Re: Crosstab query problem.
  • From: Floyd Forbes
• Re: Joining two fields to make one
  • From: Rick B
• Re: Truncated memo fields from queries within queries
  • From: Allen Browne
• Re: Truncated memo fields from queries within queries
  • From: Richard Reinertson
• Re: Seconds as DD:HH:MM:SS
  • From: John Spencer
• Query returning a blank result?
  • From: Rashar S via AccessMonster.com
• Re: Create a query to calculate the # of work days excluding holidays
  • From: Allen Browne
• Re: Truncated memo fields from queries within queries
  • From: Allen Browne
• Re: Truncated memo fields from queries within queries
  • From: Richard Reinertson
• Re: Is Null and Is Not Null for criteria
  • From: Jeff Boyce
• Re: Default values in queries
  • From: Jeff Boyce
• Re: Default values in queries
  • From: Allen Browne
• Re: Query too complex? Access 2003
  • From: Paul (ESI)
• Re: using a field from a querry in some VBA code on a form
  • From: Allen Browne
• Re: MULTIPLE LOOKUPS
  • From: Jeff Boyce
• Re: Help with date query
  • From: John Spencer
• Re: query for a bank statement
  • From: Allen Browne
• Re: General question Acces Database Queries
  • From: Rick B
• Re: General question Acces Database Queries
  • From: Rick B
• Re: Like operator with accented character
  • From: John Spencer
• Re: Formula not working in a Query
  • From: Duane Hookom
• query for a bank statement
  • From: aa
• Re: UPDATE table1 SET truefalsefield = -1 where key = 500; Never updates!
  • From: suica
• Re: UPDATE table1 SET truefalsefield = -1 where key = 500; Never updates!
  • From: Allen Browne
• Re: Like operator with accented character
  • From: Michel Walsh
• UPDATE table1 SET truefalsefield = -1 where key = 500; Never updates!
  • From: suica
• Re: Formula not working in a Query
  • From: Lincoln Beachy
• Re: Like operator with accented character
  • From: John Nurick
• Re: Select the last version of a bill line
  • From: Tom Ellison
• Re: Calculating Overtime Problem Thank You!
  • From: `Tis Me
• Re: Select the last version of a bill line
  • From: Tom Ellison
• Re: ENTER MULTIPLE Items in a Query Pop-Up PROMPT e.g. [Name:]
  • From: Duane Hookom
• Re: Formula not working in a Query
  • From: Duane Hookom
• Re: UNION query hyperlink inactive. How do I make it active?
  • From: Allen Browne
• Re: Truncated memo fields from queries within queries
  • From: Allen Browne
• Re: Like operator with accented character
  • From: John
• Formula not working in a Query
  • From: Lincoln Beachy
• Re: limit records by 60 days
  • From: tina
• Re: Calculate 7 day high lows
  • From: MGFoster
• Re: limit records by 60 days
  • From: Bill Ciaburri
• Re: Calculate 7 day high lows
  • From: John Spencer
• Re: Sum in two Columns
  • From: Tom Ellison
• Re: Sum in two Columns
  • From: Jeff Boyce
• Re: MS Access 2003 CrossTab Query Question using VBA--Item not fou
  • From: MGFoster
• Calculate 7 day high lows
  • From: Kelley
• Re: MS Access 2003 CrossTab Query Question using VBA--Item not fou
  • From: Mike S. S.
• Re: ENTER MULTIPLE Items in a Query Pop-Up PROMPT e.g. [Name:]
  • From: kev100 via AccessMonster.com
• Re: ENTER MULTIPLE Items in a Query Pop-Up PROMPT e.g. [Name:]
  • From: kev100 via AccessMonster.com
• Re: Counting records with start date between two dates
  • From: MGFoster
• Re: Search in many fields at same time.
  • From: Duane Hookom
• Re: MS Access 2003 CrossTab Query Question using VBA--Item not fou
  • From: MGFoster
• Re: Help please with Update Query
  • From: jwr
• Re: Search in many fields at same time.
  • From: Wind54Surfer
• Re: First - Last
  • From: Michel Walsh
• Re: First - Last
  • From: John Nurick
• Re: Search in many fields at same time.
  • From: Duane Hookom
• Problem filtering Dates between Access and Excel
  • From: Lanstone
• Re: Crosstab query problem.
  • From: John Spencer
• advanced query
  • From: Ghena
• Re: Update query to populate a column
  • From: John Spencer
• Re: Using a new table with old query
  • From: Vincent Johns
• Re: between/and parameter help
  • From: Van T. Dinh
• Re: Update query to populate a column
  • From: Byteguy
• Re: Query too complex? Access 2003
  • From: Vincent Johns
• Re: Access: Need to separate a field. Steph Hanes to FName & LName
  • From: Tom Lake
• Re: Crosstab query problem.
  • From: Floyd Forbes
• Re: Many-to-Many relationship Query
  • From: Vincent Johns
• Re: Like operator with accented character
  • From: John Nurick
• Re: Crosstab query problem.
  • From: John Spencer
• Re: Crosstab query problem.
  • From: Floyd Forbes
• Re: Problem w/ Parameter in the Query's criteria
  • From: Michel Walsh
• Re: Update query to populate a column
  • From: Byteguy
• RE: Just want the top record
  • From: Bonnie
• Re: Help please with Update Query
  • From: OfficeDev18 via AccessMonster.com
• Re: MS Access 2003 CrossTab Query Question using VBA--Item not fou
  • From: Mike S. S.
• Re: How do I create a comparison query?
  • From: OfficeDev18 via AccessMonster.com
• Re: Calcuations in queries
  • From: John Spencer
• Re: How to approach complex query
  • From: Vincent Johns
• Re: non-equijoin using a subquery
  • From: Michel Walsh
• Re: Crosstab query problem.
  • From: John Spencer
• Re: Just want the top record
  • From: John Spencer
• Re: Crosstab query problem.
  • From: Duane Hookom
• Re: Calcuations in queries
  • From: Marshall Barton
• Re: query unique count for field
  • From: Michel Walsh
• Crosstab query problem.
  • From: Floyd Forbes
• Re: If then else statements in sql
  • From: Allen Browne
• Re: Many-to-Many relationship Query
  • From: Glenn Brown
• Re: How to approach complex query
  • From: Julia Boswell
• Help please with Update Query
  • From: jwr
• Re: How to approach complex query
  • From: Julia Boswell
• Re: Many-to-Many relationship Query
  • From: Amy Blankenship
• Re: Help with Query Checking 2 Fields
  • From: Jeff Boyce
• Re: How to approach complex query
  • From: Vincent Johns
• Re: How to approach complex query
  • From: Allen Browne
• Re: Many-to-Many relationship Query
  • From: Vincent Johns
• How to approach complex query
  • From: Julia Boswell
• Re: query unique count for field
  • From: Lancslad
• Re: help on query for a report
  • From: Vincent Johns
• Re: query unique count for field
  • From: Lancslad
• Re: Like operator with accented character
  • From: Tom Ellison
• Re: Like operator with accented character
  • From: John Nurick
• Re: Help please!
  • From: Tom Ellison
• Re: Help please!
  • From: Tom Ellison
• Re: Left, LTrim, or what
  • From: Randy Harris
• Re: Left, LTrim, or what
  • From: Allen Browne
• Re: Left, LTrim, or what
  • From: Duane Hookom
• Re: help on query for a report
  • From: Bart
• Re: Add to rows in the same table with query?
  • From: Monsignor JAV
• Re: Like operator with accented character
  • From: John
• Re: Show remaining balance in same query
  • From: Pat Hartman\(MVP\)
• Re: Like operator with accented character
  • From: Tom Ellison
• Re: functions in queries
  • From: david epsom dot com dot au
• Re: Like operator with accented character
  • From: John Vinson
• Re: create new expression?field? in a query based on two fields
  • From: Duane Hookom
• Re: Like operator with accented character
  • From: Tom Ellison
• Like operator with accented character
  • From: John
• Re: Combining two IIf expressions into one
  • From: Peter Lawton
• Re: Count No of orders for customer
  • From: mogens
• Re: Update query to populate a column
  • From: John Spencer
• Re: Query to replace unwanted characters
  • From: John Spencer
• Re: create new expression?field? in a query based on two fields
  • From: John Spencer
• Re: Combining two IIf expressions into one
  • From: John Spencer
• Re: Show remaining balance in same query
  • From: annysjunkmail
• Re: Help with Query Checking 2 Fields
  • From: Alan
• Re: Count No of orders for customer
  • From: John Nurick
• Re: Query to replace unwanted characters
  • From: Jeff Boyce
• Re: Calculation
  • From: Jeff Boyce
• Re: Help with Query Checking 2 Fields
  • From: Jeff Boyce
• Help with Query Checking 2 Fields
  • From: Alan
• Re: functions in queries
  • From: Douglas J. Steele
• Re: functions in queries
  • From: david
• Re: Error querying Access text fields if dash or minus sign in middle of text
  • From: david
• Re: Count No of orders for customer
  • From: mogens
• Re: Show remaining balance in same query
  • From: Tom Ellison
• Re: Show remaining balance in same query
  • From: annysjunkmail
• Re: Count No of orders for customer
  • From: John Nurick
• Re: Help with Date and Time Query
  • From: Duane Hookom
• Re: Help with Date and Time Query
  • From: John Vinson
• Re: Troublesome query
  • From: John Vinson
• Re: non-equijoin using a subquery
  • From: Tom Ellison
• Re: How to add a new field to a Make Table query?
  • From: Allen Browne
• Re: Update query to populate a column
  • From: Byteguy
• Re: Troublesome query
  • From: John Vinson
• RE: Troublesome query
  • From: RWhittet
• Query to replace unwanted characters
  • From: John
• Re: MS Access 2003 CrossTab Query Question using VBA--Item not found i
  • From: Duane Hookom
• Troublesome query
  • From: RWhittet
• Re: create new expression?field? in a query based on two fields
  • From: John Vinson
• Re: Using exist/not exist in subquery
  • From: Damon Heron
• Re: Combining two IIf expressions into one
  • From: John Spencer
• Re: Combining two IIf expressions into one
  • From: Douglas J. Steele
• Re: Using exist/not exist in subquery
  • From: John Spencer
• Combining two IIf expressions into one
  • From: Peter Lawton
• Using exist/not exist in subquery
  • From: Damon Heron
• Re: Show remaining balance in same query
  • From: Pat Hartman\(MVP\)
• Count No of orders for customer
  • From: mogens
• Re: Show remaining balance in same query
  • From: Steve Schapel
• Re: Transfer spreadsheet, Main tbl and details tbl?
  • From: tina
• Show remaining balance in same query
  • From: annysjunkmail
• Re: Howto copy data from previous line and column if a field is blank
  • From: John Nurick
• Re: Transfer spreadsheet, Main tbl and details tbl?
  • From: Randy
• Re: Problems linking two number fields
  • From: mogens
• Re: percentage of total froma query
  • From: Marshall Barton
• Re: How to add a new field to a Make Table query?
  • From: tina
• Re: How to add a new field to a Make Table query?
  • From: Allen Browne
• Re: Transfer spreadsheet, Main tbl and details tbl?
  • From: tina
• Transfer spreadsheet, Main tbl and details tbl?
  • From: Randy
• Animals in China
  • From: d¨l
• Re: can't input into form
  • From: Rick Brandt
• Re: Problems linking two number fields
  • From: Jeff Boyce
• Re: Update query to populate a column
  • From: John Spencer
• Re: can't input into form
  • From: Allen Browne
• Re: Calculating Overtime Problem
  • From: Allen Browne
• Problems linking two number fields
  • From: mogens
• Calculating Overtime Problem
  • From: `Tis Me
• Re: non-equijoin using a subquery
  • From: John Vinson
• Re: Missing cents in the pivot table
  • From: Vincent Johns
• Re: Use crosstab column heading in a calculation
  • From: Vincent Johns
• Re: Update query to populate a column
  • From: Byteguy
• Re: Parameters removed - still get prompted for them
  • From: Allen Browne
• Re: IIf and Trim
  • From: Tom Lake
• Re: MS Access 2003 CrossTab Query Question using VBA--Item not fou
  • From: MGFoster
• Re: Age
  • From: MGFoster
• Re: Access03 Bug - parameters in Query grid
  • From: John Vinson
• Re: Age
  • From: John Vinson
• Re: Query is not updatable -
  • From: John Vinson
• Re: MS Access 2003 CrossTab Query Question using VBA--Item not found i
  • From: [MVP] S.Clark
• Re: clarify
  • From: [MVP] S.Clark
• Re: aumming query
  • From: [MVP] S.Clark
• Re: MS Access 2003 CrossTab Query Question using VBA--Item not found i
  • From: MGFoster
• Re: IIf and Trim
  • From: [MVP] S.Clark
• Re: aumming query
  • From: MGFoster
• Re: aumming query
  • From: MGFoster
• Re: Age
  • From: MGFoster
• Re: Need some help on this one: Combining two records into one
  • From: [MVP] S.Clark
• Re: Name order streamlining
  • From: Tom Ellison
• Re: How to remove duplicates from linked table query?
  • From: Penny
• Re: mutiple date filters - query
  • From: Paul
• Re: Using a function as criteria in a query
  • From: Duane Hookom
• Re: Split Field based on criteria
  • From: John Nurick
• Re: unique records with summed quantities
  • From: Olden
• Re: How does access parse the information in a query?
  • From: John Nurick
• Re: Error querying Access text fields if dash or minus sign in middle of text
  • From: John Nurick
• Re: Name order streamlining
  • From: Stephanie
• Re: Query is not updatable -
  • From: Douglas J. Steele
• Re: mutiple date filters - query
  • From: Douglas J. Steele
• Re: Multiple combo boxes - send parameters to a query?
  • From: Marshall Barton
• Re: Calculate time lapsed between two records
  • From: Tom Ellison
• Re: query a time text field
  • From: MGFoster
• Re: query a time text field
  • From: [MVP] S.Clark
• Re: Checkbook Register - Need Help
  • From: [MVP] S.Clark
• Re: Add to rows in the same table with query?
  • From: [MVP] S.Clark
• Re: multiple criteria in query using three tables
  • From: MGFoster
• Re: Split Field based on criteria
  • From: [MVP] S.Clark
• Re: Name order streamlining
  • From: Tom Ellison
• Re: 2 lines of data in 1 field
  • From: I''ve a feeling I''m not in Unix Anymore
• Re: What is best way to filter through multiple fields to get an answe
  • From: John Vinson
• Re: Use query name in Open recordset statement
  • From: [MVP] S.Clark
• Re: 2 lines of data in 1 field
  • From: John Spencer
• Re: How can you compress / group by on a crosstab query when column na
  • From: Dan V.
• Re: Update query to populate a column
  • From: John Spencer
• Re: Query is not updatable -
  • From: jleckrone
• Re: User input of a Where parameter,, how?
  • From: jleckrone
• Re: Name order streamlining
  • From: Stephanie
• Query is not updatable -
  • From: Doug Johnson via AccessMonster.com
• Re: Calculate time lapsed between two records
  • From: Zimme
• Re: Parameters
  • From: Keith Leslein
• Re: Parameters removed - still get prompted for them
  • From: Scott F via AccessMonster.com
• Re: Use crosstab column heading in a calculation
  • From: Bill R via AccessMonster.com
• Re: Update query to populate a column
  • From: Byteguy
• Re: Use crosstab column heading in a calculation
  • From: Vincent Johns
• Re: How do I create a comparison query?
  • From: OfficeDev18 via AccessMonster.com
• Re: non table values
  • From: Lynn Trapp
• Add to rows in the same table with query?
  • From: Monsignor JAV
• Re: Update query to populate a column
  • From: OfficeDev18 via AccessMonster.com
• Re: Use crosstab column heading in a calculation
  • From: Bill R via AccessMonster.com
• Re: Average Sales Query.
  • From: John Spencer
• Re: Parameters removed - still get prompted for them
  • From: Allen Browne
• Parameters removed - still get prompted for them
  • From: Scott F via AccessMonster.com
• How can you compress / group by on a crosstab query when column names are unknown
  • From: Dan V.
• Re: specifing dates in a report
  • From: Jen
• Re: How does access parse the information in a query?
  • From: Joanne
• RE: Re-posting problem with Cartesian product
  • From: '69 Camaro
• Re: Average Sales Query.
  • From: Chris M
• Re: Error querying Access text fields if dash or minus sign in middle of text
  • From: Dan V.
• Re: Calculating total hours
  • From: RJS76 via AccessMonster.com
• Re: Error querying Access text fields if dash or minus sign in middle of text
  • From: Dan V.
• Re: User Interface: Query
  • From: Allen Browne
• Re: Save a query with 33millions rows without invalid argument
  • From: Keith Leslein
• Re: Calculating total hours
  • From: RJS76 via AccessMonster.com
• Re: specifing dates in a report
  • From: Wayne Morgan
• Re: Calculating total hours
  • From: Allen Browne
• Re: StringDate >= Date -7
  • From: Rod
• Re: specifing dates in a report
  • From: Allen Browne
• Re: multiple criteria in query using three tables
  • From: trainbow2
• Re: Select Case in Query?
  • From: John Nurick
• Calculating total hours
  • From: RJS76 via AccessMonster.com
• Re: Average Sales Query.
  • From: John Spencer
• RE: Parameter value in query
  • From: Zurichoise
• Re: Access03 Bug - parameters in Query grid
  • From: Gary Walter
• Re: Access03 Bug - parameters in Query grid
  • From: Gary Walter
• RE: Parameter value in query
  • From: Ofer
• Re: Access03 Bug - parameters in Query grid
  • From: Van T. Dinh
• Re: Help with time difference query
  • From: red skelton via AccessMonster.com
• Re: query unique count for field
  • From: Michel Walsh
• Re: Prob... please Help.... KRISH
  • From: RobFMS
• RE: Parameter value in query
  • From: Zurichoise
• Re: Average Sales Query.
  • From: Chris M
• Re: Average Sales Query.
  • From: Chris M
• RE: Parameter value in query
  • From: Ofer
• Average Sales Query.
  • From: Chris M
• Re: Select Case in Query?
  • From: RoyVidar
• RE: Parameter value in query
  • From: Zurichoise
• Re: Select Case in Query?
  • From: Tom Lake
• Re: query unique count for field
  • From: Lancslad
• Re: How to group by and sort by a date
  • From: ianc
• Re: How to group by and sort by a date
  • From: ianc
• Re: How does access parse the information in a query?
  • From: John Nurick
• Execute Store Procedure
  • From: SF
• Re: Looking for a solution to my problem, amybe an IIf statement will
  • From: John Vinson
• Re: Update query to populate a column
  • From: Byteguy
• Re: Error querying Access text fields if dash or minus sign in middle of text
  • From: Allen Browne
• Re: multiple criteria in query using three tables
  • From: MGFoster
• Re: Use crosstab column heading in a calculation
  • From: Duane Hookom
• Re: StringDate >= Date -7
  • From: Duane Hookom
• Re: limit records by 60 days
  • From: tina
• Re: LEFT JOIN returns a single space instead of NULL
  • From: ifiaz
• limit records by 60 days
  • From: Bill Ciaburri
• Re: Name order streamlining
  • From: Tom Ellison
• Re: Cross tab query construction with Subqueries
  • From: Vincent Johns
• Re: MAKE-TABLE FROM UNION QUERY
  • From: Tom Ellison
• Re: LEFT JOIN returns a single space instead of NULL
  • From: Douglas J. Steele
• Re: functions in queries
  • From: Douglas J. Steele
• Re: MAKE-TABLR FROM UNION QUERY
  • From: [MVP] S.Clark
• Re: Query Chaos - Selecting Certain Field from Different Tables/Querie
  • From: [MVP] S.Clark
• Re: Is there a running sum function for queries, As there in reports
  • From: [MVP] S.Clark
• Re: Use query name in Open recordset statement
  • From: [MVP] S.Clark
• Re: Default values
  • From: Wayne Morgan
• Re: How does access parse the information in a query?
  • From: Joanne
• Re: Repeating records on a query
  • From: turtlewick
• Re: Access03 Bug - parameters in Query grid
  • From: Van T. Dinh
• Re: How does access parse the information in a query?
  • From: John Nurick
• Re: How to update this...
  • From: '69 Camaro
• Re: How to remove duplicates from linked table query?
  • From: Van T. Dinh
• Re: Error querying Access text fields if dash or minus sign in middle of text
  • From: John Nurick
• Re: What does "Alike" in the filter criteria mean?
  • From: MGFoster
• Re: help in calculation
  • From: sheela
• Re: Access03 Bug - parameters in Query grid
  • From: MGFoster
• Re: Why are there duplicates in my query results?
  • From: MGFoster
• Re: multiple criteria in query using three tables
  • From: MGFoster
• Re: UNION With If?
  • From: Tom Ellison
• Re: Mailing Labels: entire recepient list is not merged [Access]
  • From: John Vinson
• Re: UNION With If?
  • From: John Vinson
• RE: How to update this...
  • From: Bonnie
• Re: Quarter of Year
  • From: Hanksor
• Re: report totals
  • From: Marshall Barton
• Query help
  • From: Darryl
• Re: Search database for namee
  • From: Rick B
• Re: Ouerie Year(Now())-1 Or Year(Now())
  • From: theresa73
• Re: Merge different rows to same column in Access
  • From: Micky
• Re: Need to find only 12th Month or nothing
  • From: Tom Ellison
• Re: Search database for namee
  • From: Rick B
• Re: Merge different rows to same column in Access
  • From: Micky
• Re: Quarter of Year
  • From: RoyVidar
• Re: Quarter of Year
  • From: Tom Lake
• RE: How to update this...
  • From: '69 Camaro
• Quarter of Year
  • From: Hanksor
• Re: Error querying Access text fields if dash or minus sign in middle of text
  • From: Dan V.
• Re: How does access parse the information in a query?
  • From: John Nurick
• Re: How does access parse the information in a query?
  • From: Joanne
• Re: Error querying Access text fields if dash or minus sign in middle of text
  • From: Dan V.
• Re: Append Query
  • From: Tom Lake
• Re: Error querying Access text fields if dash or minus sign in middle of text
  • From: John Nurick
• Re: Finding the 70th percentile
  • From: Tom Ellison
• Re: Use crosstab column heading in a calculation
  • From: Bill R via AccessMonster.com
• Re: Multiple combo boxes - send parameters to a query?
  • From: John Spencer
• Re: How does access parse the information in a query?
  • From: John Spencer
• Re: Most Current Rev Only
  • From: Tom Ellison
• Re: Joining two fields from one table to one field in another table
  • From: Marshall Barton
• Re: Most Current Rev Only
  • From: Micky
• Re: Multiple combo boxes - send parameters to a query?
  • From: Marshall Barton
• Re: Merge different rows to same column in Access
  • From: Duane Hookom
• Re: getting all entries from main table and matching from another
  • From: John Spencer
• Merge different rows to same column in Access
  • From: Micky
• Re: Update query to populate a column
  • From: OfficeDev18 via AccessMonster.com
• Re: Need to do a comparison query based on a field with 13 or 12 chara
  • From: John Spencer
• Re: Help with time difference query
  • From: John Spencer
• Re: Querying by Primary Key SSN with Count
  • From: Wendy Lee
• Re: Error querying Access text fields if dash or minus sign in middle of text
  • From: Dan V.
• Re: Error querying Access text fields if dash or minus sign in middle of text
  • From: Dan V.
• Update query to populate a column
  • From: Byteguy
• Re: Querying by Primary Key SSN with Count
  • From: Wendy Lee
• Re: Search database for namee
  • From: Rick B
• Re: Concatenate multiple matches into single field?
  • From: Duane Hookom
• Re: Use crosstab column heading in a calculation
  • From: Duane Hookom
• Re: Agents and sub Agents in a query
  • From: Michel Walsh
• Re: Error querying Access text fields if dash or minus sign in middle of text
  • From: Dan V.
• Re: Error querying Access text fields if dash or minus sign in middle of text
  • From: Dan V.
• Re: new query, new problem
  • From: red skelton via AccessMonster.com
• Re: how do I print date picture was taken while printing picture
  • From: Rick B
• Re: new query, new problem
  • From: Allen Browne
• Re: LEFT JOIN returns a single space instead of NULL
  • From: ifiaz
• Re: query unique count for field
  • From: flc123
• Re: Concatenate multiple matches into single field?
  • From: Ann Scharpf via AccessMonster.com
• new query, new problem
  • From: red skelton via AccessMonster.com
• Re: how to drop and create a table using sql
  • From: Brendan Reynolds
• Re: query unique count for field
  • From: Lancslad
• Re: Finding data for the latest date
  • From: Allen Browne
• Re: combo boxes
  • From: Francis
• Re: combo boxes
  • From: Francis
• Re: Repeating records on a query
  • From: turtlewick
• Re: query unique count for field
  • From: Michel Walsh
• Use Zip Code long and lat to restrict sales area
  • From: Timothy . Rybak
• Re: query unique count for field
  • From: flc123
• Re: query unique count for field
  • From: John Spencer
• Re: Help with time difference query
  • From: red skelton via AccessMonster.com
• Re: Multiple Record Query
  • From: Christine Lisi
• Re: Parameter Date
  • From: John Spencer
• Re: Help with time difference query
  • From: John Spencer
• Re: Use crosstab column heading in a calculation
  • From: Bill R via AccessMonster.com
• Re: query unique count for field
  • From: John Spencer
• Re: Altering fields in a query
  • From: Mark Olsen
• Re: Joining two fields from one table to one field in another table
  • From: John Spencer
• Help with time difference query
  • From: red skelton via AccessMonster.com
• report totals
  • From: rkg
• Re: How to automate this...?
  • From: SteveS
• Re: Table or Query information
  • From: Mike
• Re: Columns to rows in a query
  • From: Mark Y via AccessMonster.com
• Re: undefined fucntion
  • From: James Minns
• Re: hard count in top values subquery
  • From: Marshall Barton
• Re: hard count in top values subquery
  • From: scrappydue
• Re: Moving annual total
  • From: Tom Ellison
• Re: hard count in top values subquery
  • From: Tom Ellison
• Re: hard count in top values subquery
  • From: scrappydue
• Re: hard count in top values subquery
  • From: scrappydue
• Re: How to return multiple columns from a single column table?
  • From: Mota
• Re: hard count in top values subquery
  • From: Tom Ellison
• Re: hard count in top values subquery
  • From: Marshall Barton
• Re: Joining two fields from one table to one field in another table
  • From: Alex Martinez
• Re: Joining two fields from one table to one field in another table
  • From: Alex Martinez
• Re: Joining two fields from one table to one field in another table
  • From: Marshall Barton
• Re: Joining two fields from one table to one field in another table
  • From: Allen Browne
• undefined fucntion
  • From: shank
• Re: How To Write Query
  • From: Allen Browne
• Joining two fields from one table to one field in another table
  • From: Alex Martinez
• Re: Use crosstab column heading in a calculation
  • From: Duane Hookom
• Re: How To Write Query
  • From: Allen Browne
• Re: How to return multiple columns from a single column table?
  • From: Allen Browne
• Re: Exporting Delimited Files
  • From: Stryker22150
• Re: Multiple Record Query
  • From: Tom Ellison
• Re: Exporting Delimited Files
  • From: Stryker22150
• Re: Error querying Access text fields if dash or minus sign in middle of text
  • From: Allen Browne
• How to return multiple columns from a single column table?
  • From: Mota
• Re: Ouerie Year(Now())-1 Or Year(Now())
  • From: James Minns
• Re: split names in into 2 fields in access
  • From: Douglas J. Steele
• Re: Can't group on memo error
  • From: Jeff Boyce
• Re: functions in queries
  • From: Douglas J. Steele
• Re: Exporting Delimited Files
  • From: Douglas J. Steele
• Re: Exporting Delimited Files
  • From: MGFoster
• Re: Variable from Exported Excel File
  • From: Douglas J. Steele
• Exporting Delimited Files
  • From: Stryker22150
• Re: Multiple Record Query
  • From: Christine Lisi
• Re: Multiple Record Query
  • From: Christine Lisi
• Re: Need Query to Delete top 100 records from the table
  • From: kevincar
• Re: Need Query to Delete top 100 records from the table
  • From: MGFoster
• Re: user-defined wildcard query
  • From: Marshall Barton
• Re: Variable from Exported Excel File
  • From: LJG
• Re: Adding data from one query to another query
  • From: Marshall Barton
• Re: Adding data from one query to another query
  • From: Tom Ellison
• Re: user-defined wildcard query
  • From: Tom Ellison
• Re: Columns to rows in a query
  • From: John Nurick
• Re: I need to transfer info from one table to another depending on one field
  • From: Tom Ellison
• Re: Multiple Record Query
  • From: Tom Ellison
• Re: Multiple Record Query
  • From: Christine Lisi
• unique records with summed quantities
  • From: Olden
• Re: Records not showing in query
  • From: Dan V.
• Re: unique records with summed quantities
  • From: Tom Ellison
• Error querying Access text fields if dash or minus sign in middle of text
  • From: Dan V.
• Re: Multiple Record Query
  • From: Tom Ellison
• Re: Multiple Record Query
  • From: Christine Lisi
• Re: Query to Count and copy records to new table
  • From: John Spencer
• Re: Multiple Record Query
  • From: Tom Ellison
• Re: Query to Count and copy records to new table
  • From: Tom Ellison
• Re: criteria characters
  • From: John Nurick
• Re: Use crosstab column heading in a calculation
  • From: Bill R via AccessMonster.com
• I need to transfer info from one table to another depending on one field
  • From: fstenoughsnoopy
• Re: Use crosstab column heading in a calculation
  • From: Duane Hookom
• Re: How to remove duplicates from linked table query?
  • From: Penny
• Re: How to fill out the empty space with 0 in CrossTab Queries?
  • From: Duane Hookom
• Re: How to fill out the empty space with 0 in CrossTab Queries?
  • From: fredg
• Need Query to Delete top 100 records from the table
  • From: May Q. via AccessMonster.com
• Re: Multiple Record Query
  • From: Christine Lisi
• Re: Multiple Record Query
  • From: Christine Lisi
• Re: Query help - modify SQL to get records
  • From: John Spencer
• Re: Query to Count and copy records to new table
  • From: May Q. via AccessMonster.com
• Re: Query to Count and copy records to new table
  • From: May Q. via AccessMonster.com
• Re: De Duplicate Query
  • From: John Spencer
• Re: Use crosstab column heading in a calculation
  • From: Bill R via AccessMonster.com
• Re: Query to Count and copy records to new table
  • From: May Q. via AccessMonster.com
• Re: Use crosstab column heading in a calculation
  • From: Duane Hookom
• Re: Query to Count and copy records to new table
  • From: Tom Ellison
• Re: Query to Count and copy records to new table
  • From: John Spencer
• Re: Multiple Record Query
  • From: Duane Hookom
• Re: Multiple Record Query
  • From: Tom Ellison
• Re: Altering fields in a query
  • From: John Spencer
• Re: Query to access column names...
  • From: John Spencer
• Re: Query to Count and copy records to new table
  • From: Tom Ellison
• Re: Query to Count and copy records to new table
  • From: May Q. via AccessMonster.com
• Re: Use crosstab column heading in a calculation
  • From: Bill R via AccessMonster.com
• RE: Access database crashes trying to save query
  • From: Jerry Whittle
• Re: De Duplicate Query
  • From: Keith Leslein
• Re: Records not showing in query
  • From: Rick B
• Re: Use crosstab column heading in a calculation
  • From: Bill R via AccessMonster.com
• Re: Multiple combo boxes - send parameters to a query?
  • From: Marshall Barton
• Re: Query to Count and copy records to new table
  • From: Tom Ellison
• Agents and sub Agents in a query
  • From: Inma
• Re: Linking Tables
  • From: John Vinson
• Re: criteria characters
  • From: ted medin
• Re: Concatenate multiple matches into single field?
  • From: Duane Hookom
• Query to Count and copy records to new table
  • From: May Q. via AccessMonster.com
• Re: Concatenate multiple matches into single field?
  • From: Ann Scharpf via AccessMonster.com
• Re: Use crosstab column heading in a calculation
  • From: Bill R via AccessMonster.com
• Re: Adding Field with an Expression
  • From: OfficeDev18 via AccessMonster.com
• Re: Use crosstab column heading in a calculation
  • From: Duane Hookom
• Re: How to
  • From: OfficeDev18 via AccessMonster.com
• Re: Concatenate multiple matches into single field?
  • From: Ann Scharpf via AccessMonster.com
• Re: split names in into 2 fields in access
  • From: fredg
• Re: Concatenate multiple matches into single field?
  • From: Ann Scharpf via AccessMonster.com
• Re: Multiple combo boxes - send parameters to a query?
  • From: Marshall Barton
• Re: Altering fields in a query
  • From: John Spencer
• Re: Trying to update a Paradox Table Via Access 2000
  • From: John Spencer
• Re: Use crosstab column heading in a calculation
  • From: Bill R via AccessMonster.com
• Re: Grouping Problem
  • From: Paul W Smith
• Re: Trying to update a Paradox Table Via Access 2000
  • From: Keith Leslein
• Re: Trying to update a Paradox Table Via Access 2000
  • From: Keith Leslein
• Re: Grouping Problem
  • From: John Spencer
• Re: Use crosstab column heading in a calculation
  • From: Bill R via AccessMonster.com
• Re: User entered data in a Query - Jet Engine Error
  • From: Winger
• Repeating records on a query
  • From: turtlewick
• Trying to update a Paradox Table Via Access 2000
  • From: Keith Leslein
• Re: [microsoft][odbc visual foxpro driver]function sequence error (#0)
  • From: Cindy Winegarden
• Re: can you use action queries with user-level security
  • From: Michel Walsh
• Re: Concatenate multiple matches into single field?
  • From: Ann Scharpf via AccessMonster.com
• Re: Concatenate multiple matches into single field?
  • From: Ann Scharpf via AccessMonster.com
• Re: Use crosstab column heading in a calculation
  • From: Duane Hookom
• Re: Multiple parameters
  • From: Duane Hookom
• Re: Ouerie Year(Now())-1 Or Year(Now())
  • From: theresa73
• Re: How do I query any combination of 7 fields - 4cbo and 3 txt
  • From: Duane Hookom
• Re: How do I query any combination of 7 fields - 4cbo and 3 txt
  • From: Michel Walsh
• Re: Grouping Problem
  • From: Paul W Smith
• Re: Multiple parameters
  • From: Michel Walsh
• RE: How to automate this...?
  • From: Bonnie
• Re: bar code script
  • From: Michel Walsh
• Re: Calculating difference between FirstOF / LastOF
  • From: Bob Miller
• Re: Use crosstab column heading in a calculation
  • From: Bill R via AccessMonster.com
• Columns to rows in a query
  • From: Mark Y via AccessMonster.com
• Re: Use crosstab column heading in a calculation
  • From: Bill R via AccessMonster.com
• Re: Append and Update 10% of records to say "Yes" and other 90% sa
  • From: Brendan Reynolds
• Re: Multiple parameters
  • From: Tom Ellison
• Re: How to remove duplicates from linked table query?
  • From: Van T. Dinh
• Re: User entered data in a Query - Jet Engine Error
  • From: John Spencer
• Re: Grouping Problem
  • From: John Spencer
• Re: Ouerie Year(Now())-1 Or Year(Now())
  • From: James Minns
• Re: [microsoft][odbc visual foxpro driver]function sequence error (#0)
  • From: Dundoan
• Re: How to remove duplicates from linked table query?
  • From: Penny
• Re: Queries Taking too Long......
  • From: david
• Ouerie Year(Now())-1 Or Year(Now())
  • From: theresa73
• Re: Calculating difference between FirstOF / LastOF
  • From: Allen Browne
• Re: Field values associated with Min or Max value in Group by Totals Q
  • From: Allen Browne
• Re: Grouping Problem
  • From: Paul W Smith
• Re: Grouping Problem
  • From: Paul W Smith
• Re: Query for Combo Box Selections
  • From: Van T. Dinh
• Re: run query for the system day
  • From: Van T. Dinh
• Re: Queries Taking too Long......
  • From: Van T. Dinh
• Re: How to remove duplicates from linked table query?
  • From: Van T. Dinh
• Re: run query for the system day
  • From: Marshall Barton
• Re: SQL Query view behaving strangely
  • From: Marshall Barton
• Re: 1-to-many relationship, i want only the last subtable entry
  • From: Tom Ellison
• Re: paramater Queries
  • From: Duane Hookom
• Re: How can I concatenate a MEMO field and a text field?
  • From: Dale Fye
• Re: Grouping Problem
  • From: Dale Fye
• Re: Query for Combo Box Selections
  • From: Dale Fye
• Re: Problem with query results
  • From: Jerry Whittle
• Re: Track a Value 15 yrs from todays date
  • From: tina
• Re: Concatenate multiple matches into single field?
  • From: Duane Hookom
• Re: Use crosstab column heading in a calculation
  • From: Duane Hookom
• SQL Query view behaving strangely
  • From: Damon Heron
• Grouping Problem
  • From: Paul W Smith
• RE: Use crosstab column heading in a calculation
  • From: Bill R via AccessMonster.com
• RE: Use crosstab column heading in a calculation
  • From: Bill R via AccessMonster.com
• RE: Use crosstab column heading in a calculation
  • From: Bill R via AccessMonster.com
• RE: Use crosstab column heading in a calculation
  • From: Bill R via AccessMonster.com
• Re: Converting data types
  • From: Bob Richardson
• Re: Negative selection
  • From: Marshall Barton
• Re: Help on Dsum
  • From: Pat Hartman\(MVP\)
• Re: Sum Query with 2 Sums on One Line
  • From: MGFoster
• Re: percentage of total froma query
  • From: Marshall Barton
• Re: Sum Query with 2 Sums on One Line
  • From: Bob Waggoner
• Re: help on query for a report
  • From: MGFoster
• Re: Recursive query, or similar
  • From: James Minns
• RE: Concatenate multiple matches into single field?
  • From: Ann Scharpf via AccessMonster.com
• Re: Query Criteria
  • From: LibbyB
• Re: Parsing Text Field In Access and using NZ
  • From: John Nurick
• RE: Use crosstab column heading in a calculation
  • From: Bill R via AccessMonster.com
• RE: Use crosstab column heading in a calculation
  • From: Bill R via AccessMonster.com
• Re: Query Criteria
  • From: John Vinson
• Re: STUCK, FRUSTRATED, PLEASE HELP!!
  • From: John Vinson
• Use crosstab column heading in a calculation
  • From: Bill R via AccessMonster.com
• Concatenate multiple matches into single field?
  • From: Ann Scharpf via AccessMonster.com
• Re: Converting data types
  • From: Bob Wickham
• Re: Update Query
  • From: Paul W Smith
• Re: percentage of total froma query
  • From: Andre C
• Re: Update Query
  • From: Rick B
• RE: Unmatch between 2 table
  • From: Ofer
• Re: How to close a query result?
  • From: Rick Brandt
• Re: Update Query
  • From: Paul W Smith
• Re: Doing the math
  • From: UT_Lab_Sup via AccessMonster.com
• Re: Update Query
  • From: Rick B
• Re: Doing the math
  • From: John Spencer
• RE: How to automate this...?
  • From: SteveS
• Re: Doing the math
  • From: UT_Lab_Sup via AccessMonster.com
• Re: How do i change a null field to a value in an acess query?
  • From: Keith Leslein
• bar code script
  • From: shank
• Re: Doing the math
  • From: UT_Lab_Sup via AccessMonster.com
• RE: Nulls to Zeros for graphing
  • From: Electricman
• Parsing Text Field In Access and using NZ
  • From: Keith Leslein
• Re: Doing the math
  • From: John Spencer
• Re: HELP HELP HELP really simple - it just won't work!
  • From: Marshall Barton
• Re: Multiple combo boxes - send parameters to a query?
  • From: Marshall Barton
• Re: Append Query
  • From: Vincent Johns
• Re: Update Query
  • From: Paul W Smith
• How to automate this...?
  • From: Bonnie
• Re-posting problem with Cartesian product
  • From: tmaxwell
• Re: Update Query
  • From: Rick B
• Re: Track a Value 15 yrs from todays date
  • From: tina
• Re: Doing the math
  • From: UT_Lab_Sup via AccessMonster.com
• Re: Track a Value 15 yrs from todays date
  • From: OfficeDev18 via AccessMonster.com
• Re: Update Query
  • From: Paul W Smith
• Re: Query trouble
  • From: OfficeDev18 via AccessMonster.com
• Re: Update Query
  • From: Paul W Smith
• Re: Sorting Problem
  • From: Jerry M. Gartner
• Re: Update Query
  • From: Rick B
• Re: Union queries
  • From: Michel Walsh
• Re: Update Query
  • From: Paul W Smith
• Re: how do I increase a query field size to more than 255 characters?
  • From: nanne
• Re: Update Query
  • From: Duane Hookom
• Re: Update Query
  • From: Rick B
• Re: Union queries
  • From: dcipollone@xxxxxxxxxxx
• Re: Error in generating DDL query
  • From: Allen Browne
• RE: Help Parameter Query .
  • From: HelloWorld
• Re: Problem with query results
  • From: Jim
• Update Query
  • From: Paul W Smith
• Re: Recursive query, or similar
  • From: James Minns
• Re: Recursive query, or similar
  • From: Michel Walsh
• Re: Comparing the Results from two queries
  • From: Mel Morris (Global Egg Corporation)
• Query trouble
  • From: StevieD via AccessMonster.com
• Re: How to remove duplicates from linked table query?
  • From: Penny
• Re: how do I increase a query field size to more than 255 characters?
  • From: Duane Hookom
• Re: Transferring Data
  • From: Rick B
• Re: Transferring Data
  • From: J
• Sum Query with 2 Sums on One Line
  • From: BarryC
• Re: Transferring Data
  • From: Rick B
• Re: Sorting Problem
  • From: [MVP] S.Clark
• Transferring Data
  • From: J
• Re: How do I add Msysobjects table to the Access 2000 query builder?
  • From: [MVP] S.Clark
• Re: Append blank rows and first row to 11
  • From: [MVP] S.Clark
• YTD previous year
  • From: jms02360
• Sorting Problem
  • From: Jerry M. Gartner
• Re: Update and Select Query results don't agree
  • From: [MVP] S.Clark
• Re: Union queries
  • From: Michel Walsh
• Re: List Criteria
  • From: Michel Walsh
• Re: HELP HELP HELP really simple - it just won't work!
  • From: Brian Bastl
• Union queries
  • From: dcipollone@xxxxxxxxxxx
• Re: Recursive query, or similar
  • From: Allen Browne
• Re: HELP HELP HELP really simple - it just won't work!
  • From: ClaireB
• Re: HELP HELP HELP really simple - it just won't work!
  • From: ClaireB
• Re: help on query for a report
  • From: Bart
• Recursive query, or similar
  • From: James Minns
• Re: Converting data types
  • From: Van T. Dinh
• Re: Cross tab query construction with Subqueries
  • From: Steven Cheng
• Re: How to remove duplicates from linked table query?
  • From: Van T. Dinh
• Re: Change text that displays when running query
  • From: Van T. Dinh
• Re: Need an Access Programmer to complete database queries (simple). Will compensate accordingly.
  • From: Arno R
• How to remove duplicates from linked table query?
  • From: Penny
• Re: User-Defined Function Doesn't Execute
  • From: John Nurick
• Re: help on query for a report
  • From: Vincent Johns
• Re: update query problem
  • From: John Vinson
• Re: What is best way to filter through multiple fields to get an answe
  • From: John Vinson
• Re: Opening Stock ----- KRISH
  • From: Allen Browne
• Re: How to insert data more than 255 into memo field?
  • From: Marshall Barton
• Re: Converting data types
  • From: Allen Browne
• Re: Converting data types
  • From: Bob Wickham
• Re: Update append query
  • From: Allen Browne
• Re: Converting data types
  • From: Allen Browne
• Update append query
  • From: Alex Martinez
• Converting data types
  • From: Bob Wickham
• Re: Help with DISTINCT
  • From: John Spencer
• Re: Need an Access Programmer to complete database queries (simple). Will compensate accordingly.
  • From: Vincent Johns
• Re: Join in query not working properly?
  • From: Allen Browne
• Re: Group by Month
  • From: MGFoster
• Re: Group by Month
  • From: tina
• Re: LEFT JOIN returns a single space instead of NULL
  • From: Douglas J. Steele
• Re: query criteria based on 2 cell values in diffrent rows
  • From: MGFoster
• Re: HELP HELP HELP really simple - it just won't work!
  • From: Marshall Barton
• Re: Join in query not working properly?
  • From: upsman via AccessMonster.com
• Re: Update Query changing text to number
  • From: Van T. Dinh
• Re: User-Defined Function Doesn't Execute
  • From: Van T. Dinh
• RE: User Supplied Parameter Query
  • From: Carla Gilless
• Re: Update Query changing text to number
  • From: fredg
• Re: Update Query changing text to number
  • From: Tom Ellison
• Re: Update Query changing text to number
  • From: Linda Burnside
• Re: Calculate time lapsed between two records
  • From: Tom Ellison
• Re: Comparing the Results from two queries
  • From: Tom Ellison
• Re: Need an Access Programmer to complete database queries (simple). Will compensate accordingly.
  • From: no . soliciting
• HELP HELP HELP really simple - it just won't work!
  • From: ClaireB
• Re: Calculate time lapsed between two records
  • From: Zimme
• Re: [microsoft][odbc visual foxpro driver]function sequence error (#0)
  • From: Cindy Winegarden
• Re: What's faster than ODBC to query SQL data using Access?
  • From: Van T. Dinh
• Re: Prompting twice
  • From: MGFoster
• Re: help on query for a report
  • From: MGFoster
• User-Defined Function Doesn't Execute
  • From: BarryC
• Re: Find the max number of columns returned from a crosstab
  • From: Duane Hookom
• Re: Crosstab Query Parameters Using Form
  • From: Duane Hookom
• Re: Constant values in a query
  • From: John Spencer
• Re: Using an IIf statement to populate a combo box
  • From: John Spencer
• Re: Updating Data from a 'GROUP BY' query
  • From: John Spencer
• Re: Problem with query results
  • From: Jim
• Re: Multiple combo boxes - send parameters to a query?
  • From: Marshall Barton
• Re: Constant values in a query
  • From: Lynn Trapp
• Re: Using an IIf statement to populate a combo box
  • From: George Nicholson
• Constant values in a query
  • From: Martin Hopkins
• RE: User Supplied Parameter Query
  • From: SteveS
• Re: Crosstab Query Parameters Using Form
  • From: Bernie
• Re: Find the max number of columns returned from a crosstab
  • From: joshblair
• Re: Queries Criteria-Not Like
  • From: Steven P via AccessMonster.com
• Re: Crosstab Query Parameters Using Form
  • From: Duane Hookom
• RE: Nulls to Zeros for graphing
  • From: Electricman
• Re: Help with Cartesian or cross joins
  • From: tmaxwell
• Re: Queries Criteria-Not Like
  • From: Duane Hookom
• Re: Find the max number of columns returned from a crosstab
  • From: Duane Hookom
• Re: Problem with query results
  • From: OfficeDev18 via AccessMonster.com
• Re: Sum
  • From: OfficeDev18 via AccessMonster.com
• Re: Make Table Query is converting currency field to a number in the t
  • From: OfficeDev18 via AccessMonster.com
• Re: Crosstab Query Parameters Using Form
  • From: Duane Hookom
• RE: User Supplied Parameter Query
  • From: Carla Gilless
• Re: Help with Cartesian or cross joins
  • From: Vincent Johns
• Sum
  • From: Steven P via AccessMonster.com
• Re: Cross tab query construction with Subqueries
  • From: Vincent Johns
• Re: form/query to update table?
  • From: fredg
• Re: Queries Criteria-Not Like
  • From: Steven P via AccessMonster.com
• Problem with query results
  • From: Jim
• Find the max number of columns returned from a crosstab
  • From: joshblair
• Re: Output Design Column Names
  • From: Brendan Reynolds
• Append blank rows and first row to 11
  • From: jasonrbaxter
• Re: Temp Query
  • From: Berny
• Re: Temp Query
  • From: Allen Browne
• Re: Doing the math
  • From: John Spencer
• Re: Creating a 'Total' column
  • From: Duane Hookom
• Re: Temp Query
  • From: Berny
• Re: Help with Cartesian or cross joins
  • From: tmaxwell
• Re: Covert Datetime to date only for calculations
  • From: Allen Browne
• Re: Comparing the Results from two queries
  • From: Mel Morris (Global Egg Corporation)
• Covert Datetime to date only for calculations
  • From: Dave
• [microsoft][odbc visual foxpro driver]function sequence error (#0)
  • From: Dundoan
• Re: Calculated query help please
  • From: Tom Ellison
• Re: Calculated query help please
  • From: Flynny
• Re: Creating a 'Total' column
  • From: Mike
• Re: Build SQL From Form
  • From: Sergiy Korzh
• Re: Need an Access Programmer to complete database queries (simple). Will compensate accordingly.
  • From: Tom Ellison
• Re: Doing the Math
  • From: Tom Ellison
• Re: Calculated query help please
  • From: Tom Ellison
• Re: Runtime error when creating a table with an SQL query
  • From: Tom Ellison
• Re: Runtime error when creating a table with an SQL query
  • From: Cevin
• Doing the math
  • From: UT_Lab_Sup
• Re: Join in query not working properly?
  • From: Allen Browne
• Re: Temp Query
  • From: Allen Browne
• Join in query not working properly?
  • From: upsman via AccessMonster.com
• Re: Temp Query
  • From: Berny
• Re: Temp Query
  • From: Allen Browne
• Re: Help - TIA ... query design grid is missing ... - qUERY dESIGN gRID IS mISSING.gif (0/1)
  • From: Steve Schapel
• Re: Help - TIA ... query design grid is missing ... - qUERY dESIGN gRID IS mISSING.gif (0/1)
  • From: Jim
• Re: Help - TIA ... query design grid is missing ...
  • From: Jim
• Temp Query
  • From: Berny
• Re: LEFT JOIN returns a single space instead of NULL
  • From: ifiaz
• Re: ENTER MULTIPLE Items in a Query Pop-Up PROMPT e.g. [Name:]
  • From: Duane Hookom
• Re: Creating a 'Total' column
  • From: Duane Hookom
• Need an Access Programmer to complete database queries (simple). Will compensate accordingly.
  • From: no . soliciting
• Creating a 'Total' column
  • From: Mike
• Re: ENTER MULTIPLE Items in a Query Pop-Up PROMPT e.g. [Name:]
  • From: kev100 via AccessMonster.com
• Re: ENTER MULTIPLE Items in a Query Pop-Up PROMPT e.g. [Name:]
  • From: kev100 via AccessMonster.com
• Re: Queries Criteria-Not Like
  • From: Duane Hookom
• Re: Queries Criteria-Not Like
  • From: Aeisedi
• Queries Criteria-Not Like
  • From: Steven P via AccessMonster.com
• Re: Help - TIA ... query design grid is missing ... - qUERY dESIGN gRID IS mISSING.gif (0/1)
  • From: Jim
• Re: Runtime error when creating a table with an SQL query
  • From: Douglas J. Steele
• Re: Help - TIA ... query design grid is missing ...
  • From: fredg
• Re: Help - TIA ... query design grid is missing ...
  • From: Steve Schapel
• Re: Runtime error when creating a table with an SQL query
  • From: Cevin
• Re: Variable from Exported Excel File
  • From: Ken Snell \(MVP\)
• Re: Variable from Exported Excel File
  • From: LJG
• Re: Group Dates in a query
  • From: sprinklingtarn
• Help - TIA ... query design grid is missing ...
  • From: Beta
• Re: Counting to zero
  • From: Jeff Boyce
• Re: LEFT JOIN returns a single space instead of NULL
  • From: Douglas J. Steele
• Re: Incrementally increase by 1 function that can be used in a query
  • From: John Nurick
• Re: Cross tab query construction with Subqueries
  • From: Steven Cheng
• Re: Runtime error when creating a table with an SQL query
  • From: Tom Ellison
• Re: VBA to edit a Query Properties
  • From: Vincent Johns
• Re: Cross tab query construction with Subqueries
  • From: Vincent Johns
• Re: Ranking
  • From: Tom Ellison
• Re: Comparing the Results from two queries
  • From: Tom Ellison
• Re: Removal/delete and update query
  • From: Jeff Boyce
• Re: Doesn't sort consistantly
  • From: Bob Richardson
• Re: LEFT JOIN returns a single space instead of NULL
  • From: ifiaz
• Doesn't sort consistantly
  • From: Bob Richardson
• Re: Incrementally increase by 1 function that can be used in a query
  • From: HanSolo
• Incrementally increase by 1 function that can be used in a query
  • From: HanSolo
• Re: Special Left function wanted...
  • From: magmike
• Re: Special Left function wanted...
  • From: magmike
• Re: Special Left function wanted...
  • From: Douglas J. Steele
• Re: Special Left function wanted...
  • From: magmike
• Re: QUERY DATE RANGE
  • From: hotrod1952 via AccessMonster.com
• Re: Special Left function wanted...
  • From: magmike
• Re: Special Left function wanted...
  • From: magmike
• Runtime error when creating a table with an SQL query
  • From: Cevin
• Re: Special Left function wanted...
  • From: John Nurick
• Re: LEFT JOIN returns a single space instead of NULL
  • From: Amy Blankenship
• Re: Special Left function wanted...
  • From: John Nurick
• Re: Determine High Error Categories
  • From: Duane Hookom
• Re: Variable from Exported Excel File
  • From: Ken Snell \(MVP\)
• Re: Special Left function wanted...
  • From: John Nurick
• Re: Special Left function wanted...
  • From: magmike
• Re: Help with Cartesian or cross joins
  • From: Vincent Johns
• Re: Special Left function wanted...
  • From: magmike
• Re: Append Query
  • From: Vincent Johns
• Re: Determine High Error Categories
  • From: Marshall Barton
• Re: dynamic crosstab
  • From: Michel Walsh
• Re: QUERY DATE RANGE
  • From: Rick Brandt
• Re: QUERY DATE RANGE
  • From: Allen Browne
• Re: Setting up a query to pull data from another table
  • From: nanne
• Re: Determine High Error Categories
  • From: Duane Hookom
• QUERY DATE RANGE
  • From: hotrod1952
• LEFT JOIN returns a single space instead of NULL
  • From: ifiaz
• Re: Special Left function wanted...
  • From: Rick Brandt
• Re: Variable from Exported Excel File
  • From: LJG
• Re: Special Left function wanted...
  • From: John Nurick
• Re: Make Table Query is converting currency field to a number in the t
  • From: Steve Schapel
• Re: Date prompt input mask in query
  • From: Duane Hookom
• Re: Special Left function wanted...
  • From: Ken Snell \(MVP\)
• Re: Special Left function wanted...
  • From: magmike
• Re: Special Left function wanted...
  • From: magmike
• Re: Special Left function wanted...
  • From: magmike
• Re: Query criteria
  • From: Allen Browne
• RE: User Supplied Parameter Query
  • From: SteveS
• RE: Guidance
  • From: SteveS
• Re: Adding a year to a date using Year() in update query
  • From: fredg
• Counting the number of returns from a query
  • From: interspectrum
• Re: Setting up a query to pull data from another table
  • From: John Vinson
• RE: Help Parameter Query .
  • From: HelloWorld
• Re: Special Left function wanted...
  • From: John Nurick
• Re: Special Left function wanted...
  • From: Ken Snell \(MVP\)
• Re: Variable from Exported Excel File
  • From: Ken Snell \(MVP\)
• Re: Special Left function wanted...
  • From: magmike
• Re: Crosstab query with criteria, dynamic columns and crosstab report
  • From: joshblair
• Re: How do I search for an asterick?
  • From: John Vinson
• Re: Crosstab query with criteria, dynamic columns and crosstab report question
  • From: joshblair
• Re: Comparing the Results from two queries
  • From: Mel Morris (Global Egg Corporation)
• RE: Help Parameter Query .
  • From: SteveS
• Re: Q: Make Table from Crosstab?
  • From: John Vinson
• Special Left function wanted...
  • From: magmike
• Re: YES/NO not working
  • From: John Spencer
• Re: percentage of total froma query
  • From: Marshall Barton
• Re: no. of days and month
  • From: John Spencer
• Re: Crosstab query with criteria, dynamic columns and crosstab report question
  • From: John Spencer
• Re: How do I search for an asterick?
  • From: John Spencer
• RE: Crosstab query with criteria, dynamic columns and crosstab report
  • From: Jerry Whittle
• Re: Calculation/Function as part of the field name.
  • From: John Spencer
• Re: Group By, Count, and Like
  • From: John Spencer
• Re: Calculation/Function as part of the field name.
  • From: BruceM
• Re: Multiple IIF Statements
  • From: John Spencer
• Re: Comparing the Results from two queries
  • From: John Spencer
• RE: Deriving a Phase and Week number
  • From: SteveS
• parameter combo box queries
  • From: Tank04
• Crosstab query with criteria, dynamic columns and crosstab report question
  • From: joshblair
• Re: Comparing the Results from two queries
  • From: Mel Morris (Global Egg Corporation)
• Re: Comparing the Results from two queries
  • From: Mel Morris (Global Egg Corporation)
• Re: Build SQL From Form
  • From: Roger Carlson
• VBA to edit a Query Properties
  • From: Kit Truong
• Re: Update and Select Query results don't agree
  • From: tkosel
• Re: Help Parameter Query .
  • From: OfficeDev18 via AccessMonster.com
• Re: Make Table Query is converting currency field to a number in the t
  • From: OfficeDev18 via AccessMonster.com
• Re: How do I search for an asterick?
  • From: OfficeDev18 via AccessMonster.com
• RE: Help with Cartesian or cross joins
  • From: tmaxwell
• Re: Guidance
  • From: John Nurick
• Re: Calculation/Function as part of the field name.
  • From: FatMan
• Re: Update query to insert a new record
  • From: John Vinson
• Re: Looping a function in a query
  • From: HanSolo
• Re: no. of days and month
  • From: ismail
• Re: Date calculation
  • From: OfficeDev18 via AccessMonster.com
• Re: Update and Select Query results don't agree
  • From: tkosel
• Re: Help with Cartesian or cross joins
  • From: Vincent Johns
• Re: Date Querry
  • From: OfficeDev18 via AccessMonster.com
• Re: YES/NO not working
  • From: OfficeDev18 via AccessMonster.com
• Re: Update and Select Query results don't agree
  • From: [MVP] S.Clark
• Re: percentage of total froma query
  • From: Andre C
• Help with Cartesian or cross joins
  • From: tmaxwell
• Re: Calculation/Function as part of the field name.
  • From: BruceM
• Re: Using Access Query in similar fashion of a vlookup function
  • From: LeAnne
• Re: Determine lowest proce
  • From: Allen Browne
• Re: Queries turned Read Only
  • From: Allen Browne
• Re: Removal/delete and update query
  • From: Jeff Boyce
• Re: A "diff" routine
  • From: Jeff Boyce
• Re: Group By, Count, and Like
  • From: John Spencer
• Re: How can i select the other 25% of Records?
  • From: Mota
• Re: Aggregate Functions & Group By Fields
  • From: John Spencer
• Re: Using Access Query in similar fashion of a vlookup function
  • From: John Spencer
• Re: Query on a text field
  • From: k . roberts
• Re: Union ALL with Count
  • From: John Spencer
• Re: cursor follows mouse pointer
  • From: Duane Hookom
• Re: ENTER MULTIPLE Items in a Query Pop-Up PROMPT e.g. [Name:]
  • From: Duane Hookom
• Re: Multiple IIF Statements
  • From: LeAnne
• ENTER MULTIPLE Items in a Query Pop-Up PROMPT e.g. [Name:]
  • From: kev100 via AccessMonster.com
• Re: Union ALL with Count
  • From: Roger Carlson
• cursor follows mouse pointer
  • From: Ron Le Blanc
• Re: Guidance
  • From: Rick Brandt
• Re: Query on a text field
  • From: k . roberts
• Re: Query on a text field
  • From: Jeff Boyce
• Guidance
  • From: JB
• Query on a text field
  • From: k . roberts
• Need a quote in my expression
  • From: dbouton
• Update query to insert a new record
  • From: Chris B via AccessMonster.com
• Re: DSUM, Running total problem
  • From: Noreen McHugh
• Re: Using wildcard in update query
  • From: Van T. Dinh
• Re: DSUM, Running total problem
  • From: Noreen McHugh
• Re: Variable from Exported Excel File
  • From: LJG
• RE: duplicate query
  • From: officeman3
• Re: Closing Queries
  • From: fredg
• Re: Closing Queries
  • From: Otac0n
• Re: Variable from Exported Excel File
  • From: Ken Snell \(MVP\)
• Re: Calculate time lapsed between two records
  • From: Tom Ellison
• Re: Calculate time lapsed between two records
  • From: Zimme
• RE: help with an update query..
  • From: SteveS
• Re: Query Prob....... KRISH
  • From: MGFoster
• Re: Weird Wildcard problem i Access
  • From: John Vinson
• Re: How can i select the other 25% of Records?
  • From: Tom Ellison
• Re: How can i select the other 25% of Records?
  • From: Mota
• Re: "IIF" in Criterea area of Query
  • From: George Nicholson
• Re: Weird Wildcard problem i Access
  • From: Peter Doering
• Re: Looping a function in a query
  • From: Marshall Barton
• Re: Delete records older than one year
  • From: Jeff Boyce
• Re: Weird Wildcard problem i Access
  • From: John Vinson
• Re: Q: Make Table from Crosstab?
  • From: John Vinson
• Re: Weird Wildcard problem i Access
  • From: Kristian
• Re: Weird Wildcard problem i Access
  • From: Brian Bastl
• RE: Weird Wildcard problem i Access
  • From: Kristian
• Re: how come information wont pull up
  • From: John Vinson
• Re: Looping a function in a query
  • From: George Nicholson
• Variable from Exported Excel File
  • From: LJG
• Re: "IIF" in Criterea area of Query
  • From: JohnG
• Re: MS access - Most recent Date
  • From: John Vinson
• Re: criteria characters
  • From: John Nurick
• Re: Looping a function in a query
  • From: Ken Snell \(MVP\)
• Re: Please help with update/join/sum query
  • From: [MVP] S.Clark
• Re: Using Access Query in similar fashion of a vlookup function
  • From: HanSolo
• Re: Update Question
  • From: John Vinson
• Re: Using Access Query in similar fashion of a vlookup function
  • From: [MVP] S.Clark
• Re: how come information wont pull up
  • From: HanSolo
• Re: Union ALL with Count
  • From: Juan Schwartz
• Re: "IIF" in Criterea area of Query
  • From: HanSolo
• Re: Multiple IIF Statements
  • From: HanSolo
• "IIF" in Criterea area of Query
  • From: JohnG
• Looping a function in a query
  • From: HanSolo
• Re: Aggregate Functions & Group By Fields
  • From: George B via AccessMonster.com
• Re: Pass-Through Query w/o Record Locking
  • From: Tony
• Re: Cross-tab Criteria not evaluating
  • From: Duane Hookom
• Re: Only retrieving first 50 records?!?
  • From: winsa
• Re: Comparing the Results from two queries
  • From: John Spencer
• Re: Aggregate Functions & Group By Fields
  • From: John Spencer
• Re: Comparing the Results from two queries
  • From: Tom Ellison
• Re: Time Difference
  • From: danka
• Re: Union ALL with Count
  • From: Roger Carlson
• Re: Cross-tab Criteria not evaluating
  • From: Juan Schwartz
• Re: Update and Select Query results don't agree
  • From: [MVP] S.Clark
• Aggregate Functions & Group By Fields
  • From: George B via AccessMonster.com
• Re: Union ALL with Count
  • From: Juan Schwartz
• Re: Cross-tab Criteria not evaluating
  • From: Duane Hookom
• Re: Make Table from Crosstab?
  • From: [MVP] S.Clark
• Re: Avg, AS, GROUP BY query
  • From: [MVP] S.Clark
• Re: YES/NO not working
  • From: John Spencer
• Re: Make Table from Crosstab?
  • From: Roger Carlson
• Re: Ranking
  • From: Duane Hookom
• Re: Ranking
  • From: Tom Ellison
• Re: Urgent! Subquery help needed!
  • From: Tom Ellison
• Re: DSUM, Running total problem
  • From: Tom Ellison
• Re: percentage of total froma query
  • From: Andre C
• Re: Simple IIF Question
  • From: John Spencer
• Re: criteria characters
  • From: ted medin
• Re: Monte Carlo Simulations
  • From: LeAnne
• Re: Append 2 relational tables simultaneously
  • From: John Vinson
• Re: Union ALL with Count
  • From: Roger Carlson
• Re: Create a indeterminate relationship in access using sql
  • From: John Vinson
• Re: Create a indeterminate relationship in access using sql
  • From: John Nurick
• Re: Update Question
  • From: John Nurick
• Re: Only show query if it contains results.
  • From: fredg
• Re: Union ALL with Count
  • From: Juan Schwartz
• Union ALL with Count
  • From: Juan Schwartz
• Re: YES/NO not working
  • From: Dan @BCBS
• Monte Carlo Simulations
  • From: Dane Cooper
• Re: YES/NO not working
  • From: OfficeDev18 via AccessMonster.com
• Re: Cross-tab Criteria not evaluating
  • From: Juan Schwartz
• YES/NO not working
  • From: Dan @BCBS
• Re: MS access - Most recent Date
  • From: pretty gal
• RE: 3 Tables and query not updateable
  • From: SteveS
• RE: Using wildcard in update query
  • From: OfficeDev18 via AccessMonster.com
• Re: Urgent! Subquery help needed!
  • From: OfficeDev18 via AccessMonster.com
• RE: Error message "Invalid Argument"
  • From: OfficeDev18 via AccessMonster.com
• Re: Age Calculation
  • From: KantFigureItOut via AccessMonster.com
• Re: Using wildcard in update query
  • From: apna
• Re: dups in a query
  • From: Dan @BCBS
• 3 Tables and query not updateable
  • From: babs
• RE: Error message "Invalid Argument"
  • From: OfficeDev18 via AccessMonster.com
• Re: A new field to auto insert numbers
  • From: Duane Hookom
• Re: dups in a query
  • From: Duane Hookom
• Re: Query date/time issues
  • From: Allen Browne
• Query date/time issues
  • From: sbatschelet
• Update Question
  • From: Dimitris
• Problems Exporting to Excel
  • From: Manuel via AccessMonster.com
• Re: Multiple calculations in one column
  • From: Rick Brandt
• RE: Duplicating Records
  • From: Stephen
• Multiple calculations in one column
  • From: Brook Morris
• Re: Division by Zero Error
  • From: John Spencer
• Re: Division by Zero Error
  • From: Calvin Willman
• Re: query based on user login
  • From: John Spencer
• RE: Duplicating Records
  • From: freakazeud
• Re: Division by Zero Error
  • From: Calvin Willman
• Re: Division by Zero Error
  • From: John Spencer
• Division by Zero Error
  • From: Calvin Willman
• Re: DSUM, Running total problem
  • From: Noreen McHugh
• RE: query based on user login
  • From: Ofer
• Re: conversion
  • From: Allen Browne
• conversion
  • From: bernard
• Re: Unwanted repeated adding
  • From: Tom Ellison
• RE: Duplicating Records
  • From: Stephen
• Re: Only retrieving first 50 records?!?
  • From: Marshall Barton
• Re: subquery question; should be easy for you
  • From: BodiKlamph
• Re: subquery question; should be easy for you
  • From: BodiKlamph
• Re: Exporting Date includes 0:00:00 - Don't Want That!
  • From: magmike
• Re: How can I insert Autonumber in query
  • From: John Vinson
• Re: Calculated field in pass through query
  • From: Tom Ellison
• Re: Make Table Query
  • From: John Vinson
• Re: how do i append a query?
  • From: Jeff Boyce
• Re: Specify criteria for a date/time field
  • From: Rick Brandt
• Re: How to join 2 Access tables to return ALL records from both tables
  • From: Tom Ellison
• Re: Lost all joins
  • From: Tom Ellison
• Re: How can i select the other 25% of Records?
  • From: Tom Ellison
• Re: Only retrieving first 50 records?!?
  • From: winsa
• Re: ORDER BY involving memo field bug??
  • From: david epsom dot com dot au
• Re: Simple IIF Question
  • From: Douglas J. Steele
• Re: How can i select the other 25% of Records?
  • From: Mota
• Re: percentage of total froma query
  • From: Marshall Barton
• RE: Duplicating Records
  • From: freakazeud
• Re: Cross-tab Criteria not evaluating
  • From: Juan Schwartz
• Re: dups in a query
  • From: Duane Hookom
• Re: Lost all joins
  • From: Sylvie
• Re: Exporting Large Query, Kills Access
  • From: david epsom dot com dot au
• Re: criteria
  • From: Cinzia
• Re: criteria
  • From: fredg
• Re: Cross-tab Criteria not evaluating
  • From: Juan Schwartz
• Re: Lost all joins
  • From: Gary Walter
• Re: how do i append a query?
  • From: Rick B
• Re: percentage of total froma query
  • From: Andre C
• Re: Age Calculation
  • From: fredg
• Re: Exporting Large Query, Kills Access
  • From: CkanoaB
• Re: percentage of total froma query
  • From: Marshall Barton
• Re: Age Calculation
  • From: Michel Walsh
• RE: Duplicating Records
  • From: Stephen
• Age Calculation
  • From: KantFigureItOut
• Re: MS access - Most recent Date
  • From: John Spencer
• Re: no. of days and month
  • From: John Spencer
• RE: Lost all joins
  • From: SteveG
• Re: Lost all joins
  • From: Michel Walsh
• Re: dynamic crosstab
  • From: Michel Walsh
• Re: dups in a query
  • From: Marshall Barton
• percentage of total froma query
  • From: Andre C
• Re: ORDER BY involving memo field bug??
  • From: Marshall Barton
• Re: age-categories
  • From: Michel Walsh
• Re: ORDER BY in queries
  • From: Marshall Barton
• Re: dups in a query
  • From: Michel Walsh
• Re: Newbie: Cross Tab. With Percentages ?
  • From: Duane Hookom
• Re: Cross-tab Criteria not evaluating
  • From: Duane Hookom
• Re: dups in a query
  • From: Duane Hookom
• Re: Nulls in Query
  • From: Michel Walsh
• age-categories
  • From: Jean-Paul De Winter
• Re: Cross-tab Criteria not evaluating
  • From: Juan Schwartz
• Re: Syntax on Create Table...
  • From: Michel Walsh
• Re: Newbie: Cross Tab. With Percentages ?
  • From: richmarin
• Re: Rolling Differences
  • From: JJEWELL
• Re: ORDER BY involving memo field bug??
  • From: Michel Walsh
• Re: Syntax error in insert into statement
  • From: Wind54Surfer
• Re: Exporting Large Query, Kills Access
  • From: CkanoaB
• Re: no. of days and month
  • From: ismail
• Re: Exporting Large Query, Kills Access
  • From: CkanoaB
• Re: Syntax error in insert into statement
  • From: Duane Hookom
• Exporting Large Query, Kills Access
  • From: Chris . Buske
• RE: Urgent! Subquery help needed!
  • From: OfficeDev18 via AccessMonster.com
• Re: Pass-Through Query w/o Record Locking
  • From: Tony
• Re: How to join 2 Access tables to return ALL records from both tables
  • From: John Spencer
• Re: Duplicates in queries from multiples tables
  • From: [MVP] S.Clark
• Re: Duplicates in queries from multiples tables
  • From: John Spencer
• Re: Unwanted repeated adding
  • From: [MVP] S.Clark
• Re: A new field to number records to a maximum
  • From: [MVP] S.Clark
• Re: Pass-Through Query w/o Record Locking
  • From: [MVP] S.Clark
• Re: Query Totals
  • From: [MVP] S.Clark
• Re: Query with lookup field in table
  • From: Rick B
• Re: Formatting Fields in Query
  • From: Rick B
• Re: How to join 2 Access tables to return ALL records from both tables
  • From: Rick B
• Re: CDate fails append query Access 2003
  • From: CatScratch
• Re: Specify criteria for a date/time field
  • From: Rick Brandt
• Re: MS access - Most recent Date
  • From: pretty gal
• Re: subquery question; should be easy for you
  • From: Brendan Reynolds
• Re: CREATE TABLE: how to define a field's DEFAULT data value?
  • From: Ed B
• Re: Syntax error in insert into statement
  • From: Wind54Surfer
• subquery question; should be easy for you
  • From: BodiKlamph
• Re: Syntax error in insert into statement
  • From: Duane Hookom
• Re: Hide the Web menu bar
  • From: freakazeud
• Re: MS access - Most recent Date
  • From: John Spencer
• Re: MS access - Most recent Date
  • From: Michel Walsh
• Re: Pass-Through Query w/o Record Locking
  • From: Tony
• Re: Hide the Web menu bar
  • From: Warrio
• Re: Data type mismatch in query
  • From: John Spencer
• Re: Data type mismatch in query
  • From: Cinzia
• Re: MS access - Most recent Date
  • From: pretty gal
• Re: masking data in password field in resulting query
  • From: John Spencer
• Re: How do I set up a parameter query using a combo box in Access?
  • From: John Spencer
• Re: How do I set up a parameter query using a combo box in Access?
  • From: John Spencer
• Re: Code based on Query Value
  • From: John Spencer
• Re: masking data in password field in resulting query
  • From: John Nurick
• Re: MS access - Most recent Date
  • From: John Spencer
• Re: Syntax error in insert into statement
  • From: Wind54Surfer
• Re: Calculated field in pass through query
  • From: Michel Walsh
• Re: CREATE TABLE: how to define a field's DEFAULT data value?
  • From: Allen Browne
• Re: masking data in password field in resulting query
  • From: Jeff A via AccessMonster.com
• Hide the Web menu bar
  • From: Warrio
• Re: masking data in password field in resulting query
  • From: John Nurick
• Re: Only retrieving first 50 records?!?
  • From: Marshall Barton
• Re: How can I calculate difference value
  • From: Nova
• Re: How to count the number of duplicate records then delete
  • From: yelhsa
• Re: Query Dates for 12 months
  • From: Duane Hookom
• masking data in password field in resulting query
  • From: Jeff A via AccessMonster.com
• Re: How to count the number of duplicate records then delete
  • From: Tom Ellison
• Re: Exporting Date includes 0:00:00 - Don't Want That!
  • From: Rick Brandt
• Re: Exporting Date includes 0:00:00 - Don't Want That!
  • From: magmike
• Re: Syntax error in insert into statement
  • From: Duane Hookom
• Re: Data type mismatch in criteria expression
  • From: John Vinson
• Re: CREATE TABLE: how to define a field's DEFAULT data value?
  • From: Allen Browne
• Re: How do I set up a parameter query using a combo box in Access?
  • From: Duane Hookom
• Re: How do I set up a parameter query using a combo box in Access?
  • From: Allen Browne
• Re: How do I set up a parameter query using a combo box in Access?
  • From: John Vinson
• Re: Make Table Query
  • From: John Vinson
• Re: Exporting Date includes 0:00:00 - Don't Want That!
  • From: Rick Brandt
• Re: Selection criteria and Group by
  • From: Tom Ellison
• Re: Help! Help! Help!
  • From: George Nicholson
• Re: Copying/Pasting into Update Query
  • From: Tom Ellison
• Re: Query Help
  • From: Tom Ellison
• Re: CDate fails append query Access 2003
  • From: Tom Ellison
• Re: How can i select the other 25% of Records?
  • From: Tom Ellison
• Selection criteria and Group by
  • From: jeanluc . praz
• Re: Make Table Query
  • From: Tom Ellison
• Re: Calculate time lapsed between two records
  • From: Tom Ellison
• Re: Data type mismatch in criteria expression
  • From: Wind54Surfer
• How can i select the other 25% of Records?
  • From: Mota
• CDate fails append query Access 2003
  • From: CatScratch
• Re: Cross-tab Criteria not evaluating
  • From: Duane Hookom
• Re: Calculate time lapsed between two records
  • From: Zimme
• Re: DateAdd in query
  • From: Wayne Morgan
• Re: MS access - Most recent Date
  • From: Michel Walsh
• Re: Code based on Query Value
  • From: fredg
• Re: can i have a querie with a linked table
  • From: Hutchinson180
• Re: Union Query
  • From: John Vinson
• Re: Merging recordsets
  • From: John Vinson
• Re: Union Query
  • From: Tom Ellison
• Re: Simple Query Not Producing Certain Records...
  • From: policeteeth
• Re: Simple Query Not Producing Certain Records...
  • From: John Spencer
• Re: Split Records
  • From: Tom Ellison
• MS access - Most recent Date
  • From: pretty gal
• Re: Calculated field in pass through query
  • From: Tom Ellison
• Re: Split Records
  • From: Alec Green
• Re: Cross-tab Criteria not evaluating
  • From: Juan Schwartz
• Re: Calculated field in pass through query
  • From: Michel Walsh
• Re: Pass-Through Query w/o Record Locking
  • From: Tony
• Re: Simple Query Not Producing Certain Records...
  • From: policeteeth
• Re: SUBQUERIES in the FROM clause with Access query
  • From: Tom Ellison
• Re: IsNull function
  • From: Michel Walsh
• Re: IsNull function
  • From: [MVP] S.Clark
• Re: DSUM, Running total problem
  • From: Tom Ellison
• Re: Simple Query Not Producing Certain Records...
  • From: [MVP] S.Clark
• Re: Pass-Through Query w/o Record Locking
  • From: [MVP] S.Clark
• Re: Calculated field in pass through query
  • From: Tom Ellison
• Re: Query Totals
  • From: [MVP] S.Clark
• Re: Selecting part of a field up until an # character
  • From: kim
• Re: DSUM, Running total problem
  • From: Tom Ellison
• Re: Data type mismatch in criteria expression
  • From: John Vinson
• Re: IsNull function
  • From: Tom Lake
• Re: can i have a querie with a linked table
  • From: John Vinson
• Re: criteria characters
  • From: John Nurick
• Re: Exporting Date includes 0:00:00 - Don't Want That!
  • From: magmike
• IsNull function
  • From: Bob Matthews
• Re: Exporting Date includes 0:00:00 - Don't Want That!
  • From: Rick Brandt
• Exporting Date includes 0:00:00 - Don't Want That!
  • From: magmike
• Simple Query Not Producing Certain Records...
  • From: policeteeth
• Re: Selecting part of a field up until an # character
  • From: Michel Walsh
• RE: Duplicate Security warnings
  • From: freakazeud
• Re: Update Query in VBA
  • From: Michel Walsh
• Pass-Through Query w/o Record Locking
  • From: Tony
• Re: SUBQUERIES in the FROM clause with Access query
  • From: A.Q
• Re: Search critieria from Form
  • From: Steve Schapel
• Re: Urgent! Subquery help needed!
  • From: Randy Harris
• Re: How can I display error message for info not found in query parame
  • From: Allen Browne
• Re: Cross-tab Criteria not evaluating
  • From: Duane Hookom
• Re: Cross-tab Criteria not evaluating
  • From: Juan Schwartz
• Re: Help! Help! Help!
  • From: Gwen H
• Re: Urgent! Subquery help needed!
  • From: Gwen H
• Re: Cross-tab Criteria not evaluating
  • From: Juan Schwartz
• Re: convert seconds into minutes
  • From: Allen Browne
• Re: Date & Time Field
  • From: Diane Walker
• Re: Date & Time Field
  • From: Diane Walker
• Re: In an access query, how do I set criteria for "most recent" da
  • From: dukejam
• Re: DSUM, Running total problem
  • From: Noreen McHugh
• Re: Need to remove duplicates and keep only the highest Status .
  • From: Michel Walsh
• Re: Need to remove duplicates and keep only the highest Status .
  • From: Michel Walsh
• Re: Need query to return all values including Nulls
  • From: Randy
• Re: help me please
  • From: John Spencer
• Re: Query Dates for 12 months
  • From: D. M.
• Re: Data type mismatch in criteria expression
  • From: Wind54Surfer
• Re: criteria characters
  • From: John Spencer
• Re: Calculated field in pass through query
  • From: Vaughan
• Re: Still Confused
  • From: John Spencer
• Re: Using current record as query criteria
  • From: Michel Walsh
• Re: New column
  • From: Tom Ellison
• Re: Problems with pulling value from Unbound Control in Form Footer.
  • From: Tom Ellison
• Re: Calculated field in pass through query
  • From: Tom Ellison
• Re: DSUM, Running total problem
  • From: Tom Ellison
• DSUM, Running total problem
  • From: Noreen McHugh
• Re: criteria characters
  • From: John Nurick
• Re: criteria characters
  • From: John Nurick
• Re: Update multible records from one table to another
  • From: John Vinson
• Re: Data type mismatch in criteria expression
  • From: John Vinson
• Re: Only retrieving first 50 records?!?
  • From: Marshall Barton
• Re: can i have a querie with a linked table
  • From: John Vinson
• Re: How can I calculate difference value
  • From: Randy Harris
• Re: Only retrieving first 50 records?!?
  • From: winsa
• Re: Enter MULTIPLE Items in a Query (e.g. [Name:] ??
  • From: kev100 via AccessMonster.com
• Re: criteria characters
  • From: ted medin
• Re: Query Dates for 12 months
  • From: Duane Hookom
• Re: Only retrieving first 50 records?!?
  • From: winsa
• Re: Need query to return all values including Nulls
  • From: Allen Browne
• Re: Union Query used for make-Table!
  • From: Tom Ellison
• Need query to return all values including Nulls
  • From: Randy
• Re: Data type mismatch in criteria expression
  • From: Wind54Surfer
• Re: SUBQUERIES in the FROM clause with Access query
  • From: Tom Ellison
• Re: Merging recordsets
  • From: Dale Fye
• Re: SUBQUERIES in the FROM clause with Access query
  • From: A.Q
• Re: criteria characters
  • From: ted medin
• Re: Date & Time Field
  • From: Dale Fye
• Re: Search critieria from Form
  • From: wazza_c12
• Re: Simple 4 field form query help needed
  • From: wazza_c12
• Re: Help! Help! Help!
  • From: Dale Fye
• Re: CONVERT A NUMBER TO TEXT
  • From: John Spencer
• Re: Search critieria from Form
  • From: Steve Schapel
• Re: CONVERT A NUMBER TO TEXT
  • From: Suzette
• Re: Simple 4 field form query help needed
  • From: Suzette
• Re: Search critieria from Form
  • From: wazza_c12
• Simple 4 field form query help needed
  • From: wazza_c12
• Re: Date & Time Field
  • From: Tom Ellison
• Re: can i have a querie with a linked table
  • From: John Vinson
• Date & Time Field
  • From: Diane Walker
• Re: SUBQUERIES in the FROM clause with Access query
  • From: Tom Ellison
• Using current record as query criteria
  • From: lab_eu
• Re: which is more efficent not in(' ',' ') or <>" " and <>" "
  • From: Tom Ellison
• Re: which is more efficent not in(' ',' ') or <>" " and <>" "
  • From: Douglas J. Steele
• Re: Merging recordsets
  • From: John Vinson
• Re: Update multible records from one table to another
  • From: John Vinson
• Re: SUBQUERIES in the FROM clause with Access query
  • From: A.Q
• Re: My query only shows results where all fields are have data entered
  • From: John Nurick
• Re: Urgent! Subquery help needed!
  • From: Randy Harris
• Re: Case When statement in ADP
  • From: Sylvain Lafontaine
• Re: Enbedded Select
  • From: CostReport101 via AccessMonster.com
• Re: Ten most recent records by date
  • From: Michel Walsh
• Re: Ten most recent records by date
  • From: John Spencer
• Re: Can't return all records
  • From: BruceM
• Re: Enbedded Select
  • From: Tom Ellison
• Re: Can't return all records
  • From: BruceM
• Re: Sum columns
  • From: Olden
• Re: In an access query, how do I set criteria for "most recent" da
  • From: Tom Ellison
• Re: Enbedded Select
  • From: CostReport101 via AccessMonster.com
• Re: Can't return all records
  • From: Tom Ellison
• Re: Split Records
  • From: Tom Ellison
• Re: In an access query, how do I set criteria for "most recent" da
  • From: dukejam
• Re: Querying by Primary Key SSN with Count
  • From: Tom Ellison
• Re: In an access query, how do I set criteria for "most recent" da
  • From: Tom Ellison
• Re: Enbedded Select
  • From: Tom Ellison
• Re: Date Query
  • From: John Spencer
• Re: First Record by Date
  • From: Marshall Barton
• Re: Using 'Like' to query related fields between tables
  • From: Tom Ellison
• Re: Using 'Like' to query related fields between tables
  • From: Marshall Barton
• Re: In an access query, how do I set criteria for "most recent" da
  • From: dukejam
• Re: Sort ignores apostrophe
  • From: Tom Ellison
• Re: Enter MULTIPLE Items in a Query (e.g. [Name:] ??
  • From: Tom Ellison
• Re: In an access query, how do I set criteria for "most recent" da
  • From: Tom Ellison
• Re: How do I use the Between . . . And Operator?
  • From: fredg
• Re: Date Query
  • From: SJJ via AccessMonster.com
• Re: Date Query
  • From: SJJ via AccessMonster.com
• Re: Specific Expression Help
  • From: John Spencer
• Re: Search critieria from Form
  • From: Steve Schapel
• RE: Urgent! Subquery help needed!
  • From: Gwen H
• Re: Cross-tab Criteria not evaluating
  • From: Duane Hookom
• Re: Urgent! Subquery help needed!
  • From: Gwen H
• Re: Case When statement in ADP
  • From: Greg Snidow
• Querying by Primary Key SSN with Count
  • From: Wendy Lee
• Re: Data type mismatch in criteria expression
  • From: John Vinson
• Split Records
  • From: Alec Green
• Enbedded Select
  • From: CostReport101 via AccessMonster.com
• Re: Cross-tab Criteria not evaluating
  • From: Juan Schwartz
• Can't return all records
  • From: BruceM
• Re: Cross-tab Criteria not evaluating
  • From: Duane Hookom
• Re: Append range of dates
  • From: Duane Hookom
• Cross-tab Criteria not evaluating
  • From: Juan Schwartz
• Re: Urgent! Subquery help needed!
  • From: OfficeDev18 via AccessMonster.com
• Re: UCase used in append query suddenly causing Undefined Function
  • From: KWeber
• Re: More Thoughts, but No Solution
  • From: OfficeDev18 via AccessMonster.com
• Re: which is more efficent not in(' ',' ') or <>" " and <>" "
  • From: John Spencer
• Re: How can I calculate difference value
  • From: Marshall Barton
• Re: Enter MULTIPLE Items in a Query (e.g. [Name:] ??
  • From: Duane Hookom
• Re: Help! Help! Help!
  • From: Gwen H
• Re: Enter MULTIPLE Items in a Query (e.g. [Name:] ??
  • From: rigby
• Re: Help! Help! Help!
  • From: Gwen H
• Re: Specific Expression Help
  • From: John Spencer
• Re: retrieve more than one record, but not all
  • From: Duane Hookom
• Re: Enter MULTIPLE Items in a Query (e.g. [Name:] ??
  • From: Duane Hookom
• Re: Newbie: Cross Tab. With Percentages ?
  • From: Duane Hookom
• Re: no. of days and month
  • From: Michel Walsh
• Re: How do I use the Between . . . And Operator?
  • From: [MVP] S.Clark
• Re: Rounding Numbers in queries
  • From: Michel Walsh
• Re: DateAdd in query
  • From: John Nurick
• Re: Sort ignores apostrophe
  • From: Michel Walsh
• Re: Monthly Totals
  • From: David M C
• Re: DateAdd in query
  • From: Wayne Morgan
• Re: How do I copy a PivotChart into a Powerpoint presentation?
  • From: [MVP] S.Clark
• Re: DateAdd in query
  • From: [MVP] S.Clark
• Re: Query Totals
  • From: [MVP] S.Clark
• Re: Invalid Argument Error Based off Append Query
  • From: [MVP] S.Clark
• Re: Parameter Query
  • From: Michel Walsh
• Re: Monthly Totals
  • From: Allen Browne
• Re: no. of days and month
  • From: John Spencer
• Re: Monthly Totals
  • From: David M C
• Re: Monthly Totals
  • From: David M C
• Re: How can I calculate difference value
  • From: John Spencer
• Re: Julian Date
  • From: red skelton via AccessMonster.com
• Re: Monthly Totals
  • From: Allen Browne
• Re: Monthly Totals
  • From: David M C
• Re: How can I add criteria of 2 fields not matching on a query
  • From: Van T. Dinh
• Re: no. of days and month
  • From: ismail
• Re: Joining 2 table
  • From: Vincent Johns
• Re: Query Help
  • From: SriRam
• Re: Calling parameterized query from ASP - which datatype constant to use?
  • From: Cinzia
• Re: Why does my USB hub forget?
  • From: Tom Ellison
• Calling parameterized query from ASP - which datatype constant to use?
  • From: Terry
• Why does my USB hub forget?
  • From: Dutchm@n
• RE: Please help
  • From: Ofer
• Re: Only retrieving first 50 records?!?
  • From: Marshall Barton
• Re: selecting part of a field after a blank space
  • From: Allen Browne
• Re: Data type mismatch in criteria expression
  • From: Wind54Surfer
• Re: create historical query
  • From: Marshall Barton
• Re: create historical query
  • From: John Vinson
• Re: Data type mismatch in criteria expression
  • From: John Vinson
• Re: Joining 2 table
  • From: ardi
• create historical query
  • From: ardi
• Re: Newbie: Cross Tab. With Percentages ?
  • From: Tom Ellison
• Keyword search across mutiple fields with different types
  • From: Terry
• Re: Calculate time lapsed between two records
  • From: Tom Ellison
• Re: Add sequential number to a query
  • From: aaron . kempf
• Re: How can I calculate difference value
  • From: Marshall Barton
• Re: Enter MULTIPLE Items in a Query (e.g. [Name:] ??
  • From: kev100 via AccessMonster.com
• Re: Adding info to query
  • From: mjj4golf
• Newbie: Cross Tab. With Percentages ?
  • From: richmarin
• Re: Adding info to query
  • From: mjj4golf
• Re: Query Dates for 12 months
  • From: D. M.
• Re: Adding info to query
  • From: mjj4golf
• Keyword search across mutiple fields with different types
  • From: Terry
• Re: How Do I Get a Dynamic "Single Person" Report in Access 2003?
  • From: John Vinson
• Re: Enter MULTIPLE Items in a Query (e.g. [Name:] ??
  • From: Duane Hookom
• Re: Query Dates for 12 months
  • From: Duane Hookom
• Re: Adding info to query
  • From: Tom Ellison
• RE: Adding info to query
  • From: mjj4golf
• Re: Date Query
  • From: John Vinson
• RE: Adding info to query
  • From: mjj4golf
• RE: Please help
  • From: Marchos
• Re: Using a Union Query to get an average
  • From: Tom Ellison
• Re: Enter MULTIPLE Items in a Query (e.g. [Name:] ??
  • From: kev100 via AccessMonster.com
• Re: Using a Union Query to get an average
  • From: David McKnight
• Re: Enter MULTIPLE Items in a Query (e.g. [Name:] ??
  • From: John Spencer
• Re: Enter MULTIPLE Items in a Query (e.g. [Name:] ??
  • From: kev100 via AccessMonster.com
• RE: Adding info to query
  • From: Ofer
• Re: Using a Union Query to get an average
  • From: Dale Fye
• Re: Using a Union Query to get an average
  • From: Tom Ellison
• RE: Adding info to query
  • From: mjj4golf
• RE: Adding info to query
  • From: mjj4golf
• Re: Query Dates for 12 months
  • From: D. M.
• Re: no. of days and month
  • From: Tom Ellison
• Re: Query Dates for 12 months
  • From: Duane Hookom
• Re: number records in a group, within access query
  • From: Ken Snell \(MVP\)
• Re: Exporting Query Results to HTML - Tag Bloat
  • From: Duane Hookom
• Re: Exporting Query Results to HTML - Tag Bloat
  • From: John Nurick
• Re: no. of days and month
  • From: Jeff Boyce
• Test Message
  • From: Stryker22150
• RE: Please help
  • From: Marchos
• Exporting Query Results to HTML - Tag Bloat
  • From: Paul Proefrock
• Re: Query Dates for 12 months
  • From: Duane Hookom
• Re: Date Query
  • From: John Spencer
• RE: Please help
  • From: Ofer
• Re: no. of days and month
  • From: ismail
• Test Message
  • From: Stryker22150
• Test Message
  • From: Stryker
• Test
  • From: Stryker
• Re: Crosstab Value field formula too long, min() and max() function help sought
  • From: Duane Hookom
• Re: Syntax error (missing operator) in query expression
  • From: Wind54Surfer
• Re: Enter MULTIPLE Items in a Query (e.g. [Name:] ??
  • From: Duane Hookom
• Re: Syntax error (missing operator) in query expression
  • From: Duane Hookom
• RE: Adding info to query
  • From: mjj4golf
• RE: Adding info to query
  • From: Ofer
• Re: no. of days and month
  • From: Jeff Boyce
• RE: Adding info to query
  • From: mjj4golf
• Re: Between Dates and Times
  • From: westdr1dw@xxxxxxxxx
• Re: Sort based on data from 2 fields?
  • From: Cinzia
• Re: Drop down list in a Query
  • From: Jeff Boyce
• RE: Adding info to query
  • From: Ofer
• Re: Sort based on data from 2 fields?
  • From: Jeff Boyce
• Re: Between Dates and Times
  • From: Rick Brandt
• Re: Between Dates and Times
  • From: westdr1dw@xxxxxxxxx
• Re: Crosstab Value field formula too long, min() and max() function help sought
  • From: nclsgna via AccessMonster.com
• RE: Adding info to query
  • From: mjj4golf
• Re: Update only 1 row
  • From: ZippyV
• Re: Between Dates and Times
  • From: westdr1dw@xxxxxxxxx
• Re: Between Dates and Times
  • From: westdr1dw@xxxxxxxxx
• Re: Date Query
  • From: SJJ via AccessMonster.com
• Drop down list in a Query
  • From: DJ
• Query Totals
  • From: westdr1dw@xxxxxxxxx
• Re: Date Query
  • From: John Vinson
• Re: Enter MULTIPLE Items in a Query (e.g. [Name:] ??
  • From: kev100 via AccessMonster.com
• RE: Adding info to query
  • From: Ofer
• Re: Enter MULTIPLE Items in a Query (e.g. [Name:] ??
  • From: kev100 via AccessMonster.com
• Re: Enter MULTIPLE Items in a Query (e.g. [Name:] ??
  • From: Tom Ellison
• Re: multiply entire column of cells by .315
  • From: J
• Re: Enter MULTIPLE Items in a Query (e.g. [Name:] ??
  • From: Duane Hookom
• Enter MULTIPLE Items in a Query (e.g. [Name:] ??
  • From: kev100 via AccessMonster.com
• Re: Between Dates and Times
  • From: John Spencer
• Re: Filter for THIS WEEK only
  • From: Kathy Webster
• Re: Keyword search
  • From: Terry
• RE: Adding info to query
  • From: mjj4golf
• Re: Keyword search
  • From: Tom Ellison
• Re: Update records based on instr
  • From: Tom Ellison
• Re: Update only 1 row
  • From: Tom Ellison
• Re: number records in a group, within access query
  • From: Ken Snell \(MVP\)
• RE: Adding info to query
  • From: Ofer
• RE: Adding info to query
  • From: Ofer
• Re: Update only 1 row
  • From: ZippyV
• Re: Between Dates and Times
  • From: Douglas J. Steele
• Keyword search
  • From: Terry
• Re: Between Dates and Times
  • From: John Spencer
• Re: sorting a calculated numeric field
  • From: Paul Ponzelli
• Re: philips toUcam pro ii
  • From: Vincent Johns
• Re: Between Dates and Times
  • From: Marshall Barton
• Re: Between Dates and Times
  • From: Jeff Boyce
• Re: Between Dates and Times
  • From: Rick Brandt
• Re: Between Dates and Times
  • From: Tom Lake
• Re: Join Types
  • From: Steve Schapel
• Re: How do I transpose a table so that rows become columns?
  • From: Duane Hookom
• Re: How do I transpose a table so that rows become columns?
  • From: Duane Hookom
• Re: Join Types
  • From: Rick Brandt
• Re: Recomendation for a reference source
  • From: Marshall Barton
• Re: Date Query
  • From: SJJ via AccessMonster.com
• Re: no. of days and month
  • From: Jeff Boyce
• Re: Need help with averaging all values which are NOT null
  • From: Jeff Boyce
• Re: Help! Help! Help!
  • From: Dale Fye
• Re: Many answers to one question, link to another query...
  • From: Vincent Johns
• Re: Filter for THIS WEEK only
  • From: Gary Walter
• Re: Make queries read only?
  • From: Chuck Arbogast
• Re: Need help with averaging all values which are NOT null
  • From: NC_Sue
• Re: Update query to a linked Excel table
  • From: Daniel
• Re: Make queries read only?
  • From: John Vinson
• Re: Replace null with "0" in expression
  • From: John Vinson
• Re: can i have a querie with a linked table
  • From: John Vinson
• Re: Make queries read only?
  • From: Allen Browne
• Make queries read only?
  • From: Chuck Arbogast
• Re: sorting a calculated numeric field
  • From: Allen Browne
• Re: Need help with averaging all values which are NOT null
  • From: Jeff Boyce
• sorting a calculated numeric field
  • From: Paul Ponzelli
• Re: UCase used in append query suddenly causing Undefined Function err
  • From: fredg
• Re: SUBQUERIES in the FROM clause with Access query
  • From: Tom Ellison
• Re: Update only 1 row
  • From: Tom Ellison
• Re: Update only 1 row
  • From: Douglas J. Steele
• Update only 1 row
  • From: ZippyV
• Re: Case When statement in ADP
  • From: Sylvain Lafontaine
• Re: In an access query, how do I set criteria for "most recent" date?
  • From: Tom Ellison
• Re: Help! Help! Help!
  • From: Randy Harris
• Re: Sum columns
  • From: John Spencer
• Re: date query
  • From: Marshall Barton
• Re: Sum columns
  • From: Marshall Barton
• Re: date query
  • From: John Spencer
• Re: Left Join not working properly
  • From: John Spencer
• Sum columns
  • From: Olden
• Re: Left Join not working properly
  • From: iTISTIC
• date query
  • From: Tim via AccessMonster.com
• Re: Search critieria from Form
  • From: Steve Schapel
• Re: Converting Text to Date
  • From: Ess
• Re: Converting Text to Date
  • From: Ess
• Re: Why is my query sorting like this
  • From: John Spencer
• Re: Converting Text to Date
  • From: John Spencer
• Re: totals
  • From: John Spencer
• Re: More Thoughts, but No Solution
  • From: Jay
• Re: Need To Exclude Certain Zip Codes
  • From: Steve Schapel
• Re: Filter for THIS WEEK only
  • From: Kathy Webster
• Re: Filter for THIS WEEK only
  • From: Dale Fye
• Re: Search critieria from Form
  • From: Steve Schapel
• Re: Why is my query sorting like this
  • From: Keith Leslein
• Re: How do I restrict the query to exclude items?
  • From: tina
• Re: Why is my query sorting like this
  • From: Steve Schapel
• Re: Filter for THIS WEEK only
  • From: Kathy Webster
• Re: Filter for THIS WEEK only
  • From: Kathy Webster
• Re: Replace null with "0" in expression
  • From: John Vinson
• Re: Access Help: Primary key and SQL statement
  • From: John Vinson
• Re: Replace null with "0" in expression
  • From: [MVP] S.Clark
• Re: totals
  • From: Melissa needing help!!
• Re: Filter for THIS WEEK only
  • From: Allen Browne
• Re: can i have a querie with a linked table
  • From: John Vinson
• Re: Filter for THIS WEEK only
  • From: Kathy Webster
• Re: Case When statement in ADP
  • From: [MVP] S.Clark
• Re: More Thoughts, but No Solution
  • From: OfficeDev18 via AccessMonster.com
• Re: Access Help: Primary key and SQL statement
  • From: Roger Carlson
• Re: Replace null with "0" in expression
  • From: Keith Leslein
• More Thoughts, but No Solution
  • From: Jay
• Invalid Argument Error Based off Append Query
  • From: gekko97
• Re: Extract one string from another
  • From: John Spencer
• Re: Many answers to one question, link to another query...
  • From: John Spencer
• Re: Complex Querys using instances of tables
  • From: Francis
• Re: Converting Text to Date
  • From: John Spencer
• Re: how do I find unmatched records from two tables?
  • From: John Spencer
• Solved Month Issue, Still Working on Week
  • From: Jay
• Extract one string from another
  • From: Leslie Isaacs
• Re: DLOOKUP FOR NEXT
  • From: shar
• Re: Many answers to one question, link to another query...
  • From: Vincent Johns
• Date Range Question
  • From: Jay
• Re: Switch from Rows to Columns
  • From: Duane Hookom
• Re: totals
  • From: Vincent Johns
• Re: Clueless newbie desperately seeking help.
  • From: Duane Hookom
• Re: Delet query using another table
  • From: John Spencer
• Re: totals
  • From: John Spencer
• Re: Clueless newbie desperately seeking help.
  • From: Jeff
• Re: DLOOKUP FOR NEXT
  • From: Marshall Barton
• Re: Need help with averaging all values which are NOT null
  • From: NC_Sue
• Re: Complex Querys using instances of tables
  • From: Francis
• Re: Need help with averaging all values which are NOT null
  • From: Jeff Boyce
• Re: Switch from Rows to Columns
  • From: saschamps9903
• Re: Page numbering in export to PDF
  • From: Rick Brandt
• Re: Multiple column headers in crosstab?
  • From: Spaan
• Re: DLOOKUP FOR NEXT
  • From: shar
• Re: Complex Querys using instances of tables
  • From: Francis
• Re: Crosstab Value field formula too long, min() and max() function help sought
  • From: Duane Hookom
• Re: Multiple column headers in crosstab?
  • From: Tom Ellison
• Re: Query problem
  • From: John Spencer
• Re: Problens with query?
  • From: Allen Browne
• Re: criteria characters
  • From: John Spencer
• Re: Crosstab Value field formula too long, min() and max() function help sought
  • From: nclsgna via AccessMonster.com
• Re: Crosstab query for Aged Analysis Error
  • From: John Spencer
• RE: Crosstab query for Aged Analysis Error
  • From: nclsgna via AccessMonster.com
• RE: Crosstab query for Aged Analysis Error
  • From: nclsgna via AccessMonster.com
• Re: Multiple column headers in crosstab?
  • From: Spaan
• Re: Export File Title
  • From: Tom Ellison
• Re: Query Help
  • From: Tom Ellison
• Query Help
  • From: SriRam
• Re: Multiple column headers in crosstab?
  • From: Tom Ellison
• Re: criteria characters
  • From: John Nurick
• Re: Filter for THIS WEEK only
  • From: Allen Browne
• Re: Filter for THIS WEEK only
  • From: Kathy Webster
• Re: Clueless newbie desperately seeking help.
  • From: Duane Hookom
• Re: Alternate, more graphical, help facilities?
  • From: Chris2
• RE: Query data calculation/conversion?
  • From: freakazeud
• Re: Filter for THIS WEEK only
  • From: Allen Browne
• Re: key violations in append query: please help
  • From: Patrick Stubbin
• Re: Need to Pull Records Based on First 3 Digits Of Zip Code
  • From: Frederick Wilson
• Re: key violations in append query: please help
  • From: Ken Snell \(MVP\)
• Re: Trouble with designing a query
  • From: John Vinson
• Re: Duplicate Description Field
  • From: John Welch
• Re: Dlookup Issue in Query Criteria
  • From: John Vinson
• Re: Add a column to a table with info from another table
  • From: CostReport101
• Re: How do I restrict the query to exclude items?
  • From: John Vinson
• Export File Title
  • From: LJG
• Re: can i have a querie with a linked table
  • From: John Vinson
• Re: Query problem
  • From: [MVP] S.Clark
• Re: criteria characters
  • From: ted medin
• Re: Page numbering in export to PDF
  • From: [MVP] S.Clark
• Duplicate Description Field
  • From: Diane Walker
• Re: Switch from Rows to Columns
  • From: Duane Hookom
• Re: Semi-Annual Totals from Database
  • From: Chris
• Re: Dlookup Issue in Query Criteria
  • From: Tom Lake
• Re: Add a column to a table with info from another table
  • From: Marshall Barton
• Re: Problem with delete duplicates query
  • From: Tracey
• Re: Add a column to a table with info from another table
  • From: Vincent Johns
• Re: criteria characters
  • From: Marshall Barton
• Re: Switch from Rows to Columns
  • From: saschamps9903
• Re: DLOOKUP FOR NEXT
  • From: Marshall Barton
• Re: criteria characters
  • From: John Spencer
• Re: Problem with delete duplicates query
  • From: Vincent Johns
• Re: Problem with delete duplicates query
  • From: Tracey
• Re: How do I restrict the query to exclude items?
  • From: tina
• Re: Trouble with designing a query
  • From: John Vinson
• Re: based on a suspense date how can I get future dates to send remind
  • From: John Vinson
• Re: can i have a querie with a linked table
  • From: John Vinson
• Re: query brings up wrong dates
  • From: John Vinson
• Re: Need to Pull Records Based on First 3 Digits Of Zip Code
  • From: Wayne Morgan
• Re: Query on text field with multiple spaces within the string
  • From: AndyB
• Add a column to a table with info from another table
  • From: CostReport101
• Re: Query Update Question - Current Record
  • From: John Vinson
• criteria characters
  • From: mmap hq
• Re: Adding Time
  • From: Kathy Webster
• Re: Query and mail merge
  • From: Steve Schapel
• Re: Variable = QueryField
  • From: Ray Todd
• Re: DateSerial; DateAdd
  • From: Chris
• Re: dcount with more than one criteria
  • From: Vjeran
• Re: Filter for THIS WEEK only
  • From: Kathy Webster
• Crosstab query for Aged Analysis Error
  • From: nclsgna via AccessMonster.com
• Re: Filter for THIS WEEK only
  • From: Kathy Webster
• Re: query brings up wrong dates
  • From: Wayne Morgan
• Re: I need a database guru.
  • From: [MVP] S.Clark
• Re: Values in a query ready for export to Excel
  • From: Rick Brandt
• Values in a query ready for export to Excel
  • From: Martin Hopkins
• Re: Adding Time
  • From: Wayne Morgan
• Adding Time
  • From: Kathy Webster
• Re: Nested IIf Statement
  • From: jkb66
• Re: Variable = QueryField
  • From: John Welch
• Re: Variable = QueryField
  • From: Rick Brandt
• Re: Query Conditionally Across Two Tables
  • From: Gman
• Re: Query Help
  • From: John Welch
• Re: DateSerial; DateAdd
  • From: John Spencer
• Re: what criteria will select a blank in a date/time field?
  • From: Duane Hookom
• Re: Query Conditionally Across Two Tables
  • From: John Spencer
• Re: Monthly Totals
  • From: Allen Browne
• Re: DoCMD.RunSQL with data that has a ' in it
  • From: Allen Browne
• Re: Monthly Totals
  • From: John Spencer
• Re: Nested IIf Statement
  • From: Duane Hookom
• Re: Nested IIf Statement
  • From: John Spencer
• Re: Query Update Question - Current Record
  • From: Rich S.
• DoCMD.RunSQL with data that has a ' in it
  • From: Jordan
• Re: Query Conditionally Across Two Tables
  • From: Gman
• Query Conditionally Across Two Tables
  • From: Gman
• Re: Help with cumulative totals by date
  • From: John Nurick
• Re: Problem with delete duplicates query
  • From: Vincent Johns
• Re: Nested IIf Statement
  • From: jkb66
• Re: Switch from Rows to Columns
  • From: Duane Hookom
• Re: Query Criteria Null Values
  • From: John Spencer
• Re: Switch from Rows to Columns
  • From: saschamps9903
• Re: Nested IIf Statement
  • From: Duane Hookom
• Re: Parameter Query with Drop-down Box
  • From: Allen Browne
• Re: Functions in Access 2000 not in Access 2003
  • From: mcl
• Re: 2nd Post for database guru.
  • From: Duane Hookom
• Re: Finding duplicates that might differ slightly
  • From: KBuser
• Re: Parameter Query with Drop-down Box
  • From: Travis
• Re: Help with my PC
  • From: Wayne Morgan
• Re: Query Help
  • From: Karen
• Re: Parameter query......query!
  • From: Jerry Whittle
• Re: Help with my PC
  • From: Jeff Boyce
• Re: Help with my first Delete Query
  • From: Dave
• Re: Trouble with designing a query
  • From: Electricman
• Query Criteria Null Values
  • From: Michael
• Re: Help with my first Delete Query
  • From: John Spencer
• Re: Complex Querys using instances of tables
  • From: John Spencer
• Re: dcount with more than one criteria
  • From: John Spencer
• Re: Parameter Query with Drop-down Box
  • From: aznan
• Re: Parameter query......query!
  • From: k . roberts
• Re: DLOOKUP FOR NEXT
  • From: shar
• Re: WHERE clause returns A and B, but not A and C
  • From: John Spencer
• Help with my first Delete Query
  • From: Dave
• Re: dcount with more than one criteria
  • From: Vjeran
• RE: Output Query to Excel
  • From: Jerry Whittle
• RE: Parameter query......query!
  • From: Jerry Whittle
• Parameter query......query!
  • From: k . roberts
• RE: Return Multiple Values via Subquery
  • From: Peter Yang [MSFT]
• Output Query to Excel
  • From: Frederick Wilson
• Complex Querys using instances of tables
  • From: Francis
• dcount with more than one criteria
  • From: Vjeran
• Re: Return Multiple Values via Subquery
  • From: Allen Browne
• Re: Can I use drop down boxes for a prompt in a query?
  • From: John Nurick
• Re: Finding duplicates that might differ slightly
  • From: John Nurick
• Re: based on a suspense date how can I get future dates to send remind
  • From: John Vinson
• Re: View contents of a folder
  • From: John Nurick
• Re: "Too Many Rows to Output" message
  • From: Van T. Dinh
• Re: Date Comparison Query
  • From: Tom Ellison
• Re: Date Comparison Query
  • From: Tom Ellison
• Re: Date Comparison Query
  • From: John Vinson
• Re: Trouble with designing a query
  • From: John Vinson
• Re: Date Comparison Query
  • From: El Gordo
• Re: Query Update Question - Current Record
  • From: John Vinson
• Re: Date Comparison Query
  • From: Tom Ellison
• Re: Filter for THIS WEEK only
  • From: Dale Fye
• Re: WHERE clause returns A and B, but not A and C
  • From: Tom Ellison
• Re: I need a database guru.
  • From: Jeff
• Re: Filter for THIS WEEK only
  • From: Allen Browne
• Re: Switch from Rows to Columns
  • From: Duane Hookom
• Re: Can I use drop down boxes for a prompt in a query?
  • From: Duane Hookom
• Re: View contents of a folder
  • From: Dale Fye
• Re: Parameter Query with Drop-down Box
  • From: Allen Browne
• Re: Type Mismatch
  • From: Lauri
• Re: Type Mismatch
  • From: MGFoster
• Date Comparison Query
  • From: El Gordo
• Re: "Too Many Rows to Output" message
  • From: [MVP] S.Clark
• Re: Creating a query to append new data as well as deleting old data
  • From: [MVP] S.Clark
• Re: Update item numbers from another table
  • From: [MVP] S.Clark
• Re: I need a database guru.
  • From: [MVP] S.Clark
• Re: EXPORT A PIVOT CHART
  • From: [MVP] S.Clark
• Re: Query is not doing what it's supposed to be doing!
  • From: Tatakau
• Re: Query - Look up one value, show another, input look up value
  • From: Marshall Barton
• Filter for THIS WEEK only
  • From: Kathy Webster
• Re: DLOOKUP FOR NEXT
  • From: Marshall Barton
• Re: Query on text field with multiple spaces within the string
  • From: John Nurick
• Re: Trouble with designing a query
  • From: John Welch
• Type Mismatch
  • From: Lauri
• Re: Query Help
  • From: John Welch
• Re: Query Help
  • From: John Vinson
• Re: Switch from Rows to Columns
  • From: John Vinson
• Re: Switch from Rows to Columns
  • From: Duane Hookom
• Re: Can I use drop down boxes for a prompt in a query?
  • From: Duane Hookom
• Re: Numbers from query concactinate when added in Report
  • From: Duane Hookom
• Re: Switch from Rows to Columns
  • From: Duane Hookom
• Re: can I create a function to display the lower of two fields?
  • From: John Welch
• Re: formula
  • From: John Vinson
• Re: Functions in Access 2000 not in Access 2003
  • From: John Vinson
• Re: sorting by everything after last space
  • From: John Vinson
• Re: Finding duplicates that might differ slightly
  • From: KBuser
• Re: Left Join not working properly
  • From: iTISTIC
• Re: Query with info from a form
  • From: John Vinson
• Re: formula
  • From: John Spencer
• Re: if statement in criteria
  • From: John Vinson
• Re: sorting by everything after last space
  • From: John Spencer
• Re: Creating a sucessful query?
  • From: John Spencer
• Re: Left Join not working properly
  • From: John Spencer
• Numbers from query concactinate when added in Report
  • From: Juan Schwartz
• Re: Left Join not working properly
  • From: iTISTIC
• Re: Functions in Access 2000 not in Access 2003
  • From: Duane Hookom
• Re: blank line in a query for blank lines in a report
  • From: Duane Hookom
• Re: DLOOKUP FOR NEXT
  • From: shar
• Re: Left Join not working properly
  • From: John Welch
• Re: Query on text field with multiple spaces within the string
  • From: AndyB
• Functions in Access 2000 not in Access 2003
  • From: mcl
• Re: Help combining records for people at same address
  • From: John Vinson
• Re: How to handle Intersection in access?
  • From: John Vinson
• Re: Finding duplicates that might differ slightly
  • From: KBuser
• Re: Finding duplicates that might differ slightly
  • From: Jeff Boyce
• Re: View contents of a folder
  • From: kremesch
• Re: blank line in a query for blank lines in a report
  • From: Sandi
• Re: Creating a sucessful query?
  • From: John Spencer
• Re: WHERE clause returns A and B, but not A and C
  • From: John Spencer
• Finding duplicates that might differ slightly
  • From: KBuser
• Re: DLOOKUP FOR NEXT
  • From: Marshall Barton
• Re: DLOOKUP FOR NEXT
  • From: John Spencer
• Re: Query with info from a form
  • From: consjoe
• Re: Query on text field with multiple spaces within the string
  • From: John Nurick
• Re: SQL Question
  • From: John Vinson
• Re: blank line in a query for blank lines in a report
  • From: Sandi
• Re: Help combining records for people at same address
  • From: Duane Hookom
• Re: Left Join not working properly
  • From: John Spencer
• Re: Left Join not working properly
  • From: iTISTIC
• Re: if statement in criteria
  • From: John Vinson
• Re: How do I use query
  • From: John Vinson
• Re: Query with info from a form
  • From: OfficeDev18 via AccessMonster.com
• Re: field is cut off
  • From: Duane Hookom
• Re: Left Join not working properly
  • From: iTISTIC
• Re: Help combining records for people at same address
  • From: Marshall Barton
• Re: How to handle Intersection in access?
  • From: John Spencer
• Re: field is cut off
  • From: Gail
• Re: Left Join not working properly
  • From: Van T. Dinh
• Re: Create a text string from multiple records in the same field.
  • From: Michael
• Re: Multiple sort orders on one report
  • From: Van T. Dinh
• Re: Update query help
  • From: Van T. Dinh
• Re: Left Join not working properly
  • From: iTISTIC
• Re: Left Join not working properly
  • From: iTISTIC
• Multiple sort orders on one report
  • From: CaroKannDefence via AccessMonster.com
• Re: blank line in a query for blank lines in a report
  • From: Duane Hookom
• Update query help
  • From: Mikael
• RE: How do I use query
  • From: Ofer
• Re: How do i set up queries for child with most popular books? HELP PL
  • From: Jeff Boyce
• blank line in a query for blank lines in a report
  • From: Sandi
• Re: How to handle Intersection in access?
  • From: John Spencer
• Re: How do i set up queries for child with most popular books? HELP PL
  • From: Rick B
• Re: update query
  • From: Vjeran
• Re: update query
  • From: John Spencer
• Re: update query
  • From: Jeff Boyce
• RE: How do I use query
  • From: Melissa needing help!!
• Re: update query
  • From: Vjeran
• SQL Question
  • From: spokane29
• Re: Query - Hiding Repeated fields
  • From: Vincent Johns
• Re: Access Make table quiries problem
  • From: Allen Browne
• Re: How to display the Parameters in a query in a form/report/page
  • From: Van T. Dinh
• Re: Week Numbers
  • From: ianc
• Re: update query
  • From: Vjeran
• Re: Please Help...... KRISH
  • From: Tom Ellison
• Re: Left Join not working properly
  • From: John Welch
• Re: Please Help...... KRISH
  • From: Allen Browne
• Re: Parameter Query with Drop-down Box
  • From: Brian Bastl
• Re: Parameter Query with Drop-down Box
  • From: Allen Browne
• Re: Help with query, possible crosstab
  • From: joshblair
• Re: Another sequential query field problem... are you out the Duan
  • From: Duane Hookom
• Re: update query
  • From: Jeff Boyce
• Re: Left Join not working properly
  • From: Van T. Dinh
• Re: Frustrated by "Invalid use of Null"
  • From: Allen Browne
• Re: Append Query
  • From: John Vinson
• Re: how do i specify search criteria for a range
  • From: Allen Browne
• Re: Left Join not working properly
  • From: iTISTIC
• Re: Not a Valid Password Error
  • From: Van T. Dinh
• Re: Performing multiple queries in Access
  • From: Tom Ellison
• Re: Semi-Annual Totals from Database
  • From: Steve Schapel
• Re: how do i specify search criteria for a range
  • From: fredg
• Re: View contents of a folder
  • From: Dale Fye
• Re: Urgent: Please help!
  • From: Van T. Dinh
• Re: Records Not Found
  • From: Van T. Dinh
• Re: Append Query
  • From: jimmy . kirk
• Append Query
  • From: jimmy . kirk
• Re: Help with query, possible crosstab
  • From: Duane Hookom
• Re: if statement in criteria
  • From: John Vinson
• Re: Help with query, possible crosstab
  • From: joshblair
• Re: Character Limit in Query Design Criteria
  • From: John Vinson
• Re: Create a text string from multiple records in the same field.
  • From: Van T. Dinh
• Re: Character Limit in Query Design Criteria
  • From: Duane Hookom
• Re: Urgent: Please help!
  • From: John Vinson
• Re: Urgent: Please help!
  • From: AccessHelp
• Re: Create a text string from multiple records in the same field.
  • From: Duane Hookom
• Re: Help with query, possible crosstab
  • From: Duane Hookom
• Re: Not a Valid Password Error
  • From: Van T. Dinh
• RE: How do I use query
  • From: Ofer
• Re: Week Numbers
  • From: Duane Hookom
• Re: Help with query, possible crosstab
  • From: Duane Hookom
• Re: Records Not Found
  • From: Van T. Dinh
• Re: Urgent: Please help!
  • From: Van T. Dinh
• Re: Help with query, possible crosstab
  • From: Douglas J. Steele
• Re: How do I use query
  • From: Marshall Barton
• Create a text string from multiple records in the same field.
  • From: Michael
• Re: Another sequential query field problem... are you out the Duane Ho
  • From: Duane Hookom
• Re: Having trouble getting DELETE Query to work...
  • From: Marshall Barton
• Re: checking if month is missing
  • From: Bob
• Re: Urgent: Please help!
  • From: John Vinson
• Re: LINK TABLE Problem?
  • From: John Vinson
• Re: Setting up Queries
  • From: John Vinson
• Re: DataAdd is giving a Data mismatch error
  • From: Eli
• Re: How do I use query
  • From: John Vinson
• Re: DataAdd is giving a Data mismatch error
  • From: Eli
• Re: determining age in peoplesoft query
  • From: jazdwit07
• Re: Week Numbers
  • From: ianc
• RE: How do I use query
  • From: Melissa needing help!!
• RE: How do I use query
  • From: Ofer
• RE: How do I use query
  • From: Melissa needing help!!
• Re: determining age in peoplesoft query
  • From: Rick B
• Re: Why this query does not return any record?
  • From: John Vinson
• Re: determining age in peoplesoft query
  • From: John Vinson
• Re: Date calculation query
  • From: fredg
• Re: How do I use query
  • From: Marshall Barton
• Re: Help with query, possible crosstab
  • From: joshblair
• Re: Counting Within Ranges
  • From: Don
• Re: Query is not doing what it's supposed to be doing!
  • From: OfficeDev18 via AccessMonster.com
• Re: Counting Within Ranges
  • From: Don
• Re: Cascading Combo Boxes
  • From: gz
• Re: Left Join not working properly
  • From: OfficeDev18 via AccessMonster.com
• Re: Help with query, possible crosstab
  • From: Douglas J. Steele
• Re: Left Join not working properly
  • From: John Welch
• Re: Why this query does not return any record?
  • From: gz
• Re: Cascading Combo Boxes
  • From: Allen Browne
• Re: Why this query does not return any record?
  • From: John Spencer
• Help with query, possible crosstab
  • From: joshblair
• Re: Cascading Combo Boxes
  • From: gz
• Cascading Combo Boxes
  • From: Dorianne J via AccessMonster.com
• Why this query does not return any record?
  • From: gz
• Re: Easy ?
  • From: Ben
• determining age in peoplesoft query
  • From: jazdwit07
• Re: Exporting access report/query to excel
  • From: siddharth147@xxxxxxxxx
• Re: Counting Within Ranges
  • From: Don
• Re: Having trouble getting DELETE Query to work...
  • From: Marshall Barton
• Re: Query is not doing what it's supposed to be doing!
  • From: Tatakau
• Re: Problem with delete duplicates query
  • From: Tracey
• Left Join not working properly
  • From: iTISTIC
• Re: Date calculation query
  • From: rigby
• Re: combo boxes
  • From: Francis
• Re: update query
  • From: Vjeran
• Re: update query
  • From: Jeff Boyce
• Re: How to obtain the table name in a join?
  • From: Jeff Boyce
• Re: Week Numbers
  • From: Duane Hookom
• Re: Counting Within Ranges
  • From: Duane Hookom
• Re: Roll up values in an Access query
  • From: Jeff Boyce
• Re: automatic warning popup!!!
  • From: Jeff Boyce
• Re: Date calculation query
  • From: Van T. Dinh
• Re: How to obtain the table name in a join?
  • From: Van T. Dinh
• Re: Date calculation query
  • From: Vjeran
• Counting Within Ranges
  • From: Don
• RE: Having trouble getting DELETE Query to work...
  • From: Johanna
• RE: Having trouble getting DELETE Query to work...
  • From: Johanna
• RE: Having trouble getting DELETE Query to work...
  • From: Johanna
• update query
  • From: Vjeran
• Re: Julian Date
  • From: red skelton via AccessMonster.com
• Re: Queries with ODBC tables
  • From: John Vinson
• Re: checking if month is missing
  • From: Duane Hookom
• Re: Master Fields
  • From: John Vinson
• Re: Semi-Annual Totals from Database
  • From: Steve Schapel
• Re: Semi-Annual Totals from Database
  • From: Marshall Barton
• Re: Having trouble getting DELETE Query to work...
  • From: Marshall Barton
• Re: Semi-Annual Totals from Database
  • From: Chris
• Append New Records
  • From: jimmy . kirk
• Re: checking if month is missing
  • From: Bob
• Re: random sort query
  • From: John Vinson
• Re: Date format
  • From: John Vinson
• Re: random sort
  • From: John Vinson
• Re: checking if month is missing
  • From: Duane Hookom
• Re: Alternate, more graphical, help facilities?
  • From: Steve Schapel
• checking if month is missing
  • From: Bob
• Re: Master Fields
  • From: Duane Hookom
• Re: split full name(last, first) to last name and first name fields
  • From: John Spencer
• Re: Alternate, more graphical, help facilities?
  • From: Rick Brandt
• Re: Suppressing messages, but logging them too.
  • From: John Vinson
• Re: Alternate, more graphical, help facilities?
  • From: ITMA
• Re: Rounding Numbers in queries
  • From: John Spencer
• Re: Alternate, more graphical, help facilities?
  • From: Vincent Johns
• Re: Alternate, more graphical, help facilities?
  • From: Rick Brandt
• Re: User defined function in SQL statement
  • From: robert d via AccessMonster.com
• Re: split full name(last, first) to last name and first name fields
  • From: Eric D via AccessMonster.com
• Re: split full name(last, first) to last name and first name fields
  • From: Ken Snell \(MVP\)
• Date format
  • From: Alex Martinez
• Re: combo boxes
  • From: Brian Bastl
• Re: Alternate, more graphical, help facilities?
  • From: ITMA
• Re: combo boxes
  • From: Brian Bastl
• Re: missing records - relationship problem?
  • From: Nutmeg
• Re: User defined function in SQL statement
  • From: Vincent Johns
• Re: combo boxes
  • From: Vincent Johns
• Re: User defined function in SQL statement
  • From: robert d via AccessMonster.com
• Re: User defined function in SQL statement
  • From: robert d via AccessMonster.com
• Re: Date Math to Milliseonds
  • From: Vincent Johns
• Re: Date Math to Milliseonds
  • From: Allen Browne
• Re: counting the number of responses
  • From: Duane Hookom
• Re: IIf help
  • From: Duane Hookom
• IIf help
  • From: jimmy . kirk
• Re: Alternate, more graphical, help facilities?
  • From: Vincent Johns
• combo boxes
  • From: Francis
• Re: Searching two tables that may contain the requested "Order Number"
  • From: Allen Browne
• Re: Suppressing messages, but logging them too.
  • From: Jeff Boyce
• Re: Moving data from one table to another
  • From: Jeff Boyce
• Re: Executing Multiple Queries
  • From: Jeff Boyce
• Alternate, more graphical, help facilities?
  • From: ITMA
• Re: counting the number of responses
  • From: Vincent Johns
• Re: counting the number of responses
  • From: sdg8481
• Re: User defined function in SQL statement
  • From: Vincent Johns
• Re: User defined function in SQL statement
  • From: Allen Browne
• Re: User defined function in SQL statement
  • From: robert d via AccessMonster.com
• How to include double quotes in an expression
  • From: BRC
• Re: User defined function in SQL statement
  • From: robert d via AccessMonster.com
• Re: User defined function in SQL statement
  • From: Vincent Johns
• Re: Problem with Dual subselect
  • From: Vincent Johns
• Re: User defined function in SQL statement
  • From: robert d via AccessMonster.com
• Re: how to query table by last 20 dates for each contact ID
  • From: scrappydue
• Re: how to query table by last 20 dates for each contact ID
  • From: scrappydue
• Re: how to query table by last 20 dates for each contact ID
  • From: Allen Browne
• Re: User defined function in SQL statement
  • From: Allen Browne
• Re: I need to set up an expired records expression
  • From: Duane Hookom
• User defined function in SQL statement
  • From: robert d via AccessMonster.com
• Re: Delete all rows in 2 tables with the same query
  • From: Rick Brandt
• Delete all rows in 2 tables with the same query
  • From: Hank Rouse
• Re: Executing Multiple Queries
  • From: Ivan Mascovich
• Re: Semi-Annual Totals from Database
  • From: Marshall Barton
• Re: cannot delete from specified tables
  • From: Hank Rouse
• Re: Semi-Annual Totals from Database
  • From: Steve Schapel
• Re: I need to set up an expired records expression
  • From: Duane Hookom
• Re: cannot delete from specified tables
  • From: giorgio rancati
• Re: Rounding Numbers in queries
  • From: Douglas J. Steele
• Re: counting the number of responses
  • From: Duane Hookom
• Re: Sort ignores apostrophe
  • From: Ed Adamthwaite
• cannot delete from specified tables
  • From: Hank Rouse
• Re: Rounding Numbers in queries
  • From: Randy Harris
• Re: Moving data from one table to another
  • From: ZippyV
• Re: Roll up values in an Access query
  • From: Jeff Boyce
• Re: Executing Multiple Queries
  • From: Jeff Boyce
• Re: Moving data from one table to another
  • From: Jeff Boyce
• Re: Moving data from one table to another
  • From: Allen Browne
• Re: Moving data from one table to another
  • From: ZippyV
• Re: Moving data from one table to another
  • From: Allen Browne
• Moving data from one table to another
  • From: ZippyV
• Re: Problem with Dual subselect
  • From: robert d via AccessMonster.com
• Re: Problem with Dual subselect
  • From: Vincent Johns
• Re: Date Query
  • From: John Vinson