microsoft.public.access.queries
- Re: Query Problem
- Re: How to Direct Query Output ?
- Re: pulling a report from 3 tables
- Re: Getting results in Rows from columns?
- Calculating difference between field values for different records
- Re: removing duplicate records in a query
- Re: delete a query where alll record descriptions start with an "L"
- Getting results in Rows from columns?
- Re: Need some query help
- Re: delete a query where alll record descriptions start with an "L"
- Re: pulling a report from 3 tables
- Append query key violation
- Re: Macro Conditional Expressions
- pulling a report from 3 tables
- Append Query - very slow
- removing duplicate records in a query
- Re: Test for query results
- Re: How to sum alphanumeric characters
- delete a query where alll record descriptions start with an "L"
- Re: Query Problem
- Need some query help
- Re: What is the T-SQL equivalent for ANSI-SQL substr?
- Re: Duplicate records?
- How to Direct Query Output ?
- Re: How to combine two (or more) records to one?
- Re: Union Two Tables with Different number of columns
- Union Two Tables with Different number of columns
- From: majed via AccessMonster.com
- Re: Combo Box List
- Re: Combo Box List
- Re: Macro Conditional Expressions
- From: Steve Murphy (Kuwait in Army**US)
- Re: Macro Conditional Expressions
- From: Steve Murphy (Kuwait in Army**US)
- Re: Update parent table
- Re: Test for query results
- Re: Add autonumber field in query
- Re: Not Enough Space on Temporary Disk???
- Re: Doing Queries in Access is Aggravating
- Query Problem
- Re: How to sum on a range of numbers
- Re: Parsing Key Field in one table in a Query
- Re: Time Deducted From matching time frame???
- Re: Update Query - change negative currency values to positive
- Re: relationship with "environ" field
- RE: Access Update Query not working
- Re: Access Update Query not working
- Access Update Query not working
- Re: How to sum alphanumeric characters
- Re: Make tabel query does not show check box
- Re: Update Query - change negative currency values to positive
- Re: Append Query
- Re: urgent ! outer join not picking all records
- Re: Append Query
- relationship with "environ" field
- Re: Unique Value property
- Re: Update Query - change negative currency values to positive
- Re: Update Query - change negative currency values to positive
- Re: Unique Value property
- Re: Update Query - change negative currency values to positive
- Re: Append Query
- Re: Trouble with simple Update query...
- Re: Update Query - change negative currency values to positive
- Append Query
- Re: Unique Value property
- Update Query - change negative currency values to positive
- Re: How to sum on a range of numbers
- Can and how do I create a query for the current record only?
- Re: Trouble with simple Update query...
- RE: Trouble with simple Update query...
- Re: Trouble with simple Update query...
- Re: Test for query results
- Re: Data type mismatch in criteria expression error returned...
- Re: Trouble with simple Update query...
- Re: >today() does not work
- Unique Value property
- Re: Add autonumber field in query
- Re: Trouble with simple Update query...
- Re: Parsing Key Field in one table in a Query
- Re: Question With A Expression
- Re: Trouble with simple Update query...
- Re: Not Enough Space on Temporary Disk???
- From: David Fawn via AccessMonster.com
- Re: Migrating to ADP
- Not Enough Space on Temporary Disk???
- From: David Fawn via AccessMonster.com
- Re: QUERY: Quarterly Subtotals on Multi-Year Report
- Re: Trouble with simple Update query...
- Re: Duplicate records?
- From: David Fawn via AccessMonster.com
- Re: AVG of a Count in a Crosstab-query
- Re: Trouble with simple Update query...
- Re: copy current record into new record
- Re: Migrating to ADP
- Re: Multiple Parameters in a Query
- Trouble with simple Update query...
- Re: Counter Question
- Re: Duplicate records?
- Test for query results
- Re: How can I run my queries that Windows XP thinks are malicious?
- Re: forms & tables
- forms & tables
- Re: Stored Procedure
- RE: Make tabel query does not show check box
- Re: How can I run my queries that Windows XP thinks are malicious?
- How can I run my queries that Windows XP thinks are malicious?
- Re: Crosstab query column headings
- Re: Converting a non-standard table
- RE: Doing Queries in Access is Aggravating
- Converting a non-standard table
- Multiple Parameters in a Query
- RE: search pattern in access module
- Re: Time query - Jeff Boyce please respond
- RE: Update Query?
- Multiple Parameters in a Query
- Re: What am i doing wrong
- Re: search pattern in access module
- RE: DoCmd.RunSQL not working
- Stored Procedure
- Doing Queries in Access is Aggravating
- Re: DoCmd.RunSQL not working
- Crosstab query column headings
- Data type mismatch in criteria expression error returned...
- From: Rashar Sharro via AccessMonster.com
- RE: Migrating to ADP
- Re: Get the query to show records
- What am i doing wrong
- RE: DoCmd.RunSQL not working
- Re: DoCmd.RunSQL not working
- Re: Time Query to handle after 12 am Logouts
- Migrating to ADP
- Re: Get the query to show records
- DoCmd.RunSQL not working
- RE: >today() does not work
- Re: create totals based on a field values...
- Re: Make tabel query does not show check box
- Re: How to return the max value from expression-list?
- >today() does not work
- Re: Macro Conditional Expressions
- Re: urgent ! outer join not picking all records
- Time query - Jeff Boyce please respond
- Make tabel query does not show check box
- Re: Null Values
- search pattern in access module
- Re: Get the query to show records
- Re: Query Question
- Re: Macro Conditional Expressions
- From: Steve Murphy (Kuwait in Army**US)
- Add autonumber field in query
- From: Freshke via AccessMonster.com
- Re: Looking for Ted Allen to answer
- Re: Leave Null spouses out
- Re: How to combine two (or more) records to one?
- Re: Combo Box List
- Re: Macro Conditional Expressions
- Re: Combo Box List
- Re: How to combine two (or more) records to one?
- Re: Storing a count???
- Re: Viewing Totals/GroupBy creates Data Mismatch
- Question With A Expression
- Re: Time Query to handle after 12 am Logouts
- Re: QUERY: Quarterly Subtotals on Multi-Year Report
- From: Robert Blair via AccessMonster.com
- Re: Viewing Totals/GroupBy creates Data Mismatch
- QUERY: Quarterly Subtotals on Multi-Year Report
- From: Robert Blair via AccessMonster.com
- Re: Viewing Totals/GroupBy creates Data Mismatch
- Re: Grouping on date field
- How to combine two (or more) records to one?
- From: David Fawn via AccessMonster.com
- Re: Time Deducted From matching time frame???
- Re: Grouping on date field
- Combo Box List
- Re: Grouping on date field
- Storing a count???
- Re: Grouping on date field
- Re: Returning the first of the month for every date in that month
- Re: Returning the first of the month for every date in that month
- Re: Unsupported Join in Access 2003
- Re: Grouping on date field
- Re: Access - form has tick for yes, want query to show tick for no
- Returning the first of the month for every date in that month
- AVG of a Count in a Crosstab-query
- From: Daan den Hollander via AccessMonster.com
- Access - form has tick for yes, want query to show tick for no
- copy current record into new record
- Re: Update Query
- Macro Conditional Expressions
- From: Steve Murphy (Kuwait in Army**US)
- Re: Combo box
- RE: Grouping on date field
- Re: Grouping on date field
- Grouping on date field
- Re: Leave Null spouses out
- Re: Leave Null spouses out
- Re: Update Query Help
- Re: Parsing Key Field in one table in a Query
- Re: Query Question
- Re: if date in another field is between two dates
- Leave Null spouses out
- Viewing Totals/GroupBy creates Data Mismatch
- Re: Show the data text corrosponding to the ID
- Re: Combo box
- Re: How do I sort criteria with Arithmetic operators ex.>315 but <387
- Re: Need to multiply in aggregate query
- Re: HELP - query question
- Re: Parsing Key Field in one table in a Query
- Re: Time Deducted From matching time frame???
- Re: Show the data text corrosponding to the ID
- HELP - query question
- Combo box
- Show the data text corrosponding to the ID
- Re: urgent ! outer join not picking all records
- adding Columns to Query - why can't I see it?
- RE: Fixed column names from a crosstab query.
- Re: Splitting 1 Column to Many
- Re: Outer Join With Where Clause For Right-Hand Table
- Re: urgent ! outer join not picking all records
- Splitting 1 Column to Many
- Re: Parsing Key Field in one table in a Query
- Re: Get the query to show records
- Counter Question
- Re: Null Values
- Re: Parsing Key Field in one table in a Query
- Re: Null Group Fields Not Equal to Null Non-Grouped Fields
- Updating records in form via query
- From: C_F via AccessMonster.com
- Re: aggregate query multiply instead of sum
- Update Query
- Re: Another data-mismatch-in-criteria question
- Null Values
- Outer Join With Where Clause For Right-Hand Table
- Re: Another data-mismatch-in-criteria question
- RE: Use of IF then Else syntax in Access
- Re: Another data-mismatch-in-criteria question
- Re: urgent ! outer join not picking all records
- Update Query Help
- From: John Roberts via AccessMonster.com
- Re: Missing Zeros
- RE: Use of IF then Else syntax in Access
- Re: Get the query to show records
- Re: Time Query to handle after 12 am Logouts
- Re: Another data-mismatch-in-criteria question
- Re: Missing Zeros
- RE: Use of IF then Else syntax in Access
- Duplicate records?
- From: David Fawn via AccessMonster.com
- Get the query to show records
- Re: Missing Zeros
- Re: How to return the max value from expression-list?
- RE: Use of IF then Else syntax in Access
- Missing Zeros
- RE: Use of IF then Else syntax in Access
- Re: How to sum alphanumeric characters
- Re: SQL Grouping Syntax
- Re: calculate new column in a crosstab
- RE: Fixed column names from a crosstab query.
- Re: reult to a text box
- Another data-mismatch-in-criteria question
- RE: Use of IF then Else syntax in Access
- Re: Export QUERY to CSV or .TXT
- Re: Data type mismatch in criteria expression error returned...
- From: Rashar Sharro via AccessMonster.com
- RE: Use of IF then Else syntax in Access
- Re: calculate new column in a crosstab
- Re: calculations in Access 2003
- Re: How can I change a string to a date in a calculated expression
- How do I sort criteria with Arithmetic operators ex.>315 but <387
- Re: Data type mismatch in criteria expression error returned...
- From: Rashar Sharro via AccessMonster.com
- How do I sort criteria with Arithmetic operators ex.>315 but <387
- Query Question
- calculations in Access 2003
- Time Query to handle after 12 am Logouts
- Re: How can I change a string to a date in a calculated expression?
- RE: Use of IF then Else syntax in Access
- Fixed column names from a crosstab query.
- Re: How to return the max value from expression-list?
- How can I change a string to a date in a calculated expression?
- RE: simple query question
- Re: query question
- Re: Sub-table Query
- Re: refer to a listbox column in the query qrid
- Re: calculate new column in a crosstab
- Re: Sub-table Query
- Re: Data type mismatch in criteria expression error returned...
- RE: aggregate query multiply instead of sum
- if date in another field is between two dates
- Re: SQL Grouping Syntax
- RE: Use of IF then Else syntax in Access
- Re: Update Query?
- Re: Adding a related table spoils the query--help!
- Use of IF then Else syntax in Access
- Sub-table Query
- From: Kilau via AccessMonster.com
- Re: create a query builder or call the query builder
- RE: SQL Subquery and sort
- Data type mismatch in criteria expression error returned...
- From: Rashar Sharro via AccessMonster.com
- Re: Null Group Fields Not Equal to Null Non-Grouped Fields
- Re: How to return the max value from expression-list?
- Need to multiply in aggregate query
- aggregate query multiply instead of sum
- RE: Looking for Ted Allen to answer
- Re: Currency Rate
- Re: putting the total row at the end of a cross tab query
- RE: Passing a parameter to a query by code. How to do it?
- RE: SQL Subquery and sort
- Re: How to return the max value from expression-list?
- reult to a text box
- Re: putting the total row at the end of a cross tab query
- How to return the max value from expression-list?
- Passing a parameter to a query by code. How to do it?
- Re: Not Enough Space On Temporary Disk
- Re: Time Deducted From matching time frame???
- Re: calculate new column in a crosstab
- Re: refer to a listbox column in the query qrid
- Re: Group By Query Problem
- Re: [Forms]![frmNameOfForm].[cboControlName]
- Re: Another Compound and Subquery question
- Re: [Forms]![frmNameOfForm].[cboControlName]
- Re: Update parent table
- Re: ODBC Fail
- Looking for Ted Allen to answer
- Re: [Forms]![frmNameOfForm].[cboControlName] -- need help w/ exception
- Re: my access pivot table says the query cannot be processed.
- Re: SQL Grouping Syntax
- RE: using a query to find dates
- using a query to find dates
- Re: Unsupported Join in Access 2003
- [Forms]![frmNameOfForm].[cboControlName]
- Re: Query comparing non-identical fields
- Crosstab is missing data from underlying table
- From: Alexus12 via AccessMonster.com
- Re: Crosstab is missing data from underlying table
- Re: Are Compound Queries and Subqueries allowed in Access?
- Re: Access not responding on Compact and Repair
- Re: Integer to Time Conversion
- Re: How to sum alphanumeric characters
- Re: Integer to Time Conversion
- Re: Parsing Key Field in one table in a Query
- Re: How to sum alphanumeric characters
- Re: Date issues
- Re: Time Deducted From matching time frame???
- Re: Integer to Time Conversion
- Re: Grouped Multiple Count Query
- RE: limit text in a querie
- Re: Null Group Fields Not Equal to Null Non-Grouped Fields
- Re: wrong CDate result
- Re: Parsing Key Field in one table in a Query
- Re: Unsupported Join in Access 2003
- Re: putting the total row at the end of a cross tab query
- Date issues
- Null Group Fields Not Equal to Null Non-Grouped Fields
- Integer to Time Conversion
- Re: Integer to Date Conversion
- Re: calculate new column in a crosstab
- Re: create a query builder or call the query builder
- Re: Grouped Multiple Count Query
- Re: How to sum alphanumeric characters
- Re: putting the total row at the end of a cross tab query
- Re: SQL Subquery and sort
- RE: Update Query?
- Re: SQL Subquery and sort
- Query comparing non-identical fields
- Re: Export QUERY to CSV or .TXT
- Re: Integer to Date Conversion
- Re: calculate new column in a crosstab
- Re: Currency Rate
- Re: SQL Grouping Syntax
- Re: Adding a related table spoils the query--help!
- Export QUERY to CSV or .TXT
- create a query builder or call the query builder
- Re: Access not responding on Compact and Repair
- RE: SQL Subquery and sort
- Re: putting the total row at the end of a cross tab query
- Appending ONLY new records to a table
- Re: Stumped on query, group count max type
- RE: Help Needed
- RE: Update Query?
- Re: Update Query?
- Are Compound Queries and Subqueries allowed in Access?
- Re: SQL Grouping Syntax
- Integer to Date Conversion
- RE: Appending ONLY new records to a table
- Re: Prevent overlapping times
- Re: SQL Subquery and sort
- RE: Stumped on query, group count max type
- RE: Help Needed
- RE: Update Query?
- Re: calculate new column in a crosstab
- RE: two statements in one?
- Another Compound and Subquery question
- Re: Access not responding on Compact and Repair
- Re: MS Access 2000 - Undefined function 'replace' in expression
- Re: How to exclude Saturday & Sunday from a count?
- Re: Text Format for query
- calculate new column in a crosstab
- Text Format for query
- One Join with 2 Criteria
- MS Access 2000 - Undefined function 'replace' in expression
- RE: One Join with 2 Criteria
- How to exclude Saturday & Sunday from a count?
- RE: Grouping
- RE: Help Needed
- Re: Quantifying Survey Responses
- Re: What's the opposite of "is null"?
- Access not responding on Compact and Repair
- RE: query question
- Re: two statements in one?
- Re: replace chars
- Re: In my crosstab query I want it to enter a "0" for null values.
- RE: Help Needed
- Re: delete join
- From: dale@xxxxxxxxxxxxxxxx
- RE: Help Needed
- SQL Grouping Syntax
- Re: two statements in one?
- Re: create totals based on a field values...
- Update parent table
- two statements in one?
- Re: DATEDIFF function problem
- Re: What's the opposite of "is null"?
- Re: case sensitive LIKE search
- Re: DATEDIFF function problem
- replace chars
- Re: What's the opposite of "is null"?
- Re: case sensitive LIKE search
- Re: What's the opposite of "is null"?
- Re: Append query
- Re: query question
- DATEDIFF function problem
- Re: Crosstab is missing data from underlying table
- Re: Grouped Multiple Count Query
- query question
- Re: wrong CDate result
- Re: What's the opposite of "is null"?
- Stumped on query, group count max type
- case sensitive LIKE search
- From: Abhishek Madas via AccessMonster.com
- Re: How i select the hours only in date feild of yyyymmddhhmmss
- Re: Not Enough Space On Temporary Disk
- Re: What's the opposite of "is null"?
- Re: List box to set q parameter
- Re: delete join
- Re: SQL Subquery and sort
- Re: wrong CDate result
- List box to set q parameter
- Re: create totals based on a field values...
- RE: SQL Subquery and sort
- Grouping
- Re: Unsupported Join in Access 2003
- Re: In my crosstab query I want it to enter a "0" for null values.
- RE: SQL Subquery and sort
- Re: Adding a related table spoils the query--help!
- RE: Help Needed
- Re: putting the total row at the end of a cross tab query
- Re: wrong CDate result
- In my crosstab query I want it to enter a "0" for null values.
- Re: How i select the hours only in date feild of yyyymmddhhmmss
- RE: SQL Subquery and sort
- Re: Currency Rate
- Re: calc a field based on values for example if [acnt_nbr] in 3009
- Re: create totals based on a field values...
- ODBC Fail
- RE: SQL Subquery and sort
- Re: How i select the hours only in date feild of yyyymmddhhmmss
- From: Josh Nankivel via AccessMonster.com
- RE: Help Needed
- RE: Storing Values
- How i select the hours only in date feild of yyyymmddhhmmss
- Help Needed
- Re: Prevent overlapping times
- RE: Multiple rows in query
- Re: putting the total row at the end of a cross tab query
- Re: What's the opposite of "is null"?
- Re: Need help on Numeric field overflow error
- Re: putting the total row at the end of a cross tab query
- Update Query?
- SQL Subquery and sort
- Re: What's the opposite of "is null"?
- putting the total row at the end of a cross tab query
- Append query
- From: Michael Stengel via AccessMonster.com
- Re: Which identity?
- [Forms]![frmNameOfForm].[cboControlName] -- need help w/ exception
- Not Enough Space On Temporary Disk
- Re: Update Query using same criteria for multiple Tables
- From: Manuel Indacochea via AccessMonster.com
- Re: help with Elseif or IIF
- Re: What's the opposite of "is null"?
- From: dd via AccessMonster.com
- Re: What's the opposite of "is null"?
- Re: Time Deducted From matching time frame???
- wrong CDate result
- What's the opposite of "is null"?
- Re: Esay way to turn rows into columns
- Crosstab is missing data from underlying table
- From: Crosstab is missing data
- Re: if you use Access 2000
- Re: Time/Billing Calculation
- Re: Time Deducted From matching time frame???
- Re: TRANSPOSE FIELDS IN ACCESS DATABASE
- Re: multiple make table queries to increase performance
- Re: delete join
- From: dale@xxxxxxxxxxxxxxxx
- Time Deducted From matching time frame???
- Re: counting matches between multiple tables
- Re: Quantifying Survey Responses
- RE: Multiple rows in query
- Re: Problems with dates in query
- Multiple rows in query
- Time/Billing Calculation
- From: Kirsty via AccessMonster.com
- if you use Access 2000
- Re: Crosstab Query
- Re: Append Same Data To Table N Times
- Re: delete join
- Re: Quantifying Survey Responses
- Re: calc a field based on values for example if [acnt_nbr] in 300999,.
- Re: How to sum alphanumeric characters
- Which identity?
- Re: Currency Rate
- Which identity?
- Which identity?
- Append Same Data To Table N Times
- From: ButchyBoy via AccessMonster.com
- Re: Adding a related table spoils the query--help!
- Need help on Numeric field overflow error
- Re: Unsupported Join in Access 2003
- multiple make table queries to increase performance
- Grouped Multiple Count Query
- Re: Unsupported Join in Access 2003
- Re: Esay way to turn rows into columns
- Esay way to turn rows into columns
- Re: Add data on double-click
- Re: Update Query using same criteria for multiple Tables
- my access pivot table says the query cannot be processed.
- Re: select and where
- Unsupported Join in Access 2003
- Re: select and where
- Re: create totals based on a field values...
- Re: passing records from a multilist box to parameter setting in a
- Re: How to sum alphanumeric characters
- Add data on double-click
- Re: create totals based on a field values...
- delete join
- From: dale@xxxxxxxxxxxxxxxx
- RE: Concatenate one-to-many into one row
- Re: Query w/ 8 "WHERE" Values
- RE: Queries - Prompt
- Concatenate one-to-many into one row
- Re: select and where
- Re: Query w/ 8 "WHERE" Values
- Re: Multiselect list to unbound box to query Parameter
- Re: many to many then one to many
- RE: Adding a related table spoils the query--help!
- RE: Need help with Elseif statement
- Re: Wildcard in IFF Expression
- Re: Odd Street Addresses
- Re: Prevent overlapping times
- TRANSPOSE FIELDS IN ACCESS DATABASE
- Re: Problems with dates in query
- Re: Delete Query based in a table (different scenario) and fields combination.
- Re: help with Elseif or IIF
- Re: Query Message: Scaling of Decimal Value resulted in data Trunc
- Re: Query w/ 8 "WHERE" Values
- RE: Query Counting Number of Items Using Custom Dialogue Box ?? Help!
- Adding a related table spoils the query--help!
- Re: is not null returns "unknown"
- Crosstab Query
- RE: All records show up instead of filtered one's by name
- Re: select and where
- Update Query using same criteria for multiple Tables
- From: Manuel Indacochea via AccessMonster.com
- RE: Need help with Elseif statement
- Re: Delete Query based in a table (different scenario) and fields combination.
- From: Manuel Indacochea via AccessMonster.com
- Re: Quantifying Survey Responses
- many to many then one to many
- Odd Street Addresses
- Re: Query w/ 8 "WHERE" Values
- calc a field based on values for example if [acnt_nbr] in 300999,.
- Re: select and where
- Re: Before, current, and ending units based on dates
- Re: Delete Query based in a table (different scenario) and fields combination.
- Re: Multiselect list to unbound box to query Parameter
- Re: select and where
- Re: Time stored as varchar
- Re: Query Help
- Prevent overlapping times
- Need help with Elseif statement
- Re: Query w/ 8 "WHERE" Values
- Re: Quantifying Survey Responses
- Re: Invalid procedure call!?
- Re: Getting a Count for a range of values
- RE: Query Help
- Re: Query Help
- Re: pivot table and weekly view
- Quantifying Survey Responses
- Re: Delete Query based in a table (different scenario) and fields combination.
- From: Manuel Indacochea via AccessMonster.com
- Query Help
- Re: Time stored as varchar
- Re: Calculating Fields
- Problems with dates in query
- Re: is not null returns "unknown"
- Re: take entries of a table as criteria for a query
- Re: ODBC Call failed
- Re: UPDATE Statement
- From: Nadine Sinclair via AccessMonster.com
- Re: Time stored as varchar
- take entries of a table as criteria for a query
- Re: Multiple field query
- Re: Query w/ 8 "WHERE" Values
- Time stored as varchar
- RE: Wildcard in IFF Expression
- Re: IIF (Expr, "*", ,[Forms]![TestForm]![TextA])
- Re: Multiple field query
- Re: UPDATE Statement
- Re: IIF (Expr, "*", ,[Forms]![TestForm]![TextA])
- Calculating Fields
- RE: Latest of several dates
- Re: Query used to produce report based on combobox selection
- Re: Query w/ 8 "WHERE" Values
- Re: Unmatched qry, 2 fields
- UPDATE Statement
- From: Nadine Sinclair via AccessMonster.com
- Re: VB6 ADO Connection does not run a query
- is not null returns "unknown"
- Re: Query w/ 8 "WHERE" Values
- pivot table and weekly view
- Re: IIF (Expr, "*", ,[Forms]![TestForm]![TextA])
- Re: Multiple field query
- Query w/ 8 "WHERE" Values
- Re: Multiple field query
- RE: How do I count the top five most prevalent text entries in a table
- From: lance carter via AccessMonster.com
- Multiple field query
- RE: SQL Query...HELP REQUIRED!
- Unmatched qry, 2 fields
- Re: No. of Open cases per day per agent
- Re: Query Message: Scaling of Decimal Value resulted in data Trunc
- Re: Wildcard in IFF Expression
- Re: Group By Query Problem
- Re: system resource exceeded
- Wildcard in IFF Expression
- Re: Truncated text in Union Query
- Re: Truncated text in Union Query
- RE: How do I count the top five most prevalent text entries in a table
- Re: system resource exceeded
- Re: Group By Query Problem
- Query used to produce report based on combobox selection
- Re: Delete certain text from field
- VB6 ADO Connection does not run a query
- Re: Getting a Count for a range of values
- No. of Open cases per day per agent
- From: Daan den Hollander via AccessMonster.com
- Re: Truncated text in Union Query
- Re: system resource exceeded
- How do I count the top five most prevalent text entries in a table
- From: lance carter via AccessMonster.com
- Re: select and where
- select and where
- Re: Delete Query based in a table (different scenario) and fields combination.
- Re: system resource exceeded
- Re: Select Distinct
- Combo Box Query??
- Query Counting Number of Items Using Custom Dialogue Box ?? Help!
- Re: Invalid procedure call!?
- Re: Select Max
- Re: Multiselect list to unbound box to query Parameter
- Re: Truncated text in Union Query
- Re: passing records from a multilist box to parameter setting in a
- RE: Query Optimisation
- Re: Group By Query Problem
- Re: Between two numbers update Query
- Re: How to sum alphanumeric characters
- Re: Parameter trouble....
- Re: Between two numbers update Query
- Re: Between two numbers update Query
- Re: How to sum alphanumeric characters
- Between two numbers update Query
- Re: Parsing Key Field in one table in a Query
- Re: Getting a Count for a range of values
- Re: passing records from a multilist box to parameter setting in a uer
- How do I remove unsolicited characters from a query result?
- How do I remove unsolicited characters from a query result?
- Re: Currency Rate
- Group By Query Problem
- Re: create totals based on a field values...
- Select Max
- RE: Record Numbering in a Query
- Re: Delete certain text from field
- Delete certain text from field
- RE: Grouping data in unequal sized groupd
- passing records from a multilist box to parameter setting in a uer
- Re: Parsing Key Field in one table in a Query
- help with Elseif or IIF
- Re: refer to a listbox column in the query qrid
- Re: Record Numbering in a Query
- SQL Query...HELP REQUIRED!
- Currency Rate
- Re: Grouping data in unequal sized groupd
- Re: Query Message: Scaling of Decimal Value resulted in data Truncatio
- Re: IIF (Expr, "*", ,[Forms]![TestForm]![TextA])
- Re: Criteria for selecting records
- Re: Criteria for selecting records
- Re: IIF (Expr, "*", ,[Forms]![TestForm]![TextA])
- Re: Criteria for selecting records
- Re: refer to a listbox column in the query qrid
- Re: Crosstab Query
- Re: create totals based on a field values...
- Re: Latest meter reading
- refer to a listbox column in the query qrid
- Re: Latest meter reading
- Crosstab Query
- RE: Query Optimisation
- Record Numbering in a Query
- Re: Latest of several dates
- Re: Getting a Count for a range of values
- Grouping data in unequal sized groupd
- Query Message: Scaling of Decimal Value resulted in data Truncatio
- Criteria for selecting records
- Re: Invalid procedure call!?
- Delete Query based in a table (different scenario) and fields combination.
- From: Manuel Indacochea via AccessMonster.com
- Re: Parsing Key Field in one table in a Query
- Latest meter reading
- Re: Getting a Count for a range of values
- Re: List box and link to subform
- Re: Parameter trouble....
- RE: Query Criteria: Converting Date to Display Month Only
- system resource exceeded
- Re: create totals based on a field values...
- Re: IIF (Expr, "*", ,[Forms]![TestForm]![TextA])
- Re: create totals based on a field values...
- Re: IIF (Expr, "*", ,[Forms]![TestForm]![TextA])
- IIF (Expr, "*", ,[Forms]![TestForm]![TextA])
- Re: create totals based on a field values...
- Re: IFF in Criteria
- Re: IFF in Criteria
- RE: IFF in Criteria
- Re: Getting a Count for a range of values
- List box and link to subform
- Re: Parsing Key Field in one table in a Query
- Select Distinct
- Re: Truncated text in Union Query
- Query Optimisation
- create totals based on a field values...
- Re: Parameter trouble....
- Re: Undefined function 'IFF' in expression
- Re: Undefined function 'IFF' in expression
- Undefined function 'IFF' in expression
- Re: How to select using multiple criteria
- Getting a Count for a range of values
- Re: select field by parameter
- Re: query parameter?
- Re: Before, current, and ending units based on dates
- Re: Obtain values from Web Browser Control
- Re: On creating select and append query
- Re: Criteria = Contents of Field
- Re: autonumber of query results
- Re: Query into several records
- Re: Pulling Data for Date Range from Excel
- Re: How to sum alphanumeric characters
- How to select using multiple criteria
- select field by parameter
- Re: Multiselect list to unbound box to query Parameter
- Re: Latest of several dates
- From: Josh Nankivel via AccessMonster.com
- Re: Multiselect list to unbound box to query Parameter
- Multiselect list to unbound box to query Parameter
- Re: Append query?
- Re: Latest of several dates
- Re: EXISTS
- Re: Delete query based on table?
- RE: Installation of Access Runtime on 2003 Terminal Server
- From: Michael Cheng [MSFT]
- Re: Latest of several dates
- Re: Comment in SQL Statement
- Re: 'Not In' Query Slow - What are my alternatives?
- Re: Overflow message
- Re: Append query?
- Re: Append query?
- From: Nikos Yannacopoulos
- Re: Query in VB
- From: Nikos Yannacopoulos
- RE: Invalid procedure call!?
- Append query?
- Re: 'Not In' Query Slow - What are my alternatives?
- Re: Comment in SQL Statement
- Re: Comment in SQL Statement
- Overflow message
- 'Not In' Query Slow - What are my alternatives?
- Re: Addition in a Query
- Re: EXISTS
- Re: EXISTS
- Re: two dates from different tables into one
- Re: EXISTS
- Comment in SQL Statement
- Re: two dates from different tables into one
- Re: Addition in a Query
- Re: Parsing Key Field in one table in a Query
- Re: Latest of several dates
- Re: EXISTS
- Re: Parsing Key Field in one table in a Query
- Latest of several dates
- Re: Truncated text in Union Query
- Re: Addition in a Query
- Re: EXISTS
- EXISTS
- Re: in need of subquery help
- Re: two dates from different tables into one
- Re: How to sum alphanumeric characters
- Re: Addition in a Query
- Re: Parsing Key Field in one table in a Query
- Re: Query Criteria: Converting Date to Display Month Only
- Parsing Key Field in one table in a Query
- Re: How to sum alphanumeric characters
- Addition in a Query
- Query Criteria: Converting Date to Display Month Only
- Re: Truncated text in Union Query
- in need of subquery help
- query parameter?
- Re: How to set a value to 0 decimal after calculation in query?
- RE: Return Multiple Records Query
- Re: Invalid procedure call!?
- Invalid procedure call!?
- Re: How to sum alphanumeric characters
- Re: 60th and 70th Birthdays
- Re: How can I do a find/replace across all Access queries to change t.
- 60th and 70th Birthdays
- From: Older Birthday Clips
- Re: Help with Selecting the most recent Date from three different Date Fields
- Re: Multiple Tables, Dont return entry if it appears in both tables. Plz Help
- Re: Asterisk vs. Field Names
- Re: InStr - trying to set a parameter by code.
- How can I do a find/replace across all Access queries to change t.
- Re: Asterisk vs. Field Names
- Multiple Tables, Dont return entry if it appears in both tables. Plz Help
- Asterisk vs. Field Names
- Re: InStr - trying to set a parameter by code.
- Before, current, and ending units based on dates
- Obtain values from Web Browser Control
- Re: How to sum alphanumeric characters
- Re: Help with Selecting the most recent Date from three different Date Fields
- Re: Filter a table by another table
- Re: InStr - trying to set a parameter by code.
- Re: Truncated text in Union Query
- Re: Filter a table by another table
- Re: Filter a table by another table
- Re: InStr - trying to set a parameter by code.
- InStr - trying to set a parameter by code.
- Filter a table by another table
- Re: Truncated text in Union Query
- On creating select and append query
- Re: Truncated text in Union Query
- Truncated text in Union Query
- Re: How to make a query of two tables (1 linked to excel)
- From: Mauro P via AccessMonster.com
- Re: how to run a delete query
- how to run a delete query
- Re: How to make a query of two tables (1 linked to excel)
- From: Mauro P via AccessMonster.com
- Re: Crosstab Row Heading w/ zero Value
- Re: Help with Selecting the most recent Date from three different Date Fields
- Re: Updating a field using a field on another table
- Re: Help with Selecting the most recent Date from three different Date Fields
- Updating a field using a field on another table
- Re: Make Table STRING field results in NUMERIC field in table. WHY
- Re: Make Table STRING field results in NUMERIC field in table. WHY
- Re: Cannot retrieve all records
- Re: typing "xbaR", i.e.....
- Re: Calling a Union query with parameters
- Re: Calling a Union query with parameters
- typing "xbaR", i.e.....
- Re: limit text in a querie
- Re: Crosstab Row Heading w/ zero Value
- Re: How to make a query of two tables (1 linked to excel)
- Re: How to sum on a range of numbers
- Re: Parameter trouble....
- Re: Calling a Union query with parameters
- Re: insert date table was appened
- Re: IFF in Criteria
- Re: How can I revert an update query action?
- Re: Strange format of the result of caculated control..
- Make Table STRING field results in NUMERIC field in table. WHY
- Re: Need net results from (2) queries
- Re: How to sum on a range of numbers
- Re: case Sensitive compare
- Re: Finding The Earliest Date
- Re: How to make a query of two tables (1 linked to excel)
- From: Mauro via AccessMonster.com
- Re: IFF in Criteria
- Re: case Sensitive compare
- Re: IFF in Criteria
- Re: Need net results from (2) queries
- case Sensitive compare
- Re: What will be the function?
- Re: Parameter query on multiple dates
- Re: Query by Form Keyword problem
- Re: Delete query based on table?
- IFF in Criteria
- Re: Help with Count Function
- Re: autolookup query w/ date range
- Re: Parameter query on multiple dates
- Re: insert date table was appened
- Return Multiple Records Query
- RE: How to recover my password database
- RE: How to recover my password database
- Re: How to sum on a range of numbers
- RE: How to recover my password database
- Re: How can I revert an update query action?
- How can I revert an update query action?
- Re: Sorting Numbers with dashes in them?
- Query in VB
- Re: Sorting Numbers with dashes in them?
- Filtering records "Automaticallly" with Query
- RE: limit text in a querie
- Re: Sorting Numbers with dashes in them?
- Re: Sorting Numbers with dashes in them?
- Re: Summarizing using the TOP command
- limit text in a querie
- Calling a Union query with parameters
- Re: How to sum on a range of numbers
- Finding The Earliest Date
- Criteria = Contents of Field
- Parameter query on multiple dates
- Re: append query
- Re: How to sum on a range of numbers
- How to sum on a range of numbers
- Re: how do i run a distinct count query in access?
- Re: how do i run a distinct count query in access?
- Re: Wrong Date format when combining Access with word document
- how do i run a distinct count query in access?
- Re: Wrong Date format when combining Access with word document
- how do i run a distinct count query in access?
- Re: can't append.
- Wrong Date format when combining Access with word document
- Re: append query
- Re: Grouping Frequency
- Re: change data in a union query
- Re: Crosstab Row Heading w/ zero Value
- Re: can't append.
- Re: change data in a union query
- RE: Using NZ but isn't working...
- Re: relation on a minimal value
- Re: can't append.
- Re: change data in a union query
- Delete query based on table?
- RE: append query
- change data in a union query
- Re: Query disappears
- Re: Crosstab Row Heading w/ zero Value
- Re: Help with Selecting the most recent Date from three different Date Fields
- Re: Crosstab Row Heading w/ zero Value
- Crosstab Row Heading w/ zero Value
- Re: And/Or's
- Re: creating query for archiving
- What will be the function?
- Re: relation on a function (minimum distantce) of a key
- Re: How to make a query of two tables (1 linked to excel)
- From: Mauro via AccessMonster.com
- And/Or's
- relation on a minimal value
- Help with Selecting the most recent Date from three different Date Fields
- relation on a function (minimum distantce) of a key
- Re: Strange format of the result of caculated control..
- autolookup query w/ date range
- Installation of Access Runtime on 2003 Terminal Server
- Re: Cannot retrieve all records
- creating query for archiving
- Re: Help with count query
- Re: Help with crosstab query
- Re: Data from combo box
- Re: Concatenate
- From: Lee-Anne Waters via AccessMonster.com
- Re: Query a table in another access database in the same directory
- Re: Cannot retrieve all records
- Re: Cannot retrieve all records
- Re: Cannot retrieve all records
- Re: Query from more than one table
- Query a table in another access database in the same directory
- Re: Cannot retrieve all records
- Re: Help with count query
- Re: Concatenate
- Re: Concatenate
- From: Lee-Anne Waters via AccessMonster.com
- Re: Cannot retrieve all records
- Re: Concatenate
- Concatenate
- From: Lee-Anne Waters via AccessMonster.com
- Re: Cannot retrieve all records
- Re: Converting Text File to Date Format
- Re: Dates and the 'Between' predicate
- From: 2.0 to 2000 converter - Bruce
- Re: Cannot retrieve all records
- Re: Cannot retrieve all records
- Re: Cannot retrieve all records
- Re: Cannot retrieve all records
- Re: Delete Query Problem
- Help with count query
- Help with crosstab query
- Re: Cannot retrieve all records
- Re: Delete Query Problem
- Re: record numbers
- Cannot retrieve all records
- Re: insert date table was appened
- RE: All records show up instead of filtered one's by name
- Re: Converting Text File to Date Format
- From: Steve Hartman via AccessMonster.com
- Re: Delete Query Problem
- insert date table was appened
- Re: Adding Rank Value to list
- Re: can't append.
- Re: in access how can i average many fields in each one record
- Re: Access Query Parameters
- Re: Hi.. I want to add the values of 4 fields in another field. Srini
- Re: Convert date field to minutes
- Re: Need net results from (2) queries
- Re: in access how can i average many fields in each one record
- Re: simple update querry help
- Re: in access how can i average many fields in each one record
- Re: Parameter trouble....
- Need net results from (2) queries
- Re: Strange format of the result of caculated control..
- Re: Convert date field to minutes
- Adding Rank Value to list
- Re: Moving from Access to SQL
- Convert date field to minutes
- Re: Moving from Access to SQL
- Re: in access how can i average many fields in each one record
- autonumber of query results
- Re: in access how can i average many fields in each one record
- Re: can't append.
- Re: Access Query Parameters
- Re: Show line results even if field is blank or null
- Re: counting matches between multiple tables
- Re: I'm At A Loss With Aggregating
- Re: can't append.
- Re: Query by Form Keyword problem
- Re: simple update querry help
- Re: need help in queries using sql
- Re: combining three fields of data into new field from one table
- Re: in access how can i average many fields in each one record
- Re: access tables
- Re: Moving from Access to SQL
- access tables
- Re: Summarizing using the TOP command
- in access how can i average many fields in each one record
- Access Query Parameters
- combining three fields of data into new field from one table
- Query into several records
- Re: how do I sort a date field in Access according to day and mont
- Re: How to make a query of two tables (1 linked to excel)
- I'm At A Loss With Aggregating
- counting matches between multiple tables
- Re: Query disappears
- Re: can't append.
- can't append.
- Re: Sorting Numbers with dashes in them?
- Re: Parches de microsoft
- Re: Delete Query Problem
- Query by Form Keyword problem
- simple update querry help
- RE: #Name?
- Re: Query Wizard dialogue box too small
- Re: Parches de microsoft
- Re: Maybe a simple question
- From: Fiammenghi Fabrizio
- Parches de microsoft
- Re: Problem with update table.
- Re: problem with Update query
- Re: Query Wizard dialogue box too small
- Re: How to make a query of two tables (1 linked to excel)
- From: Mauro via AccessMonster.com
- Re: Two tables / one to many relationship - need single record
- Re: How to exclude items from one table to other
- Re: Goto specific record
- Query Wizard dialogue box too small
- Problem with update table.
- problem with Update query
- Re: How to sum alphanumeric characters
- Re: Strange format of the result of caculated control..
- Re: Add 72Hrs to a Date Exclude wknd
- RE: Maybe a simple question
- Re: Maybe a simple question
- Maybe a simple question
- From: Fiammenghi Fabrizio
- Re: Top 50% of each product
- Re: Filter Data from Query
- From: Nikos Yannacopoulos
- Re: Can you make a query run faster?
- From: Nikos Yannacopoulos
- Re: how do I sort a date field in Access according to day and mont
- Re: Converting Text File to Date Format
- Re: Data not found
- Re: Query - Memo
- Data not found
- need help in queries using sql
- All records show up instead of filtered one's by name
- All records show up instead of filtered one's by name
- Pulling Data for Date Range from Excel
- Can you make a query run faster?
- Filter Data from Query
- Re: Duplicate Records
- Re: Query disappears
- Re: Strange format of the result of caculated control..
- Re: How do I request updated personal details of people in Access data
- Re: How to sum alphanumeric characters
- Re: Show line results even if field is blank or null
- Two tables / one to many relationship - need single record
- From: Robert Blair via AccessMonster.com
- Re: Converting Text File to Date Format
- From: Steve Hartman via AccessMonster.com
- Re: String field contains "abc" using ASP to query Access database?
- Re: Converting Text File to Date Format
- Re: Show line results even if field is blank or null
- Re: Show line results even if field is blank or null
- Query - Memo
- Re: Moving from Access to SQL
- Converting Text File to Date Format
- From: Steve Hartman via AccessMonster.com
- Moving from Access to SQL
- Re: Sorting Numbers with dashes in them?
- Add 72Hrs to a Date Exclude wknd
- Re: Compute change in Fields from Previous day
- RE: Big queries
- How to sum alphanumeric characters
- Re: String field contains "abc" using ASP to query Access database?
- RE: Can a join query be accessed directly by a novice user?
- Re: An expression from a linked excel table will not calculate
- Re: Summarizing using the TOP command
- Re: Can a join query be accessed directly by a novice user?
- Re: how do I sort a date field in Access according to day and month, .
- RE: Combo Box "Selecting All" feature
- Re: Extremely slow IN clause
- Re: Parameter trouble....
- Re: How to make a query of two tables (1 linked to excel)
- RE: data type mismatch error 3464
- Re: Strange format of the result of caculated control..
- Re: Extremely slow IN clause
- Can a join query be accessed directly by a novice user?
- Re: String field contains "abc" using ASP to query Access database?
- Re: using the "Like" fuunction in queries
- most recent entry append query
- most recent entry append query
- using the "Like" fuunction in queries
- Combo Box "Selecting All" feature
- Re: Using Count in query
- Compute change in Fields from Previous day
- From: Day Falde via AccessMonster.com
- Re: MS Access - STRING Datatype (truncating data)
- Summarizing using the TOP command
- Re: Retrieve date from field with date/time.
- Re: Retrieve date from field with date/time.
- data type mismatch error 3464
- Retrieve date from field with date/time.
- Re: String field contains "abc" using ASP to query Access database?
- RE: Displaying quotes in a query field??
- Re: How to make a query of two tables (1 linked to excel)
- From: Mauro via AccessMonster.com
- RE: probably easy manipulation
- Displaying quotes in a query field??
- Re: Sorting Numbers with dashes in them?
- RE: Combining Queries
- probably easy manipulation
- RE: Parameter trouble....
- Re: Strange format of the result of caculated control..
- Re: Parameter trouble....
- Re: Sums for each record in a query
- Re: How to make a query of two tables (1 linked to excel)
- Re: MS Access is giving 'undefined function 'abs' in expression' when.
- Re: MS Access is giving 'undefined function 'abs' in expression' when.
- Re: Set Field Size with Make Table Query
- Re: String field contains "abc" using ASP to query Access database?
- Using NZ but isn't working...
- Re: cumulative time in a report
- Re: Sorting Numbers with dashes in them?
- Re: String field contains "abc" using ASP to query Access database?
- Re: Sorting Numbers with dashes in them?
- Re: Why does select criteria by date range ignore year?
- Re: Access append query problem
- Re: how do I convert an access query to a table
- Re: Goto specific record
- Re: Strange format of the result of caculated control..
- RE: Combining Queries
- Re: Trouble deleting records from table
- Re: Sums for each record in a query
- Re: String field contains "abc" using ASP to query Access database?
- Re: String field contains "abc" using ASP to query Access database?
- Re: Combining Queries
- Re: INSERT INTO with a date field
- Re: Strange format of the result of caculated control..
- cumulative time in a report
- Re: Sorting Numbers with dashes in them?
- Re: Sums for each record in a query
- Re: INSERT INTO with a date field
- Re: MS Access - STRING Datatype (truncating data)
- Re: Limit on iif statements?
- Re: Sums for each record in a query
- Re: Limit on iif statements?
- INSERT INTO with a date field
- Re: Sums for each record in a query
- Parameter trouble....
- Re: MS Access - STRING Datatype (truncating data)
- Re: Sorting Numbers with dashes in them?
- Sums for each record in a query
- String field contains "abc" using ASP to query Access database?
- Re: MS Access - STRING Datatype (truncating data)
- Combining Queries
- how do I convert an access query to a table
- How to make a query of two tables (1 linked to excel)
- From: Mauro via AccessMonster.com
- Re: Sorting Numbers with dashes in them?
- Re: MS Access - STRING Datatype (truncating data)
- Re: How to exclude items from one table to other
- From: Manuel Indacochea via AccessMonster.com
- RE: Extract Data
- Re: MS Access - STRING Datatype (truncating data)
- Re: How to design a query to get unique IDs?
- Re: Sorting Numbers with dashes in them?
- MS Access is giving 'undefined function 'abs' in expression' when.
- Query in a list box moved to sql
- Re: Extract Data
- Re: Most recent
- Re: error '80040e10' ......
- Re: Most recent
- Re: Query disappears
- Extract Data
- Re: Set Field Size with Make Table Query
- Re: Goto specific record
- Most recent
- Set Field Size with Make Table Query
- Re: Query disappears
- Sorting Numbers with dashes in them?
- Re: Using Count in a query
- Re: Extremely slow IN clause
- An expression from a linked excel table will not calculate
- Re: error '80040e10' ......
- Re: Extremely slow IN clause
- Re: error '80040e10' ......
- Re: Using Count in a query
- Goto specific record
- Re: Adding 2 values in 2 queries
- Re: Using Count in a query
- RE: Error message on left function
- From: Tennis Loving Programmer
- RE: Error message on left function
- From: Tennis Loving Programmer
- Re: Query from more than one table
- Re: Why does select criteria by date range ignore year?
- Why does select criteria by date range ignore year?
- Re: too many crosstable columns (357)"
- From: Nikos Yannacopoulos
- Re: Adding 2 values in 2 queries
- Re: Using Count in a query
- Re: Can we use join keyword without using INNER keyword explicitly in.
- Re: too many crosstable columns (357)"
- Re: Using Count in a query
- Adding 2 values in 2 queries
- Re: Using Count in a query
- Re: Access append query problem
- Re: error '80040e10' ......
- Re: Using Count in a query
- From: Nikos Yannacopoulos
- Re: Using Count in a query
- Create a query with linked excel table
- From: Mauro via AccessMonster.com
- Using Count in a query
- Access append query problem
- Re: error '80040e10' ......
- Re: error '80040e10' ......
- Query disappears
- Re: error '80040e10' ......
- Re: error '80040e10' ......
- Re: error '80040e10' ......
- Re: How to design a query to get unique IDs?
- error '80040e10' ......
- Re: Coding a complex field value
- Re: Form SQL statement
- Re: How to exclude items from one table to other
- Re: forecast production days
- Re: String Function
- Re: Show line results even if field is blank or null
- Re: record numbers
- Re: forecast production days
- String Function
- too many crosstable columns (357)"
- Re: Count Number of times date selected
- Can we use join keyword without using INNER keyword explicitly in.
- From: S.SRIKANTH,GUDIWADA,AP,INDIA
- Re: Limit on iif statements?
- Re: Advice on direction of finance query
- Re: Excluding nulls in a query
- Strange format of the result of caculated control..
- Re: Query from more than one table
- Re: record numbers
- Re: record numbers
- Re: How to design a query to get unique IDs?
- Excluding nulls in a query
- Re: Show line results even if field is blank or null
- record numbers
- hi
- RE: How to design a query to get unique IDs?
- Show line results even if field is blank or null
- Re: Extremely slow IN clause
- Re: Separate data in one column into four columns
- Re: Form SQL statement
- Re: Delete Query Problem
- Re: MS Access - STRING Datatype (truncating data)
- Re: Parameter Query and Criteria
- From: Comanche Ace via AccessMonster.com
- How to exclude items from one table to other
- From: Manuel Indacochea via AccessMonster.com
- Re: Elapsed days
- Re: howto convert 123 minutes to 2:03
- Re: wildcard
- Re: MS Access - STRING Datatype (truncating data)
- Re: Data from combo box
- Re: Using Count in query
- Re: Remove all data from field except a part
- Re: Delete Query Problem
- Re: Delete Query Problem
- RE: Trouble Getting Result
- RE: wildcard
- Re: Delete Query Problem
- Re: stored procedure (query) from out vb6 does not work?!
- Re: Extremely slow IN clause
- Re: MS Access - STRING Datatype (truncating data)
- Re: stored procedure (query) from out vb6 does not work?!
- Advice on direction of finance query
- Re: Delete Query Problem
- RE: wildcard
- RE: wildcard
- Re: MS Access - STRING Datatype (truncating data)
- Re: Separate data in one column into four columns
- wildcard
- Re: Undefined Function error in 2000, not 2003.
- Trouble Getting Result
- Undefined Function error in 2000, not 2003.
- Re: howto convert 123 minutes to 2:03
- Re: Moving from Access to SQL
- How to design a query to get unique IDs?
- Data from combo box
- Re: Moving from Access to SQL
- Using Count in query
- Re: #Name?
- Re: Moving from Access to SQL
- Re: Separate data in one column into four columns
- Moving from Access to SQL
- Re: Sort date lists into month
- Re: Group Column
- Sort date lists into month
- From: Nyanko via AccessMonster.com
- Re: Limit on iif statements?
- Form SQL statement
- Remove all data from field except a part
- Limit on iif statements?
- Re: Coding a complex field value
- Re: Extremely slow IN clause
- Re: Help with update query and IIf statement
- Re: Help with update query and IIf statement
- Coding a complex field value
- Re: Extremely slow IN clause
- #Name?
- Separate data in one column into four columns
- Re: What is the difference between a stored procedure and a function?.
- Re: Help with update query and IIf statement
- Extremely slow IN clause
- Re: adding leading zeros
- Re: Date Criteria in Report
- Re: Big queries
- Re: * problem
- Re: Date Criteria in Report
- How do I eliminate the pop up window in pivottable view
- What is the difference between a stored procedure and a function?.
- Help with update query and IIf statement
- Big queries
- Re: MS Access - STRING Datatype (truncating data)
- Re: adding leading zeros
- Date Criteria in Report
- Re: MS Access - STRING Datatype (truncating data)
- Re: MS Access - STRING Datatype (truncating data)
- * problem
- Re: adding leading zeros
- Re: Question using Like in a query
- Re: Question using Like in a query
- Re: Duplicate Records
- adding leading zeros
- Re: minus doesn't work !!!
- Group Column
- Re: Question using Like in a query
- Re: Query Ranking (Was: Cao Thanh Trung)
- Re: Cao Thanh Trung - THK26
- Re: Query for 'confirmation'
- Re: Delete Query Problem
- Re: Question using Like in a query
- Re: Duplicate Records
- Duplicate Records
- Re: Numbering
- Re: forecast production days
- Re: Error message on left function
- Re: Question using Like in a query
- Re: implicit call to a control in a form???
- Question using Like in a query
- Re: Find/Replace Characters in a database
- Error message on left function
- From: Tennis Loving Programmer
- Re: Parameter Query and Criteria
- Re: minus doesn't work !!!
- Re: Top 50% of each product
- forecast production days
- Re: Criteria for query
- From: Nikos Yannacopoulos
- Top 50% of each product
- RE: Query from more than one table
- minus doesn't work !!!
- Re: Deleting spaces
- Cao Thanh Trung - THK26
- Cao Thanh Trung - THK26
- Cao Thanh Trung
- Cao Thanh Trung - THK26
- RE: implicit call to a control in a form???
- RE: implicit call to a control in a form???
- Criteria for query
- From: uday kulkarni via AccessMonster.com
- Re: Query for 'confirmation'
- Re: Total cost calculation help please!
- Re: stored procedure (query) from out vb6 does not work?!
- implicit call to a control in a form???
- Re: Printing
- Re: Can anyone tell me where to download a good FREEWARE date picker that can be bound and that will not error out on null record feilds which the built in microsoft version does please...TIA
- Re: Count Number of times date selected
- Can anyone tell me where to download a good FREEWARE date picker that can be bound and that will not error out on null record feilds which the built in microsoft version does please...TIA
- Printing
- Re: stored procedure (query) from out vb6 does not work?!
- Re: Select X # records of each name in a column
- Re: Format for new fields in query
- Re: Why does my query equation have a - in front of the return?
- Re: MS Access - STRING Datatype (truncating data)
- Re: Delete Query Problem
- Re: Rolling forecast query help.
- Re: Grouping Frequency
- Re: howto convert 123 minutes to 2:03
- Re: MS Access - STRING Datatype (truncating data)
- Re: criteria
- Re: Criteria parameter
- Re: Criteria parameter
- Parameter Query and Criteria
- Re: Using Check Boxes and Dates in a Query.
- From: Daryl B. via AccessMonster.com
- Re: Elapsed days
- MS Access - STRING Datatype (truncating data)
- Re: Oracle SQL vs. Access SQL
- Re: Changing FieldName in a Query
- Re: concatenating with a append query
- Delete Query Problem
- Re: Total cost calculation help please!
- Re: Why does my query equation have a - in front of the return?
- Re: Sort By Date - Month Only
- Re: Update table automatically
- Why does my query equation have a - in front of the return?
- Re: Total cost calculation help please!
- Re: Select X # records of each name in a column
- Format for new fields in query
- Total cost calculation help please!
- Re: howto convert 123 minutes to 2:03
- Re: Elapsed days
- Select X # records of each name in a column
- RE: Rolling forecast query help.
- RE: Sort By Date - Month Only
- Re: Proper use of update query
- HELP: stored procedure (query) from out vb6 does not work?!
- Re: Numbering
- Re: Sort By Date - Month Only
- Re: Item number ranges
- Grouping Frequency
- Re: Numbering
- Re: Compare one field to another
- Re: Compare one field to another
- Re: This should be easy
- Re: extract part of a field
- Re: creating/defining relationships between two tables
- Re: Sort dates in Crosstab query...
- Re: This should be easy
- Re: Numbering
- Re: Proper use of update query
- Re: creating/defining relationships between two tables
- Compare one field to another
- Re: Oracle SQL vs. Access SQL
- RE: This should be easy
- Re: Sum column comes up blank
- Rolling forecast query help.
- From: VT2000 via AccessMonster.com
- Re: Sum column comes up blank
- From: C Naughton via AccessMonster.com
- Re: creating/defining relationships between two tables
- RE: SQL Problem
- Sort dates in Crosstab query...
- Re: Sum column comes up blank
- Re: Using Check Boxes and Dates in a Query.
- Re: extract part of a field
- Re: creating an expandable query using the "+" and "-"
- RE: creating an expandable query using the "+" and "-"
- Re: This should be easy
- Re: database relationships
- From: graham menzies-kitchin
- Sum column comes up blank
- Re: criteria
- Re: Query for 'confirmation'
- Re: This should be easy
- From: C Naughton via AccessMonster.com
- SQL Problem
- RE: Show groups with zero values
- creating/defining relationships between two tables
- This should be easy
- Re: database relationships
- Appending Memo fields
- From: C Naughton via AccessMonster.com
- RE: HELP! adding parameter to a query
- Re: Oracle SQL vs. Access SQL
- Re: Current month sepcific day query
- database relationships
- From: graham menzies-kitchin
- Re: Oracle SQL vs. Access SQL
- Current month sepcific day query
- RE: Auto Month Input
- Re: Erroneous Errors!
- Re: Oracle SQL vs. Access SQL
- Oracle SQL vs. Access SQL
- Sort By Date - Month Only
- Re: Force Decmials To Show
- Re: Using a form to enter query criteria..
- Using a form to enter query criteria..
- Numbering
- Re: search rows to see if name shows up in any column
- Re: Deleting spaces
- Re: HELP! adding parameter to a query
- Query from more than one table
- RE: HELP! adding parameter to a query
- HELP! adding parameter to a query
- Proper use of update query
- Deleting spaces
- RE: Auto Month Input
- Re: Erroneous Errors!
- Re: search rows to see if name shows up in any column
- RE: Auto Month Input
- query split
- Auto Month Input
- RE: Rounding to the nearest 10
- Re: Value after calculation
- Re: Rounding to the nearest 10
- Re: Value after calculation
- Re: concatenating with a append query
- RE: Rounding to the nearest 10
- Re: query to move row to different table.
- Re: Changing FieldName in a Query
- Rounding to the nearest 10
- Re: Update table automatically
- Re: Access 2000 Recursive Query Help
- query to move row to different table.
- Re: Elapsed days
- Re: How to set a value to 0 decimal after calculation in query?
- Changing FieldName in a Query
- Value after calculation
- Re: Update table automatically
- Re: Criteria parameter
- Re: Troubleshoot append querry
- Re: Advanced export to excel file
- Re: creating an expandable query using the "+" and "-"
- Re: Advanced export to excel file
- Re: Elapsed days
- Re: Advanced export to excel file
- Elapsed days
- Re: Update table automatically
- Update table automatically
- Re: Query for 'confirmation'
- Re: Select Query with Parameter
- Re: Need Criteria expression that will ask for "from" and "to" dates and then select records that......Thanks Douglas !!!!!!!
- RE: Advanced export to excel file
- Using Check Boxes and Dates in a Query.
- From: Daryl B. via AccessMonster.com
- Query from more than one table
- Re: trying to print box that asks for"enter parameter value"
- RE: Export/Import/Update Query Question
- RE: Help with IIf
- trying to print box that asks for"enter parameter value"
- Re: criteria
- Re: last invoice number
- RE: Queries - Prompt
- RE: Calculated feilds
- Re: Erroneous Errors!
- Re: HOW TO INSERT DEFAULT N NORMAL VALUES IN MS ACCESS
- Advanced export to excel file
- Re: criteria
- creating an expandable query using the "+" and "-"
- Re: concatenating with a append query
- Re: concatenating with a append query
- Criteria parameter
- Re: concatenating with a append query
- Re: criteria
- Re: Strange output from Right function
- Re: Calculated feilds
- Calculated feilds
- Calculated feilds
- invalid argument
- Re: last invoice number
- RE: concatenating with a append query
- Re: SIMPLE QUERY WIZARD/ hOW DO i USE IT ON MY ACESS ALSO WHAT DOES DI
- SIMPLE QUERY WIZARD/ hOW DO i USE IT ON MY ACESS ALSO WHAT DOES DI
- Re: Rank Scoring
- Re: concatenating with a append query
- Re: top 2 records per group
- Re: last invoice number
- Re: how to use Cliparts
- Re: Rank Scoring
- last invoice number
- Re: Access queries failing after transfer to XP
- how to use Cliparts
- top 2 records per group
- criteria
- Re: exclude a record in a combo box in a query
- Re: Rank Scoring
- Re: Select Query with Parameter
- Re: Failure to search records
- concatenating with a append query
- Re: Select Query with Parameter
- Rank Scoring
- Re: Access queries failing after transfer to XP
- Re: Count the no of replies.
- Access queries failing after transfer to XP
- Re: Need Criteria expression that will ask for "from" and "to" dates and then select records that fall within that date span for access 2000 Please...TIA
- REQ: Need Criteria expression that will ask for "from" and "to" dates and then select records that fall within that date span for access 2000 Please...TIA
- Re: Convert Date Value
- Re: Convert Date Value
- Re: Convert Date Value
- Convert Date Value
- Re: Item number ranges
- Re: Select Certain Records In Database
- Update query
- exclude a record in a combo box in a query
- Re: How I can extract a list from another one??
- How I can extract a list from another one??
- Re: Failure to search records
- Re: VBA Varible in SQL Query
- Re: Union with IIF - More issues
- Failure to search records
- smart way of slit 2
- smart way of slit
- Re: Query from two or more mdb files
- Re: VBA Varible in SQL Query
- Re: Union with IIF - More issues
- Re: Question about calculating dates into different variables in MSAcc
- Re: VBA Varible in SQL Query
- Re: Query from two or more mdb files
- Re: Erroneous Errors!
- Re: Problems from converting a file from Access2000 to 2003
- Erroneous Errors!
- Query from two or more mdb files
- Re: VBA Varible in SQL Query
- Re: VBA Varible in SQL Query
- Re: VBA Varible in SQL Query
- Re: Query for 'confirmation'
- Question about calculating dates into different variables in MSAcc
- Re: VBA Varible in SQL Query
- Re: Currency Value in Create Table Query
- Re: VBA Varible in SQL Query
- Re: VBA Varible in SQL Query
- Re: Query to look up a number of zip codes or area codes for bulk
- Re: Union with IIF - More issues
- Re: Problems from converting a file from Access2000 to 2003
- Re: The months in a query appearin alphabetical order.
- Re: VBA Varible in SQL Query
- Re: VBA Varible in SQL Query
- Re: The months in a query appearin alphabetical order.
- Re: Union with IIF - More issues
- Re: VBA Varible in SQL Query
- Re: Change Phone# Format
- Re: VBA Varible in SQL Query
- Re: Change Phone# Format
- Re: VBA Varible in SQL Query
- Re: Counting Updated Records
- Re: Change Phone# Format
- VBA Varible in SQL Query
- Re: Change Phone# Format
- Re: Change Phone# Format
- Re: Change Phone# Format
- Multiple Tables - how, where do I start?
- Change Phone# Format
- Re: Union with IIF - More issues
- Re: Can I change the header on an Access query to give me a timestamp.
- Re: howto convert 123 minutes to 2:03
- Can I change the header on an Access query to give me a timestamp.
- RE: Queries - Prompt
- Re: query for customers that have not purchased within 6 months
- query for customers that have not purchased within 6 months
- Re: Like Operator
- Problems from converting a file from Access2000 to 2003
- RE: Show groups with zero values
- Re: Access function same as Excel's TEXT function???
- Union with IIF - More issues
- RE: Help with IIf
- Access function same as Excel's TEXT function???
- Re: Access function same as Excel's TEXT function???
- Re: Force Decmials To Show
- RE: Export/Import/Update Query Question
- Re: Query to look up a number of zip codes or area codes for bulk
- Re: Query for 'confirmation'
- RE: Access function same as Excel's TEXT function???
- RE: Item number ranges
- RE: Show groups with zero values
- RE: Export/Import/Update Query Question
- RE: Help with IIf
- Item number ranges
- RE: Export/Import/Update Query Question
- RE: Help with IIf
- RE: How do I set criteria for calculated total fields in a query?
- RE: Export/Import/Update Query Question
- RE: Help with IIf
- Access function same as Excel's TEXT function???
- Re: Counting Updated Records
- Re: Force Decmials To Show
- Force Decmials To Show
- Re: Counting Updated Records
- Show groups with zero values
- Re: Counting Updated Records
- How do I set criteria for calculated total fields in a query?
- RE: Select Certain Records In Database
- Export/Import/Update Query Question
- Re: How do I raise a value to e in a query?
- Re: Select Query with Parameter
- RE: Select Certain Records In Database
- Currency Value in Create Table Query
- Re: Select Query with Parameter
- Select Certain Records In Database
- Help with IIf
- How do I raise a value to e in a query?
- Re: Update and Append Query
- Re: query execution
- Re: Select Query with Parameter
- Repost For John Vinson
- RE: The months in a query appearin alphabetical order.
- Re: Count the no of replies.
- RE: Autolookup expression example
- Re: Count the no of replies.
- Re: How to set a value to 0 decimal after calculation in query?
- Re: Access query...
- Re: How to set a value to 0 decimal after calculation in query?
- How to set a value to 0 decimal after calculation in query?
- Re: update query confirmation boxes?
- Re: Select Query with Parameter
- Access query...
- Re: how to update multiple records with one entry?
- Re: pass unbound form fields to an update query
- Re: storing tableid
- Re: Problem counting
- Re: HOW TO INSERT DEFAULT N NORMAL VALUES IN MS ACCESS
- Re: storing tableid
- Re: Selecting last 12 months data
- RE: Union with IIF ??
- Re: Query for 'confirmation'
- Re: Selecting last 12 months data
- Re: filtering out duplicates... SORT OF :)
- Re: MakeTable Problem
- Re: query execution
- Re: Like Operator
- Union with IIF ??
- Re: Query to look up a number of zip codes or area codes for bulk
- Re: Sort order in Union query
- Re: Select Query with Parameter
- Like Operator
- Re: Query to look up a number of zip codes or area codes for bulk
- HOW TO INSERT DEFAULT N NORMAL VALUES IN MS ACCESS
- Re: Rounding Down
- Re: edit function to accommdate integer
- Re: Why doesn't a new contact get properly alphabetized in contact li.
- Re: update query confirmation boxes?
- Re: update query confirmation boxes?
- Autolookup expression example
- Re: update query confirmation boxes?
- Re: Rounding Down
- Re: 'First' doesn't always pull 'First'
- Re: 'First' doesn't always pull 'First'
- Re: One table is missing information nothing comes up
- Re: Count the no of replies.
- Re: howto convert 123 minutes to 2:03
- Re: 'First' doesn't always pull 'First'
- Re: Select Query with Parameter
- Re: Append query - key violations??
- Select Query with Parameter
- Re: howto convert 123 minutes to 2:03
- Re: 'First' doesn't always pull 'First'
- RE: filtering out duplicates... SORT OF :)
- Re: Append query - key violations??
- Re: Update and Append Query
- Re: Counting Updated Records
- Re: specific query
- Re: Query to look up a number of zip codes or area codes for bulk
- Re: howto convert 123 minutes to 2:03
- Re: update query confirmation boxes?
- Re: Why doesn't a new contact get properly alphabetized in contact li.
- Re: Troubleshoot append querry
- Re: Sort order in Union query
- RE: Union Query Dropping Rows
- Re: truncate end of record
- RE: 'First' doesn't always pull 'First'
- RE: 'First' doesn't always pull 'First'
- Union Query Dropping Rows
- specific query
- Re: howto convert 123 minutes to 2:03
- Why doesn't a new contact get properly alphabetized in contact li.
- update query confirmation boxes?
- query execution
- Re: howto convert 123 minutes to 2:03
- Counting Updated Records
- Re: Update and Append Query
- Re: Final Plea for Help
- Re: Built-In Functions not working
- Re: OR Functions,
- Re: howto convert 123 minutes to 2:03
- Re: Update Problem
- Re: truncate end of record
- RE: Queries - Prompt
- howto convert 123 minutes to 2:03
- Re: Final Plea for Help
- Re: 'First' doesn't always pull 'First'
- Re: pass unbound form fields to an update query
- Built-In Functions not working
- Querying from multiple form parameters
- OR Functions,
- RE: The months in a query appearin alphabetical order.
- RE: 'First' doesn't always pull 'First'
- Re: Final Plea for Help
- RE: Queries - Prompt
- truncate end of record
- RE: 'First' doesn't always pull 'First'
- RE: Create field with full name
- RE: 'First' doesn't always pull 'First'
- RE: 'First' doesn't always pull 'First'
- MakeTable Problem
- Re: Selecting last 12 months data
- Re: Find/Replace Characters in a database
- Re: Query for 'confirmation'
- Re: Sort order in Union query
- Re: Query to look up a number of zip codes or area codes for bulk mail
- Re: Update Problem
- Re: 'First' doesn't always pull 'First'
- Re: 'First' doesn't always pull 'First'
- Re: Sort order in Union query
- edit function to accommdate integer
- RE: One table is missing information nothing comes up
- 'First' doesn't always pull 'First'
- RE: Replicating an Excel formula in a query and/or field
- RE: Create field with full name
- filtering out duplicates... SORT OF :)
- Re: Troubleshoot append querry
- Re: Final Plea for Help
- Replicating an Excel formula in a query and/or field
- RE: adding table to query
- averaging amounts from one form to another
- RE: Query Help needed please!
- Re: Final Plea for Help
- Create field with full name
- Re: Final Plea for Help
- Add Update Records
- Re: Final Plea for Help
- Re: Strange output from Right function
- Add Update Records
- Selecting last 12 months data
- Re: Sort order in Union query
- Re: Sort order in Union query
- Re: Final Plea for Help
- Re: Count the no of replies.
- Re: how to update multiple records with one entry?
- Find/Replace Characters in a database
- One table is missing information nothing comes up
- Re: Strange output from Right function
- Re: SELECT on Query
- Re: A work-around for a problem query?
- Re: Strange output from Right function
- Strange output from Right function
- From: Kevin Beck via AccessMonster.com
- Re: Final Plea for Help
- A work-around for a problem query?
- SELECT on Query
- Re: database gets placed in a State that prevents it from being opened
- database gets placed in a State that prevents it from being opened
- Re: Final Plea for Help
- Re: Final Plea for Help
- Re: Count the no of replies.
- Re: Final Plea for Help
- Re: Count the no of replies.
- Count the no of replies.
- Re: Final Plea for Help
- Re: Troubleshoot append querry
- Re: undefined function error running Access 2002 on a Windows 98
- undefined function error running Access 2002 on a Windows 98
- Troubleshoot append querry
- Final Plea for Help
- Re: The months in a query appearin alphabetical order.
- Re: Use of Checkbox as Criterion in Query Iput Box
- Query Help needed please!
- Query for 'confirmation'
- Re: Sort order in Union query
- Re: The months in a query appearin alphabetical order.
- Re: Use of Checkbox as Criterion in Query Iput Box
- Re: Use of Checkbox as Criterion in Query Iput Box
- Re: The months in a query appearin alphabetical order.
- Re: Append query - key violations??
- Re: how to update multiple records with one entry?
- The months in a query appearin alphabetical order.
- Re: Monthly Reports
- Re: Dates
- Re: Use of Checkbox as Criterion in Query Iput Box
- Use of Checkbox as Criterion in Query Iput Box
- Re: Sort order in Union query
- Dates
- Re: How can multiple command buttons run a single query and pass a vec
- Re: pass unbound form fields to an update query
- Re: "Invalid SQL Statement" message from union query
- From: Alison Downing via AccessMonster.com
- Re: Update Problem
- adding table to query
- Monthly Reports
- Re: Counting records, but only when field is not zero
- pass unbound form fields to an update query
- Re: Sort order in Union query
- Query to look up a number of zip codes or area codes for bulk mail
- Re: Sort order in Union query
- Re: Formatting query results
- RE: Queries - Prompt
- RE: Mail merge from Quiery, no recipients
- Sort order in Union query
- Re: Query Question
- Re: Have a Problem With Fields Type Date in Queries
- Have a Problem With Fields Type Date in Queries
- Re: "Invalid SQL Statement" message from union query
- "Invalid SQL Statement" message from union query
- From: Alison Downing via AccessMonster.com
- Re: Make Table: Record Too Large
- Re: Ranking Records in a Select Query
- Re: Problem counting
- Re: Counting records, but only when field is not zero
- Re: Querying Variations in Text?
- Re: Update Problem
- Formatting query results
- Re: unwanted CR's in query's export text file
- Re: Append query - key violations??
- Re: How do I count True or False Fields
- search multple columns with individual criterion
- Re: Update Problem
- How can multiple command buttons run a single query and pass a vec
- unwanted CR's in query's export text file
- Re: need query to return record with ChangeDate Field within last 3 da
- RE: need query to return record with ChangeDate Field within last 3 da
- need query to return record with ChangeDate Field within last 3 da
- Queries - Prompt
- Re: MS Access Database - Chinese Characters
- Re: Query from two databases into Excel
- Re: Update Query Question
- Re: Convert hr:min to decimal (payroll solution)
- Correct Criteria from data access page
- Update Problem
- Re: mail merge not showing recipients
- Query from two databases into Excel
- RE: mail merge not showing recipients
- mail merge not showing recipients
- Mail merge from Quiery, no recipients
- Re: Using IIf in Access Query criteria
- Re: Decimal
- Update Query that increments by up to 4 then resets
- Update Query that increments by up to 4 then resets
- Re: How to format and display date '20001231' as 'DD-MON-YYYY' in a q.
- Querying Variations in Text?
- RE: Convert hr:min to decimal (payroll solution)
- how to update multiple records with one entry?
- Re: If no values, return 0
- Re: How do I count True or False Fields
- Convert hr:min to decimal (payroll solution)
- RE: Need help on criteria syntax related to
- Re: Append query - key violations??
- Re: Case Sensitivity
- How do I count True or False Fields
- From: How To Count Logical Fiels
- Case Sensitivity
- RE: Query Question
- If no values, return 0
- From: Robert Ross - rross(at)edfund(dot)orgNOSPAMPLEASE via AccessMonster.com
- RE: need help query
- need help query
- From: pansy Peng via AccessMonster.com
- Field names when exporting queries to Excell
- Query Question
- Re: Using IIf in Access Query criteria
- Re: Decimal
- Re: query
- Re: Decimal
- Re: Using IIf in Access Query criteria
- Re: check box query
- RE: Decimal
- RE: check box query
- RE: Query Formula
- check box query
- Test
- Query Formula
- Using IIf in Access Query criteria
- Decimal
- Re: Query not returning nulls
- From: Brent via AccessMonster.com
- query
- Counting records, but only when field is not zero
- Query Form for field value
- Re: Consecutive Records
- Re: I need help w an Update Query
- Re: Count distinct in 1 query
- Re: Text Calculations
- Re: I need to create an IIF statement in an update query help!!
- Re: I need to create an IIF statement in an update query help!!
- RE: Update Date with Null value
- Re: Union query with left join
- From: Abdula Zakaria via AccessMonster.com
- Re: Append query - key violations??
- Re: Need help on criteria syntax related to
- RE: Need help on criteria syntax related to
- Union query with left join
- From: Abdula Zakaria via AccessMonster.com
- query dsum
- Append query - key violations??
- Re: Query Question
- Re: Make Table: Record Too Large
- Re: Query Problem
- Re: SQL Query converted to SQL Server
- Re: Character limit on field in crosstab query
- Re: Count Number of times date selected
- Re: Update Query Question
- Update Query Question
- Re: MS Access Database - Chinese Characters
- Need help on criteria syntax related to
- Re: Make Table: Record Too Large
- MS Access Database - Chinese Characters
- Re: MS Access Database - Query
- Query Question
- MS Access Database - Query
- Re: Access to Excel
- Re: Trouble deleting records from table
- Re: How do I do nested (3-4) functions--step by step?
- RE: Complex Query
- Re: In query
- Re: Text Calculations
- Re: Time Counting
- Trouble deleting records from table
- RE: Time Counting
- Re: Make Table: Record Too Large
- Re: Make Table: Record Too Large
- Re: Query not returning nulls
- Re: Make Table: Record Too Large
- Make Table: Record Too Large
- RE: Update Date with Null value
- Re: Update question
- Re: I need to create an IIF statement in an update query help!!
- Count distinct in 1 query
- Re: Query Performance
- Re: Query Problem
- Re: Multiple Where clause in query expression
- Re: ANSWER NEEDED
- Re: I need to create an IIF statement in an update query help!!
- Re: Clean data
- Consecutive Records
- Re: Querie
- Re: Comparison Query
- Re: How do I search date/time only by mm/dd and include all years?
- Re: How do I search date/time only by mm/dd and include all years?
- Query Performance
- Re: Date calculation problem
- How do I search date/time only by mm/dd and include all years?
- Re: Update Query is not Working / Updateting
- From: Carlos Garcia via AccessMonster.com
- How do I do nested (3-4) functions--step by step?
- Re: Summing records selected in query
- Re: Ranking Records in a Select Query
- Update Query is not Working / Updateting
- From: Carlos Garcia via AccessMonster.com
- Query not returning nulls
- From: Brent via AccessMonster.com
- Query Problem
- Re: Update Query to populate newly added field
- Re: Time Counting
- Re: ANSWER NEEDED
- Re: ANSWER NEEDED
- From: matt donker via AccessMonster.com
- Re: ANSWER NEEDED
- From: matt donker via AccessMonster.com
- Re: Makin some sort of an update query
- RE: Update Date with Null value
- Re: Update question
- Re: Makin some sort of an update query
- Re: ANSWER NEEDED
- Multiple Where clause in query expression
- ANSWER NEEDED
- From: matt donker via AccessMonster.com
- RE: Problems with RIGHT JOIN and VBS
- In query
- Text Calculations
- RE: Problems with RIGHT JOIN and VBS
- From: Carlos Garcia via AccessMonster.com
- Re: Makin some sort of an update query
- From: matt donker via AccessMonster.com
- RE: querys: Getting two collumns of summed totals based off a thir
- Re: Update question
- RE: Update Date with Null value
- RE: Two list boxes in sync.
- RE: New User - Filtering Out Query Data
- RE: I need to create an IIF statement in an update query help!!
- Re: Select first, If no first, then select 2nd
- RE: Problems with RIGHT JOIN and VBS
- Re: Access to Excel
- RE: Update question
- Re: Problems with RIGHT JOIN and VBS
- Makin some sort of an update query
- From: matt donker via AccessMonster.com
- Appending 2 data sheets
- Update question
- Re: Querie
- Re: Parameter query options...
- Re: Query to get data automatically
- Problems with RIGHT JOIN and VBS
- From: Carlos Garcia via AccessMonster.com
- Querie
- Re: Query to get data automatically
- Re: Multiselect listbox used in Access2000
- Re: Multiselect listbox used in Access2000
- Re: SQL Query converted to SQL Server
- From: Chris Motherwell via AccessMonster.com
- Multiselect listbox used in Access2000
- From: Lee Stafford via AccessMonster.com
- Re: Query to get data automatically
- Parameters for field data in Query
- Re: Ranking Records in a Select Query
- I need to create an IIF statement in an update query help!!
- Re: Character limit on field in crosstab query
- Re: Ranking Records in a Select Query
- Re: Comparison Query
- From: Brian via AccessMonster.com
- Re: query simple sum
- Re: Ranking Records in a Select Query
- Re: Access 2000 Recursive Query Help
- Ranking Records in a Select Query
- New User - Filtering Out Query Data
- query simple sum
- Re: SQL Sum producing rounding error on currency fields
- Update Date with Null value
- Query to get data automatically
- Re: Access to Excel
- RE: querys: Getting two collumns of summed totals based off a third
- Re: SQL Sum producing rounding error on currency fields
- Re: Clean data
- Re: Query leaving out data
- Two list boxes in sync.
- querys: Getting two collumns of summed totals based off a third
- Re: querying a query
- Re: Multiple Single Page Reports
- Clean data
- Re: Finding a Text String with an asterisk in it
- Re: Count Number of times date selected
- RE: query time
- Re: Query by Form
- Re: Find all records in a field from a table that contains a key word.
- Re: How to use "like" in following case
- Re: How to use "like" in following case
- Re: Calculating Totals
- Re: Parameter query options...
- Multiple Single Page Reports
- How to use "like" in following case
- Re: Filling query with zero values (scale problem)
- Re: Calculation down a column
- Re: Parameter query options...
- Re: calculated fields in query in secondary calculation
- Find all records in a field from a table that contains a key word.
- Complex Query
- calculated fields in query in secondary calculation
- RE: Query by Form
- Calculation down a column
- Re: Parameter query options...
- Re: Access to Excel
- Re: Select first, If no first, then select 2nd
- Filling query with zero values (scale problem)
- Re: Select first, If no first, then select 2nd
- Re: Comparison Query
- Parameter query options...
- Select first, If no first, then select 2nd
- Re: criteria
- Re: ODBC Connection String
- Re: Time Counting
- criteria
- querying a query
- Re: A query with fields from two tables
- RE: Query Question?
- query time
- ODBC Connection String
- Re: Find nearest value
- From: I need help!!! via AccessMonster.com
- Find nearest value
- From: I need help!!! via AccessMonster.com
- Re: Isolate Characters to Sort By
- Re: Access to Excel
- Query leaving out data
- Query Question?
- Re: Time Counting
- Re: Rounding Down
- Re: Isolate Characters to Sort By
- Re: Getting User Name from a User Table
- From: Christopher Hickman via AccessMonster.com
- Re: Comparison Query
- From: Brian via AccessMonster.com
- RE: Isolate Characters to Sort By
- Re: Totals in queries and unexpected results
- Re: access switchboards
- RE: Update Query to populate newly added field
- Re: Update Query to populate newly added field
- Re: Isolate Characters to Sort By
- Re: Trimming a string with an update query - Help
- Re: Comparison Query
- Re: Append Query
- From: John Webb via AccessMonster.com
- Comparison Query
- From: Brian via AccessMonster.com
- Re: Date calculation problem
- From: John Webb via AccessMonster.com
- Re: storing tableid
- Re: SQL Sum producing rounding error on currency fields
- Re: I need help w an Update Query
- Append Query
- Re: Trimming a string with an update query - Help
- Re: Next function in Access
- Totals in queries and unexpected results
- Re: Can delete records using Delet Query
- Re: access switchboards
- Re: storing tableid
- Re: how do i set up a query for mondays only
- Update Query to populate newly added field
- Re: Merge Query Results
- Next function in Access
- Re: I need help w an Update Query
- access switchboards
- Isolate Characters to Sort By
- Re: Merge Query Results
- Re: Access to Excel
- Merge Query Results
- Trimming a string with an update query - Help
- Re: SQL Code Problem
- Re: SQL Code Problem
- Re: SQL Code Problem
- From: matt donker via AccessMonster.com
- Re: SQL Sum producing rounding error on currency fields
- Re: Find Numbers in Text Field
- I need help w an Update Query
- Re: SQL Sum producing rounding error on currency fields
- SQL Sum producing rounding error on currency fields
- Re: SQL Code Problem
- From: matt donker via AccessMonster.com
- Re: storing tableid
- how do i set up a query for mondays only
- Re: storing tableid
- Re: storing tableid
- Re: Problem counting
- Re: A query with fields from two tables
- Re: calculating an average with one or more values being NULL
- Re: Count Number of times date selected
- Count Number of times date selected
- Re: Insert Into Problem
- Re: Insert Into Problem
- Re: Access to Excel
- Insert Into Problem
- Re: Listing top 60 cars that are InStock.
- Listing top 60 cars that are InStock.
- Re: Calculating Totals
- storing tableid
- close parametered query automatically
- Re: Hiding duplicates in a query
- Re: A query with fields from two tables
- Re: expression has two many arguments
- Re: Hiding duplicates in a query
- Re: calculating an average with one or more values being NULL
- Hiding duplicates in a query
- Re: Calculating Totals
- Re: combining rows
- Re: Max totals
- combining rows
- Re: A query with fields from two tables
- Max totals
- Re: How do I calculate and show a percantage of a field value in query
- How do I calculate and show a percantage of a field value in query
- Re: A query with fields from two tables
- Re: calculating an average with one or more values being NULL
- Re: calculating an average with one or more values being NULL
- Re: Calculating Totals
- calculating an average with one or more values being NULL
- Re: Using a queries to supply criteria
- Re: query problem with unbound form
- Re: Access to Excel
- Using a queries to supply criteria
- Re: Error Message
- Re: comparing dates
- Re: Access to Excel
- Re: comparing dates
- Re: comparing dates
- Re: comparing dates
- comparing dates
- Re: A query with fields from two tables
- A query with fields from two tables
- Re: query with no relations!
- RE: Calculating Totals
- Re: Retuning multiple values from Variable
- Re: Access to Excel
- Re: Access to Excel
- Re: Problem counting
- Re: Error Message
- Error Message
- Re: How can I find a specified number of records in a SELECT query?
- Re: wildcards in the like statement
- Re: Access to Excel
- Re: query with no relations!
- Re: Updateable passthrough query
- Re: How can I find a specified number of records in a SELECT query?
- How can I find a specified number of records in a SELECT query?
- query with no relations!
- Re: Query not showing right results on form in combobox
- Re: Updateable passthrough query
- Re: SKU011.CAB
- Re: Calculating Totals
- Re: Calculating Totals
- Re: wildcards in the like statement
- Re: Crosstab multivalue and column order
- Re: Character limit on field in crosstab query
- Re: wildcards in the like statement
- wildcards in the like statement
- Re: Append Query Headache!
- Re: Calculating Totals
- Re: Access to Excel
- Re: Access to Excel
- Re: How do I calculate a percentage of a filed value in a query?
- Re: Access to Excel
- Re: How do I calculate a percentage of a filed value in a query?
- Calculating Totals
- Re: Access to Excel
- Re: Access to Excel
- Re: How do I calculate a percentage of a filed value in a query?
- Re: Access to Excel
- Re: How do I calculate a percentage of a filed value in a query?
- Re: How do I calculate a percentage of a filed value in a query?
- Re: Time Counting
- Re: How do I calculate a percentage of a filed value in a query?
- Access to Excel
- Re: Query producing duplicate records
- Re: Append Query Headache!
- How do I calculate a percentage of a filed value in a query?
- Re: mismatch JOIN Expression Problem
- Re: Append Query Headache!
- Re: Append Query Headache!
- Re: Calculating on Null Fields
- Append Query Headache!
- Re: Updateable passthrough query
- SKU011.CAB
- Re: Crosstab multivalue and column order
- Time Counting
- Character limit on field in crosstab query
- Calculating on Null Fields
- Re: Updateable passthrough query
- Access 2000 Recursive Query Help
- Re: Multiple Instances - Database Opens
- Re: Crosstab multivalue and column order
- Re: Numbers to Words
- Re: deleting a record
- deleting a record
- Updateable passthrough query
- Re: extract part of a field
- Multiple Instances - Database Opens
- Query not showing right results on form in combobox
- RE: How can I query or sort on just a 5 numeric entries in a field?
- Re: Numbers to Words
- Re: Close query automatically
- Re: How can I query or sort on just a 5 numeric entries in a field?
- Re: extract part of a field
- mismatch JOIN Expression Problem
- RE: How can I query or sort on just a 5 numeric entries in a field?
- Re: extract part of a field
- RE: How can I query or sort on just a 5 numeric entries in a field?
- How can I query or sort on just a 5 numeric entries in a field?
- RE: a simple query, maybe
- Numbers to Words
- Re: Query not responding
- Query not responding
- Re: Table Joins 101
- Re: extract part of a field
- RE: How do I calculate the first 2 characters each of two fields i
- Re: Need Between not UpTo (not including)
- Re: extract part of a field
- RE: How do I calculate the first 2 characters each of two fields into.
- Re: extract part of a field
- Re: SQL Code Problem
- Re: SQL Code Problem
- From: matt donker via AccessMonster.com
- Re: a very slow SQL query
- Re: sequencing make quantity
- From: Ryan Arledge via AccessMonster.com
- Re: Create a Date Query
- Create a Date Query
- How do I calculate the first 2 characters each of two fields into.
- Re: SQL Code Problem
- Close query automatically
- Re: Multi-Table Query
- Re: SQL Code Problem
- From: matt donker via AccessMonster.com
- Re: Hide Columns where there is no value
- From: dale pinn via AccessMonster.com
- Re: Complex Query Question
- Re: What type of query?
- Using an Autolookup Qry to add new rows to table
- From: D Macpherson via AccessMonster.com
- Re: Operation must use an updateable query
- Re: Table Joins 101
- Re: Table Joins 101
- Table Joins 101
- Re: Horizontal structure to Vertical Query
- Re: Accumulating sums
- Re: Accumulating sums
- Accumulating sums
- Re: query
- query
- Re: sequencing make quantity
- Re: How can I creat an Access query to find duplicate records?
- Re: "dynamic" column lookup
- Re: Operation must use an updateable query
- Re: update query and case sensitive
- Operation must use an updateable query
- Re: Sum of Query not reporting zero values
- Re: Sum of Query not reporting zero values
- Re: update query and case sensitive
- Re: IIf statements
- update query and case sensitive
- Re: SQL Code Problem
- Re: Sum of Query not reporting zero values
- Sum of Query not reporting zero values
- Re: The like clause of sql
- Re: The like clause of sql
- Re: Nevermind I figured it out
- Re: Find Numbers in Text Field
- RE: Nevermind I figured it out
- Re: "dynamic" column lookup
- Multi-Table Query
- Re: Export query to .txt file
- Re: Getting User Name from a User Table
- Re: query problem with unbound form
- Re: The like clause of sql
- Re: IIF STATEMENT IN UPDATE QUERY
- Crosstab multivalue and column order
- Re: query problem with unbound form
- Complex Query Question
- Re: Return all data, even null in query
- Re: Is it possible to create a graph based on two or more queries?
- Re: Export query to .txt file
- Re: Query producing duplicate records
- Re: The like clause of sql
- Re: IIf statements
- Re: IIF STATEMENT IN UPDATE QUERY
- Re: MULTIPLE JOINS
- Getting User Name from a User Table
- From: Christopher Hickman via AccessMonster.com
- Re: Retuning multiple values from Variable
- Re: sql problem
- The like clause of sql
- Re: IIf statements
- Re: Toolbars and Menus
- Re: IIf statements
- Re: Summing records selected in query
- Re: sql problem
- Re: Summing records selected in query
- Re: How to combine Queries
- What type of query?
- Re: Table vs Query - question
- Re: IIf statements
- IIf statements
- Re: Summing records selected in query
- Re: sql problem
- Re: Horizontal structure to Vertical Query
- Re: Horizontal structure to Vertical Query
- Re: Is there a way to specify column width in a crosstab query?
- Re: Sorting problem in access
- Re: sql problem
- RE: select field which contains certain text
- Re: Help with Max Date please ...
- Sorting problem in access
- RE: ALTER TABLE Query Pops-Up an empty Message Box
- RE: ALTER TABLE Query Pops-Up an empty Message Box
- Re: Summing records selected in query
- RE: select field which contains certain text
- Re: Summing records selected in query
- ALTER TABLE Query Pops-Up an empty Message Box
- Re: "dynamic" column lookup
- Re: How can I creat an Access query to find duplicate records?
- Re: query question about Between
- Re: Multiple Returns
- RE: Help with Max Date please ...
- RE: Summing records selected in query
- Re: Type Conversion Failure in Update Query
- Re: The like clause of sql
- Nevermind I figured it out
- Multiple Returns
- Find Numbers in Text Field
- How can I creat an Access query to find duplicate records?
- Re: Type Conversion Failure in Update Query
- From: Kevin Beck via AccessMonster.com
- Re: Type Conversion Failure in Update Query
- From: Kevin Beck via AccessMonster.com
- Re: Need Help Referencing a Year
- Re: Need Between not UpTo (not including)
- RE: Summing records selected in query
- Re: The like clause of sql
- select field which contains certain text
- Re: Need Between not UpTo (not including)
- Re: Problem counting
- Re: Need Between not UpTo (not including)
- Need Between not UpTo (not including)
- MULTIPLE JOINS
- Re: sequencing make quantity
- query problem with unbound form
- Re: Union Query works on my PC's but not on clients machines
- Re: date difference using current date is no date is entered
- Re: The like clause of sql
- Summing records selected in query
- Re: date difference using current date is no date is entered
- Re: Type Conversion Failure in Update Query
- Re: The like clause of sql
- Re: Combine text from same text field
- Re: Combine text from same text field
- Re: Combine text from same text field
- sequencing make quantity
- From: Ryan Arledge via AccessMonster.com
- Type Conversion Failure in Update Query
- From: Kevin Beck via AccessMonster.com
- Re: CALCULATED FIELDS
- "dynamic" column lookup
- Re: date difference using current date is no date is entered
- Re: Combine text from same text field
- Combine text from same text field
- Re: SQL Code Problem
- From: matt donker via AccessMonster.com
- Re: date difference using current date is no date is entered
- Re: extract part of a field
- Re: date difference using current date is no date is entered
- Re: sql problem
- Re: SQL Code Problem
- Re: CALCULATED FIELDS
- Re: SQL Code Problem
- From: matt donker via AccessMonster.com
- Re: extract part of a field
- Re: SQL Code Problem
- From: matt donker via AccessMonster.com
- date difference using current date is no date is entered
- Re: SQL Code Problem
- From: matt donker via AccessMonster.com
- CALCULATED FIELDS
- Re: SQL Code Problem
- Re: Hide Columns where there is no value
- Re: SQL Code Problem
- From: matt donker via AccessMonster.com
- Is there a way to specify column width in a crosstab query?
- From: Carl Jansson via AccessMonster.com
- Horizontal structure to Vertical Query
- IIF STATEMENT IN UPDATE QUERY
- Retuning multiple values from Variable
- Re: SQL Code Problem
- Return all data, even null in query
- Toolbars and Menus
- From: Steve Murphy (Kuwait in Army**US)
- Re: Problem counting
- Re: Hide Columns where there is no value
- From: dale pinn via AccessMonster.com
- Problem counting
- SQL Code Problem
- From: matt donker via AccessMonster.com
- Re: query question about Between
- Re: query question about Between
- Re: Hide Columns where there is no value
- Re: SQL Variable Issue
- Re: How to enter data into a multiple table query
- From: Nikos Yannacopoulos
- query question about Between
- How to enter data into a multiple table query
- RE: Compare lowest and second lowest records
- RE: I need a query for getting the 2nd highest marks from a table.
- Re: Multiple columns
- I need a query for getting the 2nd highest marks from a table.
- From: Query of 2nd Highest Marks
- Re: query question
- Re: Generating an Auto Number ID Field in a Make Table Query
- Re: How to combine Queries
- Compare lowest and second lowest records
- Re: Generating an Auto Number ID Field in a Make Table Query
- Re: Implementing Oracle's MINUS set operator in T-SQL
- Re: Query dates less than a year old.
- Re: How to combine Queries
- RE: Query dates less than a year old.
- Re: Query dates less than a year old.
- Re: Query ???
- Query dates less than a year old.
- Re: Combine 2 tables for a report
- Re: Combine 2 tables for a report
- Re: Date Conversion
- Re: Generating an Auto Number ID Field in a Make Table Query
- How to combine Queries
- Re: Query producing duplicate records
- Re: Order records Access 2000
- Combine 2 tables for a report
- Re: combine fields in a payoff system
- Re: Date Conversion
- From: Send Object Command - Two attachments
- Re: JUst the year lookup
- Re: Need Help Referencing a Year
- Re: make-table query, naming the table
- Re: JUst the year lookup
- RE: Multiple columns
- Hide Columns where there is no value
- From: dale pinn via AccessMonster.com
- Is it possible to create a graph based on two or more queries?
- JUst the year lookup
- Re: Order records Access 2000
- Re: SQL Query
- Order records Access 2000
- Implementing Oracle's MINUS set operator in T-SQL
- Re: Query ???
- Re: Date Conversion
- Re: Query ???
- Re: Need Help Referencing a Year
- Re: Query producing duplicate records
- combine fields in a payoff system
- Date Conversion
- From: Send Object Command - Two attachments
- query question
- Query ???
- Export query to .txt file
- SQL Variable Issue
- From: Kurt Abele via AccessMonster.com
- Re: Help with IIF in a query
- From: Kurt Abele via AccessMonster.com
- Re: Generating an Auto Number ID Field in a Make Table Query
- Re: Need Query for Duplicate Problem
- Re: Where to type the IIF statement?
- Re: search rows to see if name shows up in any column
- Re: Criteria Help
- Re: Append Queries
- Re: can you change a query to a table?
- Re: can you change a query to a table?
- Re: Null Value To Show All Records
- Re: can you change a query to a table?
- Re: Need Help Referencing a Year
- Re: Need Query for Duplicate Problem
- Null Value To Show All Records
- can you change a query to a table?
- Append Queries
- From: Michael Stengel via AccessMonster.com
- Re: InStr function
- search rows to see if name shows up in any column
- Re: Help with IIF in a query
- Re: Need Help Referencing a Year
- Re: InStr function
- Re: InStr function
- Re: make-table query, naming the table
- Re: make-table query, naming the table
- Re: InStr function
- Re: make-table query, naming the table
- Re: convert memo to text
- Re: Generating an Auto Number ID Field in a Make Table Query
- Re: Need Help Referencing a Year
- Re: InStr function
- Re: expression has two many arguments
- RE: multi table query doesnt work!
- Re: make-table query, naming the table
- Help with IIF in a query
- From: Kurt Abele via AccessMonster.com
- Generating an Auto Number ID Field in a Make Table Query
- Re: filtering calculated fields
- Re: Where to type the IIF statement?
- Re: make-table query, naming the table
- RE: InStr function
- Need Help Referencing a Year
- Re: InStr function
- expression has two many arguments
- filtering calculated fields
- Criteria Help
- Re: make-table query, naming the table
- Re: InStr function
- RE: multi table query doesnt work!
- From: DowningDevelopments
- make-table query, naming the table
- InStr function
- Re: convert memo to text
- Re: convert memo to text
- RE: multi table query doesnt work!
- Re: Show top 10 count for data
- Re: Subtract one field from another to make a third field in a que
- Re: Subtract one field from another to make a third field in a que
- Re: Multiple columns
- Re: Multiple columns
- Re: Subtract one field from another to make a third field in a query?
- Re: Multiple columns
- Re: How to get the computer out of safe mode
- Re: Multiple columns
- Re: HOW DO I GROUP BY A TEXT FIELD AND SUM THE AMT..
- Re: Multiple columns
- Re: SQL Query converted to SQL Server
- RE: multi table query doesnt work!
- From: DowningDevelopments
- How to get the computer out of safe mode
- Re: Multiple columns
- RE: Parameter Values
- RE: Parameter Values
- Multiple columns
- Re: Next Record In Table
- multi table query doesnt work!
- From: DowningDevelopments
- Re: Table vs Query - question
- Parameter Values
- Re: Where to type the IIF statement?
- Re: ODBC Linked tables
- Re: Performance questions
- Subtract one field from another to make a third field in a query?
- Re: update query..not updating % field..
- Re: SQL Query converted to SQL Server
- From: Chris Motherwell via AccessMonster.com
- Re: grouping on dates
- Next Record In Table
- Re: Sort by two, then sum?
- Re: SQL Query
- Re: convert memo to text
- Re: This is just great....
- Re: help in writing query in access
- Re: count/sum issue
- Re: This is just great....
- Re: Where to type the IIF statement?
- convert memo to text
- Re: Can delete records using Delet Query
- Re: This is just great....
- This is just great....
- Re: Can delete records using Delet Query
- Re: Query with multiple on/off fields
- Re: Rolling Sum
- Re: Putting a Timestamp in a memo field on a form.
- Re: Syntax error in INSERT INTO Statement
- Re: Problem linking tables for a Totals query
- Re: How can I get the current date to print on Access 2003?
- Re: update query..not updating % field..
- How can I get the current date to print on Access 2003?
- RE: Query to Generate Flag if Customer has E-Mail on file
- Re: Where to type the IIF statement?
- Re: update query..not updating % field..
- Table vs Query - question
- Re: Differences in record formats / same data
- update query..not updating % field..
- Query producing duplicate records
- Re: Sort by two, then sum?
- Where to type the IIF statement?
- Re: help in writing query in access
- Re: grouping on dates
- Re: SQL Query converted to SQL Server
- Re: grouping on dates
- Re: How do I use functions to update queries in Access?
- Sort by two, then sum?
- From: Andrew Knapp via AccessMonster.com
- Re: Query Problem
- Re: Date Format Question
- Re: help in writing query in access
- Re: How I can make linked query?
- Re: test for error in if statement
- Re: How do I compare two excel files in access?
- help in writing query in access
- Re: Problem linking tables for a Totals query
- Re: count/sum issue
- Re: test for error in if statement
- Re: Performance questions
- Re: count/sum issue
- Re: Append or Update or What?
- Re: How do I use functions to update queries in Access?
- Re: ODBC Linked tables
- Re: Parameter query ulcer-ridden report results
- Re: grouping on dates
- test for error in if statement
- Problem linking tables for a Totals query
- Re: Complex Select Query
- count/sum issue
- Re: how do i query an access database by date?
- Append or Update or What?
- How do I use functions to update queries in Access?
- ODBC Linked tables
- Re: SQL Query
- Re: a very slow SQL query
- Re: Return zeros in a table instead of blanks in a make-table quer
- Re: Comparing fields from two different tables to give quantity re
- Parameter query ulcer-ridden report results
- Re: Return zeros in a table instead of blanks in a make-table quer
- Re: Union Query
- Re: a very slow SQL query
- Query Problem
- Re: how do i query an access database by date?
- SQL Query
- Re: Return zeros in a table instead of blanks in a make-table quer
- Re: queries
- Date Format Question
- how do i query an access database by date?
- grouping on dates
- Re: Return zeros in a table instead of blanks in a make-table query
- Return zeros in a table instead of blanks in a make-table query
- Re: query returns no records
- Re: a very slow SQL query
- Re: Compare two tables
- Re: User Parameters in a query??
- How do I compare two excel files in access?
- Re: query returns no records
- Re: Returning only the Numeric portion of a field in a query
- Re: Returning only the Numeric portion of a field in a query
- User Parameters in a query??
- How do I compare two excel files in access?
- Re: Compare two tables
- Union Query
- Re: query returns no records
- Re: Reverse a check box value
- Re: Truncate data into another field
- Re: result sort
- Compare two tables
- Re: Sort button's dual functionality bug confirmed.
- Re: Setting Record Source property to a Query
- From: Jeff A via AccessMonster.com
- Re: Setting Record Source property to a Query
- Re: Setting Record Source property to a Query
- From: Nikos Yannacopoulos
- a very slow SQL query
- Setting Record Source property to a Query
- From: Jeff A via AccessMonster.com
- Re: Performance questions
- Re: Can delete records using Delet Query
- Re: Returning only the Numeric portion of a field in a query
- Re: Syntax error in INSERT INTO Statement
- Re: How to crop a leading blank space resulting from a query
- Syntax error in INSERT INTO Statement
- RE: How to crop a leading blank space resulting from a query
- Re: SQL Query converted to SQL Server
- From: Chris Motherwell via AccessMonster.com
- Re: Putting a Timestamp in a memo field on a form.
- How to crop a leading blank space resulting from a query
- Re: Link a query to show more fields
- Re: Link a query to show more fields
- Re: How can I return a limited set of table fields conditionally?
- Re: Show top 10 count for data
- Re: Dcount gives incorrect result
- Re: Returning only the Numeric portion of a field in a query
- Returning only the Numeric portion of a field in a query
- Re: update table rows using key..
- Re: Search within time range
- Re: Search within time range
- Re: show parital data from a field
- Re: date/time query
- RE: show parital data from a field
- Re: Search within time range
- show parital data from a field
- date/time query
- Complex Select Query
- Search within time range
- Dcount gives incorrect result
- Re: Change a field in a query
- Re: update table rows using key..
- Re: query returns no records
- Re: query returns no records
- Re: two tables in Access. Table 1 has 6000 records table 2 has 200. I.
- Re: query returns no records
- two tables in Access. Table 1 has 6000 records table 2 has 200. I.
- Re: Access crashes when query is saved or when opening design view
- Re: query returns no records
- Re: Rolling Sum
- Re: query returns no records
- Re: Relationship Help!
- Re: Rolling Sum
- Re: Query Problems
- Re: Relationship Help!
- Change a field in a query
- Re: Rolling Sum
- Rolling Sum
- Re: query returns no records
- Re: Show top 10 count for data
- Re: problem with query in vba
- Re: Trying to Average an Average
- Re: Access crashes when query is saved or when opening design view
- Re: Relationship Help!
- Re: Link a query to show more fields
- Re: Simple Query
- Re: Basic Query !
- Re: Timeout
- Re: query returns no records
- Re: Show top 10 count for data
- Re: Simple Query
- Timeout
- Sort button’s dual functionality bug confirmed.
- Basic Query !
- Re: queries
- Simple Query
- Re: queries
- Re: Truncate data into another field
- update table rows using key..
- Re: Truncate data into another field
- Re: Return Max Value in Row
- Re: Reverse a check box value
- Re: convert queries to code
- Re: How to with Delete Query
- Re: Query with multiple on/off fields
- Re: convert queries to code
- Re: which operator
- Re: query by phone number
- Re: Query Problems
- Re: Union Query works on my PC's but not on clients machines
- Union Query works on my PC's but not on clients machines
- Re: Link a query to show more fields
- Re: Reverse a check box value
- Query Problems
- Re: Reverse a check box value
- Re: Return Max Value in Row
- Re: Reverse a check box value
- Return Max Value in Row
- Relationship Help!
- Reverse a check box value
- Re: Truncate data into another field
- Re: How to with Delete Query
- Truncate data into another field
- Access crashes when query is saved or when opening design view
- How to with Delete Query
- Show top 10 count for data
- Performance questions
- Re: Need a query within a range of dates
- Re: query returns no records
- RE: Need a query within a range of dates
- Re: Need Query for Duplicate Problem
- Re: Help with query counting unique records???
- Re: query returns no records
- query returns no records
- Re: How can I return a limited set of table fields conditionally?
- Re: Trying to Average an Average
- Re: stop the "Can't append all records" message from showing
- Re: stop the "Can't append all records" message from showing
- Re: Total
- Re: Query results allowing new record?
- Re: Can delete records using Delet Query
- From: Nikos Yannacopoulos
- Total
- RE: In Excel this would be a "lookup"!
- Re: Query with multiple on/off fields
- In Excel this would be a "lookup"!
- Re: Query results allowing new record?
- convert queries to code
- stop the "Can't append all records" message from showing
- Re: result sort
- Re: result sort
- Re: Append query with criteria to coimpare values of 2 fields
- which operator
- Re: Dateadd function
- Re: Help with query counting unique records???
- Dateadd function
- From: na via AccessMonster.com
- query by phone number
- From: na via AccessMonster.com
- Re: Link a query to show more fields
- Re: Complex Time Calculation
- Re: Transform, crosstabs via Visual Basic Code
- Complex Time Calculation
- Re: Need a query within a range of dates
- Transform, crosstabs via Visual Basic Code
- Re: append queries
- RE: Need a query within a range of dates
- Re: Need a query within a range of dates
- Re: Need a query within a range of dates
- Need a query within a range of dates
- Re: Challenging DLookup expression
- Re: How can I return a limited set of table fields conditionally?
- Re: query problem
- Re: Form Field use in a DMAX Statement
- Link a query to show more fields
- Re: result is not what expected...
- How I can make linked query?
- Re: queries
- queries
- Re: query problem
- Re: Help with criteria for an updatequery
- Challenging DLookup expression
- Re: math formulas for stdev
- Re: DLookup in query; percentage format
- Re: About Access
- append queries
- From: Michael Stengel via AccessMonster.com
- DLookup in query; percentage format
- running sum in queries
- Re: WORKING WEEK IS MONDAY TO SUNDAY
- math formulas for stdev
- Re: How can I return a limited set of table fields conditionally?
- Re: WORKING WEEK IS MONDAY TO SUNDAY
- Re: Trouble getting Results based on Date AND Time
- Re: Help with criteria for an updatequery
- Re: Using a Simple Query Wizard
- Re: Help with criteria for an updatequery
- RE: Help with criteria for an updatequery
- Form Field use in a DMAX Statement
- Help with criteria for an updatequery
- RE: Trouble getting Results based on Date AND Time
- Re: WORKING WEEK IS MONDAY TO SUNDAY
- Re: How can I return a limited set of table fields conditionally?
- Re: null date field
- Re: Add Query
- Re: WORKING WEEK IS MONDAY TO SUNDAY
- Re: WORKING WEEK IS MONDAY TO SUNDAY
- Re: Help with query counting unique records???
- Re: Multi Criteria Query
- WORKING WEEK IS MONDAY TO SUNDAY
- Using a Simple Query Wizard
- Re: query problem
- Re: Need Query for Duplicate Problem
- Re: greater than and blank wih same field
- Re: null date field
- Re: Update Query - writing a value into a blank field
- Re: greater than and blank wih same field
- Re: Help with query counting unique records???
- greater than and blank wih same field
- Re: Access 97 - query by form using many combo boxes
- Re: result is not what expected...
- Re: query won't return results
- Re: query won't return results
- Re: result is not what expected...
- Re: Append query using paramters
- Re: query won't return results
- Re: query won't return results
- Append query using paramters
- Re: null date field
- Re: Query Woes
- Re: query won't return results
- Re: Multi Criteria Query
- Re: Updateable Query Problem
- Updateable Query Problem
- RE: why this wont work?
- result is not what expected...
- Re: Need Query for Duplicate Problem
- why this wont work?
- Multi Criteria Query
- Update Query - writing a value into a blank field
- query won't return results
- Re: How can I return a limited set of table fields conditionally?
- Re: Unable to open query with Complex Expression
- Re: Add Query
- Unable to open query with Complex Expression
- Re: SCREEN UPDATING MACROS
- Re: How can I return a limited set of table fields conditionally?
- Re: null date field
- Expression Builder
- Re: Add Query
- Re: What is the difference between Excell database and Access databas.
- Add Query
- Re: Access SQL on Oracle Tables thru ODBC
- Re: Date Query Help Please
- Re: Wrong result from INNER JOIN query if not sorting.
- null date field
- Date Query Help Please
- Re: Trying to Average an Average
- Re: SQL Query converted to SQL Server
- Query Woes
- About Access
- From: Ramaprasad Keshavamurthy via AccessMonster.com
- Re: List Box Access 97
- SQL Query converted to SQL Server
- From: Chris Motherwell via AccessMonster.com
- Is Datatype, my incrementing problem?
- What is the difference between Excell database and Access databas.
- How can I return a limited set of table fields conditionally?
- problem with query in vba
- Re: Yesterdays Date
- Re: random records
- Re: Yesterdays Date
- Re: Yesterdays Date
- Yesterdays Date
- Re: query problem
- Re: Wrong result from INNER JOIN query if not sorting.
- Re: sorting/filtering series of dates to return only most recent data.
- Re: query/report on multiple dates
- Re: List Box Access 97
- random records
- Re: Budget Comparison
- RE: Sum Total from previous records
- Re: query/report on multiple dates
- Re: Access SQL on Oracle Tables thru ODBC
- Re: pass through query for ODBC links
- Re: Multiple calculations on same field in Query, by range of valu
- Re: problem with query in vba
- Re: Append query with criteria to coimpare values of 2 fields
- Re: How do I show all records in from two tables in a make-table query
- Re: null or is not null
- List Box Access 97
- Re: query problem
- query problem
- Re: Update Query To Append Zero to front of deptid
- From: Denise Blum via AccessMonster.com
- Re: Need Query for Duplicate Problem
- Re: Update Query To Append Zero to front of deptid
- Re: Need Query for Duplicate Problem
- Update Query To Append Zero to front of deptid
- From: Denise Blum via AccessMonster.com
- Re: query
- Re: Current record/row ID in query
- Re: Use old "sales quantity" fields to predict next years likely quan
- query
- Re: Need Query for Duplicate Problem
- Re: problem with query in vba
- Re: Error from Append Query
- Re: Calulating quarters from date field
- Re: problem with query in vba
- Re: problem with query in vba
- Budget Comparison
- Re: Error from Append Query
- Re: Error from Append Query
- Use old "sales quantity" fields to predict next years likely quan
- Error from Append Query
- Re: split string
- Re: Proper Case
- Need Query for Duplicate Problem
- query/report on multiple dates
- problem with query in vba
- Re: Multiple calculations on same field in Query, by range of valu
- Re: Trying to Average an Average
- Calulating quarters from date field
- split string
- Re: My query is not showing any information, and it should based on t.
- Re: Multiple calculations on same field in Query, by range of values
- Re: Current record/row ID in query
- Re: How do I see the whole contents of a large field in Access?
- Re: Help with bi-weekly ending date
- Re: Proper Case
- Access SQL on Oracle Tables thru ODBC
- Re: Differences in record formats / same data
- How do I see the whole contents of a large field in Access?
- Re: Querying for phrase that includes the word And
- pass through query for ODBC links
- RE: Multiple calculations on same field in Query, by range of values
- Re: My query is not showing any information, and it should based on t.
- From: Nikos Yannacopoulos
- Re: Running Totals / Running Sums
- Append query with criteria to coimpare values of 2 fields
- Re: Query help recquired please
- My query is not showing any information, and it should based on t.
- How do I show all records in from two tables in a make-table query
- Re: Running Totals / Running Sums
- Re: Proper Case
- Re: Differences in record formats / same data
- Re: Current record/row ID in query
- Running Totals / Running Sums
- Help with bi-weekly ending date
- Proper Case
- Current record/row ID in query
- Re: Putting a Timestamp in a memo field on a form.
- Re: Calculating in query
- Re: Multiple Combo Box Queries - one OR the other?
- Re: Calculating YTD
- Re: Calculating YTD
- Re: Date/field query problem
- RE: Calculating in query
- Re: result sort
- Re: RunSum
- Re: calculating age
- Putting a Timestamp in a memo field on a form.
- Calculating in query
- Multiple Combo Box Queries - one OR the other?
- Calculating YTD
- Date/field query problem
- Re: Total query using date range.
- Re: calculating age
- calculating age
- Re: Delete Records From One Table that are Duplicated in Another
- Re: Need query to split table into 2 linked tables
- Re: Trying to Average an Average
- Re: Querying for phrase that includes the word And
- Re: Querying for phrase that includes the word And
- Re: case insensitive query in join
- Re: Querying for phrase that includes the word And
- Re: Distinct Record Query
- Re: Query Title for Printout
- Re: Querying for phrase that includes the word And
- Re: Need query to split table into 2 linked tables
- Re: RunSum
- Re: Querying for phrase that includes the word And
- Re: how to count records in a query
- Re: Wrong result from INNER JOIN query if not sorting.
- From: david epsom dot com dot au
- Querying for phrase that includes the word And
- Re: case insensitive query in join
- Re: case insensitive query in join
- Re: Problem in building dynamic query
- Re: case insensitive query in join
- Re: Differences in record formats / same data
- null or is not null
- Re: Need query to split table into 2 linked tables
- Problem in building dynamic query
- Re: Hours formatting issue
- case insensitive query in join
- Query Title for Printout
- Differences in record formats / same data
- RE: CountofDate
- Trying to Average an Average
- Re: Help with Query: SQL
- CountofDate
- Re: 2 Seperate Date Ranges in query criteria
- Re: 2 Seperate Date Ranges in query criteria
- Re: Query results allowing new record?
- Re: 2 Seperate Date Ranges in query criteria
- Re: Rewritten question
- Re: Multiple calculations on same field in Query, by range of values
- Re: Make Table qry - trim SSN to last 4 digits
- Re: Query that can do calcualtions and hold previous values
- Re: Need query to split table into 2 linked tables
- Query that can do calcualtions and hold previous values
- Re: Query results allowing new record?
- Re: 2 Seperate Date Ranges in query criteria
- 2 Seperate Date Ranges in query criteria
- Query results allowing new record?
- how to count records in a query
- Re: Make Table qry - trim SSN to last 4 digits
- Re: Make Table qry - trim SSN to last 4 digits
- RE: Query to Generate Flag if Customer has E-Mail on file
- Re: Make Table qry - trim SSN to last 4 digits
- Re: Need query to split table into 2 linked tables
- Re: Make Table qry - trim SSN to last 4 digits
- Multiple calculations on same field in Query, by range of values
- Make Table qry - trim SSN to last 4 digits
- RE: Delete Records From One Table that are Duplicated in Another
- Re: Need query to split table into 2 linked tables
- RE: Delete Records From One Table that are Duplicated in Another
- Re: Delete Records From One Table that are Duplicated in Another
- Re: select query using user defined variable
- Re: select query using user defined variable
- Re: Newbie: date-time help
- Re: Union query
- Re: Update query
- Re: Total query using date range.
- Need query to split table into 2 linked tables
- Delete Records From One Table that are Duplicated in Another
- Re: Newbie: date-time help
- Re: Union query
- Re: Wrong result from INNER JOIN query if not sorting.
- Re: Date B4 16th Each Month After 16th Each Month
- select query using user defined variable
- RE: Frequency Query
- Newbie: date-time help
- Re: Total query using date range.
- Frequency Query
- Union query
- Update query
- Re: Word Note
- Re: Date B4 16th Each Month After 16th Each Month
- Total query using date range.
- Re: Function to convert TEXT to a STRING
- From: Andre Laplume via AccessMonster.com
- Date B4 16th Each Month After 16th Each Month
- Re: RunSum
- Word Note
- Re: RunSum
- Re: RunSum
- RE: Query to Generate Flag if Customer has E-Mail on file
- Re: result sort
- RE: Calculating Reorder Cycles
- Re: How to get the quantity of a previous three months?
- Re: Same Parameter Query For More Than One Field
- Re: Comparing fields from two different tables to give quantity remain
- Re: RunSum
- Re: Distinct Record Query
- Re: how do I limit the number of decimal places in Access 2003?
- Re: How do you derive an amount available in a query?
- Re: Exporting a Query Result
- Re: Hours formatting issue
- Re: how do I limit the number of decimal places in Access 2003?
- RunSum
- how do I limit the number of decimal places in Access 2003?
- Re: Need to speed up this query
- How to get the quantity of a previous three months?
- From: Gracela Pilots via AccessMonster.com
- Comparing fields from two different tables to give quantity remain
- Re: Working out Different between several times
- Re: Add hour to date/time field
- Re: Add hour to date/time field
- Re: Exporting a Query Result
- Re: Wrong result from INNER JOIN query if not sorting.
- Re: Add hour to date/time field
- Re: One-To-Many Relationship On One Row
- Re: One-To-Many Relationship On One Row
- Re: One-To-Many Relationship On One Row
- Re: One-To-Many Relationship On One Row
- Re: Add hour to date/time field
- Add hour to date/time field
- Re: Deleting duplicate records
- One-To-Many Relationship On One Row
- RE: Exporting a Query Result
- Re: Query help recquired please
- Re: Same Parameter Query For More Than One Field
- Same Parameter Query For More Than One Field
- Re: Totals Query
- Re: Returning Uppercase entries
- Re: Returning Uppercase entries
- RE: Level Organized DB - Is Query the Answer?
- Returning Uppercase entries
- RE: Looking for missing criteria
- RE: Calculating Reorder Cycles
- RE: Calculating Reorder Cycles
- Re: Totals Query
- Wrong result from INNER JOIN query if not sorting.
- Re: Totals Query
- Re: Totals Query
- Re: field values
- Totals Query
- Re: Update query ...
- RE: Help with Query
- Re: Help with Query
- Re: field values
- Re: Query help recquired please
- Re: Query help recquired please
- Re: Function to convert TEXT to a STRING
- Re: Update query ...
- Re: Validation Rule Error
- Function to convert TEXT to a STRING
- From: Andre Laplume via AccessMonster.com
- Re: Query with value from separate forms
- Re: Update query ...
- Re: field values
- Re: Can you use field names to point to needed data?
- Re: combine access tables into one table
- Re: Hours formatting issue
- Re: Join Query problem for Stock Control
- Re: combine access tables into one table
- Re: Query with value from separate forms
- RE: Duplicate entry in my query
- Re: combine access tables into one table
- Re: combine access tables into one table
- Re: Updating a table from a form
- field values
- Help with Query
- Re: Max and Max-1 in query
- Re: Query help recquired please
- Validation Rule Error
- Re: Distinct Record Query
- Query help recquired please
- Re: Here's a challenge
- Re: Hours formatting issue
- Re: What is the problem with this query
- Need to speed up this query
- Exporting a Query Result
- Re: What is the problem with this query
- Update query ...
- Level Organized DB - Is Query the Answer?
- How do you derive an amount available in a query?
- Can you use field names to point to needed data?
- Re: How do I query a due date plus 90 days?
- Re: How do I query a due date plus 90 days?
- Re: combine access tables into one table
- Re: combine access tables into one table
- Re: Trouble getting Results based on Date AND Time
- How do I query a due date plus 90 days?
- Re: combine access tables into one table
- Re: Working out Different between several times
- combine access tables into one table
- Join Query problem for Stock Control
- Median from a Query
- Updating a table from a form
- Using dropdown to get max records?
- RE: a simple query, maybe
- a simple query, maybe
- What is the problem with this query
- Max and Max-1 in query
- Looking for missing criteria
- RE: Access - ActiveX component
- Rewritten question
- RE: input parameter to 3 fields
- Re: Working out Different between several times
- RE: Duplicate entry in my query
- Re: rank and update query
- RE: Query to Generate Flag if Customer has E-Mail on file
- query with wildcards
- a simple query, maybe
- Distinct Record Query
