- Dates again!!!
- 'Add' records
- Timing of Access Queries
- Joining Tables in a Query
- Using expression builder - HELP!
- Adding a counter field in a query
- Find a max date in one table less than a date in another
- parameter/variable criteria
- Joining Queries where join requires matching/unmatching data from both tables
- Averages
- Retrieve non equal rows between two queries
- displaying column headings
- Time calculations using 24 hr clock
- Deadline! Count clients only once who come multiple times?
- Searching for records by a date defined by the user
- I need help with Immediate If Function
- Rounding Up
- Running Total w/out storing & using Dsum??
- Subtracting days from a date
- Autopopulate (append query) new table with subform
- Date Differences
- Database Design
- Specific Criteria required
- Multiselect Listbox Parameters
- Count Fields
- Finding first date
- find a record and move back
- Creating Age Bands in a query
- Duplicate results in Query
- Only shown with criteria
- auto fill
- Do i need all the fields?
- Update with a twist
- Help with appending recods
- COUNT BLANK FIELDS
- Update date when report is run
- Number fields?
- SQL won't work
- Update Table using query
- multiple selections from string in criteria
- building altavista type of text search query
- Update Table
- difficult? maybe not.....
- Top n for each employee
- Query from 2 tables
- Custom sort order
- Show entire record
- Dynamic Cross Tab Queries?
- how to combine tables into a query
- Counting Multiple Field Contents
- DLookup in a Query
- Time
- Parameter Query
- Counting Values in Single Field
- "Group by" cuts off my lines!
- Queries Access 97
- Concatentating a COLUMN
- Union Queries
- How To Create a Delete Query
- query on a field that has =now() as data
- Find Similar records in Two Tables
- Can you join tables with more than one field?
- Queries return no records
- move previous
- Easy Update Question
- prompt query
- Non-Date Parameter Query.....HELP!
- extracting zip from city, state zip
- deleting dashes & spaces using query
- Grouping
- help with query
- numbers in queries
- house numbers from addresses
- Duplicate Entries....HELP!!
- Delete query won't work
- Can this even be done? - Sorting Query Results a strange way
- DatePart
- Is there a way to do a count like this?
- Remembering user form locations
- Calculate total number of days between two dates in a query
- counting string occurences
- Changing Tables within Queries
- Designing a query with a parameter and a lookup field???
- Totals with a query?
- Getting all my SQL in one place
- Set primary key for make-table Table???
- Dynamic Delete Query from form using parameter
- Filter on NT WinLogon\DefaultUserName
- Help needed once again- Find inconsistencies
- translate excel formula to access expression
- no java please help
- Query: only returns 14 out of 2000 records!
- Finding times greater than an entered value
- Calendar vs Accounting Dates
- Replace records in one table from another
- Linking Date Fields
- Field enlargement Access
- NZ function and curency formatting
- Reformatting a field using an update query
- Crosstab Query
- queries
- multiple date counting
- How to filter out duplicate records
- Duplicate Entries 'begone'...grrrr
- GETTING THOSE DUPLICATES OUT
- Can I get a query to do this?
- selecting attrebuts that are not matched
- QUERIES
- Changing a date from yymmdd to mmddyy
- Is it Possible?
- need help with reorginizing a table with a query
- Making a link with a between
- Entering criteria into a Crosstab query
- IsNull
- query pulling records multiple times, but not all
- Am I using the Right Code
- Cummulative Sum
- auto queries
- Mission Impossible ?
- query only returns 14 out of 2,000 records
- Date() Doesn't Work - Access 97
- Breaking down SQL's
- return certain dates?
- Random generated query
- Absolute Value Total
- Update Query
- Query/primary key
- Updating Data Using Queries with table open
- Update query formula
- CREATING DROP-DOWN LISTS ON QUERIES
- Select statement
- How can i change a String in a field?
- Combining records
- Report from query on multiple tables
- Update Query Punctuation
- Update Query Data Mismatch
- Search for Strings
- Excel Notes
- restricting entry options
- Zero Value
- input mask
- List which field names are populated in table?
- Field Name as a value
- newbie question
- Combing Fields
- highest value
- Addind Carraige reuturns to a line in a query
- How do use the same paramater for every query?
- Relationship disappears from query
- Subform Query
- parameter messages
- sort records by month
- extracting data by date
- Current record only query
- queries brought over to excel
- Including Null Values in Count Query
- Editing parameter box to ask all criteria at once.
- Query a Table for a date
- substr function in query
- Querying A Field With 2 Columns
- OK, I'm praying that this can be done...
- searching, editing parameters and criteria- at once!
- sort between 2 dates and sort again
- Easy? Calculating b/w records
- INSERT INTO
- Query range of dates from multiple fields in one table
- Sorting by the last two characters
- Query Challenge - Merge Data
- contains number in any position
- are they safe to do? (compacting databases)
- Force Column Headings in a Cross-tab query?
- Replace Function!
- joining unrelated tables
- Selecting only one checkbox
- Driving me cookoo!!!
- multiplying 2 fields
- field dependent sums!!!!!!
- highest values??
- last date
- Filtering by a control causes error in crostab query
- Queries That Ue look Up Values ?
- Keep getting duplicates in my results!!
- Strange behavior from a totals query
- Selecting a field based on the result of another
- Running Sums Over a Group in a Query
- Can't change format of field output from query
- Only Return Record with latest updates
- baffled I am?????
- Default Value in Combo Box
- Append Query and Autonumbering
- Inner join on two tables - with record offset
- Archive / Update
- Delete duplicates?
- Deleting relationships using SQL
- Count query problem
- using multiple iif statements
- Extremely Difficult Query
- linking a URL
- Need query to return empty records
- Delete Query on Linked Table
- Parameter Query with ORDER BY
- Query Query
- Can you do validation from tables using code
- IIF(Len)
- #Error in calculation query
- I don't get this
- Printing gridlines in Address Query
- Need help with nested queries
- removing duplicate records
- Querie return nullS when id like 0'S
- Retriving data using date as criteria.
- Append/update queries
- Query Problem...Dont know what to call it
- Returning the last of a number of entries
- Maximum no of fields in a query
- Acc97, SQL, IF Statements in Queries
- Need Help With Querydef
- hidden macros
- Information on a table
- Query Help or SQL Help not really sure...I'm Lost
- Deleting Multiple Records
- Nth select
- Need Help on building an expression, first time expression builder
- Trying to reference like Excel
- Is it possible to do query based on word in a field??
- trying to get the query right
- Getting zeros like tinker
- limiting queries
- Difficulty Using Form with Checkboxes as Query Interface
- Passing a parameter to a query
- Fill in blanks
- How do I query a text box?
- Queries not listed
- query - 3 tables all linked error???
- if-then statement in criteria
- Macros in query?
- Easy query problem
- goto nextrecord when it is currently lastrecord
- filtering
- getting rid of repeptative records
- Finding a sum total in a query after using an expression
- Query question
- Date Format in Column Headings
- List Box Multiple Selection for query criteria
- between dates criteria
- Aggregate Function?
- Filter a query
- Sum filtered criteria
- null in queries
- Combo box query