microsoft.public.access.queries
- IIF statement in query criteria to have "Like "*" or Is Null" as the result if true,
bdt513
- Re: SQL Syntax Bug,
Jeff Boyce
- Form variable in query,
Tezza
- help with sql query,
ifoundgoldbug
- Column Order in Output,
tmort
- Re: Using Totals w/ an Updateable Recordset,
Allen Browne
- Export to Excel??,
Ket
- using a query to compact and repair,
Nick Monsour
- Re: Borders disappeared,
Rick B
- join with no related field,
mcnews
- What should be a simple table comparison...,
nintendomasta811
- Re: Enter Parameter Value Message,
John Spencer
- Performing expression on all (varying number of) fields,
jeremy . groups
- Trick for ColumnName,
x-rays
- Replace data in field,
anil
- Query with Multiple IIF,
rdemyan via AccessMonster.com
- Re: last day of month,
Rick Brandt
- Re: Query To Retrieve Less Than or Equal To,
MGFoster
Re: Database Search with string portion,
John Spencer
combine valu es from 2 fields,
JN
Re: Access 2003 Query by form,
Allen Browne
Re: how do I pirnt the lines in the excel ledger,
Douglas J. Steele
Re: What's max limit for MAXLOCKSPERFILE in registry?,
david
Error executing sql statement,
Ivan Debono
How to search between main & sub-form?,
hkgary33 via AccessMonster.com
Correct Profit Margin (%),
LJG
How do I STOP access sorting my data?,
dave.mclachlan@xxxxxxxxx
Re: my employee listing,
Amy Blankenship
Query for all recs Between 7/10 at 2:PM and 7/12 at 6 PM ???,
kev100 via AccessMonster.com
query like to search for upper case characters,
monsey11
Re: Selecting the top 1/3 of a table,
John Spencer
Re: Update query or create new table query or ??,
Amy Blankenship
Re: select information from a field,
Jeff L
Comparing 2 access databases,
Ivan Debono
Create INSERT SQL statements,
Ivan Debono
Setting DEFAULT to empty string using SQL,
Tomas Eklund
Re: How do I count tick boxes in Access?,
John Spencer
Re: Query Message,
John Spencer
need to update record with autonumber as primary key,
MES via AccessMonster.com
How to set up a criterion that returns everything but one option for that field,
Sari
Re: Comparing 2 tables, deleting duplicates,
John Spencer
showing only one Field record,
jumpy262000
ad post and related fields,
Maria
Data not updating on table from form,
Gwen
Re: Calculating Class Percentages by Student,
Duane Hookom
Re: Percentage Calculation,
tina
Re: Embedded Iif statement,
fredg
DateDiff Calculation Off By One Year???,
Ronster
Re: leading zeros in month and year fields,
Douglas J. Steele
Re: Help with WHERE part of SQL statement,
Michel Walsh
Re: DateDiff,
Michel Walsh
Re: Creating Dates in a Query,
John Spencer
Re: Vacation Calculation,
Jeff L
find unique rows,
reversetype
Re: How to use update query to update multiple fields in a table,
John Spencer
Re: More help for Trim of Mailing Address,
Jeff L
Display the LASTEST TIME from the records returned in Query,
kev100 via AccessMonster.com
Re: multiple criteria,
Allen Browne
Re: Using BETWEEN AND with DatePart,
Jeff Boyce
Re: Acess Query,
Jeff Boyce
Re: Update query only works the first time,
Jeff Boyce
Problem with Dates in Access/Visual Foxpro query,
mark . godecke
Re: Multiple Query Parameters,
John Spencer
Re: Subquery to pair off line items,
John Spencer
Re: Trim(Left( -- what if no spaces?,
John Spencer
Lookup data display,
shank
Re: Crosstab Query - Horiz and Veritcal Buckets,
Duane Hookom
Audit trail,
Elainie
Re: Make a Hidden Table,
Allen Browne
Re: Query returns all records not just selected,
Rick Brandt
syntax error,
cporter
Re: query date ranges,
OfficeDev18 via AccessMonster.com
proc pls outmodel,
maarb6
Query Code and Form,
Russ
error in delete query,
Maria
Append NOMATCH DATA,
learning_codes@xxxxxxxxxxx
Delete a file from MS Access,
abou_ddan via AccessMonster.com
Grouping!?,
Ron
MS SQL,
Gregc.
Form Question "Continued",
Rodney
Re: How to deal with run-time error # 3122 using VBA in MS Access?,
strive4peace
Re: Update Query only works first time,
strive4peace
Show null in Select Query.,
jenn . semo
Expression too complex Error,
Jen
Re: DateTime Format,
Michel Walsh
Re: round eror in 2003 and VB6,
Michel Walsh
Re: Sum Query,
Michel Walsh
Using 2 multiselect list boxes,
kwaldman
Re: How can I open a picture CD made from Apple Computer,
John Spencer
Inserting Records in Query Based on Value from Field Table,
david . isaacks
Problem with Visual Foxpro dbf query,
mark . godecke
Inputting what partial data I need,
lucidxile
Comparing Values,
lewysjones
Re: Showing certain criteria in a query,
Holly
Security Features on Access Database,
Juan
Re: 4 Table query,
Allen Browne
Re: Selecting child records,
Jamie Collins
Re: Form Question,
Allen Browne
Re: Removing alpha characters from string,
Svetlana
Re: count unique combinations,
Jamie Collins
Re: division by zero,
Duane Hookom
Re: tickler for quarterly reports,
Allen Browne
SQL Statments _ON_ a query/recordset,
robertjaym@xxxxxxxxx
RE: rename fields in queries,
KARL DEWEY
Re: Update Query not Updating,
Michel Walsh
Re: date range question,
Michel Walsh
Re: Count Checkboxes Per Day,
Michel Walsh
Re: time conversion,
Wayne Morgan
Re: Is record time field value > n min after the next rec ID,
John Vinson
Re: two parameter query,
Marshall Barton
Re: Help with a query,
[MVP] S.Clark
Re: Combining Fields Within Query,
John Spencer
Re: Group by for Latest Equipment Repair,
[MVP] S.Clark
Pass thru Query problem - converting from a case /replace in SQL,
Holly
update query conditional data,
cporter
Re: update query conditional data,
John Spencer
UNION QUERY,
geebee
Access query help??,
Ynot
Re: Copying calculated values into existing fields,
Jeff Boyce
Re: Returning the existing value,
Vsn
Re: Combining rows in query,
Vsn
Re: Accidentally Ran Append Query Twice; Need to Delete,
John Spencer
How to expand query to include multiple weeks,
jas0n
Delete main record that has no subrecords,
mcdowdjr
understanding an sql query result,
Bob Weiner
Re: how do I to build a simple search expression using a query,
fredg
Too Many records showing up,
SAC
Re: Monthly billing,
OfficeDev18 via AccessMonster.com
Re: Limiting my query responses,
Svetlana
Incremental User input into Listbox display problem...,
Regnab
Count Query Help,
Daveo
Positions 1st, 2nd, 3rd etc,
Peter Mitchell
Allocating 1st, 2nd, 3rd etc,
Peter Mitchell
query add to table from other table,
informatique
Re: Mail Merge from Query instead of Table,
Iona
Combing the Output from Two Queries,
Gregc.
Coax the DatePart Function into Two-Digit Month Output?,
tbl
Re: how do i subtract figures in attendance from the figures in capac.,
Duane Hookom
Re: Query Returns First 255 Characters of Memo Field,
Duane Hookom
Re: 2 crosstabs,
Duane Hookom
Re: Nested Queries,
Jeff Boyce
RE: Multiple criteria causing confusion,
KARL DEWEY
Re: separating data into new table,
Jeff Boyce
Re: Calculated total scheduled work hrs per day and per week in Access,
Michel Walsh
Re: Problem with a query comparing multiple feilds,
Michel Walsh
Re: Exclusion Logic,
John Vinson
Re: How do I query two fields from one table at the same time,
John Vinson
Show Rec's AFTER certain Time AND Date WITH Default Date Entry....,
kev100 via AccessMonster.com
Re: query helppppppppppp,
Craig Hornish
Query on all tables?,
FpwL1399
Re: Update blanks to zeros,
Jeff Boyce
Re: Exclude a field from a query,
Jeff Boyce
Re: ODBC linked tables vs. SQL specific passthrough,
Jeff L
RE: crosstab,
geebee
RE: Counting of Dates,
Ofer Cohen
RE: Union query dropping duplicates,
sebastian stephenson
Re: Date query not giving EndDate,
Allen Browne
How to query for latest record by date & time?,
hkgary33
Running Total - Running Sum,
Jacques
RE: List of Matches in WHERE Clause,
Ofer Cohen
Re: Subtracting Hours,
Duane Hookom
Re: If Statments in Access,
Duane Hookom
Re: combo list problems,
SusanV
Please read this it may be helpful to you.,
James Henry
Re: How do I access the keyboard layout. EX. Russian vs English,
SteveS
RE: Problem when I change the starting value of an autonumber fiel,
Remy
Re: problem adding new field to query,
Allen Browne
From string to long date,
abou_ddan
Re: Parameter query runs on one pc but not on another,
Allen Browne
Re: Query for Field Names,
Allen Browne
Re: Query Criteria help.,
John Vinson
Form control value update via SQL quick 'n' easy statement help...,
blfreei
Re: Updating two subforms,
Marshall Barton
Re: query returns duplicated fields from the table,
Marshall Barton
Re: Find and replace,
Marshall Barton
Re: minus 6 weeks,
fredg
Query Help,
Jay
- Re: Query Help,
Ken Snell \(MVP\)
- Re: Query Help,
Jay
- Re: Query Help,
Ken Snell \(MVP\)
- Re: Query Help,
Jay
- Re: Query Help,
Ken Snell \(MVP\)
- Re: Query Help,
Ken Snell \(MVP\)
- Re: Query Help,
Jay
- Re: Query Help,
Ken Snell \(MVP\)
- Re: Query Help,
Jay
- Re: Query Help,
Ken Snell \(MVP\)
- Re: Query Help,
Jay
- Re: Query Help,
Ken Snell \(MVP\)
- Re: Query Help,
Jay
- Re: Query Help,
Ken Snell \(MVP\)
- Re: Query Help,
Ken Snell \(MVP\)
- Re: Query Help,
Jay
- Re: Query Help,
Ken Snell \(MVP\)
- Re: Query Help,
Jay
- Re: Query Help,
Ken Snell \(MVP\)
Re: run an append query on a selected record,
Steve Schapel
Re: DistinctRow for Date portion of a DateTime column,
Steve Schapel
Re: Column limits on queries,
betwalk
Re: crosstab query,
Michael Gramelspacher
Re: value copied,
Michel Walsh
Query as Form RecordSource question,
WAstarita
Re: Query based on Form Fields,
Gary Walter
<no subject>,
叶美娟
Query to group and count distincy products,
bhavin.pardiwala@xxxxxxxxx
Re: Access Query,
Allen Browne
calendar month report,
aar241
Re: Form to change query criteria,
John Vinson
Re: What does blocked mean when besides anothers name?,
John Vinson
Re: Help with query,
MGFoster
Re: Query Design Help,
MGFoster
Calling Queries with parameters from form events,
M . McDoom
Re: Running a query when checkboxes are included,
Lynn Trapp
Re: delete duplicate records without creating a new table?,
Lynn Trapp
RE: Complex Crosstab Query,
Robert_L_Ross
Re: how can i make a query that is linked from one field in table 1 to,
John Vinson
Re: What happend to the "Total" row in Select Query?,
Rick Brandt
Question regarding and/or Query,
Joe C
Re: Repeating Rows...,
Duane Hookom
Re: Top 10 of each,
John Spencer
Count Unique Field Values,
Katherine
Re: Remove Character from field,
Juan
Adding null Cell in Query Mode,
Juan
Delete data from table that was in another one.,
eclypz
Make Table Query Help,
efgh
Update Yes/No on One table depending on Set of Records on another,
Hotshots
Re: Query Criteria,
MGFoster
Re: Syntax error (missing operator) in query expression,
Gary Walter
Can Access to "FULL OUTER JOINS"?,
Conan Kelly
Re: Combo boxes on query datasheet view,
Conan Kelly
- Message not available
- Message not available
Combine two tables with a query - How to?,
Shyguy
Re: need number in Criteria not enter number,
John Vinson
Re: need number in Criteria not enter number,
John Vinson
Help with SQL Query - Conditional SHOW,
Jen
Can't figure out a Query,
Jay
Re: If null then display zero,
Michel Walsh
Re: convert or replace number using .(dot) for decimal to ,(comma),
Michel Walsh
Re: Query Update Limits List Box Choices,
Michel Walsh
Re: Changing currency criteria with a check box on a form,
OfficeDev18 via AccessMonster.com
How to get around the dialogboxes when a delete query is launched,
Tom E Jensen
Re: Query Active directory and populate access table,
MGFoster
Re: exclude records,
John Vinson
Re: Summing top 3 results,
MGFoster
Re: I am trying to do a query to find grades a, b or c from a grades t,
John Spencer
Re: Complex formula,
John Spencer
Re: Top n Query,
John Spencer
Re: Help with character count in queries.,
John Spencer
Re: Access Query Right Align,
MGFoster
- <Possible follow-ups>
- Re: Access Query Right Align,
Gary Walter
- Message not available
- Re: Access Query Right Align,
John Vinson
- Message not available
- Re: Access Query Right Align,
Gary Walter
- Re: Access Query Right Align,
Donna
- Re: Access Query Right Align,
Gary Walter
- Re: Access Query Right Align,
Donna
- Re: Access Query Right Align,
Gary Walter
- Re: Access Query Right Align,
Donna
- Re: Access Query Right Align,
Gary Walter
- Re: Access Query Right Align,
Donna
- Re: Access Query Right Align,
Gary Walter
- Re: Access Query Right Align,
Donna
- Re: Access Query Right Align,
Gary Walter
- Re: Access Query Right Align,
Donna
- Re: Access Query Right Align,
Gary Walter
- Re: Access Query Right Align,
Donna
- Re: Access Query Right Align,
Donna
- Re: Access Query Right Align,
Gary Walter
- Re: Access Query Right Align,
Donna
- Re: Access Query Right Align,
Gary Walter
Re: Including records,
Rick B
Missing Weeks/Months in a Crosstab,
Conan Kelly
Re: Not operator,
Debra Farnham
OnOpen Event of a query,
NathanJ
Re: Report Queries,
Allen Browne
Changing when a day starts and ends,
Mark
Re: Appending one row at a time,
Duane Hookom
DEFAULT Value in a Query PROMPT (Criteria-type) ??,
kev100 via AccessMonster.com
Re: Deleting records from one table contained in another?,
Mathieu Pagé
Re: Help with Master Documents query!,
Gary Walter
HELP with query to sort by date and last entry,
M . McDoom
Appending data and Cross Table queries Question,
Faisal...
Re: can i combine columns from tables into a one column query,
Mathieu Pagé
Bug in Access Execution plan ?,
Mathieu Pagé
Re: AutoLookup Queries and data in tables,
Duane Hookom
Re: Financial Year quarter,
John Spencer
Re: IIF Statement fustration,
John Spencer
strange query error,
Joseph S.
Re: remove Hotmail emails from a query,
John Spencer
Re: Wrong data returned on "Between" "And" parameter in simple query,
Allen Browne
Re: Get the Minimum Value for a set of record,
Allen Browne
Re: Jet engine stopped,
Allen Browne
Re: expression which calculates GST at 7% before July 1 and 6% after?,
Ken Snell \(MVP\)
Re: Hours per WorkWeek calculated from Start / Finish Dates?,
lottaviano@xxxxxxxxxxx
Re: Need to export a pivot chart view of a query,
jordanjennings
Multiple subqueries in a union query,
Steve
Re: Reformat date 10106=Jan 1,06,
MGFoster
Re: Help please !,
Duane Hookom
Re: how return max value from one of three "fields" in a query?,
MGFoster
Re: FORMAT WEEK NUMBER,
MGFoster
RE: Query return value is Null,
OfficeDev18 via AccessMonster.com
Re: Query with two time periods,
Jen
RE: Dynamically build an Access query,
Klatuu
Re: What is the difference DBEngine vs Current DB?,
Allen Browne
Re: Query for time period,
tiger0268 via AccessMonster.com
Re: Filter for Previous Month's Records,
Allen Browne
Attempting to Create a "Top N Values Per Group" Query Runs Unexpec,
Orlanzo
Re: How to use several joins in one query?,
OfficeDev18 via AccessMonster.com
Re: convert date format from mm/dd/yyyy to dd/mm/yyyy,
Allen Browne
Convert to string/varchar?,
KatMagic
Query returning duplicate entries,
cbure
Re: combo box in form to operate query,
Allen Browne
Re: Problems with SQL Query Counting Unique Records,
mark . godecke
Re: Error in Reporting from Crosstab Query,
Duane Hookom
Calculating Weekdays in a query,
T Best
Re: Report only last record,
Duane Hookom
SQL Query Double Counts on Multi-Table Query,
Rich
Re: Help calculating AGE!!,
Gary Walter
Re: Slow Subquery to make a calculation with a previous record,
Gary Walter
Formatting Text Problem,
Mac
Re: Saving a query outside of the database,
Allen Browne
Re: Calender control,
Anne
Re: Calculated field??,
Teri
Re: Select Query to Make Table Query,
John Vinson
Re: Multiple Iif statements?,
tina
Finding time overlaps,
JKlein
Simple Calculated field wont work!,
alecgreen
Re: Simple Update Q Problem,
MGFoster
Divide by Zero when it should not.,
Mathieu Pagé
Re: how to save info with timer,
fincenobite
Re: List Box within a query,
Allen Browne
Function returns #error in a left join,
Fjordur
Re: select query,
Svetlana
HELP PLZZZZ (can i use NOT IN for this case???how to???),
marco_pb via AccessMonster.com
RE: help with querry,
Supicek
Re: Query does not show all,
Allen Browne
Re: Try again,
Duane Hookom
Re: fake it for the public image and then shout and yell and slam the,
John Vinson
Re: I've been fighting with this for weeks now,
Ken Snell \(MVP\)
Re: Create a telephone book search in a website,
Duane Hookom
Beginner query help please,
hmcgregor
- Re: Beginner query help please,
Duane Hookom
- Re: Beginner query help please,
Iona
- Re: Beginner query help please,
Iona
- Re: Beginner query help please,
Duane Hookom
- Re: Beginner query help please,
Iona
- Re: Beginner query help please,
Duane Hookom
- Re: Beginner query help please,
Iona
- Re: Beginner query help please,
Duane Hookom
- Re: Beginner query help please,
Iona
- Re: Beginner query help please,
Duane Hookom
- Re: Beginner query help please,
Iona
- Re: Beginner query help please,
Iona
- Re: Beginner query help please,
Duane Hookom
- Re: Beginner query help please,
Iona
- Re: Beginner query help please,
Duane Hookom
- Re: Beginner query help please,
Iona
- Re: Beginner query help please,
Iona
- Re: Beginner query help please,
Duane Hookom
Re: Printing,
Ken Snell \(MVP\)
Re: Dlookup formula in query using BETWEEN,
Gary Walter
Re: How to get desired results from query,
Michel Walsh
Re: Access query, ignores a multiplier uses a 1 value instead,
MGFoster
Re: IIF Function for Queries?,
MGFoster
Re: Time Calculations,
Douglas J. Steele
Re: Update Query - Error 3113,
John Vinson
Re: Display records from previous month,
Lewis M
Re: CrossTab Query - Display Is null Fields,
Duane Hookom
RE: Conditional Record selection,
wal50
Re: date range selection and verify,
Allen Browne
Re: This one's a challenge: 1.9 not equaling 1.9..... What's going on???,
pwizzle
Re: Single choice from multiple fields,
Allen Browne
Changing a date to start of next month,
David Gartrell
query won't run in access 97,
Hornsby
Re: Access 2003 Email a query,
[MVP] S.Clark
Rankings baseline performance,
zartan
Re: add value to results returned by a query,
Duane Hookom
#Error,
Gary
Re: Query from an unbound form,
Armen Stein
how to convert rows to column in Access,
kirtagrawal
Re: How to create a query that will evaluate multiple check boxes,
tina
Re: Using a union of a left and right join for subreport,
Michel Walsh
Re: How can I?,
Michel Walsh
Re: Pulling data that is null (front and back end),
Michel Walsh
Re: subquery,
Michel Walsh
Re: Last 30 days in Query,
Michel Walsh
Re: button action,
Michel Walsh
Re: How to set default Recordset type,
Michel Walsh
Re: Covariance Query,
Michel Walsh
Re: Can i use Select Distinct?,
Michel Walsh
Re: display results in columns,
Michel Walsh
Re: module coding in query,
Michel Walsh
Re: Update muliple records query,
Michel Walsh
Re: reference form for update variable,
Michel Walsh
Re: SQL table Access combo box,
John Nurick
Re: Query TIME saved as TEXT to Sort PROPERLY (e.g. 1:36 PM to list after 10:00AM) ?,
John Nurick
Re: Help get me started: transfer query,
Rob Parker
Re: Multiple Field Search Query,
Ryan
Re: Not appending correct data,
John Vinson
RE: a question about alter procedure,
Michael Gramelspacher
Re: Simple Query, complicated user.,
Bill (Unique as my name)
Re: Date Parameter,
John Vinson
Re: Update Query Failure due to Validation rules,
Conan Kelly
Re: "Group By" makes Simple Query Run FOREVER,
Marshall Barton
Re: return a list of dates when nothing happens,
news.shaw.net
Re: Date Criteria pulled from Calander,
Conan Kelly
Re: Count between times,
Jeff L
Re: matching on multiple records in two tables to find a match,
Jeff L
</