Microsoft Access Queries [Archive] - Page 7

Print sub form only
Re: Queries
Re: Date Subtraction in MSAccess
Re: Date Subtraction in MSAccess
RE: Report Gets #Name? on database launch
I need to include a field in a crosstab query just to sort
Updatw table with a given criteria
Querying across Multiple Databases
How do I move a record from one table to another in Access
Fixed Numbers
Help with Append Query
Re: Data Fur Report
Sorting data with query
Need Unique Entries From Across Tables
Date Query
How to get a running balance total
Is it possible for a query to blow up the database?
Calculate hours worked minus lunch
Re: Data Fur Report
Append Query, right or wrong way
Aggregate Query Question
IIF questions with < or > signs
summing hours in a query
Union Query by Month
Crosstab Query/Table Mystery
Need Help With Make Table Query
Pictures won't stay in form -Access 2003
I need to divide a query
RE: Data Fur Report
Looking for Existing Records
Set update query to reduce single field by user defined number
Re: Data Fur Report
Re: Data Fur Report
Re: update query
Union query, combine all 4 fields into 1 field
how to output Access table to a text document?
Random performances of same query??
Query Trouble
Compound Indices
Multiple IIF query
Re: Selection Box's ? Noob question ..... please help !
A form for selecting tables
DateDiff calculation
Calculation Error in Select Query
Re: change currency symbol
How to display an age in query based on Datediff expression in a f
Add Table Name as Field in an Append Query
DatePart function
Multi table query
how sum values with comma?
Output a user entered value
Conditional Count Column in Query
Re: Query to add totals
if else with insert update
Checkbox controlled criteria
Another case sensitive query
Grouping Periods Of Dates - Sequential and Non-Sequential
Case Sensitive Query
Query to retrieve top 2 of the Name & marks
Syntax error in append query
query which selects data at an intersection
Truncated Text
Moving records
YES /NO Query
function that returns the field name
Calculating days from last meeting held
update query on a JOIN Table with a query Not Work
Return records within whatever date range is entered on Form
Query with INNER Join
Subtracting timestamps
Multiple Unrelated Tables w/Similar Field in Single Query
Update table based on partial text in field
Sources for query parameters
Count person only 1 time and show person not counted
How to queryvery many conditions in VBA
My append Query does not work
Query Criteria for a Newbie
Query Criteria
ODBC -- update on a linked table [table name] failed
Pull Column 1 from a combo Box and display in a Query!
Question on Pass-through Query
Iif Statment
Duplicate values in Crosstab
Query for 1st field, if blank then query 2nd field but not both.
Can a report automatically update from a crosstab query?
Phantom multiple decimal places added when querying
Help on QBE to SQL
Insert Into Queries
In a query, show master records even if a child record doesn't exi
Running into error while writing Append Query
Append Records to ORACLE via ODBC
Data Type Mismatch even with CStr?
Unable to create a temporary table
Text field in Access query is blank
Date Criteria not working...
Re: query
Inner join with some null values
How to query a Dataset to Return Records that contain "a thing"
sql query migration
limit query to top 'n' records
How would I do this?
Using Access to Calculate YTD Percentages Using Geometric/DaisyChaining
Find character in a string
MS Access SQL Book Recommendation
Show Multiple Values on one row
Not Like Query
RE: Two Queries not getting along in another query
Multiple records
multiple OR criteria
Form to Query
Reserved Error (-1517) There is no message for this error
Dlookup a range with multiple criteria
Append query - Append to table with Autonumber field
How to calculate a Rolling Average
Only first few records visible in table after running append query
Problem with Null Queries
Write Query to Automatically Create Text File
Repost: SQL SELECT WHERE Problem
Unable to add record to another realted table
SQL SELECT WHERE Problem
Acess 2000 and Access 2003
Subqueries
Memo fields in a query
help in compile error
filter last five rows in a table using query builder in MS access
Trying to make a query that's based on a variable table name
Date Range Comparison
Pull latest date from Multiple entries
Trying to write an Append Query
Using a JOIN on Two Different SQL statements
Access 2002 Append Query Problems
Compound IIF Statement
Query comparing two fields in a table gives wrong results-why?
Addition to "Check SQL Please"
Time and Minimums
criteria for date field using iif()
IIF update query with Between Criteria
Access 2007 won't let me save a query
Check SQL please
Ambiguous Name Detected error
Inserting values in a database..
Help on Sum
Re: VS2008 : Error Using IIF in Select Query
Re: error
Removing excess spaces in data
Adding New records in multiple tables
Count
Total numbers by month
Union query - sort of
Link Tables
Serious Problem with a Date count fields & YES/No field
Auto Notification
MS Query Problem
Parameter
select latest records
Crosstab Query based on Query
how to return record with latest date
Search for number in memo field
Run query in another database
Previous Value Subquery not working as needed
bland fields
If value = true then make field = blank...
RE: Parameter issue
RE: Parameter issue
Why prompted for parameters multiple times?
Trying to grab only one Status
Query for Subform Needed Please
Crosstab Query based on Ordinal Values
Records Missing from Report
querying based on a form
Choice of Criteria
Pull records from 3 Years ago
Extracting keywords from a string
Count and assign
Re: VS2008 : Error Using IIF in Select Query
Re: VS2008 : Error Using IIF in Select Query
Re: query
projecting due dates
Re: Crosstab with more then one value
Adding to combo box
formula requires parameter in error
Query Too Complex But it is pretty simple.
Selecting the same field more than once
All of the sudden stopped working!!!
Query Help!
auto populate field when query run
freezing data at a certain date
Query question
How do a create a query to find non-duplicate values?
Update Query and Format issues
Every record is coming out twice on the query
iif statement and defining calculated expression once only
calculated currency field sorts like text instead of numeric
hide SOME query results for unauthorized users
How to do a rolling average on a query that asks for input
Query that make table in another database
Re: Active Form text box as criteria
Distinct Issue
SQL Statement to Combine Like Items and Sum Quantities
Crosstable filtering
Unmatched query help
Multiple conditions for selecting an entire row
Union Queries
retrieving duplicate records from multiple tables
Count in totals query
Year to date month/year
RE: Grouping age group within a query
passthrough to DB2 - specific records
RE: Parameter Query Text
Parameter Query Text
grouping data - possible crosstab
RE: Grouping age group within a query
Transpose rows to columns
Date/time query
Query between dates - help needed
SUM of a field in a query
Re: Else if statement
INSERT INTO Multivalue field
Record -1 year
Re: Normalize Help
average price
Count by user & month
Query taking too long to open
Re: Access Date and aggregation Query
Access Date and aggregation Query
Split data based on date & recombine automatically
Loan
Problem referring to a subform control from a query
update hyperlink values but not displayed text
RE: #ERROR question
Re: #ERROR question
Unmatched Columns
Re: #ERROR question
RE: Query for combo box returning no result
RE: #ERROR question
RE: IIf (maybe) this, else leave blank
RE: IIf (maybe) this, else leave blank
IIf (maybe) this, else leave blank
Can't edit my query
How to manage stock in a table from a subform
Help with counting in query
Query Line Numbering
using a form to create a table
Help with a query
Records missing from query/report
2 Databases in the same folder
Crosstab Query Header Fields (?)
Re: Month and Year only
Month and Year only
help !
ms access product function
Show data source in Union Select All Queries
dlookup !
Parameter in WHERE defaulting to All
RE: Creating a totals per row in query
Date update in append query
Sorting by month
No Records Deleted Message
running code from a macro
union query
RE: using a calculation in a query
Combo box automatic number propogation
using a calculation in a query
Selecting Fields From a Record
Checkboxes Option Group Questions
What's wrong with this query?!
Select Fields for Query
where clause
weight query
Need description instead of code to show
I need help on a query.
Truncate decimal
Referencing a Caculated Field in another Calculated Field
Help with TOP 10 query please
Option Group Message Box
Access Pass-through Query to SQL Server
in access 2002, using a "not" statement
help with SQL statement
Re: Record output in queries
Record output in queries
Iif Statement
If Statement
Sort date field by year (not day)
Simple way to combine unmatched and matched records in one query?
Missing data in report
Printing query
simple syntax question
Cross rabular query
Nested If in Query
Re: Is it possible to update a report, based on a crosstabquery?
RE: different parameters - same field
data comparison/update query
Re: different parameters - same field
RE: Get a Count of Columns with a value
Get a Count of Columns with a value
new to if statements
Unmatached in 1 Table
result rows go missing on sort A-Z
Unmatched in same(1) table
Query result to text field
Query only records with checked box
Joining different parts of the same table
comparing data
Null input returns all values using wildcards
Re: Null date parameters 2000
Null date parameters 2000
Trouble with concatenate code from Duane Hookum
Cross Tab Queries
Delete whole table with SQL and ADO
Re: Trming In MSaccess
RE: Trming In MSaccess
Re: Trming In MSaccess
View Memos
Filters not working?
Combining operators
Getting request that a query have a destination field
Form Closed
Form Closed
Form Closed
One query for report and Excel
set a payment date of 2nd of month
Re: Order by Asc or Desc a"Total Sum" in a Crosstabquery
Delete all but first
Update access table to sql table
date criteria or all
Create a query
Query to find "almost" duplicates
Total competitors points
Iff Question (Should be simple but I can't see to get it right!!)
>=[BeginDate] And <=[End Date]
UNION QUERIES
Quick way to update records
automatically filling in data for a value manually input
multiple grouped counts in one query
Re: How to write IIF statement
Re: How to write IIF statement
Formula to Remove Empty Spaces
circular reference
Running Multiple Append Queries through a command button.
DateDiff Null Values
RE: Help with Distinct
Help with Distinct
RE: Hide/Unhide fields in the query Output
query records by a sum of a field
Adding Query Design Grid columns in Access 2007
Hide/Unhide fields in the query Output
Parameter Query Problem
Appending queries
Mutiple IIF Statements
Non-bound control on bound-form
Using Like In An Update Query
Problem with multiple selection query
Query or Report
Less then and greater then operators in iif criteria expression
Invalid Argument - Append Query
Query summing on one line
Pulling the last date of multiple entries
crosstab - different prices as column heading - not fixed
Percentage Change
Query of Queries
Multi-step query/automation problem
Change a field type from data to date/time??
RE: counting days between dates with parameters...
RE: counting days between dates with parameters...
dsum issue
counting days between dates with parameters...
RE: Left join query problem
Column headings reverting to field names when exporting to Excel
Left join query problem
Summing Time
Averaging across rows
Average Inventory
Parameter Query on an expression
append query didn't update one field
Inventory Activity Query For Report?
I have deleted a query in access and lost the data in a form?
blanks and Windows Mail
Retrieve records, and all records joined to those records, etc., e
Returning zero in a query?
Force a query to populate consecutive dates?
Manage append query key violations?
Count based on multiple fields
Multiple check boxes on form determine criteria in query
trim leading zeroes / change data type
Re: Queries with check Boxes
Date Sorting in Crosstab
Re: Queries with check Boxes
Delete Query
Queries with check Boxes
RE: Convert Date from yyyymmdd format to numeric day of week (1=M, 2=T
Convert Date from yyyymmdd format to numeric day of week (1=M, 2=T
Problem with "Latest Date" Query
Re: Seperating 450 records per group from a table into new tables
Re: Seperating 450 records per group from a table into new tables
Memo - text display in output excel cell
Count function
How do I display an age calculation in a query?
Query type
Jet SQL Help
RE: Report help with crosstab quary
listing out nos
Query about renewal dates
Query Def/MsysQueries Table
query join problem?
Securities
subquery in group by query
Using pass-through query results in forms
Access queries for Access 2003
Type one number into Access, get another in the database
Strange query behavior
Change criteria based off of Option Group
Create a queries with many yes/no check boxes
Create new fields from one field codes
Missing Data
Financial Year Query
Select query returning too many records
Change number format
counting days worked per month
Append with Sub query
Populating a combo box's values based on another field's value (data entry)
override the value in table/query when I delete the value
Multi-value fields and Queries
Strange characters
Oranges, Apples and Bananas...Selective Query!
Expression help
Date calculations
Splitting up a field for an update query
Creation of Forms - Automatic generation of VB code
Use field values as names names?
Difficulty with LIKE operator
Date and Time from URL string
Changed Date in Query
Query criteria
help with dates
calculating compound interest
Re: How to retrieve the value contain in a column maxed with text
Re: Multipe Joins!!!
Including "ALL" in a combo box
Public Function Acos
Re: Multipe Joins!!!
Database Table/Field Information
help with query
selecting records from various tables
RE: Help with a report
How do I run a query using multiple conditions?
Re: Wildcard not functioning
Parameter date format
Unstable result
Queries & table locking
sort options unavailable for column of data in query
Query math
Make query showing first,last,comp,fax but eliminate duplicate fax
Re: Wildcard not functioning
remove duplicates by clubbing together
splitting field data
VBA? Program Command Button to Open Data Entry Form instead of Report
DSum & Dates
Counting Issue
Query impossibility?
Questions regarding 2 similar queries
praca
Using 2 form fields as one criterium
NZ not returning 0 values
Compare Logged Project Time to Expected Project Time
Run query based on results of previous query using code
SQL query help
Using the format function for a percent with four decimal places
Do I use and IIF statement to display another field or not? What
How can I do this date manipulation
Criteria not including today
Query Question
SQL Query in Access 2003
Query with count, but what am I counting?!
Query with Picklist Crieteria - Part 2
text to date and criteria
quirky query problem
Running Sum in Query
255 limitation
Date Format in a Query
MS Access 2000 query related
qurey related
Crosstab and Date help needed!
Re: Running a query to calculate age from the date of birth
Creating Reoccuring Event Records
Building a Reoccuring Date set of records
Query returns no records problem
Fill Blanks with Zero on CrossTab
How to get the LAST data for each group?
Query Parameters
Cross-tab help
Sort order by customer name not working in query
concatenate
Date query Criteria
Building an accumulator in access- module or query and how to?
Purpose
Query with Picklist Crieteria
Combine the contents of a field so only one row is displayed
Passing Form Values to Queries
Crosstab voes
Re: HELP! how to match table Field data with listbox data in form
Three reports based on query with dates in 4 fields
Re: Query is blank if one field does not have data...
CONCATENATE
Convert week "number" to actual number to sort it in column headin
Concatenate & forms
search facility
Extract date from date/time field in query used with mailmerge.
RE: Iff Statements
Online Library---No Risk FREE TRIAL! ---- Need Research Help? 6,000Topics, Primary Sources, Books, Journals, Citations & Bibliography.
Count <>0 not working
calculated field in query
row/column totals in crosstab query
Combo box problem
dmax not working in 2003
Newbie to VBA Programming
Get rank on based on productivity
Get rank based on Productivity
Re: SQL Count with Multiple Columns, Single Table
query
Find data in field after a specific character & display specific d
Re: report Date
Selecting Table based on user input
Query for All
Re: Problem proofind data to M-to-M relationship
Complex Query?
Restricting Records
Calling dates from two fields... IIf - IsNull help.
Read Only Query, need a little help
Motel Register - Displaying records between dates
Pass through query to oracle db
How do I use count in a query in Access
Query design help
Date projections
Re: Keeping just one line for each e-mail
Create join 'between dates'
Re: Query help / search specific records
Renaming Column Headers with IIf as a Result of a Crosstab Query
Multiple Table Query Is Blank
Group By Question?
delete parent records where child fields are blank
Date range and creating a formula to use in a second date range
Is there a maximum number of rows
Combine all info
Can I split a string or use the split function in design view?
appending more than 255 characters into a Memo field
Using a Cross Tab query as a subreport
Using the OR criteria. Am I doing it right?
Replace Query with records in table
Crosstab query - want report to look like crosstab
Returning one record per address from a contacts database
Trying to delete records from multiple tables
Tweaking a query
Top n query using Allen Browne's "ConcatRelated"
LIKE problems in a query
Displaying 1 combo box dependant on details chosen in another combobox
appending new records to a table with a compound primary key
Comparing weeks with highest and lowest sales Query--HELP
signature problems - please respond!!!
Re: Help needed with query returning rows?
Need to Count by two different criteria in same Totals query
Criteria linked to form combo 'Yes/No or All' expression help
RE: Help needed with query returning rows?
Really slow query
SQL Question
append error message
Can't get " * " to work to add all fields to query - Help!
Importing a new query into a report
Re: Setting Queries Allow Edit
Runsum in Query by group
Probable Access 2007 SP2 Error: Query too Complex
Adding zeros
Maximum number of Criteria Rows in Query Designer?
Reading System Date
automated Db backup
querey design help
Running Sum Query of Ranked Data
QUERY VALUE TO TEXT BOX
IIF Statement Problem
update query with iff
Changing form data
Recordset locking up
Re: Updateable Query
IIf statement not working
how can I return a record not found message if the record is not f
Re: Updateable Query
NOT IN and Sub Query
append and update queries to PostgreSQL backend very slow
Rearrange information in a table
Difficult Select Query
Re: Convert decimal to time.
Re: retrieve the first record of a set of records
Re: Convert decimal to time.
RE: retrieve the first record of a set of records
Re: How to run a Query in a Subform?
Re: Complex IIF
Date/Time Selection problem!!!!!
comparing two tables with the same field
Query min date for change in data element
Geocode an Address
Calculating Age from Birthdate field in Query
query with zero records
Problem querying table linked ODBC Database
Problem with a parameter query
Eliminating part of a field
I need to find top 3 records from my table
Simple query not working
Monthly data based on dates
Re: Complex IIF
Re: Grand Total on the main form
Re: Grand Total on the main form
Can I convert text to columns in a query?
Can I convert text to columns in a query?
Append Query and Odbc
Using COUNT in Access 2002
import errors
question on saving file as text
Reports return results after 15 mins!
Calculations and Expressions
Re: Ignore the letter and look at the number
Conversion from 2003 to 2007 deny's access to forms and databases
Change the SQL in an existing MS Access query
Crosstab Query does not return all records
expesssion in query
Input data validation
Re: list box data populated left to right
Getting column values into row values (transpose)
Concatenate function from a Query, not a table
Data Type Mismatch in Criteria Expression
Case Statement Help
Inner , Right, Left JOIN
Access Append Query
IsError function
Showing serial #
Field Unupdateable
'Data type mismatch in criteria expression' error in Count query
'Data type mismatch in criteria expression' error in Count query
How to assign table name to be value of a field in a UNION query?
Subquery
Use an update query and offset records
IIF issue
IIF function qry run from 2 tables
search on a memofield doesn't work
Query question
Incrementing a line no in a query or form
Generating system date in Query
Invisible text
Invalid Procedure Call (driving me nuts)
use cdate in a query?
I need aquery to get all products suplied by both s1 and s2 supliers
Record not showing if no record in many table
String Manipulation in an Inner Join
Re: Total weeks
show all results even when null for each name
Delete query foible
Text is not visible!
Simple Access Query using VBA
Creating a DSum calculation in a query.
convert a field/column from kilos to metric tons
UPSERT Query Performance
UPSERT Query Performance
Calculate inventory in report
Random Selection by Group
data mismatch
data mismatch in query
data mismatch in query
data mismatch in query
Update Query
JOIN question - unlike fields
Last Date Query
Inverse Crosstab Query
How to make a single record query to pricing inquiry
how do i query if(isblank)
Crosstab Results - different for co-workers!
Multiple Queries in One Data Sheet....
Nikon Vibration Reduction Lenses
Nikon Dx Lens
Compare budget to actual figures in a account
Changing Bathroom Faucets
Cuisinart Blender & Food Processor
Zenith Watchs
Bar Dishwasher
Delonghi De400 Dehumidifier
Need help with less complex Query
Need help writing a complex Query
How do I express a combo box column reference in a query criteria?
Query Based on Main and SubForm ID Fields Not Working
Formula Question
Union query not showing all fields
Update Value in Table based on to that of Another Field
Re: Convert number to date
Formula for specific date range
Query By Form, Master, SubForm, SubSubForm
Convert Access Queries to MSSQL
Access 2003 Datasheet as a Subform
No Value Given for one or more required parameters
Multiple Field Index Problem
add records to INNER JOIN query
How to create an easy to use grouped query
key violations
CrossTab Query How Do I change Column Headings...
Join help
Parameter Query SQL and Date Ranges
Query sort order apparently ignoring ORDER BY
Access 2007 / update query
Crosstab without column heading field
Date Timestamp
How do I update to multiple tables?
I am looking for a template for running a pool league
update charts in design view
How do I verify if value is a number or text?
Re: Convert Number to Text and keep leading zeroes
Queries, see new fields when table design has changed
Re: Assign Dates To One Week Periods And Two Week Periods
duplicate records
How do I generate a random selection query in Access?
RE: Run queries and export into excel
Excluding items from a table so user cannot see or select them
Re: Assign Dates To One Week Periods And Two Week Periods
summing time
summing time
Rounding up a fraction
Access not recognizing Date Format
Retrieve data after a certain date
Re: How do Update fields with wildcard as a text
Re: How do Update fields with wildcard as a text
Re: How do Update fields with wildcard as a text
hOW TO INCLUDE SERIAL NUMBERS
Update Record
Criteria & <>
Output query based on data field.
Re: Help With Query
Re: Assign Dates To A specific Period
Newbie: filtering out duplicates
Max function query
Operation must use an updateable query
Re: Help With Query
finding a gap and counting the months after the gap
Re: Assign Dates To One Week Periods And Two Week Periods
Re: Update Query
help with query
Re: Using Replace need help with blanks
SQL Query Problem
Re: Textbox query filters
Re: Query Help
IIf statement in Access 2003 query
use field list from form to specify query fields
Help to create this crosstab query
Calculating Percentages Using a Query
Re: Is there a way to get mulitple specific records from 1 query
Fields with Data only