Queries [Archive] - Page 80 - Access World Forums

Append query nightmare!
Using Combo Box in a Query to run report
Custom dialog box+query link with a 'where' in total
pass parameter from table, yes-no does not work
How do I get around this one?
Elapsed time
Help needed with update query
Append Qry - destroys d/b
Fill listbox if a form date falls between 2 dates in a query
Find unmatched records
Show a record for each side of a join
Date of Max Value
MS Acces Query Help needed
Count doesn't work
How to create a teble from a query
Queries - Dates
Days since last entry
Serious help needed!
Creating a Calculation in a Query
Query / Function Problem.
append multiple tables
something similar to sumproduct...
Multiple Table query
VBA Query with LIKE won't return data
Recommend a DELETE method?
Query for Adding Duplicate Fields
SQL Question - OleDB from C# Application
Strange query problem using dates...
Queries - Strange Date
Search Exact number on Query
appending data to a queries....
SQL help
Query within a Query - is this possible?
Dealing with dates and null values in parameter query
Removing Left and Right characters and getting only the middle characters
Time Values
Queries
Parameters, convolution and multiple query calls
Basic stock control problem
IIF Statement with an Or
Append to a passworded database?
Booking Query
Report running off page
SQL Group by problem
Allow only 8 characters in Query Search/Parameter box
Query criteria return no records
Insert into table
Statement ageing date totals
Query 3 tables - Sum quantities and return range of prices
Variable column Crosstab query
Merging records with same address
Query multiplication of null fields
Can someone help me with this update query?
Please help me decipher this code
Append query to parent and child tables
Converting #error to 0
If I can't aggregate....
Weekly Totals in Crosstab Query
Crosstab Query Buckets
Missing Time periods
Multiple SUM(Column) on different table at the same time
OutPut of quries1 = Input into Quries2
ODBC Call Failed (3146) - but only on some PC's!
Automatic update of field names
Query problem
Thoughts or guidance on the structure of a query?
Counting consecutive months in Access
How can you search for a specific character from a string.
Update logic field with Update query
Data parameter value issue
Multiple Table Query - Duplicates Messing Up Count
Excel help (SUM IF formula)
IIF/IsError sql Combo still returning #Error
totals query does not show zero and currency format
Counting Distinct Values In A Query
Search Criteria Month Function
Acc2003 - SQL updateable Passthrough
replacing null values with a number using query in desing view
Lookup in a Query?
Help with criteria for subform
query with calculation
Help Me Pls Here! Thank You!
Help with query
Converting dates to week number
Simple query and yet won't work?
Combo box not passing Parameter to query
Getting First/Last Values from a query
Query to create a new column for each week interval
How to display date into required format
Counting Consecutive Months in Access
Append Query - 2 Issues
Forms,Queries,Macros..
Selecting all from combo box to use as a parameter
How to calculate average time/duration?
Pass parameter to query from a table
DB in Read-Only
adding travel times without regards for timestamp
Help with using not like in parameters
How to convert Number to Time in Table
Please help me organise my DVDs !
Querying a date and time stamped field
HELP NEEDED: Running Balance with Data Containing NULL
Deleting all the data in a table
Criteria the day (Today)
Sending Query output as password protected XLS
Simple task for you pros I am sure
key violation error
Help creating a running sum based on a calculated field in a query
Select Query referencing multi select list box
Hi, Pls help me about this Update Query
To Do List Query
Query to change table columns
Trouble with IIF and time
Show only record with latest date on subform
Query - pull entire prior month
Updating a field, when records match
SQL - problems editing
Count Days Between Two Dates and Exclude Weekends
Creating a user friendly Query/Form on multiple fields
comparing dates
prepared statements
Getting values from a column A that has same values in column B and C
Date today to end of week
How to find privious month,day,week,qtr data
Hello! Pls help me in this update query I have.
creating a form into a query format
Convert yeardays to year-month-day
Force empty columns in a crosstab query
Query to Create Record with next Autonumber
Measure Query Run-time
Joining two large linked files in Access
Query - Tally date
Removing All Spaces Between Data In Text Field ?
Multiple Queries and Null Drop Downs
Multiple queries returning all fields
Access TRANSFORM (Crosstab) Queries and Missing Rows
joining information in two tables
comparing data in two tables
invalid argument. anyone know how to solve it ?
Pass Through take long time while save in MsAccess
Calculate the time difference where a number of users are involved
Reference to main form in append query
Consolidating data?
Between Dates Query on Multiple Fields
if condition
If the string contains a text Value
about queries
Select top statement
updating text field with numeric value?
Edit data in Query's
Displaying a calendar in a query
help with query
Searching query based on searched query.
function in query
extract records using list of "keywords"...
Selection list of Mondays
While statement
Query Help! (two tables)
Max Date & Time
how to substract total of groups
IIF & IsError in combination always give me "#Error"
help with update query please
Working days/hours in a query
use concatenated expression in Instr function
Display last 12 weekdays data
Updated Table with External Data
Previous months in months order
how to get data that crosses two dates
Extra criteria
Using another date as a criteria?
SUM between two dates
last 12 Business days starting from today
Updage Query Problem...
Displaying a Query Result in Form field?
Count Number of distinct students seen by each tutor?
Date Filtering from my form
Update using WHERE EXISTS
problems with splitting date and time fields
Calculate money spent =<200 for customers during 2008
Unable to Delete a Table
Query to find different between 2 tables.
Sort a calculated query into descending order
IIF Or
Combine several fields into 1 Field
Joining Fields shows duplicates
Criteria Current Month
User-Input queries?
SQL Union group by problem
Append Query through Macros
Question
ADO and Where ((table1.colum1x <> table2.column2x) is Null)
Automatically creating and updating a form record
data type mismatch
update query data type mismatch issue
Different results in query
order query please help
Counting Days Problem
Brackets and Exclamation Points
Calculating average time help
Passing value from text box to query
NEW & DELETED Records Query
Query Returns when data mis-matched
Dynamic Pivot Header in SQL Query
Simple Query I am sure - but I just can't see how!
Wildcard in Query
Query with variables as dates
Simple Query Question?
"In any calendar year" as criteria
Query displaying Dates withing one year
Update SQL in VB problem
Syntax to refer to combo box in query
Query returns no results when expPilot is added
Newbie question - How to show all records in a query
retrieve unique entries
How to do dynamic counting in the query?
appears easy (to me), appeared difficult (to me) : Query
Currency Field in Query
Counting 0s
form based parameter query with multiple values
Update Query question -
Loop and Append Text to a Memo Field
problem with using <>
Strange!
Query on field name and primary key
Querie using check box
limiting a look-up column based on current row data
=( why is this Data Mismatch?????
How to search every field of every record
Queries select rows with chronologically updated value in one text field
Displaying weeks with two digits
SQL Statement correct - But not returning results
cbo RowSource Query
Sorting records with a query
Staff count month on month.
Quering and re-Quering aint working !
Date Query
Help with expiry flags
Update queries and record locking
vat % calculation from a record
Top X Query
Update a Record From a Record in Another Table
Getting a query result by comp'ing a date in a child table to a # in the parent
Combo Box Select All Help
Confused trying to produce results in a query
Help with Access/SQL view syntax please
Covert english date format to fransh date .Use of Order BY in access 2000
Null Values and IIF problem
Calculating time in a query
Caluculating the percentage of sales for individual items
Simple Query Help