Queries [Archive] - Page 109 - Access World Forums

Append Query: Making too many records.
Query Not Showing All Results
Queries with spaces in field names
Auto-append query
Query by range between start and end date?
Query with optional and must criteria
Query from Data in Combo Box
Cannot Record Changes Because A Value You Entered Violates...
Update table from other table and random selection
Protecting data in simple query
Query to find 'orphan' records.
Calculation in Access
Tallying query
Compare records with Excel Sheet
Record1 to Column1, Record2 to Column2?
Query only newest input
query that runs a number of times = input
Help With Queries
Updatable Query
DDL to create table field validation rule
Super Query
Combine records
correct data and generate report
Join 3 or More Tables and Apply OrderBy
Calculating columns in crosstab query
Auto renumber after I delete a record
Books on SQL
Problem referencing form control in query
square root in acess
Iif statement
Convert normal db results TO un-normalized flat file
query - for how many days consecutive change is happening
Form Field Reference in RowSource
Nested Query
Group By Month and Year as well as Count instances
Access 2010-Combining Make Table and Append Queries
How to pickup a data???
complicated Qry
Top values as a parameter? ?
Compare Data on 2 Tables
Check boxes in queries
Date and time
Zeros in crosstab columns
Union Query
Multiple conditions in a where clause
run time query export to excel
Acces Lookup
using a form to put items on a report
Column Comparison
Customising Order Values in Query
Using SubQuery to find 0 Sales Stores
help with query
Simple query wont run properly - PC setting?
Query criteria select between two numbers
Previous record of same recordset
Left and right join question
run query
Button to generate InvoiceID and save it for specific records
Delete query with multiple tables
Simple SQL
Work Days Difference, Need Same Day = 1
Query to concatenate fields and then insert into existing table
Need help creating a query to find film reviews by name, without changing structure.
Query is showing auto number key field rather than data - help
I thought this is simple!!..pls help
Parameterized query as datasheet
CountIf Query
Query to Pull Data for Specific Day of the Week
Update Query
Copy or move a record to another table
Query equal to a specific instance
Iif or help
Finding a particular record
Record specific query
Number to Text Format as hh:mm in Query
Capturing Error when converting to Date
Instring function in Access, extract first two characters
Append Data from Users
opening balance in access report
records in month a year ago?
How to fill Null value="Absent"
Help with Multiple-Valued Query
Create a query to remove duplicate records by choosing the highest order num
help with queries
Query not finding all data
Date and Time Issue
Querying a Blank Field
some access security questions
Query 4 fields associated with identical drop down lists
Date compare issue
Creating a Query to list all Months and Years from Jan 06 to Present date
Date range query
Return Max Date before a certain date
Query using operator <>
Legal Pleading
Is Null criteria in query ignored by report
building a query.
Dcount to Rank but ignore a zero value?
Blank return
query math
Using Iif statement in query criteria
Update Query
Update Query - Update Duplicate value from Single Matching value from another table
join 3 table query with
Make table query -> table name to be the parameter
using wildcards
Crosstab query calculations
Running Sum Problem
Close a Query with no tabs?
Multiple criteria
select query
Data Type In Calculated Field
"Type in mismatch in expression"
Convert TSQL query to MS SQL query
Get last unique number from a field for each group based on another field and adding
Urgent Help: queries between two tables
Crosstab Query with "EXISTS" statement
Converting excel formula to access
Update query with Inner join
NEWBIE - confused as to how to configure query structure
If statement for select query
Query Criteria Parameter 'Like Iff Between'
Pass-through query error "non-fixed-columns" for subrebort/subform
Relationships
Multi-table query returning only stalest record in child table
How to filter an Add/Edit table form
Calculating Sums in Query
Query Criteria Assistance
Excluding Records in a Query
query format
Update Query
Updating the next n number of records
Expression Assistance...
Comments Field
Crosstab Issue
Help linking Null fields please - new member
Query based on subform combobox
Surpress Append Query Pop Ups
Append query key violations
Help with SQL query in Access
Newbie with MAJOR HELP needed on this query
Replace a Zero value in a cell with 4 digit string
calculated field to display numeric data from combo box as text
summing filtered rows from query
Function in Query
Creating a query with a self-dependent field
Query result not correct in Access but correct in Excel
Round function
+1 in update query
Can someone tell me what this error code is?
Query returning multiple results when record includes selection from a combo box
Moving Average
Duplication Issue
valiadation rule violation (again)
Query to find things that don't exist
Using a query to substitute one record with several more detail records
How to make this query more efficient?
Primary Key Violation
Date Calculation
Subform control query
Pass through within a pass through query
syantax error missing query expression
Update value with dcount
Why do I get a parameter prompt?
Update Query not doing a Find/Replace for me
Queries to calculate and compare across random table values
Linked Tables with Wildcards?
Problem with Switch
finding items, if not found, message box
Gathering data from a calendar query
Ommitting blank values
Need to calculate difference from cumulative data
Form to enter multiple query parameters
replace value if less than certain length
type mismatch with DLookup
How to get query input from second source if first is blank
Sums within a text box
Crosstab(?) of software installed
Crosstab search
Checking requirements from one table against approvals from another?
Exact Date Criteria is hit
Query Giving Wrong Results
Need to count number of distinct values
Converting Oracle code to Access
Append Query
change date format
Append Query - IIF statement
Search for specific format
Date Time Query
Date and Time
Query to update table based on another query
Trying to populate listview with secondary table data
Update Command Error
Update Query
Simple Query Summary
new records in datatable don't show in query
Query with an input mask [Password]
Case Sensitive Query
Quaries
Looking for specific information in a string
Data Type Mismatch in criteria expression
Crosstab Calculations
Quick Help Minds Forgot
Field with tricky lookup in query
Multiple Condition where Clause - Not working
turning column to row
Remove Time from a Date/Time field
Subtracting minutes from Date/Time
Combining Multiple Records into one field
How to add a blank row to the top of a query?
Change Parameter Box Title
Update Filed with Percentage
Query: Not commands
DateAdd along with CASE query
If you need to post a picture or database before 10 posts...
Complex Query
Query to sent email notification
Monthly reminders - Need a little help
Autonumbers
Access the correct program?
Need query to only show rows that contain data
Query on Dulpicates- Need some help!!
Query efficiency, alternatives
Using * or something simalar in sql?
Query using AND and OR user input?
How to segregate-single out part of the date field (month)?
Counting two fields from a query, using a query
Query Help
EndDt Production where not in Staging using Staging.LoadDt
List all the constituents of a Group in another column:
Can I do this with an update query?
Query Last 60
Query column return denoting records as top 80%, next 10%, & sums bottom 10%
First customer record only
relationship and primary key problem
Date and time function
Concatenating Date & Text using Currentdb.execute
Making table
Repeating dialog box
Missing data from query
Dividing time by a specific number
Start and Stop times where condition true
Expression not working in query
Pass Through Query to SQL database
How do you make a Query show when you need to call someone back?
Open directly SQL view
Update Table based on If/And
Loop to assign value
How to pass a column name as a parameter in a query
Date Range with Partial Overlap - Is This Possible?