- calculating number of years in job
- Display only part of field
- query to search records having some chars common
- Query Duplicating Data
- Autonumber a "Make Table" Query
- Choice of Criteria from two forms
- error messages after import
- Decode ???
- Limiting Record Selection?
- Problem with querie count?
- Query criteria
- Passing data from a form to an append query
- Help with extracting "date"--need today!!!
- Find vs Querying
- Cricket Database
- Querie count??
- My Database Reports the wrong size
- Writing query to exclude information
- joins
- Restriction clause for date
- Quirky design problem with dates & column headings
- query source database
- Searching for ? (Question Mark)
- Twice Key Clears Record
- URGENT HELP PLS: running sum/<=100%
- apend error -Must contain at least one table etc
- Append Query stealing my decimals
- Problem With Nest Query
- Joining 2 Queries
- Search question containing Like statement
- DateDiffW Function in a Query
- Update query problem
- Duplicates from an update query
- Build Expression with Sum form another field
- 2 seperate parameters for one query
- Really need your help!!
- part of date
- Concatenating issue with a twist. . .
- Query criteria in a parameter popup
- display data of last 14 days
- Update Query
- Add all choice
- I need to Manipulate Dates
- String as criteria in query grid?
- query to purge old data
- Primary Key Violation
- compare data
- Simple Delete Query
- Access error
- update query many joins
- running average every week -which query?
- If Then Else for a calculated control
- Using Query to match exact time bet. time ranges
- Financial Year Query
- Date Query Problem
- DESPERATLY SEEKING EXPRESSION HELP
- DateDiff
- Help on Sub-Query parameters - how to do this?
- Date question
- Sybase produces different results
- Query/Report Help
- Complex Aggregate Function
- Date selection via Form buttons
- Grouping Records
- Date Range in a Query
- Packing Charts out
- Wildcards???
- Pull Data from One Table to Another
- Combining Field Data
- Adding Country to City
- HELP WITH THIS SIMPLE QUERY
- How to choose only one month?
- crosstab query and quarters
- Taking records out of one table based on another using a query?
- subtracting two queries
- A LIST FROM TWO TABLES
- help!!!!!
- display data of last 13 weeks/6 mths from present date
- Date Queries
- Age in yrs,months and days
- User Selected Dates
- Hours Over 24
- text search
- search for a range
- Crosstab Query with Week-based Column
- 'sub-sort' within a sort
- DateDiff Query
- Autonumber field in Make Table query
- Strange problem with a query
- DateDiff with Business Days
- MonthName function
- Week ending date
- Week ending date
- UGG! - Access SQL Problem
- displaying a report from a query
- Over 24 Hour Trouble!!!
- problem concatenating two fields
- filtering null values with iif
- Crosstabbing by week increments
- Eliminating Repeating Rows
- Update query problems
- To query or not to query
- apostrophe in a string used in a query to build a recordset
- Pulling Data from Multiple Tables
- Comparing data in another table
- A complicated Append query?
- Do I use Append/Delete?
- Week ending date
- Guys.. i need help urgently!
- need query help please!
- Roling year
- select from mutiple queries
- OK I GIVE UP!! Help Me!!!!
- Search across multiple fields in query
- Display record in query once only
- IIF queries
- Displaying queries in forms
- DateDiff with a Difference
- Partial Date in Query Criteria
- Counting Records That Aren't There
- Downtime - Uptime = differencedowntime
- Queries in Reports
- Parameter Query
- Creating Running Totals in Tables
- Selection or All
- choosing 2nd word in 3 word field as criteria
- SQL queries in excel
- Company & Branch Lookup Query
- Show all data except for certain part types
- TideTable grouped by date
- sales per month
- Hidden switchboard
- error: enter parameter value
- selecting certain data
- Concatenated list of sub-record values--cannot make into memo
- How to update one table from another table
- Record Pointer Problems
- Delete Old Records
- Results like Append Query
- Numeric Overflow and ghost fields keep appearing in query
- VALIDATION PROBLEM
- Calculate days in month
- Basing a recordset on a query
- Query To Check Date Range
- Automatic Append
- monthly report ???
- Extract data from "old" DB.
- Using Combo Box Column( ) Property in SQL Code
- Update Queries and Carriage Returns
- Parameter Value
- Total for Query
- monthly report???
- Previous 12 months
- New Problem???
- Bookmark Explanation
- Help on converting Yes/No field to positive number
- NZ Function through Microsoft Jet
- Making Fields Blank
- Numeric Field Overflow
- Set Query Parameter
- Inconsistent Error Message - please help!
- Help with an expression
- IIf function
- Running an Access Query in VBA
- printing query problem
- Error: Type Mismatch
- Calculating Total Time Worked
- Date Range spans 2 yrs
- SQL Passthrough Query
- Prompt user for table name in Make table query
- new problem?
- dates in query
- dates in query
- Single date parameter
- line Number Generation
- General help
- A Query that selects two other queries and subtracts them?
- getting query to recognise number as a currency for searching
- 'calculating' text fields
- Input Parameter Date Format
- Close Form Attached to Query If No Records Found
- Have to enter Value Twice to Run Append/Delete Queries
- Using Append Delete Queries in Relational Databases
- Calculating Time (I'm desparate)
- Filter customer records who have exceeded their loan period together with amount owed
- parameter query
- Union Query
- Queries
- query to table?
- Calculating Total Time
- 1 name per score
- Unions not allowed in a subquery
- suma field and move to different named field in different table
- When I try Group By only one value shows
- Query problem
- Converting Numbers to Date
- Query Calculation from 2 Tables
- Access bug???
- Changing Columns to Rows
- Insert Query..Invalid Operation
- New fields from existing data
- last row
- ODBC query concatenation
- duplicated data
- last inserted ID
- Please help with counting!
- Average Date/Time Field
- Field search for inactive customers
- Format Quarter Date for Governement Quarter Format
- Retrivieving the Max value From a Table on the Many to One Side
- How do i use a union query?
- Subtracting End Time from Next Start Time
- dcount problem
- Parameter query
- update date/time
- Parameter Query
- Finding all appointments today: wierd behaviour!
- Mismatching
- Help!
- searching specific characters in a text field
- Using an array as a parameter?
- Saving a derived value from a Query
- Appending to Another Database in Another Folder
- Making a query to show items in a week
- Stuck with SQL/Query expression
- passthru query rounding my return
- Suppress Null Fields
- CrossTabQuery Counter Help
- Adding Time
- Find records with matching dates
- help with date/time..i don't want 00:00:00 i don't use the time
- please advice...extracting data using queries
- Date trouble
- why won't my query update ?
- Comand Button To Query Wizard?
- exponential calculation
- Appending text to a Lookup field
- Invoking Table/Query cells in VBA
- Showing first 5 numbers out of 8 from a field
- combo selection
- Parameter queriy problem
- Querying Whole Records with Total Row Functions
- Sort a field with numbers and letters
- which query to use???
- Looping and create table query
- Invoking Table/Query cells in VBA
- Apostrophe in SQL Statement
- TOP solution
- Query gives blank result in some rows
- Parameter query