Microsoft Access Queries [Archive] - Page 4

Week, monthly, quarterly
Converting check box data into useable narrative
Switch
Using " in a string expresion
Re: How do I count text fields?
Re: How do I count text fields?
Re: How do I count text fields?
Re: How do I count text fields?
How do I seperate information using a delimiter
HAVING / Where time count / excluding any instance
querying a percentage of table info
HAVING clause
Update Query: Enter Parameter Value
insert rows after count
Monthly Averages
UNION query taking 5 minutes for approx 2000 records - any tune uptips?
Creating an index in a query
Date range for a report
splits investment transaction
Make URLs
Need help getting query to reference a field in a subform
calculated field
How to add another field to a max query result without grouping
How do I copy a SQL query from one database to another in Access 2
format OXXXXXO
Is there a way to turn off the prompts of a make table query?
help with nested iif statement
I believe I have an AutoCorrect Issue with a field name?
show top values
RE: how do I make ACCESS populate fields in a table
Re: Run 3 update queries at once
Dlookup Expression Error
Changing existing primary key to autonumber
URGENT MATTER
Append ODBC tables into Access Table
Delete Query
increace package no
Use of date/time
Excluding email data
Blank field in form
Query using a date criteria
Query needed
Update Query Randomization
trying to create a sample table with 31,000,000 rows
Double Booking Query
Dynamic query -How?
Adding New Record to a linked table from Query
revers minus
revers minus
revers minus
Unique Query in not working correctly ... too complex?
Query records late to me
Quick way to put all records in email field of query in Bcc of Outlook
Economical Auction Site
access 2007 use the old query builder format
query in access 2007 pulls yes only answers
Re: New User, having problems with DLookup
Re: TreeView Query and or Queries Question
Re: Comparing Crosstab queries
DoCmd.RunSQL HELP!!! I will not work!
Re: Comparing Crosstab queries
All Tables as Queries?
Finding the largest size in a group
RE: search with multi values and get resaults order
Re: search with multi values and get resaults order
Where Not Exists
Question about query optimization
Checkbook Register
subquery
Creating Multiple Records from Single Delimited Field
Adding the value of two fields when value is null
Access Query
Summing multiple fields
Re: how to get last records out of 4 records per customer?
One Query as datasource??
Group by Range in Crosstab Query
Does not include the specified expression as part of an aggregatefunction
Need specific record in report
Joining IIF statements together
Passing criteria to queries from forms
Query criteria in a memo field
date selections from one table to another
Evaluate String for Value from Table
Looking up across date ranges in Access
Re: Adding Fields together..
Re: Adding Fields together..
RE: Adding Fields together..
Re: Adding Fields together..
Iif then statement needed for Access 2007 please
Multi-level Group By Clause is not allowed in a subquery
Help Needed on Complicated Query
Re: This query not giving correct results
using a rolling date range to sum
max for each person
multipling
Microsoft Query
Re: query to find when an event happened
HOWTO query by passing a parameter from Infopath 20007 to a MicrosoftAccess 2007 database?
Indentifying a payperiod
Between dates
If then statement??
Removing empty space character in cell
RE: Record AFTER latest by date an time, grouped by serial number
1 Field and 2 Criteria
error 3061 with insert into sql
select every 100th records
Parametery Query
Update type conversion error with nulls
moving averages
RE: SQL Code Help
Open Query Design View or Saving Extremely SLOW
how do I create supervisor hierarchy with the access table
How to append query w/lookup fields....
Combo Box for Column Heading
getting players records vs. other players
passing a parameter based on multiple selections
Query formatting problem
Combine Records
Re: problem with query in ASP using date()
Query Criteria - Making them stay on one line
duplicate records
Table Link
Combine the Table and Insert a value
Parameter Criteria from a forms Text box - 2003 - not working
And Or in a Parameter Query
How do I add numbers across columns of a single record?
Need to update records in a table based upon records in another ta
Sorting Xtab Column Headings
Export To Excel
How to use IsError()?
Error upon exporting results of query to text file
Database Feedback
Parameter Value in Crosstab Query
Tranform Pivot Query?
RE: Parameter Query
Delete records
Summing fields between two dates
Date and Parameter question.
yes/no or both Error 3071
deleting duplicate records obtained from a duplicate query
parameter query
rst.findfirst not working with two conditions
Update Query Question
Why does query convert "Like" criteria to "ALike"
Re: Date Range query design
Join Question?
Using 'LastOf' function in queries
How use a group by in a sub query
How do i add the values of a column in a query in Access
How do this tricky query?
My query doesn't pick up records added to the table after a parti.
query to filter by current record id?
getting Tags ID used in queries
Pass-Through Query Error
Printing Porblem
delete query using inner join
ConcatRelated
Carriage return grrrrrr
query to overcome field type problem?
Total number of days
Problem With CDec Function
Next in alphabet
Combo Box Not in List function
Re: Formatting Concatenated Fields
Use of Wildcard in String Expression
RE: Call function from query 'Criteria' line.
RE: Call function from query 'Criteria' line.
Re: Call function from query 'Criteria' line.
Real 10 random records
Help with a Monthly Summary Report
Need a query to get rid of duplicates using two tables
IIf Statement in Query Criteria
Problem with Dates in Query
jeramie bellmay
Autofill Options
RE: convert month text (MAR) to month number (3)
selecting a query from a combo box
Divide by Zero error
Sumif function in Access
Assigning text response to a value
2 criteria for query
Access pass-through query to Oracle 10g stored procedure - results
Text manipulation in update query
Re: Office 2007
Why is my Access Queries take a long time to generate?
text to number
Update joined tables with info that is currently in Excel?
last entry per record query..
"Invalid use of Null" in query
Query is too complex
Append query without duplicate rows
access 2007 criteria in query
syntax error in JOIN operation
Minimum date difficult situation
make query from to 64 bit system
Update query with date criteria
BKF-Display Results (a number) on form from a query
how do i creat something like this?
ranking a query or report
Combine and Insert query
Simple Query
Query from 3 tables
Can I create a query using the results of a Macro?
how to count specific values only not total count
no criteria
jeramie bellmay
Cannot see fields in query design view on laptop; Access 2003
nested if in criteria
Append Rows based on field value
Re: Query to add 2 different record values
Prevent query from changing number values to text values
Multiple records in table to display single records
combining fields
IIf statement in query criteria
update query
Boolean expressions in the where statement
date format lost in UNION query
Wildcards
Calculated Query
Making null
Query Parameters error of the Upsized database
Re: Double Results in Query
SQL View
Re: Double Results in Query
Soft Carriage Return
Conversion Problem - Text to Exponential
timestamp handle
Creating a parameter in a Union Query
Query from Multiple Checkboxes
ADODB.Connection to Teradata Timesout
Change Form/Report Query Based on User Selection
Displaying Yes or No rather than 0 or 1
Trouble shooting a query
Crosstab query and Lookup field problem
MS Access Query criteria Problem
Add % to Existing Number
Parameter query with expressions and calculations
How To Specify No Criteria
classify
Add existing table
How do I query multiple data values in same field?
Query with common fields to all records
excel calculations in Access
Why do these two queries give me different answers?
unable to run the query
Not equal to zero
IIf Statement Error
How to append running number
wish there was a CountDistinct() function
Number to Number "Data Type Mismatch in Expression" in Join
Is date in between
crosstab query?
What character(s) is(are) used to preface comments in Access SQL?
Is there a quick way to create an Update query?
how do you use <, >
Re: sutraction after sum
Transpose Access Table / Query
Odd Too few parameters issue
Can I call a function in query criteria?
Sumarize data in Query like in a Pivot Table
how to append date to table name using mk table qry
Must use an Updateable Query - Issue
need help removing zeros with Left or right??
Difficultyentereing/editing fields on the Query Grid
Criteria Filter
Max or DMax - Issue
Top N Records minus lower scores
Simply confused - Query stopped working
query result in relation with table
Re: Parameters And Null Values
show if has two specific records
VAL Function Error
IIf statement too long. Other options?
update next row
query parameters
how to find records based on three sets of criteria
InStr Function not finding space
Stacking queries and Calculations
Prevent duplicate append - nothing unique
Return records only when all linked records meet criteria
DateAdd not working correctly. Need fast help!!
How to Identify Records with Overlapping Dates
Passing Multi-Select to a Query
Help with: ...query that does not include specified expression ....as part of an aggregate function...
SHOWING MORE THAN ONE VALUE FIELD IN CROSSTAB QUERY
Sum Only Subset Records Included in Max Sale Date
queries written inside MS-Access are getting deleted
Unable to bring back all results from table with query
Re: Select a query showing only selective post codes relating a relevantpostal area
Re: query help
Re: query help
Re: Too Few parameters. Expected 2. (3061) - Northwind DB - Please Help
'new record' grayed out in query
Query joins using > and/or < operators
Query to find select columns in several tables....Help!
Why won't resizing changes stick?
Re: Criteria based on Check Boxes
Criteria based on Check Boxes
Simple Question on Addition
Return All Record if Check Box is Blank
Duplicate Values in Query
Duplicate Values in Query
Return a date range based on today's date
Query twice with the same criteria ==>
Year Minus One
Best Prometric Center@ Delhi
Append Query To Table
Re: Query critieria to exclude 2 words
Criteria based on checkbox
Summarizing quantities by Part Number
Top 3 by Sum of Value
Update Kanji Char in SQL Database from Access returns question mar
query by form problem
Drop down text to permanent text?
Re: Cumulative value
Reclac Conditional Formatting
What is wrong with this SQL?
Re: Cumulative value
Return all records many to many
how to allow the user to enter their search criteria
Complicated text to date query - urgently need help please
Query-matching data with multiple choices
Queries
Export query to Excel with formated heading
Calculating a difference between an absolute value and a sum of va
Re: Run a Query using VBA without User Interface
Re: Query Based on Time Rane and Date Range
Obtain Top Value from Table
Using a field name as variable in a query
Linking Multiple Queries and a SharePoint List
A dialog box pops up when I start my application
Re: Filter for Same Value in Two Fields
RE: Filter for Same Value in Two Fields
Filter for Same Value in Two Fields
Combo Box Not in List function
Query design help requested
Requerying Automatically
Merging queries by column in access
Duplicate Returns.
Expression Exceeds 1024 character limit of design view, HELP!?
Query repeated values
Temporarily disable relationships/constraints
Previous Dates
Re: Not statement not working
Joining tables
Query duplicated entries
Update query only partially working
Archive in query
YTD Subquery is not including December why?
there isn't enough free memory to refresh the display
How to use Delete Query for specific for rows > 5
Columns using month and year
Re: # in table
Crystal Reports formula to Access
Remove Certain String from Query Field
RE: Ask for date
Re: Ask for date
RE: period question
Re: Pass Through Query Translation
Re: Pass Through Query Translation
period question
Pass Through Query Translation
Rolling Periods
help with finding lowercase characters in table
Comparing columns in two otherwise identical Tables
using field name as value in query
Query is showing invalid totals (due to multiple records)
Nested or Sub query?
FORMATTING RESULTS IN CALCULATED FIELD
Export Format not avaiable
Pass-Through Query / Multiple ODBC Connections
Sum means empty query?
Re: Convert to PST from GMT time
24 rolling periods how to calculate.
24 rolling periods
This should be easy but....
can't save modified query
Query Help
RE: Survey Qustion
A Team Required for an update query
Grouping results
Double Booking Query
Append Union Queries
Re: Survey Qustion
3-Tier Crosstab Report
Re: Survey Qustion
MID Function
RE: Survey Qustion
Running Total
Records with null values aren't being returned
3-Tier Crosstab Report
Using combo box(s) to create a query
microsoft access
Can I use an IIF statement with the NZ function?
Salary Commissions
Need an Expert... Update with a DMAX
Conditional query question
Querying between two dates doesn't work if Start and End are ident
Queries
A calculated field in access
Returning null values
clean up typos in domain part of email
multiple postcode criteria selection
Find more than 1 @ in email
Evaluate Yes/No Field Based on User Input
Queries.
Show the last record based on the last recorded date - JCW
"referrer" entries in an alaphabetic list
Re: convert layered MS Access queries to .NET
Re: convert layered MS Access queries to .NET
Re: convert layered MS Access queries to .NET
querry 2 tables
Join based on next closest value (like Excel VLOOKUP)
Outlook 2007 Calendar
Time Between the Time of the Current Record and the Next Earliest
Numerical query criteria and quotation marks
RE: Combining Tables
Re: Combining Tables
Access Query
Identify missing numbers
Convert datatype using query
Sorting in Queries
Data Conversion Expression returns #Error
Data Conversion Expression returning an #Error
DateDiff("yyyy",[Anniversary],Now()) returns rounded number
Distinctrow
Query to populate combobox with names of tables, only if they contain data
Date Function in query
WHERE CLAUSE
Re: Date Expression
Re: Date Expression
Crosstab qry not adding up
iif and between
can not rerun Make table query - say has to delete prev.
Using Criteria for a Y or N response
Creating queries asking for counts
Query in a subform field
Counting records matching criteria
Yes/No parameter for Yes or No or Both
Query for Multiple Lookups
Identify closed/finalized records the month they were opened Acces
Batching Append Queries
Text to Time converstion problem
How do I add a field to a query and make a calculation?
Clause order in SQL select query
Denormalize
Making a query that shows a value based on another value.
Creating a select query from multiple fields on the same table
reports by year
NZ function
Problems with Crosstab Query
how do you use a function in a view (access project / adp)
how do i perform a Count(Distinct) query for 2 different column va
how do i perform a Count(Distinct) query for 2 different column va
Aliasing a column header field name
how do I print out query criteria
join with different number of rows
Error 3061
I can't figure out how to do this.
Counting records in a query
Using IsNULL/IsError with IIF funtion.
Report from a Crosstab w/Parameters
Adding Information to a Table
Type mismatch in Function
Alias outfield column header
two null fields
How do you sort 2 date fields in assending order (query or report)
Web based news browser
Check Box Option in joined query
Union Query with division
counting totals, but not using "like"
Can't insert record
how do i not count weekend days in an access querry
making an equation in access
Count IF
COUNTIF
SQL Error Help
SQL Error Help
Build Crosstab query from existing query
Make a change to an Update Query
Change an update query
Troubleshooting Delete Queries
inserting a link on an access report
update a multivalued field access 2007
Re: Show Fiscal Year
Re: Delete Queries, any help appreciated!
Re: Delete Queries, any help appreciated!
Inserting a character
host "smtp" could not be found.
Close Matches???
Help with queries
Removing/replace special character in a field
delete identical duplicate records
Re: Show Fiscal Year
Showing a sum total in a query for fields based on the year - JCW
Query to show "&" only if second field is not null
date recognition problem in Access 2007
crack ecm2001 titanium torrent rapidshare download free gRJqCvw+up
Newbie Query Help!
Parameter Query
Help with sql string building
New column to get fiscal year from existing dates
USING SQL STMT FOR QUERY
Query and Combo Box
How to query a text string when case is in upper and lower
Numbered Transactions
1 query 2 tables
Hide all characters after "hyphen"
Select Query & Crosstab Query
query help
Update Field from Query Result
sql passthru query - MAX
Probably a simple question
RE: Issue in create a certain query
Display all latest Entries
Update checkbox on all but most recent Transaction
array query
Query help for a census database
Complicated Query?
"Data Has Been Changed" error with MSSQL 2005 backend using left j
Appending to a data record
Creating queries on the fly
Selecting month out of a date using a query?
Type mismatch in JOIN expression. (Error 3615) Join data stored asText and Number
Select dates
Max in sql passthru query
extracting LAST x characters of a string
Re: Joining or Combining two tables
Re: Joining or Combining two tables
Some records do not show up in the report using crosstab query
Crosstab - Multiple values on each row
Re: Append Query
IIF in Select Query
dialog input to get part of table name for a make-table query
RE: Split delimited field data TWICE to populate specific other fields
Re: Split delimited field data TWICE to populate specific other fields
return a specific quarter data is in
Logical Expressions in Access
How do I make a query return just 1 record
Convert String to Date
Need to create totals using a Crosstab Query
Table View - How Can I see description
help with
Re: Outstanding Drafts
Find start position of the 9th occurance of a <character> in a str
crosstab query with Sum -conditional
crosstab with conditional SUM()
Wrong Database Design
Crosstab query with multiple fields
Grand Total in a Query
Date parameter question
Export Query To Excel Problem
Re: Data type mismatch in criteria expression even the datatype is the same
Appendding to/from Upsize_ts (time stamp) field
Make Table Query Truncating Memo Field at 255 Characters
Process to modify multiple queries simultaneously
Age calculation in Query
update and append queries
Re: Data type mismatch in criteria expression issue
Summary Queries
select distinct fulladdress
Finding Matching data
Lost in time!
Query Service History/Future Dates
Query Service History/Future Dates
Last record by text field of an unsorted table
Multiple IIF In Query
Re: 2 Table Query issues
Crosstab Returns Empty Fields
Crosstab returns blank fields
Can understand access code
Auto join in access 2007
Problem with Expression
Remove all characters after "hyphen" in field
Inverted Query
separate field
Re: iif statement
Append record with Yes/No
Combining Records Question.
query result in text box
Subquery Range Lookup
Querying Numbers - Field Size = "Double"
Subquery help
Choose the highest and second highest from three field
...cannot use a calculated field in a Where clause...
find who the driver is
where do i get a windows installer download from
Show a picture on a form specific to each record - JCW
Characters found at end of sql error-Repost
Characters found at end of sql error
Query to Find Records with only 1 transaction
where clause
RE: Ms Access List boxes
Is it an Ms Access bug?
Trying not to run multiple queries
Custom Counter Question (Repost)
RecordsetNot Updateable
find exact match or match those only few cents off
Error in syntax
DateAdd and other functions
IIF in Query, more output then I want
Modifying subform's underlying SQL statement
200 results per page
MS Access
Calculation in a query
Create update query for remaining records
Changing query criteria to supply a form
Pie Chart
Queries; Make Ready
Turn Off Access Field Re-name? Calculation fields in query
Query Weekly Data
Determine position in query recordset
Re: dcount
combobox in query
Select row by ID to nearest date, future (or past if no future dat
Query-finding umatched data with duplicates
Maximum Number of Crosstab Column Headings
fConcatChild issues
Subquery Issue 1
Use of Max is quite working
IIf statement in query criteria
How to find previous, current and future values
IIF statement with DCount crashes A2007
IIF statement and multiple items
cross tab query outer join
nested iif function
...efficient method of finding closest date between unrelated tables
can only name folders with 8 letters or less how can I extend it .
Query Problem
search criteria in query
Update table with values from another table
Calculating time in Access based on an 8 hour day
Multiple records in a query
Totals with WHERE left() criteria
Count of Groups
IIF statement to compare two fields.
Year Beginning Date
Custom Counter
How to get the previous, current and next values for a field
Report Query
Report query / filters
Query to update a table
How to get previous and current and next values on one line
Using Wild Cards in Paramter Querry
RE: Insert query using DateAdd function
Query to return only one value.
Performance when a query references another querie
Finding both the Prior and the Next Record
RE: #Error in query
#Error in query
Trim trailing spaces for name field in query
Re: Query to find offstting transactions
RE: Query to find offstting transactions
deciding minimum passing marks & distinction grade
Calculate Previous Balance as of a date
Between date with greater than or eaqual to
Parameter month query
Filtering records for 2 types of dates
Where clause is not working
Update Table with query
Fill Blanks
Message Box
query to pull between two dates
Append changed data into a history table
Going Crazy! Form Datasheet does not reflect changes to SQL query
Using 2 criteria for the same field
IIF Statement
Query within a query
Calculate Start and End Date of a Quarter
Display columns without data in cross tab query
Prompt user for a list of values in a query
Not "Y"???
Append query to another database
query prompt for One or ALL months in database
More Complex Calc in Query
Replacing * in order number
To find the earliest dated record
Joins in unmatched query
table formatting not carrying to calculated field in query
table formatting not carrying to calculated field in query
DSum Problem
Query for multiple due dates
Pass through / ODBC Data Source
merging two tables and matching only Badge numbers
Query problem
Crosstab query possibly?
Convert Date
IIF with multiple requirement
DSum Problems
Triple Key Match with nulls
Matched Query
New page
Syntex Error
Empty results when sorting multi-table query using toolbar buttonOptions
Query out transactions Continued..
Change Text format to Numbers format in a query
Combine queries
where conditions
Calculate interest amount based on average daily balance
query - express builder
Update Query
Query Results as a string
cross tab query label change
How to remove multiple symbols from a field
Adding <ALL> to a combo box
Quering out transactions
Query Not Seeing Changes to Source Tables
Help with DCOUNT syntax
formula in query criteria
Query out transaction
How to get various purchased amount made by persons
more efficient way to add lots of query criteria items
Adding a comma after a field
Query with empty fields
Search within a string and return text between two characters
2 weeks prior
Access 2007 - not recognising dates under "last" in a query
Long Date - Can't pull records accurately
Ranking Query Results
HOW TO GET ALL CONSTRAINT NAME ,TYPE,TABLENAME WITH QUERY
sort alpha numeric
adding another table to a union query
My query in access has records and my Mail merge does not
Using one calculation in another
Returning a random selection
Update query error: "Operation must use an updateable query"
Crosstab query problems
Subquery issue
If Statement or ?
RE: Split DB
Re: Split DB
Autofill fields
Letter in Reports
Re: Split DB
Use DATE in query expression
Unique Count
Multiple Criteria in query
If/Then in Access 2007
Query Too Complex with Total line
Concatenate email addresses
SQL query to select rows with highest vales
Transpose rows to columns in Access.
IIF statement in criteria not working
Function in query causes loop?
Count IP Addresses
How can I Return Just One Row With a Query?
Multiple criteria - one of them to exclude several codes.
Need total amount of items purchsed for all the persons
Query not returning null value
outer join not working