Microsoft Access Queries [Archive] - Page 6

Update query - sequential numbering
RE: Sort by text
Query + cumbo box
Re: Group By and Grouping
Re: Display highest rate of record
How could I combine these 2 queries into one in Access 2007?
Query Sorting
Re: Group By and Grouping
Query export as Table
Re: Group By and Grouping
How do I add a column that calculates the product of two fields?
Query by Form "blows-up" when query is closed and re-opened
Format Cells in a query created using SQL
Query to show 2 records from each unique entry in a field
Select 2 dates on form and use query/report to sum cost between da
RE: query
audit a formula
Update Form
Query for Forecasting Fuel Usage
Add records to Join Table
Re: Average query
queries delete themself after i print my reports
5 Facts You MUST Understand if You Are Going to Lose Your Belly Fat
Re: Yes/No
Find unused subqueries?
Sum between Dates
Query to add rows with a criteria
calculating budget queries
Senior moment on capturing all records from joined query
Strip $ and , from a Text field
Reports are only totaling the fields for the first record
displayFormat (non-SQL programmer)
including null values in a sum query (non-SQL programmer)
Want to edit a table based on a query of a query of several querie
Find $
dynamic queries
RE: counting number question
Must enter something in a field
Donor query
Update Query
Return records entered today
Insert Record into Oracle Table
Second Post
DateDiff returning incorrect years
Print a list of tables in MS Access 2007
Appending data
Database Conversion To A Web Based Application
Add separate record query
return code with maximum RVU
Grabbing Data from Multiple Tables & Pasting it into Another?
Checkboxes that return zero are counted as 1 in my report
Query Design
Selecting a Query from a drop down box
Criteria not excluding data
Re: Quickest way to display null values or 0 for multiple columns in table
Re: Quickest way to display null values or 0 for multiple columns intable
how make table name in make-table query an input?
Setting field size to double when create tableusing a make table q
SQL Strings Truncating at 255 Characters ? Why?
If then AND statements in access
If then AND statements in access
Between 2 dates
Count of in Range of Dates
Re: Help Access Append Query
Calculate Fields
Maximum number of elements ina an IN() Clause
Verify if a date is between two other dates
Eliminate Popup for Make query
Update Query
RE: Append query won't run on one PC - runs on all others.
Insert data from SQL table into Access table
Two tables, multiple relationships?
make table query
Pls help. urgently required
Date Range
Allocation Query
Incorrect Data Returned
Trouble pulling most current record
Access SQL and pass though difference?
Convert 112010 to date field
Help with calculation query
Delete all one side records with no many side records
Re: Access 2007 query performance
Help! Need to update linked SQL table in Acc07
iif, or, else?
Group by and count queries
Changing reference cell in query
VBA Code to omit certain records
Converting Text Date to Real Date to #
I need help writing a query
How to reference all dates to a "Monday"
Calculation from query
IF Statements - JCW
Delete Records by Date - 2 tables involved
rounding to closest 15 minute increment
Query vs Report
Tables aren't indexed
compressing error
spelling list-
Query with "In" in the WHERE clause isn't updateable
Append and Delete in one step
IIf Query assistance
Really need query help!!
Test records from one table / query against a date range in another table
SQL Syntax for Hyperlink
# of days between two dates
Query Range of values
Statistics in Query
Query Checkmarks
LIKE Query
gl code
query too complex when transposing
Using Parameters when using an expression
Join Dates from 2 tables with different formats in a query
Crosstab Query & Month Names
Create duplicate records using a query
how do i get the last 5 for all assets
query a multivalued lookup field
Which String functions to use?
Display query results only if field is not null
Cannot add or edit to my form, nor select from the combo boxes on myform
change data type
Re: How to extract query code from MSysQueries ?
calculating Subtotals in Access Reports but under certain criteria.
Sorting question (by column)
Null Criteria Problem
Query Field Format
Criteria ignored in Excel 2007 linked to Access 2007
default to 0 when query comes up with no results
Custsom Formula for Null results
Subform Querie dependednt on main form combobox
Comparing two fields in two different records
Daily County of date records
keeping duplicates
IIf help
Total Row to Sum a Column
Need help with SQL statement
SQL query to Access database
RE: Separation
Query a text field
Re: Zero instead of null in query
Using IN() with IIF in criteria
replace characters in table
Three fields conditionally based on other fields
does Access 2003 have a "proper" case? Upper case/then Lower
Percentage and subtraction
Query specific data
Query for things happening this week
Divide By Zero Error
Update ODBC Link Table
Using IN() with IIF in criteria
Re: Import
RE: Import
Re: Import
Date Query
Count Matching records
How do I parse street address with 4 parts #,Dir,Street,Type
Query returns Arabic and/or sanskrit characters
RE: Update Query
Running Balance
IIF statement format percent
finding a registrationID for an individual.
Tag
Deleting Duplicates
Quer related to Count Function
Quer related to Count Function
count data of multiple rows independently
ERROR 3125 switching to "totals" aggregate function
Export query with passed criteria
how do i limit the records in a number of groups in access
sub totals in query come up zero
How to fix formula to avoid divide/zero and aggregate issue.
Query User Defined date range
Left Outer Join Producing Incorrect Results
ORDER BY clause not working ?!?
Re: negative number between values returns incorrect result
RE: negative number between values returns incorrect result
complex criteria to find one record using wildcards?
Update message problem
What will work best here
RE: Query join
Final Problem - Running AR updates
Make this work?
IN clause error
Max of a set of records
Passing multiple criteria to query a table
Microsoft Access Converting Dates
SQL Contains query
Re: SQL Statement with " ' " quote
Re: SQL Statement with " ' " quote
SQL Syntax for an update query
Having trouble with Outer Join
execute query from a form connected to sharepoint
Re: Count YES/NO Field
IIF statement
Multiple Dates
Select data to populate a report by GROUP
Query Design - Display data depending on date
Query with expressions that allows new records insert
Re: display records not on a date range
Increase values in integer field
Finding the last day of the year
Re: Daty entry in Query
Wildcards in parameter queries
Delete duplicate records
Ranking on a report
IIF Statement not working as expected
Query with several tables.
Subqueries
GANA DINERO VIENDO PUBLICIDAD
sub-query
Multiple queries with same filter problem.
Access Query
How to get the correct ranking from a query
Add a (sequential not autonumber) number in append query
query parameter
Pivot Table needed that groups part numbers and dates
how to change format of data already entered
Update Query for Multiple Records
wrapping dates with # question
Concatenating produces duplicates in each record.
Adding a space between fields
Field not Updateable
Query Parameter Syntax
Query Parameter Syntax
Date Query using date in the date field
IIF Statement in Query
Import Access Choose function into Excel spreadsheet - issues!
Help importing Access Choose function into excel.
Macro for copy
query
swap query axis for export toe xcel or for for reporting
Get total number of records within a crosstab query
exclude certain data in query
Query expression
Re: Assign Dates To One Week Periods And Two Week Periods
Query Help - NEW USER
Split database
Re: Expression too complex in query expression
Concatenate Values using a lookup field
RE: Expression too complex in query expression
Create query based on fields specified in list box of form
Delete Duplicates
Query Filter Help
Cross tab query with averages?
build an if statement with conditional parameters
join
Pull user's Usernames from their login screens
Difference between dates
Queries: putting multiple cells of queried data on only one line
Query for Last Name, First Name works except for one record
How do I create a column alias in Access?
RE: append query with no duplicates based on ID
RE: report query error
Memo Field Separation
Lookup in a table? Or an Update Qry?
RE: Connection busy on update query
Find unmatched query with selected date
Query Criteria using Text Box Control
Update automatically - Date Last Updated & ID
sort query with null values at end
Search on entered or blank criteria
Re: Percentage of Complete records
How to ignore the Year in a Date - Query
Query to calculate despite form fields being left blank
Subquery - merge heading and subheading titles
Update query using DSum
Nz function
Undeliverable Mail
joining two strings before query
From 1 table, make a second report of part of the records
RE: Percentage of Complete records
Re: Field in Query Expression Displaying Number on Report
Update Queries
SQL: Two criteria on one field doesn't return any records
RE: Percentage of Complete records
Re: Field in Query Expression Displaying Number on Report
Re: Field in Query Expression Displaying Number on Report
Parmeters
Memo fields not displaying in query
Update table to add new records
RE: Same Name with Multiple IDs
Does not recognize >=10
Functions not working in Access 2007 Queries
Update Query based on leaving date
Cartesian join in Access
Totals query per day per month
Several parameter queries with same question
Using a field reference in a query critereon
Subery help please...
Counting Missing values in a specific field.
MSAccess major Bug or am I loosing my marbles ?
Count Query Help Please
Summing time worked by an individual on a weekly basis
Compare Planned to Actual monthly payments
using only partial data for stats
data base split
Crosstab query as data source for update query
Query
Query to work out which rate should be inserted
Please , help me
Filling in blank records
Select vs crosstab query - different result
run query every 24 hours
select month data
Syntax for nested joins on 3 tables
Re: Check Box fails to return all the required records
Use Combobox column in Query
Combine 2 tables
Totals for month and year
Convert mid month date to month end date
RE: how to get he Data Type information of a field.
Comparing one set of data to another
Append query from excel vba?
field not part of aggregate function
14 field query fails Output To Excel with "Too many fields defined"
Update Query - Want to Update Only the First Match
Append query unknown field name error, views but doesn't run...
check box and new record buttonn
DATES - Grouping sets of sequential dates
Parameter Query to filter dates as entered in and if not to show N
Query parameter from listbox
Newbie: counting unique records
distinct DCount - so close! or so close?
Blank Columns in Xtab
Append Query - key violation - no duplicates, records exist in par
Sum points per round when winning team takes every game
Summing By Week
calculate freight = extendedprice * 8%
cannot get null value to equal 0
Create new date column
Table/Form/Query Question
Serialize function and Make Table Query
Access query help, expression fields work seperately but not toget
Unique Work Order
"Query is too complex" Problem
Data type mismatch in criteria expression
Can't get Enter Parameter Value boxes to disappear
Help with "if" Statement in Query
Lastest 3 dates for each part number, subquery?
IIf Criteria Question in a Query
Re: Getting the SUM
RE: Getting the SUM
RE: Multiple IDs for same Employee
"is not a valid name. Make sure...
Query with 3 tables with 1 to many relationship
Iif Query
Help with a Query
Criteria Question
Retrieve "up to #" records in a select query
multiple OR criteria
Access 2003 Query Bug?
make month, day and year into one field
Running query from form
List boxes, functions and query criteria
Parsing out Initial and period Only
Duplicate
date parameter in query
Extract Data from Memo Field
Remove trailling space
Date Tracking Query
How do I get just the weekday out of a long date
Union Select Top Doesn't Work
Need a Case-Sensitive Group By Totals Query - Is there a Workaroun
Parsing Full Name and Title/degree
Dcount in a query
Dcount in a query
How do I sum a row?
"negative" query
Re: Multiple Null Reponse Criteria
What does "invalid class string" mean and how can I get attachmen
Extracting data of different Depts from a table
How can I set TEX type parameters in query in lookup type filed?
Re: Time subtractions
Open form in Add only
Switchboard in 2007
Opening form in Edit only
Query comparing multiple tables
Length
Operation must use an updatable query
Re: Remove Trailing Spaces
Question re: splitting table
"Division by Zero" Question
Make-Table Query
sub query refrence field in main query
Hide Query Prompts
Add a field in a query. Easy. . .so I though.
Mid-function does not look at length parameter
Append but no table?
Query not updatable - advise on how to change it
RE: Change a Text Column to Yes/No Column in a Query
End of Month: Parameter Query?
Query-Report
Access Report
RE: Help needed with filter in query...
List Box Query within the same Table
Error message
Count Distinct in a crosstab
Search any field
challenge with generating a range of sequential numbers
Strange Query Behavior
Activate/Enable Multiple users
Query Criteria
Finding unmatched data
Re: Combine Tables with Different Field Name
Add sequential number to select query
Data does not show on form header after entering and saving
RE: Help needed with filter in query...
Where is there a template for current inventory log
Corsstab Queries
Re: Combine Tables with Different Field Name
Query excessive motel expenses
Count issue continued from "text then date ascending count"
"Data type mismatch" without any criteria!
Finding a count of duplicates
Access ADP Form and Stored Procedure as RecordSource
Update Query - Convert % to Number Format
How to make a module out of a query
Transforming Data
transfer field descriptions
Most Frequent string by region
Customer DB Duplicates
optional queries fields output
Keyword Search works in 2003 but not 2007 ??
Convert Text to Date
Summary query - Is there a better way
Re: Append Unique Records only
Access keeps "untidying" my SQL
Format the result field in a make table query
Can rich text format (memo) carry over in a make table query?
Timing Access queires
How to use the results from a runing total query to update a table
Replace or insert characters in text string
Re: Query records from the current year, month and records with Null value
Flag First Record
Re: Append Unique Records only
Turn off warning message
invisible summation index
trim first letter to leave number
Transfer data between Access 2003 & 2007; Data does not show on formheader
Transfer data between Access 2003 & 2007; Data does not show on formheader
recurrant transform
WHERE mystery
convert survey results
Re: How do you remove all character to the left of an underscore?
Re: How do you remove all character to the left of an underscore?
Update To Formulas Gone
Can I display just the fieds that are checked
Insert Varying Leading Zeros
Update query syntax: SUM and GROUP BY
Query help...some criteria or none
Display Month and Year Only
Problems With Microsoft Access
Parameterised query to return all records or those Between two val
Moving the last numbers of a field
Create a table with code
parameter query and making a new record
counting dates (months) using SUMPRODUCT
*REPOST* Select Records based on 2 dates
query excluding listings from table
ODBC Pass-through query with parameter from table
Table design - multiple values
Code or Macro maybe?
Extract data preceding "#http:"
Union Query is deleting data
Re: search text using a list of key words
Object Reuired error
RE: search text using a list of key words
Can't Filter Pivot Table
In Access 2007, how do I view the query list with details?
Access Append Query Failure
Data type mismatch error
Re: Update first number.
How to create a "point in time" calculation that is date stamped
NOT IN SQL Statement please
Not a valid password error
Comparing Dates in rows/records
Windows Security popup
Comlex union query question
Query driven by form field
Lookups, Parameters
Tricky query question
Re: Concatenate missing zeroes
Passing Order By Parameter Not Working
Query - Table
Contatenate quote character
Concatenate Values in Crosstab Query
Remove last character
Number Filed
How do i?
Multiple column values in crosstab query
RE: issue with crosstab query
Parse text string and insert characters
Can I pass one parameter to two queries at the same time?
Select records based on 2 dates
Using Buttons to display datasheets
RE: Subtracting time Help
Delete query based on criteria in a linked table
Best 4 out of 6
Finding max value
Problem with (complicated) expression in query
Selecting from a database where the joins have history
Cumulative counts in a query
Improving append query speed
Append Query/Relationships
Re: converts military time into standard AM/PM .
Re: DateSerial function - criteria in query
Using Transactions with Access 2007
Re: converts military time into standard AM/PM .
Re: converts military time into standard AM/PM .
RE: converts military time into standard AM/PM .
default value of "No"
Query with one to many relationship
Remove text that precedes "#"
Query Criteria
Imported Query Not Updatable - Identical Front End Databases
Changing date format
blanks in one or all of the fields
Blanks in one or all of the fields
Can I Automatically Re-Link Tables
stack query from a group query
query
Complex Query Slowdown...
What is the date when the total of minutes became >=600
Parameter Help
How To Display Message "No Records Found" In Forms
Outer Join?
option fields output
Crosstab query help
Can't get delete query to work...
Add a day and a month with DateAdd
Parameter with "OR" not working
Query/Report on dates between begin and end
Date() function
text - code problem - query not returning full results
Quary help
Image display in a query, is it possible?
Aggregate Error
Query Total
quary help
Selection Criteria
INT() and FIX() returning the wrong value?
Newbie using SQL
can't change data in form even thought the query is updateable
Update File Location Where Images will be Stored from a Query
Lots of data
Field that is not numeric
Query within a report
Average Query
Multi Dlookup in a query with grouping
Re: Table subtraction
QueryDef Field Properties -- CAPTION?
Re: Create a new table and set the fields type
RE: show text instead od ID
RE: Create a new table and set the fields type
Rounding up .5 in a calculation
Convert dense_rank and row_number sql server functions to access
Re: Calculate hours worked outside regular shift using date/time and iff condition
Selection Criteria: Problems with Or
Wildcard parameter query not working
Display in Landscape
Student classes completed
Get Table name for a query from form
Problem with Query Calculation
refer to form filter
Access update table
Re: Query that will display record if it has 3 or more YESes
Top 5 grouping of material based on usage
Using Like in Criteria of a Query
Re: Calculating hours missed from actual shift schedule using date/time
IIf Statement Criteria Problem
Re: Get the last price
Query Difficulty
'Database has reached maximum size'
Dmax Function (I think!)
I get this sign <> in my query
Data Type error in WHERE, but not in SELECT
Null Date Question
RE: trying to get on hand per location
avoid #error
Query Incorrect Grouping and Summing Problem
Query format problem
Problem with query output
how to export MDB file from the command line in Windows?
IIf error message
Convert Excel formula to Access query
Removing zero values
Counting text type codes
DSUM - Computing Runnig Totals Question
Concat Related / Query Design Problem ?
union query says "System resources exceeded"
question about running a certain query in access
Self Join Problem
How do I automatically select a database record randomly?
Looking at multiple fields in a query
selecting criteria
Deselect (Not delete) common records of two query
Re: ComboBox + Like
Query Help
Parsing a field
Re: ComboBox + Like
Re: ComboBox + Like
Re: 5 Week Moving Average Query
Combining Queries (2)
query grouping issue
RE: Query Date/Time field without opening design view
Re: Like / IIF issues (as query criteria)
RE: Setting up the following expression in a query
Date add working day only and take account of US holiday
how create cards to file then a database can access by name file
Access Checkbox and Sum (right post)
Summing Check Boxes
Date subtraction
Pull criteria from a Form
Sorting in a Cross Tab Query
Combining Queries
Sorting Text Field containg letters and numbers
Report Summary
Maximum Value in 2 fields of a record
"Enter Parameter Value" dialogue boxes
Convert Date
Importing Date fields from Excel
Limits of a Switch Function? (Recoding Value into Value Labels)
Case Sensitive Query
Determine size of individual record & space taken in each table!
Query parameter
Including form controls as fields in a query
Date Difference limited to 100 years
Nested IIf stops after two conditions
Add proceeding zeros to zip less than 5 characters
Help with totals function in query
Union query help - multiple unions
Transposing data
Today's Date in Update Query
Update Query - Automatically Store Todays Date
Date / Time
IIF statement
making age group query work
SQL query urgent pls help
Get rid of Design View from print preview shortcut menu
Help with Union & lookup
report open by clicking on record in datasheet
Calculated fields not populating
RE: Parameter query with dates
query for dates
Re: Parameter query with dates
If statment as condition in query
Queries returning with missing info (plus asks query question twic
Access Query Values
Custom Function behaving strangely in query
RE: Two Forms and one Query.
Queries take FOREVER to run - ???
Concatenate Problems
Multiple Dates in a table
IIf Problem
Distinct not working in 2007 as in 2003
Return only records with empty field
Unable to Append All the Data to the Table
Append with Criteria
Update Query with multiple criteria
Referring to fields in a subquery
Query ask two questions
Returning maximum of 2 values
UPDATE Query
Strip leading characters from field name
Table has a variable size filed. limit filed size to left 10 chara
Search criteria for words in the "middle" of text string
Parameter queries and null values
Access 2003 Query: Dsum function Help
A fast and Easy way to populate records from Temp Table to Permanent Table?
Getting error re: table that was deleted
Using query like source for masses emails
Nested If Statements II
Nested If Statements
Append Query and Combo Lookup Problems
Re: Parameter Query Null Response Error
Re: Some text isn't recognized in report's query
Re: Parameter query
age groups
Re: Some text isn't recognized in report's query
Re: Most Recent Contract
Changing UPPER to Proper Case
Obama checking out girl obama, obama looking at girl, obama checking out, mayara tavares, drudge report video photos
Re: Make Table Query
RE: Max of two joined queries
SUM NOT INCLUDING ALL RECORDS
Bug? Using full identity expression in any arbitrary column works
Re: query grouping issue
Re: query grouping issue
Select records between the fith of one month and fith of the next
query grouping issue
Iif Statement based on 2 conditions
RE: Select certain items in query
Trouble with Query Results
do I need more indexes - followup
Counting the number of characters in a text field
SQL - Query count not working
Query between dates
Query Between times
Can Data from a Table Field be Used to Create Queries Automaticall
Access automatically changes name of form in conditional query
Query to merge text values from two columns and DLookUp text value in another table
Query the ealiest date within several columns in table
If Like "#*" gives me everything that starts with a number, what do I use to get only alpha?
Query (Recordset) is Not Updateable
Rolling Totals for 6 month and 12 month
In String - Urgent Request
template for timesheet - calculation wrong
UNION, WHERE or Something else?
identify missing numbers in sequence of records
how to select a random item from a field
Help with "Like" in a query
sql string as field data; ado?
table
Re: Add 2 queries
Sorting data from different centers
RE: Previous Months data
RE: Add 2 queries
"microsoft office access" unknown error
Query to Form View
Creating an "if then" in a query
short date, short time
Re: Find duplicates query
Counting posts
Query to show all if parameter is blank
Extracting data from field
Nested SQL? Need easy to understand "How To"
creating a form
RE: Previous Months data
query for non matching fields
three query union.
Combining Records from the Same Table?
Trim a field down
Multiple Queries / Same Criteria
IIF statement as criteria
Combine Crosstab Queries?
function to return a portion of a cell
Select Case with date range
querry sql problem for previous month
Is field between date range on form
SQL Formatting does not save
Sort by text field in crosstab query
Is there a way to ignore Null values in a crosstab query?
Compare capitals with non-capitals
Update Query Question
Re: Joining different parts of the same table
Ranking
DCount
Dates - Grouping Start and End dates of sequential assignments.
Single Query