Microsoft Access Queries [Archive]

"Query Too Complex" Access 2000 help me make this one query less complex?
Need Join help
Ranking- Multiple Columns
Make table query: [Enter 1] AS Test
Re: Remove only the last comma
How to count consecutive records base on 2 groupings
decimal - off by one
scaling of decimal value resulted in data truncation
Prorata calculation - ARRGGHHH!
return without gosub error
Round up or down to nearest 5, but not 10
Delete query with joined tables
Transposing data in Access 2007 Query
Incorrect sum in MS Access query
formatting a function
Top 3 per group
create table from template table
dynamic calculated field in query
Access IIF and Instr function
Date and Time
Query Key
Using "like" from an external link
How to Return the value of field from two lookup?
Issue with OLE DB Query - Date Search
Duplicates in union query
query on date
iif exists - too complex?
hopefully quick question
Find the Next Date for a given ID
Query data from 3 tables with similar data
DSum update query with multiple fields
Filter Fields Containing Values Found in Another Table
Access to split First and Last name
AND query
Another most-recent date query
Make-table query with around 2 ml records taking too long
limiting distinct to above threshold
Count Query Help
Using Crosstab column headings for conditional formatting in report
Multi-Value Field Query
Populate Dropdown combo from multiple tables
Have both records from two queries/tables under one Query without related fields.
Need help transposing multiple columns in a query
Access 2010 - Form - Box "Search" in Navigation bar
Count subselect
Calculating Meal Period Violations in Access
calculation based on previous record
query to get top player
Error in Access Query
A query for 12 month rolling values
Help needed to create a query
Max & Min Dates
Any other ways to use excel fcts in Access SQL
Inner Join on left() too slow
Numeric Field Overflow when appending date - how to convert it to text
ConcatRelated: How do I add an additional field?
Excel fcts in Access
Call ext db from/in
Squirt query result into new table
most frquent substring
NAB + NCD -> NABCD
Query with results in a value list from a combo box?
How Search RAFT2 control by querying
Concat fields from one table to other
Access Form
How Do I saggregate(Saparate)last characture from Text Field in MSAcess Xp Version
access form
How to build subquery on aggregate query
SQL query with join on substring
Division by Zero Error
Decimal places and formatting within query! aargh!
Nested IF or IIF Formula Help
Re: Requery after you modify the SQL statement in VBA Access?
Re: How to return Max date or Null (if there is a Null present)
Complicated Calculated Field Logic
print form filtered (on a report)
update query vs make query
Hundredths of Seconds Since Midnight
Re: Query to return latest dates
Update Query Help *urgent*
Re: Query to return latest dates
Queries across tables, merging/concatenating
how to call the photo and faxviewer
Re: DatePart Expression
Help with Access Query! - Merging Rows with Unique ID
perform INNER JOIN on query results
Schedule Auto run Query on append table
Using variables as table names in an append sql statemnt
Problem with Cross qry
Re: Zip codes
dsum sytax error
Access 2000 append unbound text box values to a table
crosstab query?
Using InStr Access 2007
if syntax
Re: Query to show items before a nominated Date
Re: Group By problem
Re: Group By problem
Re: IF then SUM
Error: Data type mismatch in criteria expression
Re: SUMIF
Re: Finding totals withing a seven day period
Re: Finding totals withing a seven day period
Exicute an append query in an after update event
Count, Fields Calucation help
Need Query Help
Re: Finding Totals within a specific date range
MS Access Form update
MS Access Form update
MS Access Form update
How to convert duplicate columns into different rows for unique id
Query to duplicate a record with one field updated
Access Query for keeping a total hours remaining.
Re: Reading Previous record of field and inserting it into current If Is Null??
determining if a field should be included
Compare current month totals with last months totals
Re: crash
Re: Calaculating a column sum from within the same query
Re: Querying a data set for a complete list
Transpose Data that involves subquery
formatting
running total of records in query
What is Redmond doing?
search multiple criteria
search query
Ranking (Look for previous ranking)
Comparing two tables in Access to look for discrepancies
To reconstruct a data table
AutoIncrement Text Field in an Insert Statement
0uery criteria not working
Subquery not integrating to query to display previous sum of quantities
Convert Formula from Excel to Access
Itereate cross tab query over another query
Unwanted Brackets
Adding fields working for some records, not all
sum a report
crosstab query question.
Need Help soon with this querry!!!!!! PLZ PLZ
Sorting Problem
Re: Really basic question about Queries
quick query question
Help Please
grouping error?
Not Equal To
Query Question
Number Items Grouped in a Query
HELP - selecting
Choose append field based on criteria
Union query
linked worksheet connection error
Crosstab Query
Exclude items in a query
Anyone else have this problem?
quick query question
cannot have memo,ole or hyperlink object in aggregate argument
Fixing up field with a row number to become PK
urgent help- access to excel
beginner sql query
Re: access query
Multiple Parameter Crosstab query filter by form
MS 2003 Parameterized Query
Formatting a query field
Exporting as CSV
Text Formatting of Expression Based Query Columns
Allen Browne's ConcatRelated() Function
Query Help Please
Query Help Please
Re: Really basic(?) Query query!
"Merging" Yes/No Fields in a query (MSAccess 2007)
Make Table Query and Autonumber Fields
Import from excel ONLY specific headers
VBA coding question.... Need expert help
DSum With Multiple Criteria and Date Value
Access 2007 - check for existing record
Re: Query To See If text string exists in a field
crazy query
help with ranking in a query
How to display multiple IIf results in one column
How to display multiple IIf results in one column
Complex query help
Access update query
Access 2003 Question
Heavy data munching - is there a more efficient way of doing this?
rank in select query not right
Moving Average Access 07
Export Query Output To Text File
Is there a way to do this with queries?
Data Import Question
Finding possible matches
Query Help
Re: Sum YTD
setting up a schedule in access
Preferred way to do sort order - column in table, or specified in query?
Sequential values in access table
Taking the sum between two dates
urgent help -- macro or form required
urgent;; macro or form or template request
template or macro required
Replace All Letters
Formula to extract only numbers and decimal
sql.request from excel
Filtering a table by using criteria in another table
Query Returning Multiple Results
Add a column to excel from access
Find duplicates in two tables, report one of them, and keep unique entries
Append query in VBA triggered by a form event for simple audit trail.
query is not updatable;; urgent
Append query in VBA triggered by a form event for simple audit trail.
Date/Time Calculation past midnight...help - Microsoft Access
Re: locating query's use
Text to time conversion
excel to acces
Urgent query needed
dsum with multiple criteria and decimals
Combining queries that don't match
How to find out how many fields from a specific list of fields are empty
Mean of Days of a Month of an event
Importing and merging tables
Apply Multiple Payments
eliminating criteria in a query
Converting "row_number()" Query Into Access 2007 Format
List all the constituents of a Group in another column:
Pls Help - "between" Criterea returning no results
Re: locating query's use
Setting field value if a value exists in another table
Setting field value if a value exists in another table
Setting field value if a value exists in another table
Trouble with large query
Re: locating query's use
Sort by number of unique entries in a datafield
Undefined function 'concatenate' in expression
Half gig xlsx file to access
Sorting
trying to NOT have so many If-Else Statements?
Subquery with Select Substring
URGENT!!! Query text & number values from the other tables
Newbie Access Help - Query with calculation..
Finding the Most Common Variation
Showing two 'counts' on the same row
extracting text
Seriously, I need ideas. Fields not transferring from table to table
Macro Question
Re: Filter Records with a space at the beginning
Filter Records with a space at the beginning
Combining multiple table rows into 1 row
queryproblem ac2003
SINCERLY NONOE.?!
Re: REQ: How to filter time field
Export to Excel with Parameter in Filename
Disable Pop Up Box
Query Question
variable in query
union query issue
Insert query
Pull a field from a form to be the criteria of an append query
query syntax / layout
showing just the latest value in a text box
sendobject action
need to show unfiltered data on chart
Re: filtering a query for charts in a form
Re: filtering a query for charts in a form
Re: filtering a query for charts in a form
quick and hopefully easy question
Re: filtering a query for charts in a form
Recordset not updateable
Re: query field names changing to expr#:
filtering a query for charts in a form
Re: query field names changing to expr#:
Re: query field names changing to expr#:
Re: query field names changing to expr#:
query field names changing to expr#:
Extract data from three tables
Query / Count Length Of Field
Re: fieldcontent to clipboard
fieldcontent to clipboard
Open a db from another db
retrieve last three characters of field
Query Question /
Union Query
Query Question
Limit combo box to show only values not already selected
Re: How many students enrolled in a subject
How many students enrolled in a subject
Modify A Query Again
Transform/PIVOT Query
Combining Queries
Query Between 2 numbers ("dates")
Microsoft Access Date Calculation
Another Query Modification Question
Query Question
Sorting
Help Needed: Create Sum in Report Footer based on aggregate expression
Query Question
default value in parameter query
re-formatting date values in query design view
subtotals in a table or query
Query Help Needed
Field Name in a Table
Deleting Rows In a Database
Import File / First Line Has Date Info
Sum & Group By
Transpose Query Output
calculate Age problem date notation european american format
Text too long to be edited
return one instance of account number
Two fields in a table linked to an other table
System resource exceeded
System resource exceeded
System resource exceeded
query on query
Can't update using docmd.runsql
Counting fields in a table row
can't find strSQL
Like "* " and function to pass parameters into a query
Running Sum in query
A module to validate SSN
Re: Really fundamental QUERY question!
Re: CrossTab Combining 2 fields into Column heading
CrossTab Combining 2 fields into Column heading
Pass Thru with a Subselect
Help Disambiguate my Join
Re: Cross Tab Query
Individuals who have not taken course
Verify data via query
Access 2010 AND Query Help
Re: counting records
Help with DMin?
Case of the curious query ; count the codes
A database to calculate workhours has to invovle last monthsworkhours how? help..
Setting values over multiple records in one Query using Loop statement
Data into Crosstab
Recommendation to learn SQL for Ms Access.
Calculate Days between dates of a sale for a particular product
text after
complicated date issue
complicated date issue
Union Query
Help with loop
Re: Help with Query
Re: Help with Query
SELECT MAX(value) from table1 and add several associated values from table2
Exclude Multiple Zeros in Query
Adding my own rows to a Union Query without adding another table?
append query exclude error data
code to rename image files from query
Reserved Error -1524, This query works on everyone elses installation!
Re: Duplicate records suppressed
Re: Duplicate records suppressed
Query Corsstab with Three months roll over period
how to make a crosstab with a where clause?
"Child39:" showing up on report under certain conditions
Convert and sort date originally formated as text
Suppress comma in calculated field given Null
result query on a form
help append query with dynamic fileld to table
crosstab problem
Date Range Query
Date Comparison
Call Stored Append Query
Access DateDiff function
query links to SQL server and mdb table
Please help - click in query criteria and hourglass, access does not respond
Filter Crosstab results
SELECT a field value into a user variable.
outer joint query
Any suggestions for optimising this very slow (45 minute) query?
why isn't this query FAST!? I've tried EVERYTHING! (query performance issue)
If Statement with "*" in Query
adding a field in a make table query
Need Memo data type to remain Memo
Group by weight
Instant Totals on Continuous Forms
Select ONE record
Criteria help
Calling Parameterized Query Using SQL Syntax
disctinct query memo field
IIF statement with blank records
Nested If conversion to Select case
Formatting date gives bad results in query
error importing excel file
Select Top Query
Splitting a large field up into six new fields
Appending null data and moving!
composite key unmatched query
Using IIF statement in query criteria
Make Table Dynamic Table Name using INTO
Creating a "grid" of data
Use a function in the "Criteria" of a query?
Listing all fields in a query
How to write a query/macro to consolidate data in the same table, anddelete the duplicate one
Queries losing fieldnames when importing from external mdb
Serial No for Unique Value
lookup table names
Query field size quandry
Calculate time difference
monthly totals
Re: Problem with queries and linked SQL Tables
Re: Problem with queries and linked SQL Tables
multiple users' simultaneous access to a MS Access database
multiple users' simultaneous access to a MS Access database
changing a number to text
Re: Using Ribbons in a Multiuser database
Using IN( ) function in a query
extract just month/year from table field??
Extract data from previous week, previous two weeks, etc.
Data changes in append query
output to Excel
query
Re: Enter Parameter Value dialogue boxes when run report
Pass a control.value to SQL statement??
Re: running queries in code
Re: Record count
Re: Running queries from code
Re: Comments in queries
Re: Non-code solution
query
upc and pos
need to rank in a query
need to rank in a query
need to rank in a query
Formula to give squense number
Formula in Access Query to genrate numbers
Help with a "like" query between two fields from two different tables...
repeating a query
can't open front end when back end in use
List box not displaying more than two columns
Can I do this with a query?
show the most recent payment
show the most recent payment
How many dates this week?
Report prob
Missing attendance records (Wizard won't help)
What makes a query updateable?
multiiple iif statements in a report query
Find Duplicate Record
counting Null fields
Field in Expression Displays Decimal Error (Access 2002)
Ranking records
grouping quarters
What will happen to this newsgroup?
Calendar Date
moving acces db to sharepoint
A query to show list between two number range.
Week Numbers
Effective date query
tracking iterations of different training classes
using CASE in access
Converting numeric state postal code to 2 digit text
Parameter query prompts twice
Is it possible to find the most common occurance/frequency of a field entry
I can not connect a document to an access prompt query (e.g. includes [What date was it booked?])
open and run access query in excel
SQL or maybe a hardware issue for finding lowest Repair order date or mileage
Filling query parameters from different forms without VB
Query Not Displaying All Main Table Records
form needed request
spreadsheet
Combine text values from many records into a single textbox
union query problem
query relelated to 2 combo boxes
Query help - creating chart
set value of txtbox in form = select query
How do I determine if the Form Header has focus in a continuous form?
Delete query problem
Need Monday date for given week number
Access displaying HTML
End with...
Export Query to Text without delimiters
editing a table thru a form
Assistance with calling UDF from a query
Group my month and then total each location - query
if statement with two conditions
Counting records in a table
Need help with a complex data set
excluding records based on a table
SQL view
Missing records on a CrossTab
Query for Export
Query needed pls urgent
Max Date in a query whilst showing all fields
very interesting query
Trying to query off of a table field name
needed SQL queries
sql required- in
linked table using SQL Query
Error using append from linked text file
One Field splits to four fields
Find fields with only numbers in Text formatted column
Find and Replace
Count Query Over Multiple Fields
open a database from another database
Re: Select / Append Query
SQL query
query sql needed
query
Calculate Difference between 2 tables Plus/Minus 10%
sql query needed urgent
Simple hack to get $1000 to your home
Using CheckSums to insure data integrity
Adding a query result to a form in Access 2007
Showing Records from one Table that do not appear in a query from another..
SQL or maybe a hardware issue for finding lowest Repair order date or mileage
IIF function, multiple IIF
HELP! - Date Issues
Unable to append due to key violations
setting warnings
#Error when dividing by zero
iif statement within query
RE: Using a combo box to determine which field to search.
Like Criteria Question using a control from a Form
in access, if then statement
Function of colon between table names when query in design view
Add character to string
Re: How to set the parameter query for this case?
Complex query
Dsum Problem with date criteria
FILTER
complex query to pull unique values
Use of Parntheses in Expressions
calculating average days
Serious Problem with Access 2010 "Query to complex"
Multiple tables search
Sum and DateDiff
Print Order Sort - 3 sections per page - to be cut and stacked
Optimization of Between Clause Queries
A field (string) is into other field (string)
Querying for most recent value
AVG BETWEEN DAYS
Looping through data with calculations
DatePart
How to calculate days due?
Forcing an ambiguous outer join
JOIN Query very slow
create a form that collects parameters
Total by certain time period
Re: Pulling specific data from table field
Switch Last Name First Name to First Name Last Name
RE: Pulling specific data from table field
Maybe Update Query?
Storing time as integers
COUNT number of times text in records
querying unrelated tables
Default Dates
How can I query a set of dates but exclude non-working days?
Multiple Queries to Multiple Reports
duplicate results in query
Conditional query/report
Changing constants in a query to user input values
2007 Concatenation problems
Delete Query not Working
Re: SQL Update question
RE: deduct order quantity from credit limit
Last record/entry from a table
Calculated field question
Free Live Voice and Video Chat!Connect with Over 4 Million Membersdownload now
convert currency to string
PLAY CAR RACE GAMES
Inventory Loop
Average time with a single entry
Union Query and Field Alias
Queries
Parameter query with and multiple "NOT / OR" selection criteria
Query Running Balance
Allen Browne's Has the Rcd been Printed - Taking it further
Re: Combo Box Query Help
Query on a subform
Please help with access expression
Select Top with aggregate function
Random Function for Selecting Records
Delete records from second table
Dropdown choice eliminated from selections
Assign batch # to rcds so report can be recreated.
Count Yes/No for three fields in one column
Very difficult query (?)
Using check boxes to select criteria to run query
Joining 3 Queries That Count
Next to Last Date
Help on muliple table queries
Update Query with Parameter
Query SQL Syntax
two level make table query and sorting???
adding new columns
Change colour of a field
Translate if statement in query
Currency Format Lost in Union Query
version
IF ISNUMBER FIND in query design expression
unique records Access 2003
RE: Change colour of a field
min query
Joins on NULL Date values
A Great Big Thank You!
Blank Fields in NOT Null Query Criteria
Access 2K2: making numbers up in a query sum
RE: Joins on NULL Date values
Retrieve all record if check box = 0 (Not checked)
How to Union Crosstabs...
RE: Translate if statement in query
RE: Translate if statement in query
Parameter Query Using Combo Box
How to use txtboxes and Combo boxes in a form
RE: unique records Access 2003
Parameter Error for Year 2010
RE: Retrieve all record if check box = 0 (Not checked)
aggregate calculation works in select query but not an update quer
Single Query for Top 10 of Multiple Items
Criteria to return all records if selection from form is null
First and Last Problem
union query without "blank" recordsl
Shift several columns in table
Re: The Microsoft Jet database engine does not recognise...
Convert string value to numeric value
How to find text that is surrounded by a wild card, specificly an
Merging Query results into Word document
Parameter queries that allow users to choose items from a list
Parameter in Union Query
Merging query fields into Word document
Union Query with two crosstabs
Trying to Siplify a Query in MS Access 2003
getertete
Re: Report
Extracting from Crosstab query
adding a Carriage Return or Line Feed character to an update query
parameter for text
Query based on multiple parameters - Access 2003
Syntax error in CREATE TABLE statement. (Error 3290)
Re: Search Tables
Re: Search Tables
MS Access 2007 Query Separating Info into months columns
Crosstab query totals
Coditional IIf with an AND/OR statement
Sorted and Unique Date Period
append crosstabs
Query Setup with Two Tables
Access 2003
Re: Export to Text Files Based on Field Value
Need help with concatenation function
Append from 1 table to 2 tables
Total - Total Fields in a Totals Query
Punch time query to calculate total work time
Help with small result type
Re: Querying 2 field unless duplicated
Past Due Expression
Crosstab queries, <> and null values
#Error
RE: Querying 2 field unless duplicated
Re: Obtaining the correct results from a two table query
#Error for False
Multiple Totals Columns in a Pivot Table
Left join in query
Access 2007 - append query only appending 0 rows???
delete query
Re: delete files
Union Query Access 2007 SP2 MSO
Calculating Elapsed Time
count qry
Week starts on Friday
Parameter Query No Results - Needs to Auto Create Record
Re: Obtaining the correct results from a two table query
Access 2003: Select Next Item in Combobox
Extract Specific Data
Mid string null value
in access, round up to nearest fraction(.5)
Concatenate Text Fields to Date Field
Word merged with Access
SQL server backend
Re: 90 days and the first of the month
Can't see existing table in Design view for a QBE
Query on SQL Server is fast, while Access is crawling
Facial Deformity Syndrome
insert into
How to retrieve dates that meets a criteria using Query? Exp Build
Help with expression builder in a Query to retrieve wanted dates
RE: Cumulative totals
Help with expression builder in a select Query
Access 2007 Append Query – Issue with automatically inserted brack
RE: No data returned from query
Re: Cumulative totals
Use Schedule Task to run Updates, but bypass User-Level Security
Min/Max Dates and Group By
Concatenate fields without duplicating data
How do I increase the size of my Query
why my parameter query doesn't work?
Re: Convert text to Combo
Re: Books & Otehr Sources
Re: crosstab
Averaging Hourly Data
UPDATE records by copying from same table?
return record if 5th character is a letter
Importing MS Office Excel Comma Separated Values Files into a MSAccess 2003 database
Multiple criteria IIF function help
Slow Join
Query result shows all fields
Determining EVERY month between 2 given dates
Flag a value in a group...
Sum using totals
Filtering for fields with character
Emailing a form created from a query
Access 2007: Need more info on 'concatenante fields'
Importing MS Office Excel Comma Separated Values Files into a MSAccess 2003 database
Find Duplicates Query Wizard Question
Limiting Records in an Update Query
SELECT DISTINCT query
Date Question...
criteria on form
What does this query error message mean: Cannot open database ".
Query to group similar number combinations?
Using TOP function
Query using multiple values from one text box
SQL subsets
Help with query calculation
Show only most recent record record
Friday's Due Date
Re: Tricky Accounting query - and not sure how to build it
Popup Calender
Lag 1 day relationship
filter
First function returning min
RE: Query null value problem
Multiple indexes on same fields in different order
REMOVING LEADING ZERO
IIF function help in query
Query from day of week
FROM and JOIN Problems
Re: Is there anything wrong with the syntax
If Statements (Nested??)
filtering data
Problem with query
Group By or MAX Question
Query and date selection
Show only this year
Query results where gaps exist Min & Max do not work
RE: Append only new records/entire record makes unique identifier
Calculated field
The not "Max" records
Re: Query Join - Outer Join?
aggregate query
Query, linked tables
Has Hierarchy the Parameter between years?
Crosstab column data count
RelationShips Queries and joins
Join on a calculated field
Daily Make Table Query
Delete Query Help
minimize repeating query criteria & generating monthly YTD totals
Ranking based on Multiple Data Fields
How can I refresh the master form from a subform?
Max Query
Query Join - Outer Join?
address in one line