Queries [Archive] - Page 58 - Access World Forums

Create a query in code
Help with query expression
How to automatically insert criteria in a query.
What's wrong with this formula???
Rounding numbers
Criteria For Calculated Field In Query
DSum not working properly
Show multiple fields as one, for searching purposes.
Another Q about date intervals
Changing Text in Queries based on Date
using row source
keywords needed to populate db
Help!!!!!! Please!!!!
display top 50 records
Double click to extract all records
Query Search Help required
Criteria For Parameter
Merging tables
display parameter value
Help designating a description to a value...
Select records from one table that does not exist in another table
Working with dates
SQL Query to Create Summary
Query Help
Querying SQL Linked Tables
Trim like an excel mofo
Help with query (make the months go in order)
Update Query Help
IIf Function - False condition problem
Getting rid of multiple records
Referencing a subform within a subform
Top of category
Help with append query
Need assitance with inserting dashes
Fiscal Year Query problem
Selecting existing table name using form's combobox for a query
Export Access Query to an existing excel file specifying range
Purchase Orders and lines - how to make the sorting of 1 field dependent upon another
Update Date with business day
Query records with todays date but I NEED the time included
DatePart and Between...And
Merging two tables and totalling
need help finding lower case characters
need help finding lower case characters
Replace in query
Addition Query
help please ???????
Not getting null values
Find Unique Products to Specific Build ID's
Problem With Double Join
Copy part of a record as value in another field
Txtbox ctrlsource = query question
SQl query or function
Displaying Accumulative for each record
Look up name from login
Query by Form
COUNT Query problem Please help! XD
Make a query look nicer?
Make a query look nicer?
query with dates, ...help pls!
Convert a Row to one column.
Queries & Calculated Fields - Headache! Help!
Question on MS Kb article - updating and appending records with one update query.
selecting fields
Consolidating multiple queries into one single result
Exception
Copy Queries
appending 0 records
query blank cells
How to sum two fields
why would this happen?
View only records of the current year
Display data from two tables in query
Help Needed
Counts before and after today
Grouping and Top 50 Records
How to move data from one colum by data position to other fields
Change Query Based On Form Fields
creating summary of data
Connect to a Text file (.txt)
Making a query that can extract 2 closest column values
Combine Records - Please help me
Help with new query
Please Help - I Give Up!!!
Compare
Error adding hours
Help with SQL code
making join between numeric field and text field
Running count in query
Want to see only those clients who has email id
Little help to finish a Create Table SQl Query
consolidate 3 queries down to 1, possible in my situation?
concatenating the many side results into one result
Having Trouble Sorting...
fields different from form to datasheet view
Figuring a start date based on end date and hours
Query Different choice in the same fields.
Fairly new to Access with a question
Pulling my hair out
A query to SELECT a columen within an interval which conatains TEXT+DIGIT+TEXT
Two queries / one report
Is this possible?
Rookie Needs Query Date Field Help
date and time criteria
Pulling No Data
ACCESS - Easy QUERY (Help)
DOB to Age
Need help on making an expression (Simple)
Insert rows skip duplicates
Simple Query Help
Select data from double clicking
GroupBy / Max ? (newbie alert! :-) )
Printing current date
IIF not returning data - if "false", should return all results
Birthday problem - Help me
Help with 4 digit numbers to date format?
Can somebody help me debug a problem?
problem with deleting
YEAR Query
help with query
Selecting two items from a single field
subtracting date/time field from integer field
Query - Extracting customers between two dates
Problem Using Query As Source
exporting dates from query to txt file as string
IIf Help - Is Open?
limited records past date
Inner Join and Left Join
conditional from 2 tables in query
Help with SQL Join Query
Another Median Query
Inventory Queries Help
Criteria search in a query
Eliminating several queries that do the same thing?
Total Data In Fields
Calculating Time in Queries
Search within MS Access Queries
Simple Query Help
Partial Dates
COUNT() and DISTINCT functions help needed
query by form issues HELP PLEASE!
does it include [date]?
Remove numbers in middle of field ?
Update Query
Query for certain Characters in a char stream
Generate Sequenced Numbers For A Report
Unmatched Q problem
GroupBy help plz
Querying multiple Columns
Display a Null Result in a query
Vertical Text Direction/Orientation in CrossTab Query
WorkDaysDiff problem
Query result as Email subject
Sign Problem using Time
Query Map
Finding The date Of An Enquiry
Exporting to Text File
Leading Zero in Week of Year
Complex duplicate entries - how to flag up etc.
Need help using expression functions - "right"
Update Query - Operation must use an updateable query
Problem with Grouping
Cannot delete records
Getting the Max value after grouping alpha-numeric values
SQL query with combo box
A Structured Query Language (SQL) challenge
Adding Trailing Spaces
new colum
remove extra records
Generating Movement from Cumulative Values
Changing date format
Date Selection Help
Concatenating different records into one field by a sequence number
SQL Help
help parsing Name field
Zero Activity Query
Criteria to look up a field.
error when trying to insert query
Modify Query for a Report
circular ref??
Updating fields through query
Help Needed with Dates.
Query a query, where it is based on a form?
Data type mismatch...
Complex Nested If Statement
Modifying a Query
NOT Operator question
Sorting...
Sequentially number records
Running a Query with multiple selections from a List Box
Counting open events by month
calculating working date between orderdate and due date
Mass update or append
Month(Date())
Problems with expression
DISTINCT FUNCTION newbe question
Top 10 results from CrossTab Query.
Text to columns in Access
can't update [column1] /([column1]-[column2])
Search all records for a given month
Sort on total field in CrossTab Query
Automatic Count of field contents
Append Query
Need to update exactly 800 records
store multiple list box selection in text box
Max for each record
AND query, across related tables
Question on Ranking and Autonumbers (I think)
union query problems
Update Query Same Field Multiple Criteria
Date Conversion
Query to comine data into a signle column
Newbie question about date ranges
Question about searching for one date accross multiple date fields. Thanks!
Fairly new to Access - Can I do this?
Fastest Method for Append Query
Function for combining 2 string expressions?
Availablity check query
DateAdd Problem
Query Criteria to change with Search Terms
Multiple Queries - Certain records missing
How to select records based on summation of another field
Two tables, one query, no results
Updating query
Date difference in years, months, days
lookup in query
Only displaying Scrapped Items with yes/no field
How to Calculate times across midnight.
How to get a list of records excluded from a Query
Append Query Question
Count for week ending.. in different fields
Calculate commissions
Delete Query...Doesn't!!!
Show Zero in column instead of Blank
what is wrong with this query?
Problem with DISTINCT and GROUP BY clause
Calculate Average Waiting Time
Move GrandTotal Column to right of weekly Columns
Sort on results of crosstab query
Another update query
Min/Max and First/Last
A Mind Of It's Own?
error and cannot figure out why
count or sum?
I want to do a MINUS operation equivalent. How?
Count and Percentage
Case/Bottle conversion problem
How do I fornat this query?
Query Question
Multiple Effective Dates (latest date)