- Counting back dates in a table
- Adding a number to a date
- Date query
- Deleting the first three characters in a given field
- Passing parameters from combo-box/text field to generate query
- Formatting a Report
- Report Based on Query
- How do I..?
- Output to Excel
- Budget Effective Dates
- Query wizard
- Count Unique URNs
- Find Expiry Date
- IIf statement in Union Qurey not working on ONE computer
- SQL "AS" clause not working trying to rename a field.
- Between Parameter Query
- DateDiff to get average time without weekends
- Drop the Remainder
- Frustrating qry problem
- Phoenetics query, anyone?
- Improving the speed of Tabbed Forms
- Sub-fields in the same table
- How to append two memo fields
- Nine week analysis?
- Reusing a calculated field in another field
- Query Results for a Now() Function in a Form...
- queries with * ??? Whats that all about then...
- subtotal in 1 column by criteria in another
- IIF Statements
- A query to select 100 random records?
- External Criteria Set In Query Using VB
- Relationships
- SQL Date Criteria Format
- Hide Zero Value Field/Column
- still need help with my question with quarters and combo box
- query of multiple queries
- Applying an * after the query prompt window appears.
- exporting a query as a text file through VBA
- Instr function question
- circular reference
- circular reference
- Parameter optional?
- Due_Date field < 7 days away
- Okay SQL whizards....
- How can I get the latest record of unique recordsets in a table using query
- All Inclusive Merge of Two Tables
- Access conversion functions???
- strange error message in query
- Duplicated cells in records, Pull new data
- rows to columns
- Null value query results
- Proper structure for quantities
- queries
- Counting fieldnames of a table
- Get rid of message boxes??
- Retrieving Duplicate Fields...
- Query with user-defined func called from VB
- scanning data into a prompted criteria box
- Concatenating a crosstab query
- Public Function
- user field selection in a query
- sql as recordset how do i use in code guys!!
- Query to Display Linked Records?
- How to get ID after inserting a row
- Query Parameter
- OR expression help
- De-normalize via query
- query dates
- running total calculation?
- DISTINCTROW
- Using Conditionals in Query
- Combo box pops up parameter table
- Queries - New at this stuff
- Query Error with Functions
- Update Query from H*ll
- Combine multiple rows into one row/column
- Need Query for Most Recent Entry
- Calculations on data in one field
- Query on current record
- problem with criteria in queries
- select a table row source for a query
- merging many side of query into one large record
- selecting a single field from a form for a query
- Criteria, Like() operator and Null value problems!!!
- Remove spaces between text
- Combobox trouble
- New field in query
- append query: delete records that are exactly the same
- Enter 2 columns into 1 text box
- Calculation in Query
- missing comlumn
- FIELD SPLITTER
- Undefined function 'Date' in expression
- Past Postings
- Too many criteria selections needed
- Recordsets of SQL Server Data
- * is defaulting to a 1 in a report
- strange update query
- Pivot Table Query
- Query to return birthdays today
- Concatenating a Crosstab query
- DCOUNT
- Filtering records
- Syntax to return count of specific records to form
- Need to build query for mailing labels
- Current Year
- Append Queries
- Fiscal Year
- Query help, using 2 tables
- Age Restricted Orders vs Dates Of Birth
- Selecting last months data
- Return Path
- Omitting Numbers From Addresses
- Multiple Criteria
- Update Visual Foxpro Free Table
- need to query from text box in subform
- Selecting the First Occurrence Query help
- DISTINCT QUERY
- Select the most recent date
- IIF Statement in a Parameter Query
- Query two tables with auto numbers
- Report & Update Query Based on Parameter
- Convert "yes/no" field text to "in/out"
- Separating Data from Query into Two Columns?
- Sum Check Boxes
- Why does SQL change in the QEB
- incremental autonumber field as query expression
- creating multiple records at once
- Append Query creating multiple entrys!!!!!
- Test if query returns any results
- only show Maximum value
- Numeric conversions of text fields: more forgiving than CInt ?
- Basic sum problem
- Standard Deviation
- query criteria
- Leading zeros in a field
- Exporting to Excel/Word Truncating Problem
- problem with or
- does order of fields in query either speed up or slow down the process esp. if...
- numeric to hours and minutes
- Splitting data in 1 column to new columns
- Update Excel 97 from Access 97
- Tracking Sick Days and Turn-ins
- Searching Memo Fields
- Is an SQL statement limited to 256 char or ...
- pivot tables
- Dsum??
- queries for forms
- queries for form
- Queries and Modules
- Cannot Average field.
- Query, join both ways
- query help
- This must be simple - please help count occurances!
- Total/Sum
- Query: Pulling up the latest report by date.
- Unmatched Records
- error message when I move app to different pc
- Calculation
- dating agency
- Parameter range Queries
- Query feeding report/date sensitive
- input boxes
- More SQL Syntax Problems re: Counting
- Date Calculation Question
- Import Specific Text
- Eliminating duplicate unique data
- QuerY Help !!!!
- Need Help Please !!!
- Parameter Values in Queries
- Grouping on combinations
- CrossTab Queries
- Automatic entry based on a relative value
- No one seems to know the answer...
- Count problem
- Appending records
- Replace data in query
- Comparing two fields on each record
- Ranks incorrectly
- Date Count
- linked fields
- Accumulative
- DateDiff
- Need Help With Total
- Related table query and DoCmd.OpenReport
- updating a table from a duplicate query
- Dynamic Query problem
- Need help setting up a filter
- Multiple And/Or Criteria
- DateDiff
- More date problems
- Criteria in a query
- PLEASE HELP.. I NEED A SIMPLE CALCULATION WITHIN 2 HOURS
- HARRY OR DAVID PLEASE HELP ME
- HI MICHEAL THANKS BUT WHERE DO I PUT .....
- Conditional statement in a query expression.
- sorting days of the week
- Ahhhhh - Why doesn't my Query work!!!
- Queries printing without gridbox
- I REALLY need help with a Calculation
- I REALLY need help with a Calculation
- Find Duplicates, then tag them?
- Convert from text to date
- Memos in SQL
- Count 2 possibilities in same query/form
- CrossTab Query duplicating records
- Conditional query?
- Sum
- Cross Tab Query, Please Help!!!!!! :(
- form calc. not showing up in query?
- Form, Recordsource and Query result
- CONDITIONAL INSERT STATEMENT ??? PLEASE HELP!!!!
- Null value to $0.00 value
- Sorting month by school year
- get data
- give me the latest date
- Pull certain fields from various records
- Need Query Help from the experts !!!!
- Query to select data that isn't in another query
- Form or query Qs - from an amateur
- calculations in a query
- Ranges..
- updating and appending
- Calculations in a query !!
- Strip Leading Spaces
- "=?" Queries and forms -
- compare records?
- date calculations
- Pull data by criteria
- Open a query using a variable field selection
- calculation of a median
- recordset cannot be updated problem
- How do i get records sorted on months?
- Date calulation
- calc. of median of several variables on form
- Qry still runs after cancelling event/closing form
- Help with statements!!!
- What query do I use for this!!
- Query on Data Access Pages (DAP)
- Query on Data Access Pages (DAP)
- Wildcards in a query
- How do i make a loop in access
- How do I split a crosstab query?
- Grouping Data
- Rich, i didn't get an answer the other day
- Urgent! Datediff query
- Requery Help !!!
- Error 3121 - Can't group on fields selected with '*'
- query parameters
- complicated query help