- Can I create multiple values based on an iif atatement?
- Delete Duplicates Query
- need to capitalize a field
- multi-select list box query
- Changing the forecolor dependent on value
- Help me please
- criteria for last however many days
- Export Query
- reference subform control in query
- Rounding to nearest whole number
- Dual Result
- Creating one list from 3 columns
- SQL "WHERE...Or" question
- Too many fields in a query?
- Selecting most recent date
- Can you filter a query to hide a field according to value?
- calculate difference between 2 fields from 2 tables
- query question
- Modify select Query with VBA
- Dynamic query example question
- Problem with append query
- #Error in the field
- Input Mask
- text box to query criteria
- Not to show certain month fields
- access Querie totals of "true" or "false"
- n00bie query probs
- Update Query with check box??
- Update Query with check box
- Update Query
- Show all records in parameter query
- Check Boxes and Queries
- One to many relationship query
- Subquery
- Date function
- Null ?
- Query Madness
- automatic numbering of records
- Parameter Query
- writing efficient query?
- I need to use Dcount i think, but cant work out how
- query exclusion code
- Roling year
- Query Parameters???
- Nearest lookup
- query problem
- Error in Summation
- Append query: order details from Excel to Access table
- Beginner trying to filter a query!!!!!
- cant get query to take "ww" criteria
- Form or Query Question?
- Moving results of merged data into rows
- parameter/wildcard w/dates
- What is wrong with my query?
- two things
- Weighted Titles to sort by
- Columns changing order
- Please Help!
- General Query
- Sum of Two fields
- frequency of a number, Dcount
- lookup in a query
- elapsed time in hours
- Query on Network
- matching data
- DATE() criteria won't work w newer OS
- Append query on a single record
- Queries: Missmatch
- criteria in a query
- I may be stupid but...
- while statement
- Dynamic Queries
- Where statement for Date FieldS
- Query/Report help
- Sequentially Numbering Entries
- Duplicate query query!!!
- multiple notes
- Top records
- I flat-out give up!
- dateadd function
- Several hopefully simple questions.
- Limit Combo Box Selection Based On Username
- masks on queries
- Date Criteria from Text Boxes
- Help on a subquery required...
- Yes/No field query
- Date - 30 days
- Query Criteria formula
- View results per month
- Parameter Query Using a Text Box instead of the generic Access Prompt?
- Form Criteria Should Return All Or "Something"
- Query Help
- Caculating totals from expression
- Blank Fields in a query
- Multiple Keyword Search
- Jon-K
- Delete Query Help
- Transform m:n-matix into n:m-matrix
- difficult query
- query help?
- Can I sort by Shift?
- crosstab query
- Help!...I have 2 days.
- crosstab query issues
- Show multi-activities and determine who paid most...?
- SQL for joining two tables
- Filter by Form - 2000 to XP
- Union Query Problem
- date criteria
- Need to input number for calculation
- Union Query
- Query repeating ID numbers
- Need help on Query!
- VBA Query Problem
- Query and checkbox
- date criteria
- Previous Month Query for 2002 data
- Employee Count
- Append to an Append Query??
- Using Prompt to select a column
- query by month
- Query that outputs a list when only first letter is given.
- exporting filtered records
- Calculating Age
- not updateable field
- help me with my query
- combining fields in a query
- Inventory help
- Referencing user inputs through textboxes
- Specialized Query ...
- Convert a date into weeks
- reporting on fortnightly periods
- I need to refer to a font type in a query
- using recordset as query criteria?
- calculate on every entry
- call (run) a query using VBA
- Rounding decimal places to 2
- Using <> Not Equals Criteria
- A Tricky one?
- Sort by color then count of color..
- simple question about a function
- Left, Mid, Right Function
- adding lines to memo
- Duplicate Records
- Append Query/ New Column Query
- Find Length
- Update Multiple values
- Mail Merge
- why?
- Really Stuck with DMax
- Make Table Query
- Query by multiple random fields
- Type mismatch error,, SOmebody help me
- Special 'aggregate' query / "Second"-function
- IIF statements in criteria row for multiple parameters
- Criteria not working for dates
- parameter in query
- Trying to check to see...
- Viewing sections of data in a table from selections made on a form.
- selection?
- Append Data
- populating a query using a form
- mailing......urgent
- Make an anti-duplicate query?
- Counter Property
- Is there a better way or counting values?
- Query with a Null value isnt working
- In the begining ...
- Save query as default/future choice
- Searching multiple tables
- Calculating Difference between closest two dates
- Subform from a Query Error
- Parameter query using "Or"????
- Current Records Query
- Format("01/01/03","ddd") Acc2000 cant read
- delete almost all rows...
- Need help with Query
- How to pass multiple value from a listbox to query
- Search problem
- SQL Statement Error
- Another "Null" Question
- Using Calculations on report from 2 queries
- Sums in Forms
- Merge Access to Word
- Remove "Run Query" status when running query?
- Turn null into 0
- Crosstab Parameter Queries Revisited
- Showing all records and updateable
- Problem Sorting info
- Count If?
- Updating stock control database??help!
- Dupe records don't show
- Getting last date in a crosstab
- Parameter Query only returning first record
- labels with a query
- Need a query that totals donations from each individual
- Anniversary Dates
- Please try and help me
- Create new field in query using IIF function
- More than one IIF statement in query
- Query based on calculated fields
- SQL code error!
- Ranking
- Case Sensitive Home Brew!
- HELP! please (the null values & the crosstable query)
- Help for my listbox
- Update Qry --> Duplicate All Values
- IIf problem...
- VBA Query --Help Me Pl
- Combining fields
- Help! Combining fields
- What kind of query can get the following result please?
- Compare the quantities of two different products
- Query
- Setting criteria in a query
- Append Query
- Exluding Weekends from Query Calculation
- Query too complex
- Group by Month
- Error 3134
- Remove Fields Query
- Query- calculations
- interesting result
- #error / division by zero
- Append to delete query?
- There can be only one!
- UK Post Codes
- Find Duplicates on Multiple Fields
- Interesting Duplication in Query
- finding unique occurences of a record in a table
- sql view (font, format and comments)
- Changing Record Sources in Open Forms
- Simple Compare Query
- Using Parameters in other Query
- version control
- Get correct record - help needed
- Find people who have NOT attended a class
- Just checking
- Sickness database
- Swapping Row & Column Positions
- Crosstab Query Sort Order
- iif statements
- need help with subquery
- Criteria in Query
- output to a table... Pl help. Thanks
- How to get Row Number in MS Access 2000?
- How to get row number in SQL
- Data extraction
- Get criteria from combo box
- Needs help about a function with dates