Microsoft Access Queries [Archive] - Page 2

Null or NOT in another table
Increment special numbers in an access query
Re: Select Min Query
Access query duplicates the table records
multiple query criteria
Query question
Access Query - returns 5 and 7 day information
MS Access - Five and Seven day queries
Numeric Field Overflow Error
Using Between...And with General Date
ODBC DSN query issue
RE: Is Not Null Criteria Problem
Linking on field that allows nulls
Access Query - "Duplicate Records Selected"
View Null Results in Query
Re: Duane Hookum's Concatentate - trouble in Access 2007?
Re: adding a new customer
Re: Replacing individual characters in a field to something else.
RE: Duane Hookum's Concatentate - trouble in Access 2007?
Convert to Proper or Title Case in Access 2003
Need null values for several fields in db
How to merge these 2 queries
RE: Query Criteria
counts NULL values in query
Expressions
Query crosses 3 tables
Re: Count by Date
Update Query
split up one field into multiple fields
Change expression from month to quarter
RE: open a message box if a query is null during an autoexec macro
Date/Time criteria problem
Group By Desing View
Query keeps looking for Query1 field
Rolling Average Calculation
vlookup in ms access
Exclude data from field, when another field equals a certain numbe
Min value & corresponding date
Sum a count total
Report + chart
ComboBox related query
Can't see what is wrong with this Union query...
Union query not displaying select statement
AVG crosstab query with one field containing text
sum weekly data into monthly
Calculated field for option group
Count records in 10 minute time period
Long list of fields, how to check if either is null
Closing Queries automatically saves them
Query ask for parameter value?
Calender to switch to the month
#num!
Help with expression for Qtr
Updateable Query Problem
First 10 numbers
populating a query
Update query question
sumif function in Access query, possible?
Parameter Query with DSum
Ranking in Access Query by Dates
RE: crosstab for day of week
How to make a query sort randomly each time it is run?
IIF update query
Re: Search for current date in a text field
Append queries - Column Headers
Query 90 expiration
Remove zero totals in query
RE: Search for current date in a text field
RE: Search for current date in a text field
Re: Search for current date in a text field
Re: Find any lower case in a field
Query to see what percentage of people scored a specific number
question driven query
Combining Duplicates in Select qry
Select Max, return unwanted rows.
PLEASE HELP: Display current Date & Time in Query Output
Calender to switch to the month
Removing Certain Records from a Query and Report
Access Queries
Custom Function
Iff Function
Duplicate a record
Query or Table Description
Viewing expressions in a listbox
Surprisingly fidly query?
Counts number of entries per day in query
Min Funtion
Printing crosstab query
Need help sorting a query
Group by query question
List of where queries are used?
Multiple Choice
#Num! in Link File
Numeric Field Overflow
Basing a query on the selection in a Combo box parameter
show criteria data from a query on a report using that query
Export empty columns to Excel
OpenDiagBox
How to make a query records as criteria to the other query
A spin on a common question. DateAdd
Recalculate a field when another field's value changes - JCW
Change format of date in query?
Running queries via forms
Query criteria based on table entries
5 Fields Multiple Values
Requesting Help Ranking Sales Values.....
Can't enter data in query datasheet
How do I prevent values from been multiplied by two or three?
how to remove html tags from a field in MSACCESS.
Multiple "Not Like" not working
Re: Filtering a Crosstab Query from Combo Boxes on Unbound Form
Finding a value in several different columns
Selecting records by rowID
list box row source
Displaying data across columns
RE: Filtering a Crosstab Query from Combo Boxes on Unbound Form
Multiple Query questions
Multitable query problem
How to combine queries????
combine multiple recs into one with repeating fields
Query to conditionally handle duplicates
Count by short date and group by agent name
Help with 3 scenerio query
days between tweak
Query between 2 tables with one-to-many relationship
Special Characters in Access 2007
Date Brackets as an IIf statement
Compare dates in two seperate records
Customizing the print view for a crosstab query
Negative Figures In A Query
Producing combined table grouped by categories
I want year in one table to be less or equal year in another table
crosstab query
Building/Storing a passthrough:How to assign connection string andmake passthrough
Append if Not Exist
Query
QUERY to show record if text present in field
Query based on date in a filed more then 3 days old
RE: You tried to execute a query that does not include the specified e
Show 0 instead of Null
pass through query variables
field no show
Append Query with Oldest top Records by Group
creating a flag to identify first, second time etc someone has app
Help with Query to find Month
Using a Password With an SQL IN Clause
Using a combo box as a criteria for a query
Please Help: compare values in two columns present in seperate tab
export query with formulas to excel
Append to two different tables
Re: deborah.bass@nhs.net
Report Printing
Date criteria problem
Serach option
Database engine cannot find the input table or query
Viewing expressions in a listbox
With Function
query
sql query reqest
Re: How to change query empty field to "0"
delete certain rows
How do I combine text fields in Access
Re: Decimals
Parameters in Queries
Extracting the numbers from the Text Field
How do you ignore entire tables in an Inner Join Query?
Grouping reports and subreports
Trying to update a field
Between Dates Parameter Query
Previous Month Query
Query using two separate query totals
Trying to update multiple fields in the same record (same table)
RE: Decimals
Multiple <> query criteria
Get run time from date time stamps
Acccess 2007 Runtime and Queries
Monthly quantities to Weekly
Percentrank
crosstab - multiple values required
Re: I Can't Do This
Remaining Balance Query
How to convert Null values to zero when create an average query
How to convert Null values to zero when create an average query
Indexing 2 sides of a relationship
How to score matching results
Crosstab Query by Week with Dates as Headers
Combination of fields to create records
Total Number of fields in a query
Combining Date queries
Sort on a calculated field
Parameter Queries in Crosstab Query
Why does this query ask for the start date and end date twice?
How to calculate average for current quarter?
Format for text field
Autoinsert of variable data into update query
Querying for Extended ASCII Characters
dynamically choose columns in query
RE: Multiple Users
Query Criteria issue
parent child link query
How to Retrieve Data From Another Access Dataase Without Linking to It?
How do I bring a filed from multiple records and join them togethe
Combining Dup Info
Date expression in Query
Finding missing operator
Average interpurchase times
Re: Date Query
Crosstab Query - Column sorting problem - Ascending
Please help with converting from Sql to MS Access 2003
Sum(IIF statement
Need to migrate phone no into the next record if the family
SQL to export query into table
problem with "#"
Insert Multiple Records into a Table
Deleting Duplicates
Help with sample query.
Trying to combine multiple records into one record in a Query
Make Table v. Append to Table: Need Some Expert Design Inputs
Extracting data from string
Include certain names in query
Opinion about aggregates
Can't get my head around this query..help!
select and count
Rank and row number in Access?
Re: Value in union query
Force data type from Text to Memo in a simple Make Table Query
Find if a Form is Open
Dsum returns #Error
please explain [], . and !
sum a count column in query
RE: Append Query Question
How to write into Excel from Access 2007
Select, update query--same query, different result
Multiple make table queries in one?
Average time from date column?
Combine multiple tables with different date ranges
Update Table Field Value with SQL Query
pattern of data
Parameter prompt when form is open
Re: text format to date format
Parameters query
Extracting a word from a long text field
CrossTab Query question
Multi-field query calculations
Run a macro on a specific date - JCW
Re: Total Minutes Worked Within IVR Timing
filling fileds in a form based on criteria
DSum doesn't work on other PCs
SQL query
MS SQL has (nolock) - Access?
Can't query datetime field formatted as m/d/yyyy
Aligning beyond "Joining" in query--forcing blank rows to appear
CAN I RUN SEVERAL QUERYS FROM ONE CONTROL BUTTUON
Re: Trying to Join specific records...
Dlookup in query - any pointers?
Query
Query for previous week, Sun thru Sat, from date field
Re: type mismatch
Error 3205 - Too Many Crosstab Column Headers (300)
Counting Combination Services
Finding data prefixed with '??'
Delete part of each record
crosstab query with datea parameters
Select Query
Using checkbox to edit criteria
Select Record Query
Record Selection
how do I put in a sequence number on yearly basis?
Query using only criteria for one column when 2 are limited
dcount problem
Criteria is entered in 2 columns, query is only utilizing one setof criteria
Show if null or greater than
Search for Words in Documents
Help with IIF expression
Re: Drag and Drop [Access 2007]
Duplicate value & delete
Cutting excess rows
SQL for specific pattern of output?
Count to 8 and start over
RE: Drag and Drop [Access 2007]
How format data to add zeros to alpha numeric data in query
Merging Fields in a query
Simply query?
User Defined Query Function Not Working with Multiple Criteria
averaging specific data
Why Won't Variance & Standard Deviation Work
Pass Through Query .sql query
Query Question...
Re: Calculating quarterly values from YTD values
Query to find missing data
slow query in survey
Re: Convert seconds to hours
RE: Convert seconds to hours
IIF function for 3 criteria, possible?
Re: Convert seconds to hours
Cross tab query
Find Replace values when they are not null
Update Record Performance - Query vs Code
Using "Count" in Queries
Append Query Fails
Re: Searching by network user name
function for date of first and last day through weeknumber
multiple iterations of same query
Prevent the table modification message in action query
Nested JOIN clauses - order of precedence (Access 2007)
Re: how do i fix and type mismatch in expression
Re: how do i fix and type mismatch in expression
Format Expression as a percent
combine like items in query
How to update data in a query
Select and combine duplicates
formatting a phone number in a string
newbie question about query with more than 1 table
updatable query
SQL BETWEEN If end date is less than start date all records betweenare still displayed.
joining two iif statements
Recalculate a field when another field's value changes - JCW
Access 2003 query to Excel 2007 problem?
Get records with a negative value anywhere in the table.
Convert Currency to String but keep commas
Append Record with Next Consecutive Number (not Autonumber)
Counting Ocurrances within a Time Frame
Using IIF to pass query criteria
concatenate
match values
Lab Value with iif function.
A Complicated Query Question
Parameter queries
SubQuery
Dealing with period variances
How to use colmn headings in paramter query
Yes / Yes + N Responses for percentage
Eliminating Duplicates from a Query Access 2007
Progress Report
Subquery
Subtracting Value from Field if Yes/No = Yes
Exclusion: How to show when staff have not completed a training fo
Can a Table be Updated From a Subquery with Aggregate Count Value?
Correlated subquery aggregate total
select records where first letter of name begins with an a through
Yes responses divided by yes + No responses for percentage
Flipping naming conventions to match two tables
Funny characters in my query results
RE: Time function
Re: Max & date
hubs
SQL Update
Summary row in crosstab query?
Using a Yes/No field to trigger a calculation in another field - J
Decimals
A different way to group data
Re: Count the number of times a character appears in a field
Dynaset, inconsistent updates
Query Help Needed
Refering to lowest record in select subquery
Oldest and Most Recent dates in header
pulling a date out of a field containing both date and time
Instr parsing with a comma delimited string
Return Random Sampling from Query
make-table
Add Fake Records to Query from Table
Many tables
Number of occurences
Query. How to add this calculated field?
Find Duplicate Records in two tables
dlookup in access
Thanks Jerry W. and John V.!!!
Expression for Criteria for Form with Combo Boxes
may be crosstab will do the job
Calculating hours on a timeclock form
Quirky Query
From large to small letters
Automatically adding data between two dates.
Crosstab query question
how do I obtain data for Friday & Saturday on a Monday
'Count' query not working
Store Employee ID in table, Display User Name in form
Select with Conditions
update crosstab
Using Access query data lookup values
help me
Top Two Items per customer
Query on or before date
read only database
Module "CarryOver" from Mr. Allen Browne
IF statement in a query....
Delete Query
grouping ...
Running a stored parameter query from a form without pop up boxes.
Cross tab query solution
Query Problem
Re: Parameter Criteria Date Picker
Query cross two table
Question Asked Grays out... Is this Normal
Time Calculation
Combo Box 2 Bound Columns?
Troubleshoot A Query
If before today's date insert Expired
using dates Part 2
This query is typed incorrectly or is too complex to be evaluated.
turning off warnings in 2007
compare two tables for mismatch data
Query not working for SQL Server
Calculated Field in Query - Date Format
INSERT / UPDATE Query in same operation
fuzzy matching help please in an Access 2003 query
Problem with Null value elimintation criteria
Count operator leads to parameter value error
Gaps in ordered series
How do I display the most recent of three dates in an Access quer.
How do I show all characters before the letter A in a Query?
IIF expresion
Not In (SELECT DISTINCTROW
return product with maximum price
update query
Queryed for 30 & Higher Returns 3's & 4's
Query set-up with two tables
Data Exceptions Split
Changing recordsource.. query in comboboxes
How could I SELECT the max of 2 different fields?
SQL searches
Nested IIf and IsNull
Re: Help filling in form from 2 different tables
What is wrong with this equation?
Multi List combo as criteria
DateDiff Conversion
using dates
Returning all values with a join
Count if Text is Equal in two Fields
Query multiple Criteria, pick one!
Query Help One-to-Many
Querying Date Field, Disregarding Year
Re: Convert Claim # to Julian Dt
Repetitive Results
Re: Convert Claim # to Julian Dt
Aggregate calculations on calculated query fields?
Delete Records Where The Like* Can Be used??
How to query
Selecting unique record from duplicate
Help needed to finish a query that display results of a subquerybased upon a count...
Using a Yes/No field to trigger a calculation in another field - J
Re: querry to seperate data
Multiple fields for same type of values
passthrough query question
TYPE CONVERSION
Making changes
Re: Query to find outliers
Query to find outliers
If statement in Update query
show records when two fields not equal
iif statement what is wrong with this expression
arr records except last
Return One Record Per Individual
underscore sign in query
RE: Query Speed
2 quesions about query
Odd Parameter request in Crosstab
Query to add fake records from table
Refresh a price list with current pricing
A bug in GUI of creating query with more outer joins between two tables
Find matching records based on two fields
Access 2007 - return maximum date
Convert Text to number
RE: IIF Statement Query??
Re: IIF Statement Query??
Update Queries
Query Help
How to Strip HTML tags from data
View unavailable
Combine Format function?
Update End Date
Update Query
an ALIAS question?
parameter query issue with single date
Query with 2 parameters asks for 3
QueryToJoineMultipleTables
Days in part of the month
Fields in a query
DSum in Query
Re: Query Output
syntax for Week number
E_lookup
Help with a partial match query
BUILDING UNION QUERY
Count
Adding lines together to create one line
RE: left join query is not working
query error
RE: Query Output
Best 5 bids
Select unique products per customer?
Excluding a day of the week (for only a short period of time)
Converting a Date
Recorset not updateable in a crosstab query
Re: SQL Update and NOW
Re: Running a query against a password protected spreadsheet
RE: Running a query against a password protected spreadsheet
dcount in a crosstab query
SubQueries
RE: SQL Update and NOW
Where are Mod's defined in databases
Control apostrophe
You can not add or change a record because a related record...
Update Query ?
Adding variables
DSUM Date Criteria
query to update familyID by last name
functions in criteria
Action Query (Append) didn't add records due to key violations.
SQL pass thru query from code always propting for DSN
Querying Dates
Displaying too many records
getting data from date range
DateDiff
query help
Delete duplicates with conditions
extracting day from date
SQL Select Query Prompting for NonExistent Parameter
Query to unnormalize some data
Returning A Varibale from a query
Loop Query values
Query filtering by Aggregate
IIf Statement
optional parameter for query
Problem Sequentially Numbering Records
How do I Excel formula =LEFT(A2,LEN(A2)-3) in an Access Query
testing for numeric or alpha
"is not a valid name. Make sure
ODBC errors?
IIF Function Within A Query
DELETE column in TABLE
Re: Total column in Query
split from one date to several dates
Re: Group by query
Repost-Edit and save query criteria
RE: Group by query
Re: Group by query
Display records one time only
query for a peculiar sort order
Best Way to Display Data
Duplicate fields in Access Database
Query Help
round to nearest 114
Exclude all records based on null value
showing the last 20 results from a union query
Crosstab query (I think)
SQL totalling items report
How do u create criteria with a LIKE "xxx" or/and
multiple one to many
Adding up row values
Update Query
Query to find records after specific date and time today
Count Records in multiple tables
Problem Passing Parameter from Form
Multiple Tables in Query not Listing Data.
Parameter in a critiria
'Type Mismatch' Error- PLEASE HELP
query too slow
Re: Remove dublecate post
Parameter Queries
Access macro
Dsum Problem
Query not showing certain records
howto convert a table field from double precision into long integerwith a query
In Access 2010, how do I create a SQL query?
show last date in a query and report - JCW
Show maximum date in a query/report - JCW
How do I execute multiple SQL statements in Access??
Parsing
Help resolving multi to multi relationship
create dropdown based on all people Not selectedyet to work onWork
Using Functions in Queries/Assigning Values to Non-numerical Entri
Matching exact data
Action Query Slow and Hourglass Method
Finding the space in a text string and returning text on either si
Access search text string for char, then extract all to right?
Filter to select from various fields on opening a form
data append & overwrite by 1 step
Re: Sequential Grouping
Getting total sales by customer
select queries that calculate the Median base on group by
SQL question - Cross Tab query
Edit and save query criteria
Update query to replace everything after comma
Iif Statement Problem
Insert a default record for all values
Add a space between two values
How to Return all Records with Blank Cells?
Random Selection of Records
Compare 2 Fields
Re: error
Crosstab query to include fields with Null value
Re: Need to Make Query Run Faster - SLQ?
Re: Need to Make Query Run Faster - SLQ?
DISTINCT or GROUP BY?
Subquery
Date serial for 2 months prior
Data Not Displayed in Query
using "Last" in query desgin
How to populate a column in a row based on a value in another colu
Column for line numbers...
Hours for month as value in query
RE: Count of Unique Values in Access Field
Re: Count of Unique Values in Access Field
Is it possible and how can it be done?
Date Query to create a report
Foreign charset showing up unexpectedly
RE: Look up by Date issue
Re: Look up by Date issue
Query on two tables with matching null fields
How do you sum on top of a group by
Query that will look for duplicate in two tables.
2010 DATE CRITERIA
Iif statement and time format
Getting rid of a Having clause
How to get query to return total using wildcard
Comparison Query - How to write it!
recursively retrieve records from 2nd table based on records from
Nz - need code -
Brain Freeze help with combobox and query
My Access query shows blank in the label merge
12 Month Running Total
I need to always Round UP if greater than zero at all. HOW?
Stacking Date/Time from Row to Row
DateAdd compile error
military time
Group like numbers
Query set-up not using cross-tab
Subquery with subraction - challenging
Re: runtime access
Pass Through Query - not returning rows
Re: efficient method of finding closest date by specify input value
Count query
How to get a query to call the parameter form
pivot table calculations
mdb file
mdb file
Calculating the days in a month
how to run onhand value report
Re: Help !
How do I access multiple records within a query?
two criteria in DLookup
Re: QUERY
Criteria in append querie
form filter acces 2007
Access 2007 - Date Serial
Query to Include cboSymbols or ‘*’
Why does MSAccess cut query after 2886000 records
Can there be too many sub queries within a single query?
No Records Found ERROR---HELP!!!
divison by zero error
Queries and Reports in Office 2007
Using Combo Boxes as a Source for Parameter Queries
query to trim name field?
Re: Query Records in Linked table
Sum duplicate lines in a table
Re: Query most recent records only
Julian Date conversion
calculated field - difficult
Query prompt one column for multiple random values
days between end of one record and start of another
Querying dates between two tables
Microsoft SQL Server Management Studio / Convert Date
Running Balance in Access 2007
This has got to be an easy question?
Concatenating with and/or without a comma
Calculating Values in a Query
how field name output same as input
RE: Subform-Query Problems
RE: Subform-Query Problems
Unique Count in Sigma Query
Query of a subform
Select to reference an other record or row
Find and replace
Multiple prompt criteria
can't get query to group
Totals query and Memo field
Append New Record Via A Form?
Hyperlink Part
challenging query
How to Handle Nulls in SQL?
Comapring rows of a table to multple rows within the same table
Update Query
Complex Combination - Is this possible?
Concatenate multiple records
Simple query question in MS Access
Schedule a Macro with Windows Task Manager
Running average - subquery?
How to sum all the records, excluding the top N ones?
IIF Record =
Unable to use filter in datasheet view or add criteria to query indesign view
Restarting Record Count in a Query
Help please with nested iif
Query with more than 8 'OR' criteria?
QBE
QBE
Calculate difference in rows in a query
changing totals as a date changes
Database shutdown after idle time
Crosstab Groupings
Crosstab query with custom grouping
RE: Now()+1
RE: Different Data Formats- Rows Vs. Columns
Re: Now()+1
Show One Record For Each Patient ID.
export to xls.
Duplicates
Choosing unlocked new record
Query Question
all posible combinations
crosstab query child table count
Search by product & alsoshow other products purchased by same cust
Return all dates for 'next month' irrespective of year or day
Very difficult query!
Between ...And
Re: Instr
RE: Instr
Re: Instr
Parameter Query Question
Eliminating duplicates in Access 2007
IIF stmt in query
Aggregating Data
duplicates data across 3 fields
RE: Query Does Not Bring Back Everything
Problems with a join
howto copy only newer OrderID data(and the other fields) from onetable to another table
Getting info from two tables with disimilar headings
Report-not required to print if field is null-concatenated field q
Re: Calculated query field will not filter
Re: Calculated query field will not filter
SQL "NOT IN" doesn't function as expected (refresh)
Serial Number - Temporarily In A Query
Joining Multiple Tables
How to make multiple values show up
Difference between numbers
Add percentages
Get Subform Data
How to break some SQL into VBA
Need help with creating condition to produce follow-up list in Acc
Query performance Access 2007
Checking if a record is also in another list
Between [First Date] And [Last date]
CalcWorkDays error
Calculate Percent Return for Stocks
Re: Multiple IIf
Disapearing Query Results!
help please with creating a Query with different
Is this Possible - Dynamic Field Selection within a QBE grid?
Multiple Values in a Query Criteria
Re: Query wants parameter value