Microsoft Access Queries [Archive] - Page 39

Error on loading DLL in Access Query Wizard
I want to automatically run a report from a Query?
How do I reschedule an attendee for the next session
Criteria across 2 fields
query issue with parameters
how to append into multiple tables at same time?
HOW CAN I DISPLAY ALL TOP 2 RECORDS IN THE DATBASE
Browse Button in Access Form
Browse Button in Access Form
Browse Button in Access Form
Multiple selections for criteria in query
Query Help Please! Is a Weekly data format Possible?
Ranking... One More Time Please
DataGrid Cotrol IN Access 2003
Appending Tables
Why won't my query to show only 2005 data work?
Linked Table in a Query
Empty Table?
Complex Autonumber Problem in a query
Explicitly declare the variable
shorten an SQL statement to work in VB.net
Query Problem - Two or More Records
Strange Problem Reading MS Access Memo field.
Prompting several different criteria from a form (Query by Form)
Combo boxes with queries
How do I used wildcard characters in Query by Form?
How to get the Value from a Table field
I want to select either specific records or all in same query
query usung datedif function
Re: How do I multiply one field by another in Access?
update select fields
Reverse Cross-Tab (Union Query) - Size Limits??
Parameter box to print one lable for two people at same address
help with if statement
multiple records with same results
Search button and field
How to use SQL variables in VBA
Query for ComboBox - Show each entry only once
Cannot see all the fields in an ODBC table/view
why is my expression being truncated?
Parameter query, null value in (table) field
DateAdd
queries with combo boxes!!
Formula/table assistance
Add a range of dates to a table
Left Join Not Properly
If statement
Problem with memo field in query
binary to text
Date query criteria
expression
Concatenating fields
help with getting to end report
Query Help - PLEASE
Variable Question
Discrepancy between query results, rounding error?
Can this be done.
Using aggregate functions in a query. When I click run I get the
Using aggregate functions in a query. When I click run I get the
How do I show query results in color
New Parameter values (from Form) not being picked up by Query
Results from Query using IsSelectVar to a Table
Equilevant of Oracle for optional records
how do I create a database using post code
Showing No Duplicates
query that pulls specific names out of a number of fields
Query Help
Calcuate Elapse Time
Query run again
How to write query for sorting data in table using VBA?
Email Query
Help with query
four columnes into one
IFF Statement
Limiting a Ccur() function to 2 decimal places
can an iif function have more than two results?
Exclude Query
database for c.v's
Entering Parameter in DateSerial expression
Return 20 Rows from Query
Add two fields of a query together?
iif Function in Query
Convert Text to Numbers - Leading 0s
INSIDER - KNOWLEDGE NEUTRALIZING!!
How can I, in an IIF statement, create the true statement in red?
Dates in a query
UPDATE query creation for SQL
please help am having a nightmare with running totals arghhh
Count in a query
FUNCTION
input date in query
Unmatch Query result
Help Not getting proper result from simply query
Stupid Query Question...Column Display
datedif function
Access Query - Don't know what type to use - Inner Join? Update?
Stock Price History Criteria
append Query
First 200 Query
MS Access SQL database Query
Access: Query criteria for uniqueness, only non duplicate records
hide repeat values in a join
update query confusion
Date Calculation
What Access formula is usee to retrieve data from 6 mo. ago?
Time Conversion Question
Another 'buckets' question
Select All but only Select some Distinct
Linking Records between Tables: Compensation Offered
Append Query clarification
How do I re-write my query so that it will decode the masked files.
query to tell number of months between two dates
Last date value from records
Can I Use a function in a queries criteria.
Calculating hourly total
how to import all lines from table even if identical
Criteria = Like "*this*" With Prompted Entry
how figure number payments still owed
RE: Ranking on sub-categories
How to stop Error# message
Multiple expression, in Query
grouping
Time Conversion
Parameters for query with Option group on form
Query for Email Address Then send to Outlook
Query Query
split address into 2 fields
extract only the numeric element of a text string.
Counter Reset Weekly
Transform Vertical Lines to horizontal please help
Randam No...... KRISH
Multiple Rows in a query
How to make null = 0 in expression query ms access?
select case statement
To enter date range once only for main- and sub forms
Reply to Maarten van Sambeek
Linking Records between two tables using queries
string two columns together and use the string in another qry
Delete records containing certain info
NOT criteria in query not working
Need Formula
Hourly volume calculation
Information from a query
Open Table results:Decimal's precision is too small...
Open Table results:Deciaml's precision is too small...
Using Between...And Criteria with Ages
help with nestled query
Create report with 2 queries
separating a string for keyword search
compare empty form text block
Using between dates
Limit # of Records by one field
Multiple Updates on one query
Multiple Criteria
Hardship with localized version of access
make bulleted items appear with a click
"Not Updateable query" error..
Problem with outer join in query
Need some VBA code help I think....
Update all in one query...
Query for data with different spellings
Help Build Query
How to limit Query return to first 10 that satisfy criteria
Struggling with query
Time Format
Time
Subtotal query
Adding query results to a table field
Where clause on a Look-up field
Query on Memo Field
Error message invalid bracketing
Change data arrangement
SubQueries
RE: Counts and averages
Counts and averages
Query Totals
How can I give a user options when using a parameterquery?
data out of range
Set up parameter query using wildcards
why don't I have "search" option in TOOLS
query to count number of records for each letter of alphabet
using numbers as characters
Date In Query
RE: Counts and averages
RE: using numbers as characters
deleting records - in a duplicate query
calulate backwards
How do I calculate % in a PP data sheet?
RE: How can I give a user options when using a parameterquery?
RE: Set up parameter query using wildcards
Calculated Field
Select query - only one-to-many records?
Select last two records entered
RE: Select query - only one-to-many records?
RE: using numbers as characters
Re: Using Query to Find and Replace
Help with query!
record with doubled value
Combine 3 queries for report
Group Query
RE: How do I calculate % in a PP data sheet?
Group count query advise
Update Query Help
Query not updatable.....
Linking a SQL database to an Access database.
Pass a Value to a CrossTab Query
Possibe to use "NewField: CDbl([ExistingField])" in a CROSS-TAB Query ??
Another Date Query
Date query
Pulling queriy criteria from a text box
Date Field plus X days
Create a field to calcualate a date.
Want Duplicate Information
Repeating records based on a number in a field
Query of what isn't linked to a certain table...
Creating a unique customer code with a function
Query that displays what isn't connected to records in a certain table
Can't Update Multiple table view?
Run-time error -2147220992 (80040200) - Access 2000 Database
update query help
update query help
Calculating # of Shifts Between 2 Date/Times
Error in query
VBA filter on unbound forms
MIN
Append / Delete Query Question
How can I round to the next month
populate blank fields
Reference a local table in a passthrough query
How do I check the date I istalled SP2
Return every nth record? - newbie
Union Query
Deleting and Recreating Access Tables
Pls help w/updating query
Case statement equivalent
Multiply Selection Update Query
Cannot tranfer Database with Date Function query
Subtract 2 dateTime stamps
Access Query Nightmare
How do I use Access to show duplicate records from two tables
Finding the first LOCAL minimum in a time series
Ranking scores
Parse one field into multiple columns
Updating Multiple Pass-Through Queries through a Form
Making Append Query generate 3 record and not running into key violations
NULL is design view criteria
Default Value in Query
PLEASE HELP! CRISIS!
Filter subform data from main form combo box(s)
Mark a query checkbox
Adding field in query design view to enter 207 blanks.
Query Confusion!!!!!
Query is too complex
Import Data - Column names in one column in Excel
Scheduler
Crosstab Columns in Datasheet Subform
Select in Query causes cartesian results
Query to get report to show specific criteria
Simple Select Query not updateable???????
calculated field in query
Sum of 2 lines of Count query
Count(*) Syntax
Multi join on same table
Parsing text string (1 field) to number and date (2 fields)
Single result from multiple records each month
Reference form controls in query
Concatonating in a query
Inventory Query Question
Export to Excel
How do I move a query to another computer in the office?
Gen Record Number within Primary Key
Date parameter
Help with date formula in query
How to get data that's NOT in another Table?
Append Key Violation
Record Locking
how do I pull information for the same month but different years?
changing the date format
Help with passing ASP variables to saved queries
Append/copy calling a module switches data
Building a query with the content of a field
QUERY: Output Data from multiple records
Determining which vaccine was given in a date range
The query-expression deletes some of the fields
Office 97 Pro Access will not open running on Windows 2000 proSP4
More fun with subqueries
Update Table Statement - Time Out Problem
Help with parameter query
Frustrating Query
Alias amnesia after subqueries in Access?
Text in a Number Field
jet sql access subquery in from clause left outer join does not work ... help!!
update (remove last 4 characters)
User to select different fields
Build on query expressions deleting closing )
how do I only pull 5 records (random)?
Minimum function problem
Get data that I want problem?
OpenForm Criteria
Summary of Donations
nz not working in A200?
Create a query that will allow users to enter data in Access
Please read before posting: guidelines for microsoft.public.access.queries
Wild card in parameter
remove # signs in my DAP field for hyperlink on my web.
Column Parameters
Help! Trying to set a maximum value on a query result.
tracking log times ...
Functions - YTM
Problem with an ASP update query
Done with one query?
Query Question
Elapsed Time
SHIFT/F2 MEMO FIELD - Overide Mode --------HELP
Not Operator
HELP WITH DELETE QUERY IN ACCESS
Aggregate Function Error
Secondary Sort for Union Query?
Using IIf null statement in a query
Query coding with variable criterea entered from a form
Simple Queries
Result of subquery sum based on fields of same record
case age
Union Query
Display Counts of records per day
Matching rows to columns
Max Query with 2 Tables Problem
OLAP CUBE ERROR
Date/Time conversion
Why can I not format a calculated field in a query to Currency?
SQL Statements
subform based on crosstab query
Criteria question
Query Issue
Seperating parts of data
creating a report from a query
Need help with following SQL... anyone?
Error Received When Appending
help with referencing second database please
Matching results in query based on periodically updated field
Calculating days between dates
combining fields
SQL Inner/Outter Multi-Join
converts secs to nn:ss
Ole DB Connections to SQL server
Pull Field name from a form
Problem with date parameters in union query
division is zero error in query
Creating Query from many to many relationship
Get a list of months spanning 2 dates.
Generating an ID
Read-only data
Unique Records
Problem editing a query based on another query and table
make-table query
Union Query Help
Pick Keywords
sql question
Calculating the Difference between two times/ dates
Query 1 Field from specific lines.
Display count by day
Query help
Rotate table help
Access Query Problem
RE: Rotate table help
Combining two fields in an update query
Microsoft Access 2003 queries
RE: Access Query Problem
Switchboard Form Not Found
sql aggregate product
Comparing 2 queries
¤ China ZhongZhan Aids Mei Mei
¤ China ZhongZhan Aids Mei Mei
criteria parameters
Counting Date entries
Aggregate smalldatetime fields in stored procedures
expired data
Subtract Workdays
Max of Date with/without grouping?
Incorrect query result????
Calculating Rolling Usage
Editing Query Data Problems
Display report for nominated client
Display report for nominated client
Using a parameter query with date and time
Deleting rows from a table based on a concatenated (composite) key
In MS Access how do a only show the 19999 of 0~19999 in a column?
delete query
Parameter Queries - duplicating parameters
Count in an Update Query
Dates
date criteria does not work
ID items in one table, but not another table (Access 2003)
Rolling Time Periods
Subquery & Text
Customize Sort
Batch Queries in a Pass-Through
Troubles with a parameter query
"Incremental Values from a Table"
Nested IIFs
Type mismatch even though types are the same
Query To Delete A certain # of records
Help on data query
Using Right(X,5) Command in a query
Select query records between dates
ODBC--call failed
Filter changes order of records
Query Help
Using a function in a query
Append & Update a table
Macro Error
List Box Criteria
How can I count records from many tables
aging query and report
Update query with date range
Counting Personnel on Leave
Access data truncation error with decimal data (error 3759)
SQL Statement (in Access)
Query very Slow
count from multiple tables
Delete Query Button on a form
Updating criteria in queries
Auto Lookup Query is impossible with Multiple Primary Key???
Calculate a number using a specified date and another number
Ink
Conditional Formatting Query
pulling random record (when running query?)
Re: date and currency
Ink
installation
Delete Query Problem
Removing duplicate entires from multiple queries
Update query on more than one table
I' unable to uninstall a previous download of Office2003Trial.
Date question
Query Optimization
How to give users a list box when running a query
Problem with UNION Query
security
Query Problem
Query Problem
Query problem
Union
i need help with access lookup wizard
Help with query to select the maximum date from a query
Problem writing a query to check table vale conflicts
criteria in crosstab query
I need help in making two queries into one query
Query to add potential nos to list in Table
Combining two tables to a third new one
QueryOfQuery with ColdFusion MSAccess - Select title first letter only
adding based on certain criteria
Append query
Taxes Please help?
True or not true, Sum
¤ China ZhongZhan Aids Mei Mei
Calcuated field does not return correct values
linking
Same Week, Different Years....
Need help with a query displaying a "No" in one or more fields.
querie using short time
Is it possible??
Syntax Error when importing from Access to Excel
Update Query
Query with multiple Not In criteria
Want query to output a word instead of the field
Improve Performance
How do I use TOP in my query?
Query or Macro to break large tbl rcds into smaller tbls to export to Excel
MS Access Query - Selecting Certain Entries In A Field
How do I count multiple choice question letter answers?
Determining a Status Based on multiple rows in a query
TransferSpreadsheet fails (error 3027) if 1 record returned?
MS Access Query Issue
Append & Update records from queries
Help string Parse
Create a table from a query
Problem with SQL Summing a Date/Time Field...
HELP!!!!getting Null value when criteria "Is Not Null"
Dynamic Column Heading/Field Label
Data Type and queries
change to UPDATE query
Query problem
Consolidating duplicate child records
SQL Where clause
Help with SELECT
SQL 2005 ORDER BY is ignored where form is based on a view in a AD
Ranking records in sorted list based on expression
Min & Max Values in a Query
Parameter Problem
can textbox with =AVG() be edited?
error selecting duplicate records in Access
UPDATE with a SELECT - is it possible?
How to do != "xxx" in access 97??
how to avoid slow count function
Grouping Records by Household
Assigning an Alias
Getting the SQL text of an MS Access Query in VBA
Ranking visit dates by individual
Help FInd Syntax error in short Query?
Call Stroed Proc Oracle from Access ADODB
GROUP BY query
yikes
MS Access: Group By: Allow random selection of value in a field
2 one to many relations
Parameter box from criteria
Append string into OLE object field
Select statement from VBA codes error
Query fails for only one user
query problems
Grab Month and Year from a date
RE: Grab Month and Year from a date
insert frame value as query parameter
Lookup in Query
how can I extract one character from field content
Query from form?
I'm trying to add a zero to the front of a field
Select Query
what is error code 0x57E
Access Query Specific Character String Select
"not like" query
How can I...
how to manipulate data from a control field in access?
Criteria in Query/Form
record counter
which type of query
Locked Fields?
Day function running on following day instead of intended current day
query differences
Restricted Update
Restricted Updating?
how do I renumber a priority field
Too few parameters when executing query
Query with memo fields
Entering current date in input box
IIF Statement
please check the syntax of this query
insert a row with next available id
getting the employees that work on project 1 AND 2
Linking fields
Changing queries by code
convert to 4 decimals places
IN external database - Read Only table link & security
Append Query Help Needed
Remove "Mr. & Mrs." from field
Append Query Assistance
delete specific data
Building a query to add 2 fields to an existing table?
counting and sorting dates specific
Expression in a query
Copying Data?
Query data into report
Build new row, consolidating columns...
querying date/time
Extracting first 2 words
Change Field Caption
Extracting records from a table using a date
Query Criteria using a Time Field
how to use a created column data in a where statement
Error Message
Access Query and PivotTable View
Access Report Completely Disregards IsNull in Order By
Need help with Query/Form.
openform using criteria to link by date...
Sub Query
All users from one tbl not in another tbl
Dates to reflect Fiscal month
Date calculation
Need some help w/ a query with 3 tables
I need a message box that will notify me to run an update query
Update FROM a Linked Table
Reformat A Field
Daily breakdown per week
Instrings
Append Query
Record the Record Number in A Query
Word Macro to Clean Up SQL
Partial Update Query Using the *
Assigning Values
"Too Few Paramters"?
I created a monster
delete query
When running a match query, my results reflect duplicates
How to prevent entering older dates
Help selecting an additional field in my query
select sum
Select query using a date field
Concatenating fields from multiple records
Query (expressions) where where I can receive 1, 2, or all records
SQL dosen't pick up local date setting! Is MS going to fix this?
Creating a query that creates rows based off a formula
How I do use kind of "Round" in Queries?
SETVALUE in in Macro for subform control fails
How To Calculate the Total on-the-clock time, by Month, in MSAcces
Return 1st Client Meeting
Help with logic on a query..
Datediff - make results permanent in table?
Splitting data into 2 columns in a query
What expression can change Hogsback Unit 34-9 to Hogsbk 34-9?
how to use the AS keyword
Help in pulling data out of a table
VLOOKUP 1 VALUE
some query help please
Using Access to Populate data in Excel
Merge two columns
Operation must use an updateable query
query parameter combo box
ERROR: Not enough space on temporary disk. WHY not?
creating a Select query w/ partial name input
Equipment Utilization
How do I find fields with missing data in a query?
list all records in table 1 even though no record in table 2
internal error 2349
Query too complex
formatting text to number in query
Not enough space on temporary disk - why not?
Update multiple records based on most recent record
Query Question
Or Like "*VIN*"
Converting a YYYYMMDD field into 3 fields YYYY MM and DD
Rich Text format not working...
Faiure of LAST function in in a Query
Filling in values
Getting error: "The expression you entered is too complex" in quer
Attempting to run An Append Query
Retrieving weekly totals from MSAccess
Editing restrictions
Gift History- from 2 Tables; creating 1 record per Customer#
How can I query to find the most current date in a list of dates?
Problem with IIf in query
parameter query in list
Filecopy problem
Criteria on a concatenated field
Delete query won't delete
Parameter Query Errors
Date query - simple
Date Query
crosstab query in access
Conditional Expression
calcuated fields
start and end times of worker in a day
Query to list all accounts with latest date
Upcoming dates
Need the results to be the UNmatched records
Update Query Must Use an updateable query
calculating text
SQL Stmt
functions in queries
URGENT-delete few characters in a field
Using Parameter Query w/ dates
Queries on how to add potential units to a another column
dlookup different table?
Change field data type using query
Building an expression
Query by dates
When Filtering Query - Query returns no records when there arer matching records
Query a Column of Data to a Field NAME
need help.. newbie....
unrecognized database format
Making Columns out of rows.
The best club for muslims all over the world!Have a try!!
Creating "dummy" rows
Simple query - compare 2 fields
Update query nighmare!
Parameter Query stops working when used as sub-query
Help with query for invoice report
Exclude Specific Criteria From Queries
Help Please
Help with running balance...
Can you help me simplify this query, if possible??
Sort query by ignoring insignificant words...
unupdateable query
Query results incomplete
Re: date and currency
relationship vss join
agregate function in subquery
Using Min() and Max() on column with both strings and numbers - can it work?
How to determine when somthing should happen.
display dates between 2 dates
update query problem
Re: date and currency
PARAMATER QUERY USING FIELD
Eliminating Blank Address Lines
How can I use data from a table as criteria in a query?
Query Ref Problem
LIKE Operator used with a form
Cannot get Between...and criteria to run
union query transposes values
Use query to change Text to Number
Grouped Query
Weighted Average - Access DB
changed queries save automatically
Query to table
Why doesn't this work
Running Total Error
creating field with blank data for append query
calculated field question
Create New Records in a Table by Copying Existing Records
what is wrong with this text expression
Fuzzy Match on two tables
error on IIF
Create a running Balance
How do I return display portion of hyperlink in union query
duplicates in query
Find the Maximum Value by Date
Resultsset order
duplicate records
Help with an IIF statement in a query
Newbie: Counting of groups of items??
Join queries
DUPLICATE QUERY results
Duplicate Query
select data from 2 Dbs in code?
Append Query
Allen Brown
Make Table Query (Hide output)
Dates, Quarters and counts
user permissions
Append Query - Number to Text
How do I run a query where the results table will have 392 fields
Compound IF Statement?
Access equivalent to Excel's VLookup function
Changing Report Dependency
Finding records
Can I "flatten" out a table
How to create and/or combination queries to display in a form
Return all data plus gaps in data
restrict field size in make table query
TWO iiF EXPRESSIONS
SQL too long?
Case statement in MS Access
opening report is askiing for parameter value of subreport ?
Formulas for Beginners
Need help setting up first query
Need basic query help.
How do I add a new industry to my database?
Summing Problem
use query as field controlsource
Joins in delete queries
Find missing or duplicate records by date
Creating a query that returns (one / multiple) records from two parameters
Combo Box Not Working
Undefined Function - MS Query
Rolling Year
Linked Excel table to Access - can't edit the Excel table - Why?
Run 1 query on many tables
Error on A Query
Unable to run an Insert query
Unable to run an INSERT query
Summing in a Query