- How to merge 2 table into 1...
- Renumber a query
- Help with query...
- A series of data in column names? how to reformat
- target database as variable
- Trying to find fields located among other very similiar fields in the same column
- easy sql question..
- Need help using Multiple Select Statements
- search duplicate by surname and DOB
- Simple SELECT question
- A recordset cannot be updated
- Insert Variable Into a Query
- recordsets
- median
- User incorrectly gets prompted for parameter to query
- Query for Similar Words
- I have some questions about writing/using SQL; Can I ask those here in this forum?
- Joining one table to another table
- query to power graphical representation
- Time lapse in seconds between days
- Inner join & Distinct problem
- Update a field based on the number of records
- Settting up query
- Showing a part of a field in a query
- Pull previous week's data
- Populate two new fields by splitting data from existing field
- IIf([tempdatestore]![RoomNo]="*",0=True,1=False
- Create new record with specific data if criteria is met
- Simple query help!
- Join property expression
- top and sum
- Trying to import xls file and convert data to fields needed for a shopping cart.
- Query on Form Returns Multiple Records
- equivalent of Trunc
- Problem with * in query
- Multiple tick boxes totalled
- Counting the Number of text entries
- Search help
- A simple lookup Puzzle :
- Combine into One Record
- Subtract value from one field from another in the same field in another record
- Multiple fields in table
- combining two tables
- SQL Format String (Adding additional Text)
- Basic Insert Question
- Random Fact Query
- "Type mismatch in expression"
- Update SQL from a form
- Query
- newbie tearing his hair out HELP!!
- Help
- Get Rid of Duplicate
- Selecting the first and last record (Min/Max)
- Parameters for Data Import
- Using "IF" and "OR" statements in a query...
- Count records
- Dates Query
- query by today's date
- 30 60 & 90 totals
- Queries: Expression Builder '$' Functions
- insert into, where?
- adding prices??
- sum of
- IIf Problem
- newbie please help - can i put a lookup into a query ??
- cross-table query help
- Problem with calculated field criteria
- daily query...
- return a value from a range of values
- Criteria ??
- Query criteria = a specific record of a specific field
- Updating a Grouping Field - TransNumber
- Chart query
- Using WHERE with Count
- help needed please? Restructuring access table data
- Blank String problem...
- Record Order
- How to tell Access New Field is Date
- Count query - no records
- Brain freeze
- Running Sum On Value
- Update Query --- IIf
- Reworded question
- I can't enter data
- Concatenating fields from multiple rows
- Joining 6 tables
- Pop UP Calendar
- Exporting Query Results to Excel
- Counting Business Days
- Building an Expression Field within a Query
- Two aggregates in a crosstab
- i don't know what to call this
- Grouping
- append query?
- Displaying Null Values in a crosstab query
- IIF function paired with Between...And
- <this field> is less than <another field>
- Query Design
- Crosstable on parameterized Query
- For... ...Next Loop relating to Query
- Update ?
- PLz help with dates
- Sorting Date Formats
- Percentages
- need criteria to show last 5 records
- One Query based on many Queries
- Equivalency for Oracle's Minus SQL command
- I can't even describe this
- Can a query do this?
- Update Query Criteria
- SQL Query: Having 'OR' clause causes problems
- I have difficulty with a query
- problem with duplicates
- Help needed please
- Using a field to control display of another field
- Help Please! Defining Null as 0 for no Result
- Counting yes/no values
- Simple query
- Copy / Printing PivotTable View
- Calculating VAT
- duplicate based between time(s)
- Return a Zero Value
- Update query to fill in multiple blank fields
- cross table help
- Query question - Any help
- NewBee please help!!!!
- Seperate Returns into new Fields
- querying cascading combo boxes
- Append Query
- Joining a Query and Table while Excluding some results
- Paremount Query - selecting customer who are 35 and under + 36 and over
- Wages Calculation
- Join Problem
- Concatenate, but with more than one condition
- Number of Columns don't match
- making people smokers (query problem)
- Searching
- Sum by week ending
- Update Query
- Totals Query Query
- Keeps asking me to fill manually values for a column
- Time measurement
- Searching through a comma delimited list field
- query results table
- Displaying many tables one after the other
- Query for date greater than 6 weeks
- Exceed Resource Limit
- Query from form's combo box w/ field list!
- Cross Tab Query via VB Code
- Remove record from count
- Today's new records in Append Query
- Update problem
- Remove Duplicate records...
- Equivalent to GROUP BY ALL?
- DOB query
- Seperating data in records
- filter results
- Find Record (first Few Characters Of Key Word)
- VB/SQL using multiple criteria
- NZ Function problem
- Need help with a query
- Transfer records in a field to another field
- Query Based on Date Value in Form
- Combining SUM, Range of Fields, and dialog/parameter box
- Combo box Query problem
- Problem when grouping dates
- Queries, Pictures & Automated Procedures
- ****
- code needed
- Complicated Query from two tables
- ***
- query on two tables
- Date Problem
- Query by form I think
- SQL string is being shortened
- Removing spaces from the middle
- Show records NOT in related table
- Dlookup in Query
- problem with ADODB.Recorset
- I actually want a cartesian product
- Timing out on insert statement.
- Query keeps prompting for form code
- Help Needed Please
- Formatting Table from Make Table Query
- Start Date and End Date question
- A combo box question?
- Count applicants
- Trying to Join two Queries
- Access 2000 equiv of InStrRev and Replace
- Set blank field to zero
- Joining two linked tables in one query
- Calculating number of days between multiple dates
- SQL BETWEEN command
- Can't figure out query with multiple filtering options
- Finding records that match comma delimeted memo field
- simple query question
- IIF Function in Query
- Append & Delete
- Retrieving all data including null values (help!)
- Delete query failure
- Multiple Date Criteria
- Addition is not working in query
- Query Similar Duplicates
- count from more than one query
- Weeknumber in a querry
- Usin "AND" criteria on the same field
- How do I pass a Form value to a VW, SP or FN in SQL Backend?
- Providing default values in user prompt
- Replacing characters in Access 2000
- Running multiple query help
- select criteria to run query
- Preparing data
- Criteria error
- Stop creating duplicate records
- Maybe I am doing something wrong
- Select Querry
- If AND
- I need a Query to do a ...
- Multiple Criteria from Form
- Matching
- Maybe a Simple Update
- Like setcriteria()
- Excel > Access query problem
- Getting an Id into a table from another table
- Non related tables in a query
- Rolling number of days dataset?
- Appending data to multiple related tables
- Newbie question : Calculation on Queries
- Using Query and finding specific records
- Crosstab query with criteria form
- Select multiple records with "In" by user input?
- Crosstab query - column display order
- Seperating a Field
- Second Highest Max
- Sort date formatted as year and week
- Count text fields in a query
- Relational Database to Flat File Query
- E-mail Hyperlink Problem
- Concantenation and Null Values
- Filter in a query
- Self-join append... "thing"
- Union query: Field Size is Too Small
- Time for running a Query too long!
- Query with conditional form criteria
- How to show the longest days?
- Show all fields from a linked table for each record
- Problem with data type of calculated value in query
- How can I accomplish the equivalent of a lookup table?
- Selecting Records Based on 3 Criteria
- Help on sorting