- V. Simple Query, not working
- Symtax Error missing operator ?
- Using IIF With an aggregate function
- help with rank query- everything gets ranked the same!
- Query not responding: empty fields?
- Date criteria in a query
- changing query to show null values
- Query with no results (Zero Count)
- Like / Not Like
- Multiple Source Query
- update query with subselect for percent total
- Count Multiple Fields
- Count Multiple Fields
- Pesky Parameter Dialog Box
- quite good gold ,look
- Day of week totals
- Day of week totals
- Hours Time Problem
- Question about format of a query
- Update query to add +1 to date?
- The Data has been changed : lock violations
- Querying for Records From Today till One Week Ago
- Plz help! Query for Summing individual records on their own
- Replace words in record that are described in different table
- Append Query problem
- Search
- Importing of data from Excel/Access to two tables linked by a querry
- Delete Spaces in text field
- Execute expression in query if not null
- YTD Values and A year from to day values
- Select Group By Having In (SELECT), HELP !
- SQL expert help needed- getting complex joins to work in Access
- SQL expert help needed- getting complex joins to work in Access
- Summing other fields per record
- Getting Checkbox to update visually
- Create multiple records based on date range
- Run query without prompt
- Selecting dates
- Total Count Of Sources Query
- query to calculate busiest day
- Query Address Help
- Counting unique ID's without duplicates
- Decode from SQLPLUS
- Using the Left function inside a "NOT LIKE" comparison
- Calculating Totals per Item
- Complicated table join with subquery
- Multiple Search criteria for 1 query
- Clean the records
- Query Job id selection vis text box input
- Very Beginner Question
- need to calculate weekend date
- Extra lines appearing in Query builder!
- Position, Automatic
- Parameter Query based on a ListBox
- Query not returning correct results
- Chart
- Counting words in a collumn on a access table
- Search Query Criteria
- How to find out all the tables contain a particular field
- Query Headings
- Simple Query
- ranking
- importing SQL instructions
- Filtering problemo!!!
- build expression for query
- Expression - want 0 results only
- Creation of two fields from parts of another
- Counting jobs completed by a vendor.
- Updating Email address in Customer List
- Simple Query, for you - not me
- Duplicate values
- expression using start/end dates
- Join on Fractional Numbers/String?
- cascades and datasheets, oh joy!!!
- New DB for me
- Struggling with TimeValue
- Count Function
- Recommendations for data retrieval
- Update query / Sql problem
- Grouping of data
- Update Query
- every record since #date#
- Crosstab query
- Query to do a Keyword Search
- Help! Query-report asks for "format" (?)
- Do Not Call Database
- Displaying relevent data only!!!
- multifield keyword search
- conditional formating of query
- updating Table
- Calculate days when there are 4 variables
- Date Query
- Calculating Daily Values For a Month
- Counting Zeros with A Criteria
- Empty field
- is it the queries or tables?
- Query help!!!!
- Pivot Table Query
- Query run the linked tables
- Running queries
- Retrieving values from 2 subforms
- SQL Wildcard and Is Null statements
- Criteria problem
- Help with Dates & values
- Query Conditional Criteria
- Trying to Combine Multiple Queries into 1 main Query
- Query help, transpose?
- Is this a Querie or Sorting problem?
- Query Question
- Find Missing Classes
- Minus <-> Union
- combine two sql queries - see example
- minus two values
- Filter parent data by child data?
- Query- Assuming wildcard if control is null
- Updatable query error
- Error
- Updating query flag if child records exists
- Simple qry using unbound textbox.
- 1 prob
- Simple qry using unbound textbox.
- 1 prob
- Return all records where an id field occurs more than 3 times
- SQl query for dividing a field
- Conditional Query using Between
- Setting query table to Number format
- Count Stages in a contract
- Converting text to date
- Converting -1 and 0 into Y or N on select
- Adding column values
- Barcode font with Mail Merge
- Need to display value from another table if current value is null
- Yes/No Field
- summing different multiple amounts with grouping
- Selecting Records through a form for a Query
- Make Table Queries and Concatenated Memo fields
- Date / Time calculation help
- Query selected fields from a multi-select list box
- Query updating a table?
- Union All
- help please
- Export and save into excel
- Couple of Newbie Access Questions
- Query over Query
- Number of Records Based On Table Value
- Appending Query
- Is this possible
- Update Data
- Delete Query based on another table
- previous record value
- Recordset update from combo
- Problem Changing Query Criteria
- Query - Search Engine
- Unknown Query
- Counting 2 columns/fields
- Fake Autonumber in Query
- adding "1" to the quantity from a barcode
- Query Criteria Is Not Allowed
- union queries
- Substitue a Null value with a Space in Query
- How to do percents ?
- Update query question
- Create a new table Ignoring dupes
- Set Criteria to Show 'W' if exists otherwise..
- Changing data source (table) for a query
- Finding missing classes, pt II
- update query error message
- how search within a field
- using if/else in an SQL query
- Criteria returning wrong results/WHERE clause length
- Where clause in a pass thorugh query
- How to make a reference to another column in the same query?
- SQL -> VBA Translation
- Pop up a calculator
- Help me please
- filtering duplicate records query problem
- Text Expressions
- delete query - simple but i dnt get it?
- Something Complicated?
- NZ Function Problem
- Union Query - create additional field / clear records
- Using IIf in Query Criteria & multiple table expression
- count query problem
- fix the expression
- Printing Querie
- Getting Count To Return Zero
- First day of week expression
- Help! Query Syntax
- --Is Not Null-- vs -- <>"" --
- finding max date
- Multiple field values need to be returned in ONE line
- How to sort by a calculated field in a query?
- Totals from Instances (not of instances)
- Application not giving desired results
- Append Records from an Access Table to SQL Server Linked Table
- Problem setting a Date range on my query criteria
- Using the Calendar once to update all records
- Number to Date conversion
- selecting data from 2 fields input into 1 field
- Criteria Query
- Qry to accumulate values doesn't work?!?
- SQL to search multiple fields
- Create a "this month" data query
- Last 50 records
- SQL question
- Hour of day calculation
- Parameter Query or other option
- Help
- Query with LEN function
- VBA Login to pass Criteria to a query and the Dlookup
- Subtracting a column from a column
- Trying to update field based on other table
- How do i count date fields?
- Using IsNull
- Query Terminology
- In need of advice
- Calculation/Date rang problems
- Update all records with random value ?
- I need Recursive Query Structure
- Days lost per month
- Advanced Sql Query
- Delete records automatically frm table
- inexact match
- Delete records automatically frm table
- where clause
- condensing records
- DateDiff in a query
- a query (i think it's simple, but impossible for me)
- DoCmd.RunSQL
- Querying via php
- Sql Intersect
- Sql Intersect
- DELETE statement
- Devious Query
- Access 2k3 Compile error. in query expression Date()
- Speed up a VERY slow append query
- adding prefix to autonumber?
- query needs to return match and unmatched results
- Retuen Zero Value in a query
- Newbie Query Problems
- no duplication in Append query
- Extremely Newbish Question
- How To Reconsile Items Logged IN and OUT
- need access help from the experts
- I need a SUM of Quantity depending also by date!
- ORDER BY dropdown output
- Count of Null records
- Expressions
- Running Query With Like In Ado
- Extracting record(s) with most recent date