Microsoft Access Queries [Archive] - Page 3

Unable to join 3rd subquery in nested query
Query for a report
Re: Grand Total Time
Crosstab Query For Fiscal Year Totals
Remove redundant text
Creating duplicate rows
RE: Reformatting Field in Query in Access 2007
RE: Grand Total Time
Re: Grand Total Time
Erratic results from query criteria
Setting Fieldname in query with a combobox
left join not working
How do you create an autonumber column in a query?
commission
how to build expression with conditins and totals
Trim Time off Date
Grouping - Distinct
Query: Calculating
Add Fields to a query that are not included in an aggregate functi
In crosstab query, how do I count not including duplicates?
Crosstab By Date (Month)
RE: Multiple criteria in query causes errors in report
Re: Multiple criteria in query causes errors in report
access query question using not " "
queries using the not command with more than one item
simple syntax issue
pass through query
Invalid syntax in dlookup
Select two records then select the next two records
Sorting does not distinguish between Œ and OE or Æ and AE
List Macro Actions
AutoNumber Field Not Populating with Append Query
Format Currency field into zero filled text field
Compare and fill from table 2 to table 1.
Best way to set up Query to get a percentage
Query to get information that doesn't match by date
New to If statements
NOT IN (SQL) or Find Unmatched (+ other stuff)
RE: SomeHelpWithSubform
Difference between fields in query
append queries records with multivalue fields
RE: Need help with query summing hours
View Most Current
Re: query to locate which record was not added
Custom Form Property, Parameter Query Access 2007 Problem
update query to remove parenthesis
Update Query and Too Many Rows
wildcard symbols around a field in a join?
RE: dcount
Re: dcount
update query based on two fields
unstable query
Query Trouble
RE: Anyway to join between two different data types?
Re: Anyway to join between two different data types?
Subquery group by
Linked Table - Query Table List Missing Fields?
Only where a specific feild is unique.
RE: Access function containing the wrong number of arguments
secure my access problem, Importing the Database.
Append query with username and date
MAX function is not picking right date in ms access
key?
Count items in percent ranges
Dinamic Naming in Design Grid or SQL
Expression typed incorrect or too complicated
Commenting in SQL
Outlook 2007 and problems with RSS Feeds
Pivot Table rounding
Help with a subquery
Return multiple records from a single entry.
how to convert lookup values to the "display text"
Counting Table (By Date)
Comparing queries
Group By, Max & Last
Filter asterisks from a field
Query Criteria
Calculate percent return for different stocks
Two different queries return same results
Help: I have difficulties in Update Where Exists
How do I copy one table to another.
Access 2007-Update Query
Only Once
Using saved query for different tables
Re: Data type mismatch error --> text to date
Chinese letters in a Query
Exclude afield when using 'Select *'
How can I find out who is in the Database?
mail merge with Word and Access Query
Date comparison in IIF statement in a query
3rd time posting this problem , still no solution
Re: Last records from a Group By query
Can I do this in a query?
Year to Date subquery
summarize data in access 2007
need to show current year and prior year totals
Help with complex query
RE: IIF statement pulling from wrong field
Same field name in two tables
Re: Trouble with Expression
how can I concatenate fields that contain numbers?
RE: Trouble with Expression
RE: Trouble with Expression
How to redisplay the text field based on a stored ID field
Struggling when there are no records
Query Results Where Qty Shipped is not Divisable by 4
Re: IIF statement, proper formula
Importing Excel data into Access?
LIKE function help needed in combobox in the form
IIf
Turning off action query confirmation messages
Do I need a subquery?
remove the database link
High light the controls
Crosstab Query - Recalculate totals after each date
Distinct count for each day
Sum up by cust w all details
Between Dates Criteria
RE: IIF statement
Re: IIF statement
Appending zero-length string
RE: Qry with dupes looking for only most recent date
Re: Qry with dupes looking for only most recent date
Help with computing date\Time between previous record
Help required in Update query
Relationship - Outer Join - Microsoft Access 2002
Use the Second Max Value in a Formula????
cross tab query
Query wont sort ?
SQL
Building a query from three tables with differing infomation
Setup of Design View
Listing out Budget, Actual and Forecast
Query producing different results each time it is run
Update date field to Is Null in an update query
2nd time posting this problem, pls help
Cant get Parameter Query to work even witht the help of Martin Gre
hepl to solve my problem
Concatenate multiple rows Into one Unique Identifier
Spliting First Middle and Last Name
Query to pull set criteria or all
Re: Another Len function not working
Sorting in select query. manually
RE: Another Len function not working
Help with a simple query
OLE object open problem
Grouping Data Fields
Tabbed Pages Not Refreshing
Update Link Tables from Excel
Modiify Records
complicate query?
Extract 5 digit number from a column
AT WITS END ON QUERY TOTAL
Re: Referencing a control on subform 1 from subform 3 causes access to crash
RE: TOTAL CALCULATION
Sort across a table
Error -1524
UNION question
Counting multiple field values in a single query/report
Calculate Average Returns Based on Dates?
'NOT IN' vs '<> ALL'
Split address field
Want to use Group By in union Query - solution
RE: Search for records with no matching foreign key
RE: Search for records with no matching foreign key
External db in sql FROM
even and odd numbers
If possible edit the data from query ?
Query return duplicate results
Using a parameter
SQL help needed please
RE: Need help with changing query
Not sure why!
Need Help with Geographical Sort
Access query with IIF statements is null for a field and not null
Update query with autonumber field
Not display information if criteria is not met
Display multiple pivot charts in several pages
too many fields defined
Multiple Commas
Re: Averages problem
combining queries into 1
Re: ranking players in a competition
Count Query
Multi User Application
Non-Recognition of a parameter
HOW 2 MAKE AN ALIAS?
Re: Convert Text to Date
Show all of one tbl and partial match from another tbl
Trying to create an Update query based on HR data to find upline V
Re: Averages problem
Use Table field in query criteria
Multiple Commas
Replace Co with Company
Query with Date Calculations
Revise an Append Query, or Change to an Update Query
Joining two tables
Data Mismatch with join
Access 2007: bug? quick filter list is sometimes empty
Recalc not working
Ten calendar harm one of the products
Updateable Query problem in Windows 7
Make query headings just contain field names?
Multiple Pivot Charts to display in one page
Update pass through query of report recordsource
Retain Field Format From Excel
Data mismatch error
I need to sum up some values in a column of a query
Calc Diff Date with ID - Karl Dewey
Values from multipule records in 1 record
Parameter Query
SPECIAL QUERY
GROUP BY???
Copying records from one (sub)form to another subform using Append
Time format different in the query than the original table
Date format in query export.
Opposite of Find Duplicates
Year(Date()) not working
RE: How can I avoid a cartesian result?
3 queries into 1
DateAdd Function
how do I extract pieces of data from a field
I cant create an MDE File
receipt
Grouping query
Prompting for a parameter in a query when one isnt present
report on a cross tab query
Code Check Request - Query to find reused values
Autonumber restarting after compact and repair
COMBINING QUERIES INTO 1
No results when adding 2nd table to query
Re: Filtering a sub-query (back-end is MS SQL)
COMBINING 2 QUERIES INTO 1
Too few paramters
Query Joins
union query
RE: Need to refine sort order
Query
Convert One Column Data to Multiple Columns Data
Re: Passing specific ComboBox info to a Query
Top 2 per Group
Querying using SQL statement
access report on a cross tab query
query very slow
Re: Comparing dates in columns from linked table
How to lock viewing Form Design.
Re: Comparing dates in columns from linked table
Avg. 1-month, 3-month, 6-month & 12-month Stock Returns
Need Min Value from Row and Heading Value that Corresponds to it.
Changing existing data in database to title case
Find Min Value in Row or Selected Cells
DLookUp
Re: Check for Values
Query behaving differently in VBA than when running as regular Que
group query
Creating a query out of another query
how do I put these 2 queries into 1 ??
Crystal Report SQL Conversion
Grouping/Deleting Dates/Times (HELP ANYONE!)
Subquery
Record with longest entry
RE: Date query
RE: Show a 0 if there is no record
I need to add data to a table from another table how do I acheive
Query to select from list
Insert Items from Yes/No CheckBox into Query
Re: Show a 0 if there is no record
New field in a query
Delete Query
Query two subforms from 3 combo boxes
Keeping 12 months of records
RE: Passing combobox selection to query
Nested Iif Formula Question
Compare (2) fields in (1) table
SELECT vs. ORDER BY - order of execution question
Access 2007 - Set default sort
query syntax or design question ...
Rank Query With Groups (Array?)
Case When statement in Access Frontend with Sql Backend
quick question
Select Query
Formatting fields....
Re: Storing Information From Queries?
Quick Query Problem
=Date() Problem
Calculating field for Previous Processing Day
Question On Join only if Left table Items Is Not Null
How can i Secure my project
query several fields
Find Duplicates within a string
Joining unrelated data in query
Query Question regarding IIf's
Overflow error on calculate field in query - Help Please
COUNTING QUERY FOR ITEMS PLS. HELP
Count or sum help on query
Re: last row or record
Specific filter for the data in a field
RE: last row or record
cursor changes to hand when focus on label
Sudden problem with functions in queries
One query to multiple databases
query syntax error
Busted IIf function
crosstab query column heading
sum for past tweleve months
column header needs '#' symbol
date confusion
Calculating or Adding Values that are 0
RE: Criteria to delete last 3 days of data
Criteria
Date calculation on 2 fields
Year query based on text
Combo box text clearance problem
Convert annual data to monthly
Need Result show in Message Box
Query Help
Chnage a value of a field in a query for a form only
Filter form using a textbox
Using a form instead of a parameter query.
HowTp Question:Append vs Update
Order of Operations in a Query
Returning only MAX(date) not all dates
Query results in datasheet with X grayed out
SQL Stored Procedure
Date question formula
Result in message box
How do I combine 2 tables?
Help needed with IIF in my query
Need to show result in message box
Re: Date Labels
Comparing data between two tables
SQL query
Adding Records to a table but preventing duplicates + other tests
default footnotes instead of endnotes in moving from text
How do I find which forms have a particular field which is blank?
Getting only the last transaction for each customer
Can run update query programmatically in windows 7
Comparing Amounts in prior years
Format data to columns
Max query results
How to close the result window with ESC
MESSAGE BOX DISPLAYS INPUT CHARACTERS
How to set password to open form
Query 1 of 3 exchange rates for specific date
Filtered Form Query
Return cost per date range
ODBC--Call failed.
Transfer Text
BETWEEN a rock AND a hard place
Access 2007 SQL Stmt returns the incorrect value ?
date calculation
how to set up a query to show only user based selections
USING PARAMETERS IN A CROSSTAB QUERY
want show result in spread sheet, in the form
If you buy the world's best and the cheapest batteries will not blame me
select user from ....
Delete Dups Query Failing
Need to show continuous time in the form
combining 2 expressions
fractional part of value returns multiple digits
Datediff
RE: Pass-Through Query Prompting for ID#
Query to text file cuts my leading zeros off.
Adding values in to table for appropriate fields only
Re: Pass-Through Query Prompting for ID#
09 R4I :COMPRAR
Re: Query - Crosstab ?
Query to Filter by Dates, Using Form
adding yes/no field
How to query for last data
Re: Nz function in query
Automatically adding a record
Best way to unduplicate records
Grouping/Deleting Dates/Times
calculating a percentage
Calculate Diff Date?
Count Number Of Employees for Month and Year historically
query export wont allow a zero value?
Splitting a table into smaller tables
Date ranges based on related table
Re: Updated fields query
Date calculation
Calculating Dates, PlEASE HELP! THANKS!
Calculating Dates
Add a record to a table using VBA
Replace third space with "-"
Linking Check Boxes or List Box to Query
Expression Builder query with zero amounts
Running Sum
RE: Display calculated time in Months and Days
IIF statement in query criteria, help!
Similar function needed to Excel VLOOKUP
SQL Solution Needed - Use Subquery to move groups of rows to columns
Calculating 0 value from static value
Re: why does this querry multiply the rows by 9
crosstab
Need to compare 2 tables and only pull certain records from one ta
All-Record criteria in a query...hmmm
not between operator not working
Multi-word string from one field to two fields
Calculated field to group numbers
1) Run query through a table and 2) keep (or throw away) records
Calculate buisness days rather than calendar days
Update fields based on concatenate
Converting dates to current dates to find out the evaluation date
Denormalize data into one single field (by query)
Re: Converting a 24hr format entry into 12hr format for display
Variables in select statement
querry LOC
automatically assign value to query
Main for with two subforms
How to Retrieve information from 2 tables in a single form
Re: Converting a 24hr format entry into 12hr format for display
Updateable querie
Query?? or something else?
SQL vs. VBA
Data appears mixed up when queries are performed.
RE: calculate headcount
Querying dates & times
RE: greatest value
Check box and make table query
Help with crosstab query
RE: greatest value
Re: greatest value
Counting the sum of related records for a primary record
IFF statement
Number records in a query
must have this and that
Ambiguous outer join
Nested views
Can not group on fields selected with '*'
Multiple Top Values
Separating Parent and Child Fields
If select ALL then show me all values?
Sorting misc text into new fields if data exists in record update
Rank question
Re: Crosstab query...
Greatest date per Unit
Alias question
Query input value to determine another field results
update two fields at once
Re: does a querry update a table
Rounding in Access and Exporting a File
FUNCTION PREDICTING EVEN/ODD COUNT IN QUERY
basage modular
Re: Date format
round to nearest 5
Merging data from a table and a query
Right-Align Field When Exporting to Text
Query File As
Re: MS Access Not Responding Make Table Qry
function based on value in another field
Update query
Set max to 3 to retrieve last 3 most recent dates
Need to be able to see the PROPERTIES of a query
How-to extract data in this format?
Query Not Returning Correct Amount of Records
Error Message
Query - How can you string to fields together
Basic Select Query Duplicating a single end user's records
Data Type Delimiters
Prevent showing duplicates based on a field
Help with query
Nested IIF Statement in a query
Group By Query
to view data of a customer from union query
getting max value
Append mail names based on whether 1 or two recipients and if marr
Inline comments in Access queries
jeramie bellmay
"IIf" formula, how to return a value of zero
Help with "IIf
parameter query needed
Adding Sequential numbers to a new feld in access table.
Re: frequency distribution and join
Replace using wildcards??
RE: MS Access Not Responding Make Table Qry
Re: Highlighting Updated Records
Re: Difference between sum and groupby in query time
Nulls making a mess!
Count in a Query
"The Microsoft Office Access database engine does not recognize...
Generating a field that is the difference between 2 dates (within
Deleting duplicate records
Date query
Query from Combo Box for Report
Muliple Critera
Query to pull most recent data
Re: Query Miscounting
Creating a sum to include a particular day plus the previous 7 days
Time calculation
Query SELECT in SELECT?
update a field by inputting data in a different table
Query with Multiple Criteria
Find xth occurrence of a specifiecd character in a string
Map fortnightly data to months - can it be done?
RE: Need the SUM TOTAL in Hours for Time Out-Time In
RE: Difference between sum and groupby in query time
Re: Difference between sum and groupby in query time
Query to create multipe total fields
changing data only after a certain date
create a single date column from seperate month, day and year colu
concatenating two vendor codes
"If" Statement help needed
Current Date in Query
query relationship text --> Number 18,6 type mismatch
How to subtract data in one chart from another chart in access?
creating a query that lists drawings of a part #
Append data / Prevent duplicates
multiple critera for one field in a query
Append Query help needed
Add character to end of string
Using Access Queries in Excel
System Resource Exceeded/Query Too Complex
Cross-tab to look like Calendar
select or dsum???
Re: Get Record Base on Selected Dates
Search Access DB using ASP and SQL
Why isn't this returning the quarter number?
Multi Value Insert Error
Problem When Sorting Query
How create ranking within subgroup
Searching for specific word in query
Null to reflect as zero
jeramie bellmay
"inter parameter value"
Access2000: Update query
Not receiving emails when responses posted
New record dosn't work?
Changing Query Filter for multiple Queries
This query runs on my pc but not on my laptop
IIF Expression returning Zero Records in Query
date/time field
MS ACCESS
How to auto create volume bands
Re: reference columns by number in queries
Re: Button on Form to Run Report based on Query with Parameters
date query without year
Re: Button on Form to Run Report based on Query with Parameters
Access 2007 calculation help
NOT expression in a Query
Between dates / Long date format
Error when using criteria to prompt for input
Finding and naming duplicates
Math problem in a function
Don't understand posted update query answers
Combine Two Queries in Different Layouts
append query for dates and hour
qryRandom
Variable as FieldName to populate a combobox
Sort syntax for multiplie IIF
Prior 3 Mo Avg Function
SQL help requested
Subquery help PLEASE! :P
MVPs out in force
Access date in 1 field and day in another
Combobox for criteria help
Re: Query to look for unused data
how to select any last record in the querry
multiple records from one
Another query too complex problem
Compare data that do not exactly match
How do I left justify a date
Queries with Linked Tables
SELECT Statement Question
Access 2000 Query very slow compared to SQL Query Analyzer
Setting a Month Criteria
Overflow
Duplicate Queries
too complex query
"if" statements
Formatting Help - Query Result for "Range"
RE: SQL select statement question
subtrscting 2 different columns from 2 tables
Re: nesting queries - best practice?
two null fields?
IIf statement
Duplicate Query
RE: making SQL the source for a report?
Search for a name with an apostrophe
mulltiple column "not in" query
trying to minimize Write Conflicts in a multi-user database
State abbreviation MI fails in query
Extract Data from a Field
Selectively Update Field in Table
Query structure and distinct
State abbreviation MI fails in query
I need to add the letter "Z" to the end of every contract ID
RE: Append current record to table
Re: Append current record to table
corresponding data query
Query Result Incorrect
Re: Append current record to table
RE: sql to create totals
Criteria to prompt for field and omit certain records
Tables in Access Queries overwritten??? :(
DATE HELP
Passing info into a text field when doing the update query
Select group number for distinct rows based on two columns
Re: Merge? Concatenate?
Query error, too few parameters
Multiple Query Report- Really Need HELP!
New Blank Query Shortcut
Re: Transform using DoCmd.RunSQL fails
Support for CASE statements in SQL
Display Query Results on top of a Form
Controlling a WHERE with a checkbox
Use Same Variable multiple times in a query with different criteri
can I generate report showing which tables are used in which queri
Query based on 2 parameter in 2 diff tables
Date Range - Between Start and End
Control Select Query Output Field Type
Re: Merge? Concatenate?
Re: Merge? Concatenate?
Re: Merge? Concatenate?
How to not include results starting with 99
Join on a UNION query
query comes up blank
SQL with IIF
SQL Statement Insert Into
Parameter Query multiple criteria help
Nested If help
Strip out seconds from a Datetime
Crosstab query error
IIF stmt in Criteria
Populate Table with Fields from Another Table?
Populate Table with Fields from Another Table
IIF Statement - Query Help Needed
How to Populate a Table based on Entries in Another
Re: Querying last months data
constant values
subquery help
multi record query
Help Totaling More Than One Entry
Query question.
RE: Query to list Company ID with Billing Period by number with date i
RE: Querying last months data
Re: List of records >10 days old
Update the values in a table from another table
Only Display records before and after a change in teh value of a f
Showing only records that are different from those preceding them.
It didn't sound difficult when I said I could do it...
Make-table issue
Please Help - Pivot Table Trouble
Unmatched Records
subquery help
List records that do not include specified value
How to ask user to criteria
how do I calculate time in access? ex: time in time out
Duplicate output destination
Unmatched records
Date Criteria
Re: update records
RE: Using DLookUp to find data
Enter Parametr Value
Microsoft Access "Classroom management database" question
Access a query without opening Access
IIF returning text value
Numbering....???
Formatting Result of Date AND Time Difference
Query for count of temperature ranges
Sequential Record Use?
Are the two queries doing the same thing?
Update field (multiple criteria and updates)
Re: Using DLookUp to find data
Help with a Monthly Report Design and Layout
Parameters
Parsing 1 field to 7 - divided by "/"
RE: Never Ending Query
Edit Update Query
query for current winning streak
Divide a a range of dates into intervals starting with the current date or the latest date in the range of dates
Remove Duplicate - Count Number of Unique Results
Using Pivot in other sheets with the raw data...
Len Function
Dividing across queries
Using If or Iif to determine a value
Re: Must use updatetable query - work around
RE: Must use updatetable query - work around
find the latest date in access 2007
Create a distinct Join
Subquery select field from previous record
Date in the query is always short date
Date in Access field is ########
Total line makes query too complex
Searching for a digit or letter only
Counting # of values in a group registration
Deleted information
Start Date/End Date require multiple entries.
Pivot Table Averages
Totals Won't Count Nulls
Ampersand in Query Criteria
IIf function, & Date(), & AND, & > & <
Update Date value to current year
Office 2007 - rename query problem
iif function syntax problem
Crosstab query question
It takes SO LONG TIME to open a query in design mode
Access query to get monthly and quarterly report
Link multiple excel files at one time
Group - Combine Consecutive Dates into a Date Range
One prompt for Four Queries
Query <3 years
query a table and subform
Please help. Question about querying a subform
Decile Ranking
Expression builder in a select query
Parameter Query Lookup
Multiple Table Search
Update Top N records in Access 2007?
Date query from datasheet in subform
Query for Single Field Value Where Another Field is at it's Max
report format
Selecting Distinct Records in union query/report
Date Calculation
Date Calculation
Joins and Query Speed
Group By, Max, many to many
Using Table to Select Records from Larger Table with Join
Is there a way to delete multiple queries at the same time?
Using date function with inline prompt
Update Query
Calculating a Date
Find the sum of similar entries
Max plus additional field
Filter Records not Begginning with Numberic Characters
Re: Calculating percentages of number of occurence of a text value
Splt a length record into multiple lengths
formula
How to link Crosstab Query to other query problem...
winning streak query
Queries
Update Query Problem
locating same text in multiple fields
How to concatenate remarks for a given purchase request
SelectCase statement
Query Needed
Error in IIf Expression
Re: Help with sql which counts records
Dcount or Dlookup
Group by month
Data values contain Parentheses (N) with String inside
MS Access Query
Concatenate same field records into one - FOLLOW UP
Query combining the tables
Convert to text
Pivot Table Questions
How do I use varibale field names
GANE DINERO VIENDO PUBLICIDAD
Concatenate same field records into one.