Microsoft Access Queries [Archive] - Page 49

engine does not recognize <name> as a valid field name or expression.(Error 3070)
Field Name in Query Results
Nz
Make Parameter available for querie based report
how do i create a date queries
Unable to View Data
Count only Yes values from a Yes/No field.
query only returns values if criteria cut-and-paste
how can i make an accumulation query
How do I change the default year setting from Jan-Dec to Oct-Sep
Find duplicates based on a negative and positive number
How do I do a random sample query of data in an Access database?
Emails in inbox have disappeared.
ado query problem
How to isolate the day-value
Using Parameter queries with reports
Return non matched values
Sequential Numbering resents on a group
Updating via queries
round vs. formatnumber
Finding a match
Help with "IF, THEN" statement
Counting yes/no fields
Expression help - query looks to subform
Re: Concatenating multiple field entries with commas (I am ready to shoot myself)
convert data
calculating sums
Concatenating multiple field entries with commas (I am ready to shoot myself)
How do I get a relationship between tables to be case sensitive
How do I create a table of unique records from two or more tables
Query criteria
Problem using Query Criteria with an Expression
select max value from multiple fields within a record
Using month as a calculation value in a query
Union Query?
Limit Form to Date Range
Query Multiple fields using wild cards
Screen resolution/ About Blank/ Help file Win98SE
Field refresh in query with one-to-one matching
Re: How to select x random records
Why doesn't Word 2003 print odd pages only?
same fields, different data???
Fix Query too Complex error in Access
run a delete query from a form
Combine like output of 12 queries
Multiple Key Word Criteria in Queries?
How do I count mulitple check boxes in one query in Access?
criteria for month(class_date)
Multiple dates in Criteria section
grouping on Month and year
average
In a Join, 0 doesn't join -0; why not? how to workaround?
Sum/Query problem
CheckBox question
How to run calculations on every record in a table
INNER JOINS
Update and Append
condition in queary
User to select query columns
Nearest max date before a specified one
Data type mismatch in criteria expression
cannot see "create query in design view" when "queries" button is
Less than current month last year
Font color & background color in a query possible
Create Table ... Random Autonumber in SQL???
ROUNDING PROBLEM IN ACCESS 2002
ROUNDING PROBLEM IN ACCESS 2002
Data Access Page from parameter Query
Is there an SQL query for table schema ...
Shrink to fit text in Access
Multiple Data
wildcards with parameters
No Clue How To...
how do I format a date from yyyymmdd to mmddyyyy in access?
Need all Form Nmaes, titles, control etc, for Bug Reporting tool
stumped
Parameter Query problem
Matching & NOT MATCHING
Alphabetical Table Fields
Tiers
Multiple dates
Really Slow Query
parameter box cancel button
Formula will not work with mail merge
custom dialog for parameter query
Microsoft Access Query Calculation
Removing duplicates
Re: Drop down menu in Query
All records
Why do my images show up as codes in my word docs?
TOTALS
rearanging data from rows to columns
how to check whether a value exists within the results of a query
Max vs. Last
proof-reading
Ranged Cells to Access from Excel?
Parameter query for variable column name...
Query
Rounding Up in a Query
Select top 10 records
sumarize table
query repeats first record multiple times
2 or more queries in a form?
Query Expression Help Needed
Editing Data
Autonumber propagating through make table query
Trouble accessing the value of a form control in a query
updating table
after i run a query i can't edit a field
How do I query multiple Tables with difernet Primary Keys
Duplicates - how to remove in a query
Using system date to determine criteria
all values less than 0 to equal 0 or null
Query help, sorting query
Query acting up!
Date Range
Parameter Query and Like Condition
Query acting up
Calculating percentages from counts in a crosstab query
Date range in query
Autonumber and Make Table Query
SPECIFYING DATE RANGE IN A QUERY
Query
Query time to execute
Date Conversion
Date Conversion
Date/Time recorded in a single field
Multipule Tables
I need help with the Round Function in Access. Is it me or Micros
Error when exporting query
Matching Tables
Full-Text Searching
"Minus" keyword
Timestamping
Query Criteria Problem
Invalid Argument
query wont bring all info together from a link
Using Unique Keys stops data from filling
query using a list box
Multiple join query with several calculations
English to Metric Update Query
First day of current month
Sum Doubles
I need help with an access query
confused query
Combining Queries
Union Query Problem
tough query (for me)
Multiple INNER JOIN statements
access.query.overflow
Crosstab query question
Pad zeros in a field
#Error in Query result
How do I insert a character in between a string in Access?
Skipping lines in multiple line address query
differentiating the date/time by shifts?
equivalent of a countif function (from excel) on access?
Updating Excel link table - Allow Unique Records didnot work
Combo box as a parameter
How do i set a value based on a data range
Number format
Date function problem
Sort query results by closest number?
Multiple IIF in a query
Fiscal Period Definition
Last day of Month/Last Week of Month
compare fields
Queries to help calculate the values through datasheet
count fun returns with no data, how can i get it to return zero
Query to update date column
Pop up window for users
need to exclude when value = $0.00
special query
how do i print a subdatasheet
Update Table Query
How to use countif formula within a table in Access?
Re: Trying to Sort by Special Date Function
Cross tab Query
display record if any field contains a certain value
Combining multiple linked tables
Union Query
Executing A Stored Procedure From An Access Query
build criteria
list by date
Grouping based on 2 columns
Calculating hell!!
Running Query classes inside transactions
Call a function in a query
Query runs but 20 min to go to last record
WeekDay problem in office 2003
how pass parameter to a query?
finding max per group
aggregate query question
Unique record with multiple columns
Re: Count "Zero values"
select fields from a table that don't exist in another table
query is duplicating information
Count "Zero values"
Another database field
Passing a form parameter to a group of queries
copying a column
Help
I can't figure this out. Please help.
A query based on a query and a Link table - Problems connecting
How do I get a parameter query to run with all or part of a criter
Help - I need to create a query that will search forms
Autonumber in a query
Creating one field to summarize several fields
I can't edit my queries in Access, is something locked?
Extracting Specific Data from the same date
How To Run a Query Automatically in Access 2000
Eliminate duplicate values in a query
Re: Calculating dates msaccess
Calculating dates msaccess
Date Difference Exclude Weekends
Identifying dups in 2 databases
Pivot Table - Microsoft Access
Marco Messages
Counting Records
How do i retrive a forgotten password from Acces?
Append only different OrderID's
How or where do I use a calculation to generate a Salesmans commis
Criteria does not return expected results
query dates
Using column name in SQL Select statement
query
JOIN and one-to-many-to-one
Most Recent Date Query
Find Top n values in each Name
The Jet SQL Syntax For Entering A Date And Time Into A DateTime Field
Date Differences
To All
Fixed vs. Relative Time Periods
How do I send a Query result in an email body (NOT attachment)?
Listing gaps in numbering sequences
Delete query does not run
How can I pick the 1st & last item & sbubtract the last from 1st?
date compare results not working
Do I need to put any type of pause in the code below?
modify a field value of all the group records
What is wrong with my query???
Proper Wildcard * or %
Parameter date equation
How to Specify Data Type of Alias?
Access expressions
match multiple fields
Date problem
APPEND QUERY DIALONG BOX
how to get weekly data from days
filter based on toggle button
"000" Not working
Dont count duplicates in a specific field
Action Failed for extracting data to append on another table
link two data fields one is subset of another
Parameter query with date field
Parameter Query run from VBA
Query Maximum value per row
Query to update next record
Cross Tab query date format and sort order
save crosstab query result
Separating "a" from "A" in a query
Append Lookup!!!!!!!!!!
Show latest record according to date
Query Append Query!!!!!!!!!!!!!!!
Crazying with Linking Append Queries!!!!
Custom Function In Query Not Working
Updating Crosstab Query?
Filling fields by code
getting auto number before form is saved
Query / Code to Normalize Columns
Not Criteria
Like [field?] - more than 1 item
IIf and Dates
Group By is not returning one record per ProjectID
Last 3 dates for each product
Display Only First Record of Repeating Records?
crosstab union???
obtain TOP n values per day (multiple days)
Memo field truncates
How to combine values from 2 fields for a report
Latest Date Entry
date evaluation on Day and Month Only
Select Record Based on Column Name
Specific Criteria
Criteria froma form
Distinct records within week
What do I enter in Criteria to query yes/no checked boxes?
Date Time query
rounding decmicals
How do I remove leading or trailing zeros from text such as 00012
sql script not returning value from form
In Access, how do I show confirmed Shp dates under 90 days?
Problems with index on fields using accents
How to use Append Queries to add new records
Help on Query
Append Queries
Images on screen
Search /Find Record Textbox
Run a Query Hidden/Invisible
how do i turn off transparent menus?
Query Date Range Criteria Doesn't Include Last Date in Range
Latest Date in Table using Query
access database
Delete query problem
Update Query using the IIf function.
Union Query WHERE criteria question
Incemental nimber in Make Table Query?
Crosstab totals incorrect
error says table not found error, but it does exist.
Remove Leading Spaces
Toggle Fields in Crosstab Query
Combining Similar Rows
Showing currency field as null
table not found error, but it does exist.
table not found error, but it does exist.
running total by customer
running total by customer
Queries by Design and Store or Progammatically
automatically exports queries into excel files
Adding Field to Tab Control Page
Re: MS Access - creating a query for monthly data
Error Function
Need to Fix a Join
Access query to differentiate between alpha and numeric invoice #
Update subform with results of query
Moving average and maximum calcuation query/queries
inconsistent updates and the consequences
not enough space on temporary disk
Doing a sum function in a query
Query in Access that automatically includes new fields
changing a value in one field base on a vlaue in another field
Convert Julian date to real date
Union Query Help
Between 2 dates
Delete Query
Data type mismatch in criteria expression
Hiring a MSAccess Pro
Employee Query
checking multiple fields for a requested date
Re: MS Access - creating a query for monthly data
MS Access - creating a query for monthly data
Use value in a field as input to a query
passing empty criteria fields?
Query with Like
Changing Criteria in Queries
Query-What format do I use to obtain unspecified unique items?
Unwanted Binary Data Type
How code this query ?
Help with WHERE clause
Export Queries to Excel Template
RE: IIF STATEMENT
Date of Month vs. Now
Date group
RE: The months in a query appearin alphabetical order.
Adding columns of a record in a query
Insert NULL question from .NET
How do I calculate the difference between 2 fields - ongoing
trying to query from a list box to a text box
Running Total in Query
copying a table
Date Type Question
Need Urgent Help!!
Crosstab qry
How do I speed up this self-referencing query?
Like, Not Like
Triggers
lookup
validate field in query
Using two tables in one query
wildcard search is query
VERY Slow Table Creation
Please Ignore My Previous Posting
Update/Insert Records If Not Exist
Conditional Formatting in Query
Analyze It with MS Excel
how do I email from a query
Query giving table heading Cust Name and 12 monthly sales (ie J F
Change date format
query very slow
Union Query Questions
Incremental number field in Make Table query
Irritating Problem...
date - # of days calcuation
Creating a select query to find the MAX volume between certain dates
Insert Recored
creating a multi part query to be able to export complete data
update simultaneously a field in a group of records
Subquery for calculated field - probs with crosstab
Show/hide columns in design mode
Yes/No Field in query
Sorting Crosstab after Format of Date
Round to Nearest Integer in Access
IsNULL and LEN differences
Parameter prompt where there shouldn't be
count ALL of one field in query
What is wrong with my SQL Statement
Search Query
Access date range querie
Join from Microsoft Project data
Help with select 1 only
Tricky query - how??
joining multiple fields in a query
Don't have the button to send & recieve mail?
Problems with Date Add
Calulating FY Totals
Help - Search Date Range
How can I print all data that contains a required single word not.
Linking between tables
Exporting to Excel with % Format
Question Query
"Init: Left([Firstname],1)" in Access Qry
Help with Average
Need query to sort by CurrentYear members
Dates in delete queries
Count Records In Make Table Query?
Problem with In(SELECT...)
Access Queries ot consistint
Concatenation and IIf
Show only Neg Numbers
2 problems with my query
Looking for a query
How do I keyword search using access like a library catalog?
access2003 returns zeros instead of valid data on SIMPLE query.
Parameter query using Date
If no records, value = 0
How do I keepr "error" from showing
Query Question
Wierd Query Behavior - Please Help
how to view xlt file type on Windows
How to run an update query on the current record (in a form) only?
DAO QueryDef - access thinks my column name is a parameter
Date Conversion...
Sending non duplicates from two tables to a new table
Multi-Level Query
Crosstab Query - Calc Difference based on 1 field used as header
Criteria Expression in a Crosstab Query Column Heading
Crosstab in SQL?
"Triggers"
How are these sorted
Parameter query
Append and Delete Queries
Date Questions in a Query I think
nest queries
Change query output column order, Access 2003
team criteria problem
Update query
table not found error, but it does exist.
nz
Duplicate Records From a Table
Three table join
Exclude unique records
So easy but missing it.
make-table error 3001
Query to pull people with no activity prior to a certain date
Driver update
a macro sometimes does not run one of its make table query??
Parameter Query Criteria
Add months with last day
displaying additional data that correlates to my query
Updateting WO Number
Query to filter all but two items
increment a value for every x records
Open Query to Filter by Form
>= 10 years query.
Syntax Error in FROM clause
Packing a number with zeros
Make Table AutoNumber?
Saving queires
RE: creating a query for a report
creating a query for a report
Query to move decimal point to the left
Create data in a field with multiple lines?
use between statement in an iif statement
Access 97 using a saved query in MS Query
Strange Error
Reduce the string length
Problems with Query Using Time in Access 2003 (11.6355)
Query
group by clause
Calculating Percentages
Cascading Delete...#Delete found in table...what the heck is going on!
get year in a sql query
Returning query name
Search for a query name
criteria in calculated fields
Setting the level of precision
Crosstab query challenge
followup - what makes this query not updatable?
Formating in criteria
Sequence of query order changes from 97 to 2000
Multiple values exclusion in a Query
MakeTable Autonumber?
am getting to many data while running the access database query
I am getting to many data while running the access database query
Two table query
left join and where clause trouble
Limiting output of a Query
update
Run Query - Workstation locked by Admin
Limiting number of table enteries in a query?
Using parameters
RE: Using parameters
Select Records w/ & w/o Corresponding Details
Calculate difference between two workdays
Query Using a Form Object as Criteria
Criteria in Queries
Select Query By Month.
Mouse-over info to show table names...
RE: Criteria in Queries
Form Object as Query Criteria
RE: Select Query By Month.
RE: Select Records w/ & w/o Corresponding Details
Records not found on query
Updateable Query Problem
RE: Select Query By Month.
Move Query result to Word document Bookmark does not work
Parameter Query - how to avoid needing wildcards
Joins in Access
Top Ten Date Query
Select Passthru query for multiple users
Things happening at the same time
Bizarre and frustrating! Phantom ambiguous field reference in a query
Append Query to Update Network Table
Can a query do this?
SQL Language Query
SQL query showing diff between actual and budget
Microsoft Office 2003 Trial Version
Seting format to be 000000000000000
Form Error
Excluding values of 0
Database suddenly stops allowing updates ! For no apparent Reason.
Re: Crystal Cross Tab Question
2 date fields
Relating records in a query
Query for commissions due
query to link field from two tables - one is entered from a combo
Determining whether a query is used elswhere
What is wrong with my query
Where are queries executed?
How do I schedule an Access Query to run automatically each day?
Select Into...Select...Drop Table
weekday function in WHERE
RE: Data Entry Problem(repost)
Division by Zero
Print off multiple reports based on combo box selection
Query under button
Nicht normal
<path> for <path><filename>
Dept/Month/Year Crosstab problem
ODBC error prevents opening database
Re: Month/Year/Dept
Access 2000 - 'Operation must use an updatable query'
How do I search for a specfic month in a query?
Query design window
Changing the source of a query
Reordering Subform/Query
How do I create a timeline?
DCount function
Advanced Filter w/date field
eliminate dup records based on partial field contents
Dim problem
Including a Sum from a calculated field in a query
Summing Calculated Fields
Immediate If Function
Table Comparison
How to Fill a Table with Random Records from Another Table
Updating field from another table.
Help updating table with data from another table
Criteria for query
Top item
creating a query to print
SQL Bracketing Bug
merge two tables
how to locate currency records with too many decimal places?
Select query depending on two criteria
To John Spencer (MVP) re Merge Question
How do I make this an Updatable Query?
Need to count check boxes without getting negative numbers
Selecting Top 3 Items from a Category and Subcategory
Totals Query from Multiple Tables
Convert #Error to 0
Need to convert this code to a query
How do I handle array's in Access 2000
Formatting data within IIf function
Formatting data within IIf function
GOOD
Overlapping timeframe
Using two tables for one report
Access SQL View qurey date function
database query problems
Finding a previous line
Re: print query in landscape
Help with a Query
Multiple Time criteria
Please help, update Query (2 tables)
Why won't this work???
Problem with query in Access
Still have a problem after requery
Grouping problem with 25M records
Help with Criteria on a query please
Top n records
ÄÜÃ´°É
Using calculated fields in multiple queries
Check all fields in linked table are completed
Querying table based on conditions of entries in linked table
Problem when query returns no records
count accross columns
Crew list
Combobox row for Criteria
calc the total number of distinct values in a field
Sort Query, on Several Date Fields, Nulls at End
Sort on Multiple Fields, Nulls at End
RE: Crosstab Query column heading order
Crosstab Query column heading order
How do I set up a query for information prior to the prior year?
Re: Linking Tables if not exact match
Need to make query,summarized report, then chart
Query Problem
Linking Tables if not exact match
Re: expression help
RE: expression help
expression help
First 3 Records
query with multiple criteria prompts
Comparing Two Tables, show matching data
Creating table and queries
total
if statement wont return currency format
Edit a Query by Code
IF Then statement in MS Access Passthrough SQL Query
ACCESS 2003 query size high problem help
Create column headings in crosstab
Query for Last Inventory Count
Date parameter query on timestamp field
Help with JET_SCHEMA_USERROSTER
Ranking
what makes this query not updatable
Check box & Combo box (either / or) linked up to query criteria li
Distinguish Cap Letters and Lowercase letters
AND querys
True or False?
Repost - Using a Parameter query in a mail merge
Overflow Runtime error '6'
Grouping Data By Weeks
SQL access 10,000 record limit
Query relults don't match
MDE file to use in Access 2003
date ranges from a calculated date field
Change display of query output
DLookup
Re: Build a query that meets a calcuated field and another criteri
Re: This Puzzle Should Be Easy...Maybe
How do I build a query
Sum of Quantity Late
How can I interpolate missing data in a Table with a query.
working with append queries
Adding a date field for last month
Access2K append queries fail under XP Pro
date in a sql statement
Removing part of case number
Error Message and not sure why Please help
mail merge
partial input a typical question for typical guys
Re: Query paramete error
Merging 2 tables
Does anyone know how I can display a spacific time frame? 9am-5pm
How do I select distinct for 2/5 columns queries in Access
Mail Merge
RE: Selecting data from lookup field for query
duplicate carrier number
Add leading zero if field has only 1 digit
multi-table query
Re: inserting single quotes
RE: not quite sure where to start
RE: results of queries don't match
RE: This Puzzle Should Be Easy...Maybe
How to extract latest record
Re: Multiple conditions in DLookUp
Using Weekday of calendar control in a query?
Re: "Hold" values?
Re: Merging tables
Re: Merging tables
Format a date field in query result
Re: How do you eliminate errors
Re: needing help with visual basic queries
No Subject
Looping to generate reports based on query parameter
Simple Calculations
SQL with current table cell as variable
Naming Queries
How to create "Insert" query for user input in Access?
PROJETOS
Report Query Too Complex
Renaming query column erases lookup's SELECT statement
Advance question: Need to "cluster" records
Update function
Access to Oracle 9i Query
How to Convert new access files to old please help!!!
Export count(*), then the records to a txt file
1544151 CD-R, DVD-R, DVD CASE CHEAP! 15
vlookup for access
Can Access 2000 retrieve a CLOB using ODBC on Oracle 8i?
dsum function in Update Query
Problem with multiple INNER JOIN
Undefined Function Message
Top 5, for each
top 5 for multiple sets of data based on criteria
Calendar using between dates
How? Linking a select all box to a query field criteria line
Adding multiple records to a query without closing/reopening the form
Return just part of a value
My adp: can't update a query with multiple (linked) tables
Change the value in a table field based on the value of another fi
Between Dates - two fields
Delete Query
Help - Join Query for total count
Create a SQL pass through without using an ODBC driver?
New to SQL...Need help with syntax
Calculation
MS Access 2003 Query error
Automatic Data Extraction for Fri-Sat-Sun on Mondays
Networkdays Function in Access 97
Networkdays Function in Access 97
query parameter issue
Select data once in a query even if there is more of the same kind
Export Query to CSV
Cann't update record value
run query's and then reset table
Adding Prefix to multiple rows n Access? Help!
Pass Through Query to Oracle Table
How do I break links in a Word doc from Access?
What am I doing wrong
restore deleted access records
how to link or bind a listbox to textbox
Calculating time
CALCULATION INQUERIES: How to fill GrossPay with a(:)?Plea
First row has customer name, subsequent rows the name field is bla
Query Question
Date
Update Query
Previous record
Access Query
how to create a crosstab query using access
Query
Printing In Access
Criteria problem in query
Converting to a Percent
Critera question
Count only text fields containing data
Show last adjustment of a bill...