Microsoft Access Queries [Archive] - Page 5

Zero fill field
Re: Using a VBA Function in the criteria of a query
Re: Using a VBA Function in the criteria of a query
Union query or Outer Joins do not create desired results
Crosstab Query using 2 date ranges
Multiple IIf's
Criteria for a Select Query
make a query dependent on a variable on a form or report
Concatenating indexed list (returns index instead of data)
DBF linked tables
Union Query Edit
untangling parallel dependent queries
Date query
Consecutive numbering using down arrow
How to add a day on a select statment
Re: Decimal to time
Re: Decimal to time
Re: Decimal to time
access query to do the same as excel =IFSUMS
modify an expression
Union Query
RE: Project/Item Time Tracking and Reporting
HOW TO OBTAIN ONLY THE DATE OF A timestamp FIELD
odd sort order
Make Table query
Delete query based on criteria HELP!
Text to Date
Remove blank spaces in email string
Remove blank spaces in email string
Grouping query to elminate dups
Create Date Field from Text
Unique values in a query
43 KewaSa.com DDL Torrents
Query to return only records with highest value?
Mixing Table Data to Create a Form
Nested queries
RE: Unable to do insert queries
Re: Unable to do insert queries
Re: Query not working as expected
RE: Query not working as expected
Percentages Total
Null Values
Query to insert column name as field value
XIRR Calculation
Updated to Access 2007 Code no longer works
Find unchecked checkboxes
changing parameters on a stored procedure
Count the receipt# if ..
Query between query fields
ODBC Call failed
Query to display all related data from 4-level tree
Run time error:"2147467259 (80004005)"Anyone ever get this error?
Multi criteria selection / filter
Need Help With Rate() Function in Expression Builder
Help with Rate() function in expression builder
Combining Records
Deleting dups out of a table or query
Grouping Records in a Query
Calculating age with If statement
RE: SQL self join
RE: SQL self join
Query Doesn't see Changes to Tables
Different results from similar queries
Want 3rd Thursday of each Month
IIf ..then...case...switch - I'm not sure
Help with Date Difference Expression
Run macro after closing a table or file....
Re: "Between" Comparison
Update a Multiple Value Field in an Update Query
Count Number of business days
Re: Data totals by date
Re: Grabbing strange number from a linked table Access XP
Remove part of address
two records for same value cell
Help with a totals or sum query
I need several records based on same cell values
Interest Rate Calc using Rate() Function
one field with number of features to be linked to feature descript
Column to Rows
Re: Query of DateValue Field for 10/20 returns 10/2
"Record too large" - what??
Help with Rate() function in Expression Builder
Right Justify text
Criteria to Select Field to Update
Re: Query of DateValue Field for 10/20 returns 10/2
loop though records in a query?
Re: No results in a summing query
Yes/No parameter for selecting either
Query 2 Return Negative/Positive Values
Help with Rate() function in expression builder
Access 2007 Runtime and Date()
Letter in forms
New Query
Split the contents of a field ie - full name into first and last n
Crosstab query for the report
Difficult Calculation
Re: Query combining information 3 tables
Rename a table
Specify Name in Make Table Query
Re: Query combining information 3 tables
RE: Queries:When a dates passes, how to auto-populate field with "Expi
More than one data in a field! HELP!
Re: Queries:When a dates passes, how to auto-populate field with "Expi
Finding lowest value
Seating chart
IIF function with *
Chg "day" portion of DateAdd Date
Querie with multiple variables
Re: record COUNT() query not working in VBA code
Re: record COUNT() query not working in VBA code
SQL 2008 no longer works with ACCESS for making queries
Most recent date prior to test date.
Query not grouping all data
Calculate date and show exact minutes
Pass-Through query used to update an access table
Query Result By Month 2003
Re: Sorting a Union Query by Sum, Where to put Desc?
Calculate time in Access 2008
Refreshing Data Daily From a Linked Excel Spreadsheet
Join a table, queryfails with "Query input must contain at leastone table or query
Compare Min and Max value of a field
Possible to return NON duplicates fields?
Update query Formatting
Similar lookup
Open a Form base on Sql String in a combos rowsource.
Unable to Enter Data
Convert Julian Date to mm/dd/yyyy
Between This and That and all If Null
42 Opinion Dsiconsolas.com
can't use an aggregate function in an expression?
Date Limit in Crosstab from Union query
question regarding string/numeric
Suming accounts
split
Entering criteria from form
edit field data in query
Not In?
Yes / No query problem
Linking Access to Excel
selecting the most recent date
delete multiples, keep duplicates
Quotation Mark Question
Group by Non-blank Distinct Values
Query Not Summing All Records
allocated vs unallocated budget
Select records based on isolated portion of string
Criteria in Query
Re: counting large ADO recordsets...
How do I make a query with repeat fields in one table fit in one l
Select Portion of a Text String
Select Record based on portion of text string
Re: help with syntax for a date range criteria please
Ignore Leading Zeros in Mixed Alpha-Numeric Text Fields Select Query
exclude weekends
Expression for combining multiple children with one parent in a qu
Populate a field in a query with the value of record
Criteria
precision in access versus excel
Countif on qry
Creating new column, with data cleaned of prefixes and suffixes
RE: Time Picker
Fixed Values in a Query
Populate entire field in query with the value of a cell
Capturing data from two tables...
Help with update query
Timeframe-specific most recent record selection
Format phone not working
Can You Figure Out What's Wrong W/ This Query
Re: Null Values in Queries
RE: Null Values in Queries
Conditional Count with multiple expressions
Query running sum - help again
Count Crosstab Resultant Columns
Eliminate results based on criteria - not working
How to generate Row number in Access?
Merge Tables with different intervals (from & to's)in Access?
create append query resulting in multiple new records
combo box
parse some text from an inconsistent text field
Counting multiple y/n fields from multiple tables.
Request to explain AUTO duplicate record query
Trying to learn how to use an Append Query ....
Auto submit form
Random operator
Complex Filter
Update Query across entire table
edit - find/replace in query SQL window...
SQL Error Help
Search for Multiple * Literals
IIF statement to choose latest date
Query Values with < > or =
Form to Execute Query
Re: Filtering words that has wildcard character.
Re: Filtering words that has wildcard character.
Re: Filtering words that has wildcard character.
Contest rank by class
Iif statement with Nulls not working
Sum query
Re: Filtering words that has wildcard character.
RE: How can I do Calculations in a Query?
RE: How can I do Calculations in a Query?
Attachment, OLE Oject, Hyperlink
How do I find the last record ?
merge docs using word 2003
Can't add records to statement with two many-to-many joins.
MANY 'or' criteria
Rank contest scores in Access
Compare results of two expressions within query
Query too complex my ass
Split field?
adding a password to a button
Show an Employee with no reviews
Lateral Data Structure
Including Table Name in Query Field Names
Formatting Query
Re: Replace commas with hard return in a query field
Problem with the Like Operator
SQL Server SQL to Access 2003
comparing field with mixed case
Limit data in field to within 90 days of another field...
Building Complex Criteria for Queries in Access 2007 (Part II)
reference a control in a subform in a query
Help prevent report from running
Remove a result from a query
Access sorting numbers
you tried to assign the null value to a variable that is not avariant data type - MsAccess 2007
Building Complex Criteria for Queries in Access 2007
running total by groups
Data type Mismatch
Sum with a null value
Calculate percentage
Wildcard on an "INNER JOIN"
expression with True of False showing up as -1 or 0
Append Query is not working
Dave Validation Expression
automated transfer of data between tables
Queries - Allowed Blank
Using Word/Publisher 2007 from a jump drive???
Concatenating Fields
Complex Query to count Loan Number
Linked Tables Append Query(ies)
Slow Query
dates in queries
Concatenate
Simple Query Expression
Re: Counting Yes/No responses from multiple records in a table
Union Query SQL
Re: Counting Yes/No responses from multiple records in a table
Re: Counting Yes/No responses from multiple records in a table
Append two tables into a query
Re: Delete using join statement
Re: Double entry of parameters used in query
delete Using Join Statement
SELECT Count / Sum
I cannot add new record to select query
Not showing some information in combined fields
Bill of material type query
Queiry to return highest value or number in a field
Display "0" if no records are present?
export crosstab query too many fields defined
Current Balance Due
Is it possible to access a temporary query from a second query?
Simply query question
Cross checking fields to find problem entries
Re: Concatenate with a value of TRUE
not = to in a query
How to create a query to Concatenate
Count
query for max per item
Opposite results
Query Help
(And) expression
update query
IF Command for Office 2007
Re: Allow 0 in Avg expression
Grouping data/Aggregate functions
RE: Allow 0 in Avg expression
Creating automatic dates for renewal from 2 possible fields
Query expression in a calculated field
Finding record between two Dates Queries
Parameter Query
Help book on access
Running Balance
Keep name of source query in Union
Combine two fields in a query to get a unique third one.
Time Difference Between Records from the same field
Problems when deleting data
Help Please interfacing to SQL
Passing Criteria From a Form
delete duplicate max ID
Append Query to a Linked Table
Re: Project FTE changes
Access 2003 Query
Checking for any null fields
Building Expression in Query
How to Reduce Decimal Places?
Transpose 2 rows to 2 columns
Counting up Yes/No fields in queries
counting yes/no fields
Total based on status in crosstab
Query only numbers out of a list with letters and numbers
How can I show the number of rows pasted by a macro?
update query ODBC--call failed
Running sum major problem
Charactor in a string
Help - how could I query a memo field and get one or more 4-character data ? Tough as hell for us to figure this out ... TIA
crack ecm2001 torrent rapidshare download free )jIKBeYqqQ
calculate results show funny figures
Multiplication Expression for Access 2003 Update Query
Update
Too Few Parameters....again
Update query with multiple spellings
What is the best way to feed Form selection criteria to a Query?
Limit Query to Current User Name
Join not Supported
Count if Populated
Access 2002 SQL Problem
Error - CANNOT HAVE AGGREGATE FUNCTION IN EXPRESSION
Using query to make a table
Not part of Aggregate/Can't have aggragate
In clause from form
Count not right
How do i get a query to display approved or not approved
Re: blank fields on a report
Creating a month field
Not like query criteria
Crosstab Query and Specific Date Ranges
combo box complexity
Find Records in Identical Tables
If statement that returns all entries or one
Date Range Query
Re: blank fields on a report
Missing Calculated Age Values
Correct Format For Formula
Add number of days to date
date format
Subtracting Fields
Field Name aliases - A2007
return 3 highest values
showing records where one field is duplicated and another is not
Matching duplicates within one table
MS Access Expression typed incorrectly or too complex
trying to get a sum in access 2003
Concatenate
Joining Dates in Access
Join 2 tables based on part of a field
Using Multiple Parameters in a Query
Row heading sort in Crosstab query
Links in Query results
How to apply a conditional Select distinct (or conditional Where onduplicated cell values in a column)
Limit the results from a calculated field in a query
What's wrong with this query?
Access 2003 - set column widths in a query
How to choose later of two or more records
Data mismatch caused by null in record
Inconsistent results - append query
Parameterizing in a Cross Tab Query
IIf funtion based on multiple criteria
Totals Query with Multiple Counts
need count to return a zero value
Ranking
Iif/IsNull Question
convert a number in "12345" to 12345
Exclusion-Type Join
Help on creating complex queries
Sub Query help
query not filtering according to form filter
Query to find the Percentage of items in a field
Count(*)
Running Sum in Query for Count Field
access formula for an excel formula
Query design view - commas being changed to pipe characters
Copy data from previous record
Percent total 101%!
extra field for a table as Text from table qry ?
Listing all fields in a query
Need a Dynamic Record Counter Function for Query Records!!!!
From TimeStart + Minutes get TimeStop
Group by part of number
access 2003/2007 - problems with unwanted pipe character
Running sum
calculate days between records and between two columns in the gro
Re: Subquery with function max
Duplicate rows - Distinct Count
12 month rolling average by location
Need to select record based on date
converting excel columns data
query return only one row with averages
Using IN expression with a parameter to filter queries
Calculation does not show minus values
SQL statement in the table
Don't want a return if it exists in another table
Partial match Join query
Delete Query
Access Data Query
Help Me Fix This Querry
Format Concatenate
Need a query to return all records that aren't related.
IIF statement in query
Loop through query and export records on a date by date basis asseperate files...
Combine results using query
Problems querying an accdb database
Using between function with General Date
Crosstab query with unique count
Rounding in Access
Conditional Find Duplicates Query Help
Query / Form Relationsship
how do i to eliminate the picture of my pc,
RE: Trouble with control reference
Update Query into a new column
INNER JOIN auto changes
Variable as query parameter
DoCmd.RunSQL woes with update query
Extracting Records
RE: Access & Vista
sircular effect
error 3048
Re: Iif Statement in query Criteria
Uppercase and * in search query
top n with duplicates
Email distribution list from Access - JCW
sum based on criteria
add a value to a date
Boolean data type mismatch
Re: Iif Statement in query Criteria
How to Retrieve and diplay the details in the form
Kindly Help and TIA ... Automating 5 mdb apps ...
expression for time sheet returns type mismatch
Subject: Need help on Iff Statement
Increment field by 1 on insert Query
How does one report a bug in Access 2007 SQL?
Top of Form Problem with Tabbed Format
calculating running totals
Crosstab Query on tables with Many to Many relationship
IIf and Check Box
reformatting phone number
Creating a total query
Top Values within multiple groups
Need help making query with criteria based on combo box selections
auto query update?
report line spacing
Query most recent entry
Using an IIF Statement to calculate discharge date
Combining Tables
How to extract portion of text
exporting a queried form to Excel
Query Problem (Duplicates)
Crosstab column heading order
Expression Description
Crosstab - What am I doing wrong?
Slow query
MS Access 2007 & SharePoint Performance
Runtime Input to queries through form.
Extract part of text
Crosstab sum doubles
Keyword Search
Critera entries
Query Logic dysfunctional
parsing a field with right string
Using a period or dot in a parameter query criteria line
Massive Large Query Issues
99222 NOT 0007
How to use arithmetic rounding in Access
Re: Query Help
Projecting Date
Rounding number
Difference between queries
Grouping query based on whats between - and -
Query issue
How do I copy a record from one query to another?
Take Parameter from Record Selected on Continuous Form to Run Quer
Query Stalls when Criteria is changed
Query Multi Value Fields
Outlook email using a macro
deleting duplicate data
Access Automatically Moving Criteria Columns to End of Query (DesignView)
Can I add to a current update query? Or do I have to make another?
Update Query
Union query producing duplicate records
Report Query Difficulties
If/Then/Else Query
A2k7 UNION Query fails on 3rd SELECT
Type Conversion Failure Error
Changing records in a table
help with crosstab or pivot function
Extract a text between two last parentheses
Cross checking two sources
Merge tables with different fields
How to execute multiple queries in 1 report
What is a 'full USENET designation'? Can you give me an example?
Error - Undefined function'[Str$]' in expression while running que
help creating a 3-way pivot
Syntax error (missing operator) in query expression â€˜tblDUES.â€™.
Crosstab?
Please help to zero filled on file
Add time to Date Field
diplaying contents of required date and also the sum of contents
Main Table References Another Table Multiple Times
Difference of 2 tables row sum
Calculation query
First table not appearing in append table dropdown
making a table with a query
Making it more user friendly
The use of "Like"
cross tab
crosstab queries
syntax help for SQL where ????? And ??????????
access joins
JOins pls help
Validation Rule
Displaying * items along with total sum
sum of row when duplicate entries of date, difference between 2 ta
Annual Census
Find records in a field based on a date range - JCW
criteria in running sum formula
Long Date Search - JCW
Select, Insert, Update, and Delete â€“ SQL Question
Date difference to show in years and months
Want the query to figure a future date
Dont count negatives...???/
Multiple Matching Records in Related Table
Concatenating with and without comma
RE: Expiration Rule for Query 18 months not to exceed a calendar year
Query -Maximum Field Length
Re: Once and for all...Can this be done
RE: Once and for all...Can this be done
Re: Expiration Rule for Query 18 months not to exceed a calendaryear
independent path queries??
date function
Close query
Add a new field that enters Y or N
query results in Access
autsum several fields
Multiple Tables
HOW CAN I GET TOP30 RECORDS IN ACCESS QUERY
help with passing filter to vba
Specify the table containing the records you want to delete
TIA - All my files were moved to a new server - applications stopped working because of pathing problem - please advise ...
joins pls help
Gary Walter
RE: counting contiguous series of similar field contents
Timesheet
compare and unmatched
query assistance
Update Query
Easy question "like"
between for paramter query for text
Re: Select Query Help
find orders 90 days past due
Dates - make query field to specify "Past" or "Future"
Why Doesn't This Work?
RE: Select Query Help
Left Join Not Returning All Records
Do I need to convert a hyperlink field to text to change it?
Report from query
RE: Query DLookup Syntax error
Re: Query DLookup Syntax error
Group by Time
Interesting query requirement
Calculated age field not populating after 1/1/09
<> not working correctly in query, unable to separate data
age rounding up or down
FindDuplicatesBetweenTables
c program for assignment problem
Microsoft Jet Database engine does not recognise...
Union query
append queries
These newsgroups!
Breakdown my budget codes by type.
Compare and check date
Query for # character not working
Returning more data than requested
Previous two years compared, query
...OK, I'M STUPID, PLEASE HELP!
Query to find minimum of two fields
Create query against multiple date fields
Need "Like" Alpha Alpha Digit
Multi-select drop-down for a query (Access 2007)
Replace function
Concatenate name fields
update query
Most recent date
80% spend from a total
Make table query won't run but Select will
Re: query to search for street name in address field
RE: query to search for street name in address field
HELP!!! MY HEAD HURTS!
Parse from Description
Need Help with Crosstab Query
Query shows no results when using 2 tables with multiple relations
select count query
Update Query ODBC --- call failed
ÏëÕÒ¸öÅóÓÑÁÄÁÄ
Query using two tables
Running Count within a Group (Time-Zero Data)
Parameter Query help - Not passing parameter?
Re: Help with "Serialize" function in query
finding unique values within multiple groups
Transpose columns to rows
Can you use query fields as function variables?
Re: query
Help on zero field
*REPOST* Query Pulling dates from one month prior to requested mon
crosstab query parameters for dates
Query to Transpose Multiple Rows to Columns
Lookup fields from various tables
count in a query
query to pull most recent record by date
search missing numbers
Limiting multiple results in query
combo box selected records
SQL Delete Stored Procedure
Delete duplicate values from a table
Help!! Extracting data from a single field
User Prompt for Month to find Date Range
Append current object to a new table
Multiple users opening queries on shared network
Query to filter next to last oper
I Combined 2 queries, but some records were missing.
Query gives me a warning when I ru it...
Too many rows output by query
Passthrough queries and "Select Data Source" dialogue box
Parameters, Passthrough UpdateQueries, and SQL
Help with String Field
Query pulling dates from one month prior to requested month
simple OR sql will not work as examples show
Summary break down and grand total
Re: Join issue Access
change data type in query through a link table
need help making a query (crosstab instead of Pivot tables?)
Update query should not fire if prompt is null
Table drop-down values disappear in query
quandary on selecting certain records Pt.2
Query Help Filtering Multiple Records
Question using Min or First for a date field
Query with compound joins
Cannot modify record based on multiple table query
Query - Show One of Everything
query for missing value
Does not equal Join (access 2003)
List in a Query
sSJ Drivers Firmware R4i, R4 Sdhc, M3i Zero, EzFlash Vi Dsi. .q^
Date Criteria Range
Add OR IIF to my statement
query with conditions
query
Pls correct this query
SQL Driver or SQL Native Client for ODBC connections
auto export (scheduled) table to text
RE: Creating a field based on another column using Switch or IIF?
Linking multiple tables
IIF "and" statement
Shifting column headings - not data...
01004 - 0 - [Microsoft][ODBC SQL Server Driver]String data, right
How to Exclude result from one query from another
finding unique values
replace in a query
Linking Tables... HELP
UDF in query of linked table Causes #Error
displaying a null value from a query
quandary on selecting certian records
Troubleshoot Select Table - Mail Merge in Word from Access Query
Access question regarding number formats
to display specific group by result in Crosstab query
Re: Multiple column query
query to check for data
remove duplicate records in Access 2007
query criteria eliminates too many record results
IIF statement is not working
Count repeats
Query works until sort is added
RE: a query to produce sales activity totals
Dates
Query criteria - exclude data and return all records if null
Left Join?
Query with Relationships not working
Query too complex? No way.
Append Invoice
Calculate between two dates
Sequential Records
Duplicating Data
Blank or Null in a Cross Tab Query in Access 2003
updateable table errors...help
update error
Return to Databases
i am getting the message "Type Mismatch"
SQL Statement
Re: Insert statement does not work suddenly !
Query in Design View - Status bar = Form View
Filling a field with an increasing set of values
Compare same fields in two queries
Turning look up values into fields in a query
linked fields in a query
Passing a variable to a query
SQL syntax error with vba
IIF Statement to return multiple values for a field - JohnW
Distinct values
Adding Text to a completed report
Re: a query to produce sales activity totals
PARSE DATE FIELD
Variable in SQL Where Statement in â€œPass Throughâ€ Query
query problem
SQL subqueries
Query assistance
Can I use a variable for the number value in AddDate?
Can't type double quote in query.
Calculations in a Totals Query
Calculations on Calculated field in Queries
Update query to update new qty and cost
Help with Aggregate Query
Week number to Monday of week
Re: Showing only one record from many-to-one relationship
"Preparing Data" stalls in Pivot Chart
Reserved Error -7711 Pass Thru Query
how match blanks in number field?
Undefined Function error - Complex
complicated query
Query Question: two tablew with same field name???
Searching for Missing Data
iif in the criteria
Return Zero if No Records
option parameter
How can i use Not Like
Re: Missing Text in MS ACCESS 2007
Using an or in my join
Append Query - destination table not available
Total Query: Adding a field to a calculation.
Add a record or edit a record on a data entry sub-form?
Adding field to query
Only show records missing fields
RE: Purged Reports
query to update sharepoint person or group column
Different type of parameter query
Can't run Query, can't build formula
queries in forms
Update Query using Table & Query
Using Append Queries with Linked Tables
Query multiple tables
Linked table query
Complex Switch Function or Maybe it should be IIF
Help writing Query
Query to display the difference of period for an employee.
Show select table entries based on yes/no checkbox answers
Parameter passed from a form to a query
RE: Show record not scheduled
IIF with wildcard and OR...
Query with <= Parameter
RE: Expression Multiplying Hours by a Number
Count a calculated field
inner join sytax error, missing operator.