Queries [Archive] - Page 99 - Access World Forums

IIf function
Disappearing fields in Query Design
Can I Use If In A Query?
Stuck with my database
Is Iif statement the right thing?
Missing number query
Rename a field in a query
totals query help. maybe simple.
Getting #Error in linked query
Query gives different results when run through a macro
Query that Creates Calling List
Negative balance
switch or sql select in access
Iif statement for 3 alternatives ?
QUERY PhhhLEESS QUERY......
Dates in query..HELP
Find Duplicates - Transposed Numbers
DLookup error
doubts regarding SQL queries for oracle tables linked in MS access
matching dates problem in query
Date from DateTime field
Transpose a Table to be used in a report
Need help regarding calculations involving different rows
missing field data in subform
Append query - avoid duplicate records
What type of query do I need for this...
Formatting date into text
SELECT statement combining field data with text string
Best Practice for Selecting Random Records
Use Expression as Column Name
Need Query Help Urgently Please - criteria formula needed
Loop Query
Fixed Asset Database Audit Query
iif with multiple criteria
setFocus & Inner Join glitch...
Filtering a Query
Returning a number between two numbers
switch vs nested iif
Crosstab Pivot from parameters
Complex query help needed!
How to separate a field with parentheses?
Referencing other calculated fields
Time confusion
Help in running Sum....PLZ
"Make Table" Query : Do Not Allow Duplicates
complex count and compare query
Retrospective Patient Census
Date criteria in DSum Function
Return fields from the same record in a grouped query
Data Access Page - query with null parameter value
populating all matching fields with a number
A Simple Task?
Binary AND in Query
Unable To Update A Value In form WithQuery Source
Qry Based On CboBox Blank or Specific
Why is this "not updateable?"
Query number range or single value
i have a good 'schema, where do i go from here?
like use
Simple Question
Data type mismatch in criteria expression - but no criteria...
Select from two tables
Search Date/Time Field Using Date Only
Retrieving all results in a query that is based off of queries with criteria
Total: Max and Min
Incorporate data from one query into another
Query using a partial match from one table and pulling in full details from another
Or in Query expression
Number field in query
Access 2007
Query that return a fixed set of results and format
Turn Off Warnings
Query on form using input from text box
Pulling Customer Table data into Bookings Table input
Multi-Select LIstbox can it be searched easily?
updating data
Update query problem with nulls.
Microsoft Access Query To Build Relationship
DCOUNT not working
Change text to date format
Find record which does not have corresponding record x
Query that has no duplicates in one field
Query Criteria - If not blank
yet another APPEND query Key Violation...
A complicated query leading into a report problem.
Calculating inside queries..
Make Table Query not inheriting data types
Require Urgent Help Regarding UNION and SUM
Question about building up XML codes inside Acces.
Crosstab query for 7 days in future
Help with Date / Time quey
delete from one if is doesn't exist in the other
Updating tables
Calculating Holidays
next 7 days
SELECT DISTINCT and ORDER BY
Group By on Pull Through Query
Select In problem
Select FIRST word
Linked SQL tables marked as unupdateable in Access
Dates
Using 1 set of criteria for many queries
Query to find duplicate records
Averaging out fees without creating customized queries for each instance
Category vs. Company
Error in query
Query missing data
syntax query
MS Access - Between Dates queries using variables from forms
Splitting alphanumeric data
Is null is not null and then
Updating A Table
Row string values convert to a single array
Access 03 vs Access 07 Date Query
Querie to count values on 2 tables
Pivot
MS Access - can't deal with recurring numbers?
Consolidation
Crosstab Query Problem
Changing column justification in queries
Comparing Data in a Query
Query data for Monday through Friday
Combining Multi-step Queries - best practice
MRP database
delete records from multiple tables
SQL Prompt for Input from Form
counting accross a row in a query...
Query for Records With No Associated Records
Currency Formats in an append query
Creating a calculated field in my pivot table
"Similar beginning" Criteria for a query
Subquery query (aahh, what a horrible pun)
Update Query
Compare column values in cross-tab query
Query Criteria and Function()
Simple two table join select query but..
Executing INSERT INTO Error
Query Criteria Help
Query Based on Two Tables ?
Duplicate Information
2 min Help Needed very simple 1-Table 1-Query
How to fill in blanks in staggered index?
query for listbox criteria help
Another Recordset not Updatable question
Date Query
Cross-tab query parameters: asking, and asking, and asking, and asking...
Averaging Records thru Query
Calculating VAT
Textbox query question
Formatting 3rd column based on 2 calcuated columns
query result confusion
Date Query - Ages?
Adding a drop down list to the criteria in a query
Update Table using data from Query
Query a lookup field
'Contains' problem
Union Query - Date Parameters
Data Type mismatch
New to update queries...Operation must use....
Query Formula Help
HELP!!! OK - Sql Intert statement into Access TBL
Query keyword from table, need it to tag result with column keyword was in
Query not showing newly added records
Query to exclude simular items
Query for latest date for each equipment item
Please help with my UNION Query
Graphing differences in Dates
Name Query
2 counts in 1 insert query
Number of Working Days left
Have Query Return Data Unconditionally
Calculating Pregnancy due date in Access 2007 or 2010
filtering survey questions and still be updatable query
info from 2 separate queries
Using a query to combine multiple lines into one.
Need Query - Form Relationship Help
phantom "Enter Parameter Value" popup
Adding Colums Error
IF statement in SELECT query?
Summing across dates - Query Help
How to get selective data to show from multiselect
Cross tab query - turning null to zero
Append two matching tables - Horizonally
Long Date Format sans Day of Week
wild card
Ratio Calculation
Is there a way to put IIF statement criteria into a table?
Draw out data from one column
Sum only unique records
Crosstab Query - Help!
Problem with Group By
Sql query to test you, Im having trouble with it..
SQL query
Expression between two rows in a table
Help with append query
Docmd directly run an existing Update Query
Table results multiple distinct rows
Dating records based on user input..
Changing record configuration
Trouble Joining Queries
Counting Records in a Query
How to make an expression look into the appropriate value
Seperate the parts of a text
Calculations when values can be zero
excel Between[]and[] query only works if not saved??
Snapshot Queries take very long time - any suggested steps for troubleshooting?
Attachement field in UNION query not possible ??
Query and Graphs?
How do I pull only records with this criteria?
Delete specific records based on specific criteria
How to compute 10% discount for select items?
Query takes time due to formula in query
System Resource Exceeded
Attempts Per Season
Export to Excel
Parameter query as forms record source
Null values in Crosstab
Update table referred to in a query
Query with counts, '0' values, and a calculation
"enter parameter value" window in query, didn´t appear in access 2007
Help...Access 2007 crashes when I run my query
Update Query
My fitler fields used to predict entries and now they don't
Pass-Through Query and MS Access Table Queries
Weekdays left this month
Easy JOIN or UNION Question
Working Out An Average
Number formats in a UNION query...
Basic Help Needed - Query Results
Access Help window
SQL Statement I can't figure out :(
crosstab query calculation problem
Criteria from a form
Do Not Allow Edits on a Query
Edit existing query by vb
Format
Counting Categories in Columns
Parameter Query to display just selected column
Query: Total Attendance.
Getting date from various data
fields not visible in query design - Urgent
Query numbers ??
rnd giving same results every time
Can anyone spot the problem?
#Name? linking a query result in a text box.
How to connect table with an interface?
Adjusting the field label size
Multiple IIf statements in queries
Counting multiple fields
Remove single qoute in the data