- Query between dates not using >= correctly
- Modifying Query Criteria Question
- Using a New Function in a Query
- query results
- need to concatenate field
- LEFT JOIN and WHERE clause
- Query too Complex...
- A2000: group detail records by customer
- Left Join & Inner Join
- delete query
- Inner Join with SQL
- Update-DateField to 2nd Thursday
- grouping by using a word contained in field
- Globally change part of a field
- Invalid use of null
- Append Query problem
- Function is not available error in secured database
- Using text in a Form to run a Query
- Without attachments
- query problem
- random incomplete query results
- Looking for LATEST DATE
- Make Table Query
- Brain cramp - pull counts of orders closed
- query date
- #Error Help Needed
- Selsct Query Problem
- Select Query
- part of string
- Find duplicates query not working.....
- part of string
- Duplicates Query
- Date Range Issue
- Replacement Query
- Dlookup problem with date..
- Date Conversion
- Rounding errors
- Grouping by Time
- lost joins in frontend
- Need help creating a counter
- Is anyone up for a Challenge? Oh I HOPE SO!!!!
- Running total in query
- Selecting records using GROUP BY
- calculating running total of a field in a query
- Max value in Query
- Unique record
- Adding two days of data on one row
- Dates without weekends
- Change column headings in crosstab querry
- SELECT statement syntax confusion
- Case Statement with the Between Date function
- Help with query searching within a string
- Date issue
- dlookup with 3 criteria
- Counting records in a query
- Zero length String?
- If Then. Maybe?
- Query expression removing leading zeros
- DLookUp with 2 criteria problem
- TOTAL column in query
- split data problems
- Is Not Null?
- Date -Data Type
- Select records based upon date
- Getting ALike instead of Like
- DatePart Function in Reverse!...
- Running sum running by date order
- Query calculated field based on another query
- acCmdPivotTableExportToExcel
- question about multiplying
- Need help in some queries code
- IIf function for 3 possible outcomes?
- Query Left Command Help
- calling function as part of criteria
- text field to date field field
- Time Averages/ Time of Day and Minutes
- Strange query results/Wild characters???
- Left function in Access
- Numbering Records with sort
- Convert Unix timestamp to Access 2003 data field
- Record is deleted error
- Query Text in the Mid of a memo
- converting text to %
- Looking for date field that is empty
- DateAdd Working Day Query
- multiple criteria selection
- Len([field])<9 return records with values of 10
- Multiple records for one parameter
- Order by ignored after upgrade from SQL Server 2000 to 2005
- Numbering Records
- Link new records to old ones
- numbering records according to date and ID
- How to query data on monthly basis
- Updating a field's data to another field in same table???
- Cascading delete reports?
- Many to Many Headaches
- Delete based on another table
- Budgets v/s actuals
- "like" and "*" problem
- Need to eliminate deleted items from a drop down list
- Query to get everyone not in table
- trouble with Office links to Excel in 2007
- crosstab query question
- AND on 2 fields along with other criteria in query
- Averaging values taken every 30 seconds into 5 minute intervals
- Append to Append Query
- Query sorting help
- Quesry criteria
- Pull Specific Data by Previous Month's Date (Date Entered via prom
- Counting
- String Manipulation help needed
- Help with query
- Another Check Box Question
- Query help
- delete duplicate record
- Add users to SQL Server
- Calculations based on varying number
- change a zero's to null in a table ?
- Records in a query between a one-many rel. not allowing data entry
- Query is making a nuts
- syntax for query to bring only one result per AccountNo
- select Month gone awry
- return all records, regardless of fields matching
- Group by & Sum
- Even and Odd numbers
- query on multiple tables
- another fieldname problem
- Calculating diff btwn two dates how to count only business days
- changing an ID to a user friendly name
- Adding record number to existing table
- Problems I got from collecting data feature of Access 2007
- Return Day of week
- Query Problem - Relationship?
- Duplicate records based on Multiple Fields
- Query Not Updating
- Access 2003 and maths
- Is there a Date Time Conversion from text?
- confused about LEFT JOIN and RIGHT JOIN
- Combos and text boxes
- Trying to round up
- invalid parsing
- maximum record
- 2-step Inventory List Generator
- UNION query and Data type mismatch in criteria expression
- Vlookup
- Another tricky selection query
- a tricky selection query
- How to detect the same substring
- Running a query that totals my Columns
- Update query question help please
- Riddle me this you wizards
- Return comination of Current record and next record fields
- Convert From Column to Row (Record)
- Null like "*" [Perameter] "*"
- Alias Circular Reference Problem
- DSUM()
- Beginner's Append Query Problem
- DateDiff partly failing
- Append Query Baffling Me!
- Replace null value with the previous value?
- Calling VBA subroutine from a query?
- IIF statement run amuck
- Highlight keywords in result of perameter query
- NOT...IN subqueries returning no records
- transaction and rollback
- Use of normalised information
- Criteria for 'Pairs'
- DSum in Query
- Displaying query from a form
- Display Query from form in Foreground
- Is my query too complex?
- Query Help
- forgot to post version for previous question posted on update quer
- Need help writing an update query
- Delete Old Duplicate Record
- dsum in query
- Auto update query
- DateDiff question
- Help Please! Need to set up query
- Question
- Using parameter in query to specify null/not null records
- Passing the output of a query to a table
- Calculate a daily rate
- Total unique fields
- How to obtain a spreadsheet-like table - Rookie
- Do you MoveNext after Delete
- Need helps on my union query
- Compare to tables and add recordsmissing in main table
- Calculating Problem
- Delete Queries from an Unmatched query
- Dislaying data from top to bottom to left to right?
- how to make a criteria regarding a subform
- Concatenating or embedding wildcards in SQL LIKE
- updating a query with data from a table
- How do I insert a coloured symbol in an Access field please?
- More understanding of the Join type
- Acc2002: Crosstabs: Column header length limit?
- Update table
- Strconv function
- Trouble with union qry
- SQL string longer than 255 characters
- Compile error in Query Expression
- Problem with .addnew
- nested query hell
- Multiple values in a crosstab
- Total clients ages by year
- Retrieve
- Need to get result of a select query in code
- update ... grouping ... replace ????
- Crosstab query
- Using different form strings to filter
- Running Total in Queries
- Copying using recordsets to new records
- Monthly Totals with a Subquery
- PAYROLL PUZZLE - LOOKUP WITHHOLDING TAXES
- Works with runsql but not with .Execute
- Duplicate date records
- Mark Records in a Table
- Due date query
- Denormalizing question response data
- Average ()
- DSUM()
- Custom sort order
- Append Query
- Combo Box Won't Return Results in Query
- Combo Box executing query, issues
- Specific Age Query for a Date Range
- counting problem
- Append/Update Query
- Previous Month in query
- Error: Cannot use the crosstab of a non-fixed column as a subquery
- Any date Last Year
- Looking for Non-records...?
- need to convert numbers to unique text
- Count numbers of logins - with names
- Retrieve a list outside the subset list
- Creating an End of Year total Query.
- showing only unique records
- Max across columns?
- How do I generate an e-mail list from Access 2007?
- Repost : Mission to populate record through a make table query
- IF Statement
- Custom Function? Another Method?
- INDIVIDUAL INQUIRES
- Query for Parent containing only ONE type of child
- update query
- query returns no records, need to convert to "0"
- 20080105
- Access querry
- New to Access, need some help with a query
- Using different data types in a query equation
- How do I find organizations with no members?
- Strange results
- Different response times...
- Query Help Needed
- round a date
- SQL needed for tricky query
- Rows and Columns
- Return a value from another table
- One to Many Lookup
- Return Uniques
- Need to remove all punctuation
- sub query
- Query on Blank Date
- How do I query companies not having members w/certain level of mgm
- "Subtracting" from query?
- Date Issues - Help!
- User input Criteria
- How can I time long running queries?
- Event Management Database Template
- using IIF to determine form state
- relates to previous question regarding memberships cards and intia
- help!
- Rerun an open query in Access 2007
- Query Filter using Not In
- Update oldest first
- Rank Order Exceptions
- Trying to pull the top number of vists AND the assocaited user's nameby client
- sort order
- Count Null Values Per Field
- Invalid data on Left Join query
- Postal Code
- Query
- Excel statement that I want to replicate in MS Access as a Query
- Running Sum
- Count
- How do I add decimals to crosstabs in Access?
- How do I make a report using crosstab queries?
- IIF Statement Definition
- query help plz
- Look up field in a table is not showing first row
- dica
- Need to see everything in field except the last two characters
- Changing format on calculated field in a query
- updating field to assign number based on record grouping size
- Filtering out a time range
- Using checkboxes as parameters
- DISTINCT ROW help needed
- Consecutive Query
- Query using date and time in seperate fields
- query to find difference in record sets
- SQL "IN" operator
- Union Query Truncates Results?
- Mission impossible....????
- Calender coding linked to MS Outlook
- More understanding on linking table and make a grid query
- Calculate work days and not weekends
- Declare in pass-thru
- I need a xtab query to show zero months.
- Operators and Drop Down
- FIND
- Changing a formula
- Left join query produces invalid results
- Show data between the first and last day of the previous months
- Report Query Subreport Queries
- Crosstab subcolumn query/report heading pblm
- COUNT DISTINCT problem
- need help with calculating fields
- Duplicates in some fields, but not others
- Create new table with current date part of the name using sql
- Query - Exclude Time
- Difficult query?
- query by date
- query from combo
- CrossTab Query that shows original data (text)
- Joining Multiple Queries
- How to selectively insert data in fields
- Stopping the ability to save a query.
- Percentage Calculations in Pivot Tables
- Query with alphabet
- Show all fields from table in select query ?
- Boolean in Query
- syntax for WHERE NOT IN?? to locate orphaned records
- Getting Multiple Queries to work
- Key Violations My Wits End
- insert, append from form to table
- Can I exclude the criteria Value from the query results?
- Mutliple Complex Queries - How to Combine into One Result/Report?
- Adding data in Queries
- Discussion Threads - Sorting
- Limiting Query Results (to only certain days of the week)
- Aggregate rank query question
- Variable Accros Queries
- change text to date
- random test
- lookup all values against all values only gives me one value back?
- Query an External Mdb
- Money AND HEALTH
- How to trim leading spaces that are not removed by Trim
- Searching using an address String
- Save me from insanity???
- Question about user-entered parameters in queries
- show only duplicates that match the current form's contents, how?
- Crosstab dual columns?
- Crosstab query columns not adding correctly
- Translate SQL query
- Creating formulas
- Do not show blanks in a query
- Unmatched on 1 field where other field is equal
- Date selection criteria expression help needed
- query does not work in Access 2003
- CrossTab Query?
- Combine Rows from the same Table
- Combine data from tables into query
- Query help to remove duplicates
- Date time combined query
- Deleting a single character in a text field
- "Convert" command?
- Error Mesage on no results
- trim in query
- update query
- Repeating an answer on the following line
- Disallow duplicates in combination of fields
- no recent records query
- Field result duplicates following join
- docmd.runsql only works when text is present
- docmd.runsql only works when text is present
- Query to count time range
- SQL - Sortingproblem
- Exporting subdatasheet data from a query to Excel
- date format not recognised in 2003
- Equation Question in Query
- Combining Functions
- Results of query has to many numbers behind decimal
- count based on another field
- Text Field
- Just Wondering
- Query Command
- Query Parameter - Between and and operator
- Query to Count If >=
- query criteria
- Delete duplicates from a table
- delete characters values
- Search for a word in a memo field ?
- Retrieve all entries in table1 eventho they're not matched in tabl
- Return all entries eventhough they're not matched
- Nz Issue - changes cell to Text
- Sort out one address
- Min Value
- Not sure if this is possible
- Paramter Update to query
- How to obtain a median?
- Monthly Query
- IIF Query Help needed
- check box fields that correlate to data fields
- Deleting characters in text fields
- Jet finds a syntax error in my SQL statement
- parameter query
- Oddity in Text Criteria
- Current Records
- CrossTab query to Report
- Field with both first name and last name
- Partial Entry in Expression
- How do I convert "yyyymmdd" to "mm/dd/yyyy via a query
- Complex Query
- How to pass query result to a from that contains subforms?
- Max Value
- combobox
- Count Networkdays
- Count Networkdays
- Averaging Time from mulitple tables
- Serial number in Queries
- I finally found SEO Services
- Help needed with Date Add function
- Difference of each row from the next row of one table
- Finding a list of personal records
- # Deleted in memo fields
- How to get "from this year on"
- combobox
- formating a field within a query
- How can I get the Next Record fields in the same Query
- Date filter
- Organize Data Like a Cross Tab, without unneccessary Blanks
- SQL Union All lost (missing) data
- way to subquery for next record in query?
- where do I set the datatype for a field
- an expression query
- The specified field could refer to more than one table listed in theFROM clause of your SQL statement.
- Writing an expression using fields with different formats
- Mail System Internal Data
- Microsoft Office Professional 2007 - Microsoft Outlook
- Query stopped allowing adding records to table
- Imported text file w/o unique identifiers, find duplicates
- Unmatched Query
- Need to put date in table
- aggregate function error
- Multi-level GROUP BY clause not allowed in a subquery
- Search directly in a form
- multiple database
- select Distinct query
- How to un-concatenate a field with full name
- Between in a query
- How to make a pop up query
- update query with DMax?
- Slow Query
- Using OR in IIF statement
- Data Entry Problem
- Rows to columns - concatenation
- Retrieve date from different tables
- Update Query and Timestamp
- The incredible returning query criteria!
- pivot table form
- Querying to fill in numerical sequence
- No results using DateDiff
- If Statement
- Combining two fields into one in a query for a report
- Lookup on a query with a wildcard
- cross tab column sum
- create input mask "yyyy-mm-dd"
- Replace
- docmd.runsql will not work
- assigning a unique query for each textbox on a form
- Object variable or With Block error
- Dates in 2008 don't work
- Alpha SQL MAX(id) increment issue
- Reverse True/False
- sql query won't work
- Limit records in combo box
- calculating a total amount
- Birthday (next 14 days)
- 'Enter parameter value' message
- Nz, IIF
- zip code with x miles of another zip code
- 2nd half of a table's fields set from the next primary key
- Fields calculated from different table
- Complex (for me) IIf query
- remove characters from text fields
- Finding the date of last pay rise
- ranking the records
- How can I strip the extensions from filenames in a query?
- Counting the maximum value
- Problems with an SQL
- removing extra pages from query printouts?
- ranking calculated fields in a query
- Is it possible to write subqueries in a query?
- Help with Parameter Query
- Make table query
- UNION Query with Join
- Problems updating Access 2003 Database
- Date/Time
- Adding same data to a field in many records
- duplicate records
- or in query
- Only want to include a field in the record under certain circumsta
- HotKey Questions
- Jet finds a syntax error in my SQL statement
- How get text of query in VB?
- QRY To List Out MAX
- Query Help
- query for values not in use
- old posts
- Combining 2 queries
- Creating Unique Line#s in Append Query
- combining same values
- Using field contents as criteria in update query
- Update query
- Update Query
- Disappearing column totals in cross-reference table query
- I think a crosstab
- Calculate next 5 numbers from table field
- Too complex? Really?
- Convert Query field display from text to hyperlink
- Symbol based on Range Hlp!
- Text Field IIf Statement
- CheckBox for data criteria
- Delete Query
- Populate a field by query
- Querry
- Most recent payment date
- query with duplicated data
- Using an unbound texbox to find a record in form
- Select Records based another table...
- Select Noted Memo Field
- Convert a non date string to date format
- Reserved error (-1524); there is no message for this error.
- Position of text within a string
- How to find which day of the week, this year, a birthday fall?
- change null count in crosstab qry to zeros Trouble with Nz
- Field names in an append query
- append query and duplicates
- Format date question
- Compare 2007 and 2008 - count records.
- Random Number in Query
- Using a variable 'Top n' value from a form control
- Get the date for the latest record ?
- queries & formulas
- Marking addresses as preferred
- Replacing Continents with Multiple Countries in an Access Table
- Convert Integer to Date in Access ADP Project
- query for financial year
- SQL statement inquiry **brain-blocked here** :o(
- "Overflow" message in UNION query
- Count >30 or if none show 0
- Make table from query
- first record query
- Combining Queries
- first record query
- Date range help
- Subtract datetime value from the datetive value in previous record
- Previous month query problem
- Unable to create table using Access 97
- Sub-Query
- Locking a Text Box
- Inner joins and table names containing spaces - a problem?
- Pass Through Quiery
- table relationship in query
- INSERT Query woes...
- Help with Query??
- Need to compare 2 created database match and add to less .
- calculating an opening balance
- Struggling with my insert query...
- if >= to, then...
- update query
- How would I combine or nest these two SQL queries into one?
- Querying one-to-many relationships
- beginner, question about date calculations
- Trouble subtracting dates??
- Cannot Update
- Query leaving out some data
- Urgent - Calendar - Need 7 days for week selected
- Count records in update query
- Different data shown based on user input
- Passing an expression from a table field to a query
- Select/Append Query Malfunction
- Crosstab query error 3104
- make table query
- Help needed re: parameter query
- Last of Date Query
- Query just beeps when updating
- SQL
- pass parameter value to query
- Sum of Qty
- Comparing next in a sequence
- Count with a condition
- Sorting Crosstab Query Values
- query criteria
- Old Records
- Query using Like
- can you reassign week numbers
- Subquery Parameters
- separate columns by numeric and letter values
- Changing commission rate at a future date
- Query works, query based on it fails.
- if.. then.. else.. in a query
- Query Help Needed!
- Test3
- Test 3
- Test2
- Newbie question, looking for earliest test record for each s/n
- Urgent! Need CrossTab help...
- setting criteria for time values in select queries
- Combo Box to open report
- Sub-query, Union, Nested or what?
- compare two tables
- Update Query with Yes/No
- Expression query
- Running sum by contract nbr and Date
- Cross Tab
- highlighting text box if...
- query not correct: between dates ?
- column headings of days
- Pivot Tables
- How do I disable 'Enter Parameter Value' prompt on an existing Que
- Sort/Odering on field in a UNION Qruery
- Convert "Date Format" and into "Text"
- Summing daily values by calendar month
- Adding totals in Query
- Query
- Unintended field "expression 1006" in the query grids
- qry return no results in given field
- Summing multiple checkboxes
- setting criteria for time value search in select queries
- Adding totals by group
- No duplicates in 2 columns
- Subquery with Field Cell Calculations
- bill of materials query
- Help in removing information from description
- Union queries and crosstab...
- Count records utilizing Where clause
- Query Problem Help!
- Here is the SQL View. Thanks!
- Query Problem Help!
- Taken Part of a Record Field
- Sintaxis of CONVERT function in MS ACCESS
- FromDate - ToDate
- Reusing Union Query with different variable values
- Sub Total
- "invalid operation" in query
- Disappearing SQL Code
- TRADE TRADE TRADE
- Simple calculated field problem
- Date Count Help
- Collating text files
- Sorting results Query
- Export text with current date
- calcluating a value if the original value meets a condition
- delete only 1 instance of each record that has more than 1 example
- Execute As
- Check boxes in forms to call a query
- Changing the search field
- Remove Redundancy in joined tables
- commas
- Delete table values automatically
- Multiple records showing when Multiples do not exist
- returning only a selected number of records
- parameter quesy
- parameter query
- Updating info from a form with query
- table not getting updated
- How do I count the number of "yes" boxes?
- Query to Mail Merge issue
- mySQL datetime field reports as Long Integer with ODBC
- sum of union queries
- Expression Problem in Form
- Select TOP 4 Records For Each Group
- Runs Ok, EXPORT fails with:Cannot define Field more than once
- presence/absense matrix
- Viewing data based on criteria
- even or odd records
- date mismatch in query..do not know how to solve
- Simple Select Query
- Access Append Query to update Sequence Generator in Oracle
- Parameter Query Problem
- Doing calculations between recurring instances of the same item.
- Changing Numbers to Text in a query
- Query not displaying correct column from a field
- Query not dislaying correct column of a field
- Convert text to date
- Query, between, Null, IF, And .........UGH
- SELECT query as subquery to APPEND
- Count how many days ?
- first record query
- Help with update query UDF
- New table from 2 existing tables
- To Record in Form View from Query
- Sorting hell
- Count Question
- Nz function not working!
- Number fields being converted to text
- Complex Query question - using distant related criteria
- Assigning a number to a date range
- Numbering Raws
- Annoying Access 2003 Query bug. Fix available?
- Odd issue linking to View
- Option Menu for queries
- Subtracting values in a query
- Need top record for each contract number
- Setting a Parameter for multiple fields
- Data From oracle stored procedure
- returning dates in a query
- Undefined function “Right” in expression
- Using Code to build criteria
- Calculation query, how to avoid extreme values?
- Append query with "if" on possible missing field.
- Show "Form1" everytime i open MS Access automatically.
- Grouping and counting
- Follow up to earlier Select Query Question
- Find Missing Numbers in a Sequence
- Select, Modify, and Append Question
- How to set up relationship query for minerals database - continued
- Can field names be changed with a query?
- Crosstab - Null to Zero
- Complex Query ?
- Sum of Descriptions Query
- Queries won't save in landscape
- date criteria problem
- Query parameter help
- Show <> Records Between 2 Tables ?? (ANTI-Join)
- Can an update query be used to update/produce a query?
- Selected Criteria or All
- date format conversion
- Converting Access to Website - ASP
- USING (LIKE) IN A QUERY
- Wildcard code for a query
- Delete record if a matching record is present in another table
- Joined table: Returns duplicated record
- open SQL store procedure from adp
- Question regarding IIf
- Query - auto fill "between values"?
- calculate null text field
- syntax error with multiple inner join query - Access 2003
- Subject: How to set up relationship query for minerals database - continued
- IsError not working
- how do I create a report or query that displays only the diff.
- timestamp grouped as time interval
- Group By Query - Sum
- Date diff excluding weekends
- Checked box as Criteria
- UNION query changes results after close and reopen
- Change Date Format