Microsoft Access Queries [Archive] - Page 9

Re: Count of fields in Database
Re: Postcode group counting in query
Query returns unwanted blank records
OT my test
If statment that looks at table for result
select only one checkbox
RE: Count of fields in Database
SQL Top 3 - More than 3 records shows even if ORDER BY primary key
Exported query Runs forever, creates huge spreadsheet with no data.
Re: Strange Cumulative in Query Results
Concatenate multiple records in query
Calculations in an Inventory data Base
Need Query Help
Send multiple emails based on employee using Microsoft Access 2007and Outlook
Query Run Time
Default Query Criteria
RE: Postcode group counting in query
Query Column Reserved Word
Equivalent of Mod function in Access
SQL SUM TOTAL Date Range Issue
RE: Using Nz in inventory running balance
outer joins using one table
How can you start a business with no investment?
Running Access from a CD/DVD
Converting a query to a WHERE condition
include either OR or AND in SQL statement
User defined field
RE: Last date
delete query that deletes data in multiple tables
Query criteria from a previous query
Suppressing warning messages from MakeTable query
Cross Tab Query with Calcuation & Dates Grouped by Quarter-Year
Cross Tab Query with Calcuation & Dates Grouped by Quarter-Year
Can't use a calculated field in the same SQL code's WHERE clause
Look up fields in table & DLookup
Re: Calculating the success rate
Sum(1)
Date Format
Counting different selections in query
Left-Right Functions?
Re: working out the percentile
IIF, but Case Sensitive
Re: working out the percentile
Calculated value does not show up in Query
Access Query -doesn't show calculated value
Re: Calculating the success rate
HELP WITH QUERY EXPRESSION
Re: Calculating the success rate
display part of a field
Date Value for a table
Left Function?
How to Pass Microsoft certification easily with hign scores?
summarize a table by concatenate a text field
RE: pivot table % calculation error
To Many Cross Tab Headers
Rounding to the Left of the Decimal
Error 3075 with Insert Into Statement.
query using datediff to calculate time in years and months
RE:Leap year.
Specified Expression/Aggreagate Function
Specified Expression/Aggregate Funciton error
Conditional Criteria
Date Question
Search Text for words
Age Group Value
Update a value in a query
How to filter on calculated dates
Unwanted Prompts
crosstab query with parameter query
URGENT!~*****First Match*****~URGENT!
Re: median function problem
Union Query to list duplicates
How to query this?
can someone take a look at this query for me? thanks.
How to query this?
Function, array, query What do I need?
Parameter that can also give all records
Why is this query not updatable?
Create new records based on a date
Trying to build a data input form that appends new entries to data
Creating new data based on date
Copy first letter from one field to another in real time
Calucation in query
Iif statement
Re-numbering of rows, after filtering data out
Calculating weeks
Re: Debugging aggregate function message
Delete Duplicates with a Delete Query
average
Re: Calculating the difference
Re: Calculating the difference
Problems with the Criteria field
Key violations on Append query - no indexes on table
Dsum Problem
select query --limiting results
i want to compare two tables and find duplicates
Form/Subform “value isn't valid”
Trying to create calculation based on a grouping of categories
Display decimals on query
Query using several of the same tables
Calculating the difference between two dates and times
Making four queries into one
Alternative to group by
Re: Creating a quarterly report from a query
Need a list of value no aggregate data
change query def
removing records that look like duplicates but aren't
rearrange data - kind of pivot table
Re: Help with DateSerial
Fixed column headings - using the IN predicate
Query fails to eliminate duplicate information
Re: Help with DateSerial
How can I make a crosstab without using an aggregate function
IIF function help...
Criteria, DLookup, and IIF
Query will only show data for first record
Update Query Error "Key Violations"
Query a table's particular column and return the field name.
Query a table's particular column and return the field name.
Pivot Table hide detail Option suppression
Can't query DateDiff
Can't query DateDiff
One to many Relationship in one record
how can I merge with an Access query in word 2003
Inconsistant query results
Update Query, 2007 - Not Working?
Update Query, 2007 - Not Working??
Resend Again - Define Correct Criteria (I can't see the responses
Exception - (duplicate entry that are not matching)
MS Access 2003 Record Filter Problem
Resend - Define Correct Criteria
changing the syntax of an SQL Select statement to appease VBA
Re: Query not finding combo box parameter
RE: Query not finding combo box parameter
Define Correct Criteria
Left 2 text digits of alphanumeric number
More than one criteria value in a query
Combo Boxes
Somar valores que estejam registrados com a ultima data
Query with tables joined by GUID
RE: Disappearing Queries
RE: Reverse TOP query
Deleting Duplicate Records in a Query
Multiple Listings to Single Line
Queries - Assistance
Simple Criteria Help
Criteria using Like
query to get max year
PLEASE HELP!!!
Flag Dupplicate Records
Pivot Table View
Format SQL Queries
formula to return a max value across fields?
Weird characters in query results
RE: formatting by week number
Update or append query?
Parametric searches with DateDiff
Summarize Answers via a Query
select query row empty if value zero/null
How to count same value as 1 in a query
How to fix spaces between last name comma first name
System Resource Exceeded
Access and Excel 2007 - 65000 rows limitation trouble
Run-time error'3464'
Memo Field Truncation
Simple Counting Query Question... But it's killing me.
Delete Query using another table as criteria
Query shows only one record
Novice needing help
Passthrough query
String instead of count number
Delete Record
Crosstab Query Calculation
Calculation in Crosstab Query
Union Query
How do I get Access to append the exact amount with decimals?
Condition and equation problems
Insert Data in One Table from Another Table
Query failing to pull results
Database based on runtime during day or speedup dlookup
Filter based on OptionBoxes
Enumerate the Days (all the days) Between Two Dates (?)
Challenging analysis inquiry...
Why has my query become read-only?
RE: query
No records...query help
Having trouble with some sql
Re: Update Query to Overwrite Old Data Automatically
transforming rows and columns
Simple select query question
jump to specific table
error 3341 message when trying to create new record
modify value from select quey on the fly
Side of the block string op
RE: Query results into a graph
How do I limit criteria to a combo box in an Access Query?
How do I insert, display, and print thumbnails in Access 2007?
entering new alias for table in query causes Access to close.
Re: update query - key violation error
Search substring in a string
Re: Date Query
Simple Qry with 2 crosstab query
Using of sql server for back end database
Concatenate text field in a report
Convert Oracle function INSTRC in MS ACCESS or SQL Server
Finding records with a "/" character in a field
Fields with exact number of spaces so spaces show in txt file
Query to Word 2003
Adding 6 records with an append query.
query date criteria
Specific Date usung a Where clause
records that are in one table but do not have matches in another t
Like IIf statement that needs results to work with even getting bl
query without blank records
Using date to specify field name to use
Calculating the cumulative totals for an ending result
Difficult query
Add records via query in a one-to-may relationship
How do I get a derrived point to have 2 decimals and rounded?
Problem Adding a field based on expression
Help - Query merge to a Word doc
Query Results in One Line
error# in field
RE: selecting correct records using calculation
Sum Elapsed time
Question on Iff Statement
What expression to use to get multible results
link queries
Crosstab query access 2000
One-to-Many join act as a One-to-One join
Queries and/or Parameter
Query To Rank Products
Query - Highest Date
Decimal Field's Precision Too Small to accept the numeric you ...
Query - pull past 12 months
Cross Tab Quary
Group and Count
MAX Query
Query hangs
Group By String concatenation
Problem with displaying query as a 2D grid
Re: Date Query
HELP ME IN EXPRESSION IN QUERY
Add constraint returns syntax error on constrain clause
3075: Syntax error (missing operator) in query expression.
About null...
query column headings
Two company names merged
Crosstab Query Issue
How to query this?
Re: Inserting yesterdays data automatically?
Query using time
Access 2003 query question
Two Date Fields
Access Sum in Query
Droping constraint
Exclusion Query problem?
date range criteria for SQL server link table
Sum of time
Coordinates: points within odd-shaped fields
Query printing with different column headers
Date wise Inventory Result
Export Subform Results to Excel
Conditionally Selecting Column Unique Data
Conditionally Selecting Column Unique Data
creating a crosstab query
Help with Repeating Records
Sequentially number a query
CASE statement in query
Update query - fill in null field with value from record above
Using form to fill in query criteria not working
Enter Parameter Value .WHY?
Why only 9 "Or" statements in a qry? How can I add more OR stateme
Multiple Selection Criterial Query some with NULL fields
Partial Matching of Fields
Date format
Use of SQL SET command to create file alias
Confused on needing If Statement or Trim or WHERE
Help with formatting a query
access database query
Mailmerge displays primary key rather than text
SQL query help needed I think
Calculate # of Hiolidays within a Date Range
DateAdd Function for and ENTIRE Month
Unable to set query parameter
Select Query to create a Total field
Show records where ALL fields associated w/ one ID are not null
What's wrong with my formula?
counting within a record
finding a range based on a value, from 2 separate queries
Multiple Records - Need Max of one Field and Corresponding of Anot
RE: Group dates in query
Dcount between Date Range
Case Insensitivity
Need Help with Formula Expansion
Query to return field names from table
Advanced Calculated Queries
Error: Must use updatetable query
Ranking records
Concatenate column in rows into one string
DupliciteRecords
Re: Combining dates from two tables in one column
text to currency
Re: Summing numbers after a specific date
Converting numerical value to text
Re: query returns null..please help...
Help with Top N query
Update or Append Query in Access 2003
Converting an integer to hours in a query
Query working with number, not name
Selecting latest revision but with criteria...
#Error in Query - but not a div by 0 - so what is it?
Making a query that isolates records with the latest date
append query and delet query
Query with <> not working
Splitting a field
perctage on a query and Pivot Chart View
Join in query with leading zero
Compare two dates and use the earlier date
IIf statement in Query
Create a record where one doesn't exist
Query the brings only 0 value
How can a querie make a record in a table
query based on date ?
Format() function in Access 2003
Expression
Re: Monthly Totals SQL
I am trying to write a small query which will remove the duplicate
Join Or IFF Statement?
....not a valid name error when using ODBC connection between msac
Creating a query with one to many all on one line
Painfully Slow Query
Iif statements that return a value from a list box
Data from Form Text Box comes up blank
Text to Date conversion
SQL PROGRAMMING - LEFT OUTER JOIN
Why do I get this prompt?
Re: help tweak this rank query please!!!!!!
queries to scrub for contract prices and then compare to existing
Get latest date for each task record
Duplicate values from Combo box criteria
Dates in a memo field
Datediff semi-annual periods
Expressions and fields
Cycle Time Calculation Returns Blank
Queries and Date Fields
Extract portion of field
Include first 3 characters in results
Delete sub query problems
3035 Exceeded System Resources - Query Too Complex
Add data from field to table, from a variable field in form
Get names from previous date
Force Percentage Form
Error when calling function from query
No Current Record Query Error
Date() in query has suddenly stopped working
Help Display The Minimun value
How refer to combo box column in query?
How to average values from multiple tables in a query
Query with autonumber
RE: Update Checkbox problem
Custom Format for crosstab headings
Format of Column Headings Crosstab
UNION and Crosstab query
RE: Returning too many results
Trim Name?
Parameter in Qry
Queries incorporating check box
How do I set criteria to show only Yes cases using a Y/N field?
Strange Problem with form buttons
Impossible Query?
Two Table Query
IIf function question
Combo Box Question
Access #Error in calculated field
net working days in access
Limitation on ORs in Query
Crosstab guery from multitables
Sum and Join
Add values between input dates
Re: Applying a filter based on a previous selection
Segregarting results of a join into two fields
Strange query behavior
To make a query from two independent tables
2 queries with link table
query index
Ranking non-numerical query results
Reporting and Counting Unique Records
Result from Multiple Fields
Query returns no records when "WHERE" is included when I use IIF &
Query runs in designer fails at runtime
what is the criteria to look up more than 1 Value in a field
User total calculating query
compare data and filter unique
criteria
Display a number field to appear as names in another field
ACCESS 2007-Parameter Query selecting previous records
Access 2003 Append query hangs
Need additional fields for every fifth report?
Writing a query using VBA - Variable where clause
Re: "SUB LOOK-UP" within 1 Query ???
macking field from table usein query, requierd when record in que
RE: count
Re: how do i run/execute query it in vbs script?
Format undefined
Multi-valued field
Need help with running Query against Sharepoint Lists
Rows to Columns
RE: count
Select records with similar data
date control functions
create queries
Frequent Data in Tables
sort a table uniquely
last date attended query
Better "Join" vs "Where" clause?
Select Query Access 2003 listing by initial
10% Random Inventory
Erisson FREE Laptop
Query to Count Duplicate Values in a Given Date Range
Filter Query
Subquery for missing items asking for date multiple times
criteria
Need help for a query
Syntax error 3075 in VBA/SQL involving two LEFT JOINS
Network Days
Change Query on datasheet
query question
Append Queries
Re: How to pull records from a main form AND sub forms within Tabs
RE: Function Help
Delete by number of months old
Function Help
How to retrieve, re have, deleted photos?
RE: how to INSERT unmatch query
********************** Action Query Assistance ****************
Re: turning off action query confirmation dialogs?
RE: Need help using values from separate records to calculate interval
RE: cross checking 2 tables
Check if a Table exists
cross checking 2 tables
Need help using values from separate records to calculate interval
RE: Simple Count Query
refresh an imported table without destroying relationships
Re: Simple Count Query
Exporting to Excel
Comparing date ranges
Re: Date Query
Query based on Check boxes
join keeps cascading
Strange query behavior
SELECT/UNION query not working
Break table up into multiple tables by row count?
Update random values from field
averaging across columns
Subdatasheet comes and goes
Query that picks different column from a table based on the inp va
RE: Query Table Name
Telephone number format in Query
Pls need help with update query
Query Table Name
RE: how do delete duplicate account
RE: error problem
update query
Como calcular a diferença em meses entre 2 datas ?
RE: Date Query
how do i pass value from form to query parameter when opening report
Re: error problem
Update HyperlinkAddress through Update-Queries
Re: how do delete duplicate account
splitting a field
Re: Supress warning message in Append Query
How do I calculate age to a specific date in the future, in Access
RE: quey help please
Re: quey help please
Re: Leading zeros
Message box popup
Re: Leading zeros
Trim value to millions place
Find question marks -- need escape character
Find question marks -- need escape character
Finding Differnces in Two Tables
RE: Date Query
RE: Date Query
How do I delete the data in a field
Using Month only in criteria
One parameter query for multiple fields?
Delete QRY
simplifying a query with SQL
Run a Query to Run a set of queries
Update with Max date
Updating Order# in an access form
Re: append EOY date based on current year
Criteria for Max date
Re: append EOY date based on current year
Time Calculations
Time/Date
Please Help with Query - I am Almost There!!!
How to ter FQDN given the IP Address
Select Unique Records
Help with Query syntax
Re: Access Query - Query Help Is Greatly Appreciated!!!!
Count Query OnClose of Form
iff Fuction question
Access Query - Query Help Is Greatly Appreciated!!!!
How do I get file names from Hyperlink string in Access
not "cl" ?
Calculations
Re: Query Group by Problem
Query Group by Problem
Re: Advice needed on an append query
How to make query non-updatable
Re: delete duplicates "specify the table containing the records you want to delete"
Select End of Month records
RE: count again please help... im stuck on it
Union Query requesting parameter
Re: Change Query Caption
Dcoumenting your SQL code?
Division Question
Query showing duplicate values
Select Query with an IIf
RE: Update Query
Can't edit most queries
Append query
Automating a report that is based on a query
Query Parameter Function
Append: Duplicate Output Destination error
Access Append Query
Query from a list of choices
Can I choose the columns queried from a form?
User Defined Query
Could refer to more than one table
TOTAL COLUMNS
Re: Current Month Total and Commulative Total
how to resolve a parameter conflict with unmatched records query?
RE: Query Problem...
Re: Query Result is Repeating The Records????????
DIsplay order change (up/downP select box)
DSum
Re: Query doesn't return the same result in code
Date to show only the month
Update Query doesn't work (Access replies with several messages)
Dates in a query
Destination Field?
Re: What Is CrossTab Query?
item Max SQL help
Syntax for IIf Len
Query to see only first several records
Grouped Records (Duplicate)
Query returns incomplete results
is there such a thing as a fast pivot table? (CAN they byoptimized???)
Figuring out what field is causing key violation on append
RE: Combining Records and Summing Data
Re: Combining Records and Summing Data
ACCESS query expression that works on one computer but not another
Multiple Donations - Mail Merge
running balance
Re: Need Help for a Query.....
using lookup values with query prompts
RE: get the total employee per position by entering the start and end
help with subselect
Re: survey count
Combining Tables
Update Query not posting
Please Help with Adding to field????
query
Re: survey count
%USERPROFILE% in Command line
which customers have no transactions in the last year
Querie based on two sets of criteria
complex sorting query
how convert Date-Time to Date only
Appending Records Using DMAX
Multivalue field and exporting to Excel
Update Query returning zero for a calculated 'update to'
Calculate usage without loops
"Too many fields defined" Error 3190
Prompt for table in append query
Help needed on zero filling the left and middle and concatenate
Can criteria be simplified?
IIf statement help
la visita de san juan del dinero
Message box when query finished
Main/Sub Form Exports to Excel??
mergemail query
RE: selective Next test Date ?
Counting UK Post Code
Order By using Choose not working
a query to search time and date
65 character limit on crosstab headers?
Check previous record when promote
Modules
ANSI-92 SQL Vs the Access default of ANSI-89
Access 2003 on Terminal Server 2008
Running a macro from within a database
Query based on multiple Tables
Access 2007 - Need YTD AND Monthly Info From Query
Query to compare multiple Tables
Query current fiscal year
return data right justified
Update Query
Query pull based on percents
SQL help - Join Problem?
item does not exist in database
CREATE TABLE...
ORDER BY using value from a text box within a form
begin with letter only
an expression
What If
Null values returned by count
Sub Query Problem
Re: number and date field
Need Help With SQL Query
Need help writing a query
Total Criteria when you get three results using First and Last
Re: Query Help Please.
Re: Joint conditions
Help with If Statement
RE: Query Help Please.
Re: Joint conditions
Re: Joint conditions
Joint conditions
Query Help Please.
Re: Tardyscans query
RE: Tardyscans query
IIF statement in query calculated field
Re: Tardyscans query
RE: count distinct
Help with a logical/calcuation query
Any way to automate set intersection discovery?
Table names in query fields
Sharing a common fields
Using automation to load a cross tab query to Excel
Problem with Update query
running sum
Supress Printing of pages within a report
Limit recordset to top 1 per group
Dividing 2 columns from selcetion queries
Invalid Parameters
Converting Access 2000
Yes or No
Want to place a prompt on a field created by using DateAdd
Access & Excel 2007 - Help Needed
Picking up last record
Count totals, yet do not count duplicates
Hardware for Fast Queries
Access 2003 query criteria issue....
Top 10 records for each ID
Re: Sum by different Group
Using a Table as Lookup
Multiple search Criteria
compute, assign and total values in a query?
Help with changing the format of a text date?
Protect Queries
IIf Statement problem
Query Error Based on Crosstab Query
SPECIFIC NO OF RECORDS
Re: Need Help With Determining Age
Append Query - Every 7 days
IN in query
Want the week number of a given date
Update problem
Filter by date in query
system resource exceeds
Erisson FREE Laptop
How to use a function to specify contents for "In" criteria?
Multiple values for Insert Into
Re: Access WildCard for Date
Re: subquery
Re: subquery
query filter for end of current month
Need Accurate Amount Due
Need to sum with empty values
number in criteria changing to text
Previous record in an expression
matching records
what is the proper syntax in a qbe grid to find a "?" in a field?
DROP LETTER
Problem editing queries
Min/Max Dates
Re: problems on insert statement
Extracting Data by time
Extracting data based on time
cascading list boxes for query
creating a query from two tables
CrossTab Query count with grouping
double data??
Queries 2007 vs 2003
Select Earliest Date Entered if Date Field Null
Select Earliest Date Entered if Date Field is Null
Select First Date Entered if Date Field Is Null
Select Next Earliest Date if Date Field Null
Min/Max Date between 2 diff years?
Min/Max Dates
Min/Max Date only sorting by months?
Min/Max Dates only looking at month?
How to extract records matching a list of strings?
Querying by multiple dates
Paramater text searches
append to multiple linked tables
appending to multiple linked tables
appending to multiple linked tables
Parameter search in a text field
Business Days / Work Days only / Date Math
query that brings a autonumber field
query that brings a autonumber field
query that brings a autonumber field
Extract data based on time
Show records even with NULL data? WHERE...IN?
Extracting Data based on time
Query to Parameter Query ?
Counting Subquery Syntax
Counting Subquery Syntax
How can I get a data and auto-number field to link?
How can I get a data and auto-number field to link?
How can I get a data and auto-number field to link?
vba code for a query
Removing Leading 0
Removing leading 0s
Character length
character length
Group by date on employeeID
Re: GETTING DISTINCT ROWS
Date range return query
Re: Sum of 3 Tables
Ordering Text Fields with Multiple Decimal Points?
Math on this time: 2009/02/04-10:49:12.229510
query in access
Any hope of doing math on: 2009/02/04-10:49:12.229510 ?
2009/02/04-10:49:12.229510 Any hope of doing math?
Query won't for editing in design view in 2007
Nz or Iif
Re: Question on Query
AlphaNumeric Values
I need to display info from two different table into one query
query question
IIf Function with "Or"
IIf Function with "Or"
querying several times ???
IIf Function with "Or"
IIf Function with "Or"
IIf function with "or"
IIf function with "Or"
IIf with "Or"
Grouping Like Dates
vba code
Query for YTD Total
SELECT DISTINCT COUNT
RE: Query group by Product Name
Parameterized query in crosstrab