microsoft.public.access.queries
- Union Query order By clause Error,
saraqpost
- Message not available
- Message not available
- Re: query criteria that will include all,
Marshall Barton
- Re: Inconsistent Output,
John Vinson
- Re: Empty But Not Null,
Ken Snell \(MVP\)
- Creating a simple query with many secondary tables,
Alain T.
- Re: Command Line Query Tool for Access DB,
Marshall Barton
- RE: Return a weekday on a query,
Frank
- Link Two Tables - Missing Information,
learning_codes@xxxxxxxxxxx
- User Defined Functions,
JohnCreighton_
- Help -- Is my there any way to not count duplicate values here?,
ShadesOfGrey
- Message not available
- Message not available
- Set Complement and Temporary Tables,
JohnCreighton_
- Re: Convert date to year,
Tom Lake
- RE: Turnover query,
Tandy
- Re: sum two seprate fields in query,
Steve Schapel
- Re: Storing binary images in Access,
Rick Brandt
- A kind of reverse concatenate,
Hallgeir
- Resources for Writing Advanced Queries,
Tonk
- DATABASE LOCK,
Darkslave
- Re: Fill blanks with value from previous record,
John Vinson
- I think this is simple...,
Shimshee
- Re: Calculating Vacation Time,
Smartin
- Re: Trim Initials from Name field,
Rick Brandt
- Message not available
- Message not available
- Count(Distinct()) with multiple fields,
S Davis
- query not returning any records,
Slez via AccessMonster.com
- sql statement with error #933,
perryclisbee via AccessMonster.com
- run queries by the batch,
Tonk
- PT ODBC sql statement list issue,
perryclisbee via AccessMonster.com
- Re: Does a recond have children?,
Rick Brandt
- discrepancy between SQL and Design view,
Tonk
- Help me construct this count distinct query!,
S Davis
- Re: email zipped file,
John Vinson
- how to locate duplicates ??,
WANNABE
- Re: 2-digit year!,
Rick Brandt
- Connect to secure database?,
ana9 via AccessMonster.com
- Re: update query design questions,
Rick Brandt
- Need help with Update query,
dee
- RE: Copying in a query,
Mike
- Re: I need to know how to exclude names in a query,
Rick Brandt
- One field with multiple values in combination with calculations in a Query,
Andre
- Re: Need help with query,
Gary Walter
- Union Query Not writing to table,
Brian
- Re: Query with most recent contract,
Marshall Barton
- RE: IFF One Date = Another Date,
Nanette
- Re: Text to Numeric,
Ken Snell \(MVP\)
- Re: Square Peg in a Round Hole,
David F Cox
- RE: display top 5 records of each subgroup in a query,
KARL DEWEY
- Re: Making it harder than I need to,
Rick Brandt
- Join Problems,
Tonk
- Re: Multiple records are changed automatically - unwanted auto fill,
Rick Brandt
- Message not available
- Message not available
- Message not available
- Re: Countif ?,
Rick Brandt
- Re: Workaround to create sub-forms based on pass through queries.,
Rick Brandt
- Re: Query Date,
Rick Brandt
RE: delet query password,
Jerry Whittle
Make Table Query Table name restrictions,
azpat via AccessMonster.com
Date Range Issue,
Kevin
ALTER TABLE ?,
Francois
Re: Only Shows Small Portion of Data,
John Vinson
Re: replace empty values,
Smartin
RE: Show Specific Data Only,
Nanette
Re: Delete query warning message,
John Vinson
Re: how to create an update query?,
Ken Snell \(MVP\)
playing w/dates,
Ron
Re: if table is null then incluse all record else only in table ...hel,
John Vinson
basic counting problem,
Jean-Paul
add a field in a query for ALL observations, where only the value of the field is available for only few, rest should be zero,
zia
- Re: add a field in a query for ALL observations, where only the value of the field is available for only few, rest should be zero,
'69 Camaro
- Re: add a field in a query for ALL observations, where only the value of the field is available for only few, rest should be zero,
zia
- Re: add a field in a query for ALL observations, where only the value of the field is available for only few, rest should be zero,
'69 Camaro
- Re: add a field in a query for ALL observations, where only the value of the field is available for only few, rest should be zero,
zia
- Re: add a field in a query for ALL observations, where only the value of the field is available for only few, rest should be zero,
Smartin
- Re: add a field in a query for ALL observations, where only the value of the field is available for only few, rest should be zero,
'69 Camaro
- Re: add a field in a query for ALL observations, where only the value of the field is available for only few, rest should be zero,
Smartin
- Re: add a field in a query for ALL observations, where only the value of the field is available for only few, rest should be zero,
'69 Camaro
- Re: add a field in a query for ALL observations, where only the value of the field is available for only few, rest should be zero,
Smartin
- Re: add a field in a query for ALL observations, where only the value of the field is available for only few, rest should be zero,
'69 Camaro
- Re: add a field in a query for ALL observations, where only the value of the field is available for only few, rest should be zero,
'69 Camaro
- Re: add a field in a query for ALL observations, where only the value of the field is available for only few, rest should be zero,
'69 Camaro
- Re: add a field in a query for ALL observations, where only the value of the field is available for only few, rest should be zero,
Gary Walter
- Re: add a field in a query for ALL observations, where only the value of the field is available for only few, rest should be zero,
Gary Walter
- Re: add a field in a query for ALL observations, where only the value of the field is available for only few, rest should be zero,
zia
- Re: add a field in a query for ALL observations, where only the value of the field is available for only few, rest should be zero,
'69 Camaro
Re: Query Help with Joins,
Smartin
Query for Days since she was born,
Bikini Browser
Very slow query,
Alain T.
need to save this data to either a database (access or oracle) or spreadsheet (excel),
Mohsin
Re: Errors after table name change,
tina
Re: Help with If statement,
John Vinson
Calender Control,
Rustle
Need Help!,
Russ via AccessMonster.com
what's wrong with my query,
cho
HOW TO SAVE DATA IN ACCESS & ORACLE TABLE FROM VISUAL BASIC FORM,
Mohsin
Re: Calculate date,
John Vinson
Re: simple data replacement,
John Vinson
IIF Issue in Query,
mattc66 via AccessMonster.com
Re: Streak - how to calculate,
John Nurick
Slow Query?,
Smartin
Re: Number of the same contents of cells in a column of a table by a .,
Gary Walter
Re: Using the replace function,
John Spencer
Re: separate first and last name,
Rick B
dynamically querying different tables based on a value in a combo box on a form?,
Conan Kelly
Re: IIF statement as query parameter,
John Spencer
Query Become read Only,
Roy Goldhammer
Re: Need All In Table To Show,
John Spencer
Re: Fiscal Month Query,
John Spencer
Merging rows,
bau
Re: Group By Sequential Records,
John Nurick
Re: remove dashes,
John Vinson
Re: VBA verbal as a criteria,
Allen Browne
Re: Dsum return 0 instead of Null?,
Allen Browne
Re: Need proper syntax for embedding DLookup inside DSum,
John Vinson
RE: How can I rank records in a query in Access?,
KARL DEWEY
Using a year from a text box in a qurey,
Paul B
Re: Using a year from a text box in a qurey,
John Vinson
Re: Using a year from a text box in a qurey,
John Spencer
Re: Need One Date,
jlepack
RE: concatonating,
Mackster66
query gets wrong data from tables,
blee via AccessMonster.com
Re: Access 2003: How many queries?,
Rick B
Re: Querie issues,
Jeff Boyce
Re: Date/Time Function,
John Spencer
Re: Can't get query to return proper records from ODBC,
John Spencer
<Possible follow-ups>
Re: Can't get query to return proper records from ODBC,
Jeff Boyce
Re: Queries - selecting certain area codes in phone field,
jlepack
Re: Expressions question,
John Spencer
Complex Environ question,
MARK
Re: Parameter asked too many times,
Allen Browne
Re: Combining Fields,
Allen Browne
Re: using one parameter input to search multiple fields,
Allen Browne
Actual / projected spending,
Russ via AccessMonster.com
open a table to update or add record,
bigbore50@xxxxxxxxx
Re: yes or no fields,
Rick B
Re: Calculating Query,
bigbore50@xxxxxxxxx
expected:end of statement,
kennytwk via AccessMonster.com
SELECT Username,
kennytwk via AccessMonster.com
Re: Search criteria Allen Browne Program,
Allen Browne
Help with Conditionals,
JohnCreighton_
Finding only the most recent visit with a customer,
JudgeYugiDad
Strange Behaviour in Crosstab,
Rob Parker
format date question?,
Russ via AccessMonster.com
Re: populate one table from 2 others,
jlepack
Sql filter for MS Access?,
antonyliu2002@xxxxxxxxx
how can I count records ?,
Roger
What's the problem here.,
jlepack
Transposing rows into columns,
anthony . pierdominici
Re: Locate an X within the data,
John Vinson
Re: Date as text,
John Spencer
Re: IIf statement,
Allen Browne
- <Possible follow-ups>
- RE: IIf statement,
Barry
- RE: IIf statement,
Barry
- RE: IIf statement,
Duane Hookom
- RE: IIf statement,
Barry
- Re: IIf statement,
John Spencer
- Re: IIf statement,
Barry
- Re: IIf statement,
Barry
- Re: IIf statement,
Barry
- Re: IIf statement,
John Spencer
- Re: IIf statement,
Barry
- Re: IIf statement,
John Spencer
- Re: IIf statement,
Barry
- Re: IIf statement,
Barry
- Re: IIf statement,
John Spencer
- Re: IIf statement,
Barry
- Re: IIf statement,
Jamie Collins
- Re: IIf statement,
Jamie Collins
- Re: IIf statement,
Barry
- Re: IIf statement,
Jamie Collins
- Message not available
- Re: IIf statement,
Jamie Collins
- Re: IIf statement,
Barry
- Re: IIf statement,
Barry
- Re: IIf statement,
Jamie Collins
- Re: IIf statement,
Barry
- Re: IIf statement,
Jamie Collins
- Re: IIf statement,
John Spencer
- Re: IIf statement,
Jamie Collins
- Re: IIf statement,
Barry
Tracking spending by payee / matching data problem,
Russ via AccessMonster.com
Re: Creating a List With Database Tables and Fields, Queries, etc.,
John Spencer
Re: Group by and Sum in same query,
John Spencer
Query includes Quotation mark,
Ger
How to Save Visual Basic Data with Access or Oracle through Data Control or ODBC,
Mohsin
Why is my copied Query is keeping parameters?,
M.Garza
Re: If statement,
Arvin Meyer [MVP]
Message not available
<Possible follow-ups>
Re: If statement,
Jamie Collins
Re: If Statement,
Jeff Boyce
RE: If Statement,
KARL DEWEY
Re: Only Update per criteria,
John Vinson
Right records on a query but doubling up when summing them,
cranberryconsult
Easy Update Question,
Matt
Join query,
chun via AccessMonster.com
all dates with month greater than equal current month,
tlyczko
Re: Error Handling when converting Text to Numbers,
John Spencer
Re: choosing only a record from multiple,
John Spencer
Date Format Issues,
DB
Indexing an Oracle Table,
CCheatham
Combo Box Filtering,
rozycki1978
Conversion error in Append Query,
robin9876
Re: Query Trouble,
John Spencer
Help Combining Two Queries...,
Sean Massey
Re: Help with query,
John Spencer
Can These Queries Be Combined?,
Tonk
Re: LOOKIN G FOR EMPLOYMENT LOOK HERE!!!!!!!!!!,
Tom Lake
Re: In Access, how do I display record yet omit empty fields?,
Rick Brandt
DLookup in Query Criteria,
steve
Re: Pass Parameter as Table Name in SQL,
Allen Browne
Search Form Results,
sunshineleo
Re: Null and Zero length strings,
John Spencer
Re: 2 mult listboxes parameters,
Gary Walter
Using ActiveX Calendar to pupulate dates,
MARK
updateable problem,
Roy Goldhammer
Re: how do I find last record of a group using query/SQL in Acces,
Allen Browne
Can I reference a form field to get a variable and use it in a query?,
wazza_c12
Re: Prompt to show field parameter query,
Allen Browne
Query criteria,
SF
Monthly Total,
kalensk
Re: Expression used to calculate previous ytd count,
chickalina
Re: "query is too complex" error message,
Allen Browne
Re: Null Not Working in Query Search Criteria Variable,
Ronster
Re: Nested IIf (I think),
fredg
Re: Expression for Date,
Amy Blankenship
How do I add a total column to this query?,
ShadesOfGrey
Re: Show only the last one by code and date.,
Jeff Boyce
Problems with Date calculation in Query,
Murphybp2
Date Function in Query builder,
The Joker via AccessMonster.com
Re: Invalid use of Null,
David F Cox
Re: word locating,
David F Cox
Re: data type error,
Lynn Trapp
TransferSpreadsheet Problem,
MARK
change data type from decimal to double,
Bongard
Renaming query fields,
John T Ingato
Weekday,
Gaetanm via AccessMonster.com
Re: count functions within a query,
Lynn Trapp
books on SQL,
steve
What do I need?,
bigbore50@xxxxxxxxx
Front-end db run Parameter query in back-end Access db using ADO?,
BogMonster via AccessMonster.com
RE: Query Criteria not working,
Todd
Re: What are the steps to change numbers to currency in queries?,
Tom Lake
Counting Unique Data 2,
TeeSee
Re: Display Weight in Lbs and Oz.,
Douglas J. Steele
Re: Counting Unique Data,
David F Cox
Function - Module,
learning_codes@xxxxxxxxxxx
RE: Comparing Fields using Wildcards,
TDAnderson
How to create this query,
CJA
Re: change value name,
David F Cox
RE: insert a Parameter query into a form,
Ken Sheridan
Re: Quarterly Sales Tax Query,
Alp Bekisoglu
Re: how to add data?,
John Spencer
RE: find and replace data,
wisconsinexplorer
Adding an autonumber field in a query?,
Alp Bekisoglu
Re: Query: return value if within + or - 10% of entered value?,
David F Cox
How to create a query view, one person per line,
Elaine16025
Re: query to return a single entry for client name,
David F Cox
Re: Update Query to change text?,
John Vinson
Re: Crosstab query alters numeric values,
taurus via AccessMonster.com
RE: Query Count,
Chey
Update macro,
ladybug via AccessMonster.com
Re: Create a front-end to keep people from messing with query design,
John Spencer
Re: Microsoft Jet Engine does not recognize <> as valid name or ex,
John Spencer
Re: concatenate and time,
John Spencer
Re: Microsoft Jet Engine does not recognize <> as valid name or expres,
John Spencer
Can I get the fields in an Access table using just an SQL statement?,
james
RE: Subquery Help!!! Top N Values,
K
Re: 3 Left Joins on Query,
taurus via AccessMonster.com
Re: Using multiple criteria in an update query,
Arvi Laanemets
Re: Query Dates using VBA reference,
Douglas J. Steele
Query Help Needed,
EA
Re: Trying to converting text field into numeric in a query,
John Spencer
Re: Is there a way in query to convert an integer (YYMMDD) to a date,
Douglas J. Steele
performing a lookup on a query,
bigbore50@xxxxxxxxx
Sequential Numbers,
Brian
Select Last payment date and amount of a group,
Kathy Webster
running queries consecutively,
the_dude
find the closest point,
asc4john
Re: How to find both left and right joins,
John Spencer
Re: brain teaser,
John Spencer
Message not available
Re: ISError in a query,
tina
Re: confusing criteria,
Allen Browne
Re: need help with append query/SQL,
Gary Walter
Re: Replace asterisk Query error,
fredg
Re: How can I put a decimal point back into the numbers in a field?,
Jeff Boyce
Re: Top Values Query,
Allen Browne
Re: Date Criteria Between Last Sat and Now(),
Allen Browne
Re: Query Duplicate Problem,
Allen Browne
RE: IIf, Queries & Look up fields,
SteveS
Re: Sum of values,
John Spencer
Choosing a range of data,
cclark
Re: Update query for multiple values in one field,
John Nurick
Help with a Query,
Bill Smith
Re: update query (date extraction),
John Spencer
Change Permissions via SQL?,
kramer31
getting last 6 months of data from todays date,
Addy
RE: query with IIF's not working,
Carla Gilless
basic sql sum statement - help i'm going mad,
Dan
Help with an update query,
Corey-g via AccessMonster.com
Record Number in Query,
Jackson via AccessMonster.com
Crosstab : PIVOT ... IN (...) problem !,
Arnaud Lesauvage
RE: Can I rename captions programatically?,
Old Data Guy
computation of calculated field in query based on conditions,
anyaley
Re: How to create a column with the percentual change,
Allen Browne
Re: I NEED A FUNCTION FOR A QUERY,
Van T. Dinh
Re: Need help constructing delete subquery,
Van T. Dinh
Divide by 0 error,
Gil Stone
Re: Key Violation, No Primary Key,
Gary Walter
- Message not available
- Message not available
Re: RunningSum in a Query?,
Van T. Dinh
Access Modify,
kramer31
Re: yes/no in UNION,
Allen Browne
Re: new record,
Rick Brandt
Re: Month/ Date Query,
John Spencer
Re: Field length restriction for grouping?,
Douglas J. Steele
RE: Primary secondary and tertiary searching,
Klatuu
plus or minus,
asc4john
Importing Data From Excel,
Rob
Re: querys with date sort,
Jeff Boyce
Re: Query to return 0,
Jeff Boyce
removing spaces from within strings,
Alex
Re: Select records based on criteria,
John Spencer
Re: Count multiple start/end work dates of an employee,
John Spencer
Re: Creating a Query out of two queries,
Sean Massey
Sort order in drop down list box,
FredVN
Problem with Calculated Fields in Query...,
Sean Massey
append query SQL help needed,
Slez via AccessMonster.com
Re: Rabbit Multiplication,
Jeff Boyce
Re: DateDiff Problem,
Allen Browne
Reading in File dates and times,
Alex
MULTIPLE IF ELSE IN MS ACCESS,
Ashley
Re: Want a message when Query Returns no data,
Allen Browne
Re: Is it possible to save a username from anybody that used my datab,
Brendan Reynolds
Re: Query To Create A New Field,
Van T. Dinh
An Approach for Updating A Table with New Records,
Tonk
Re: Bug - Cannot ALTER field to NULL,
Van T. Dinh
how can I move records down to be able to insert a new one?,
rich
Re: Don't know how to change SQL correctly.,
Gary Walter
Re: Multiple field search,
David F Cox
Data Type mismatch in a query that uses a calculated field from another query,
John T Ingato
field names,
BrightIdeas
Grouped Row Numbers,
cliopia
Re: Assign value from a field as named in another field.,
Douglas J. Steele
return part of a field,
mbc04
Re: append with duplicates,
Jeff Boyce
Access crashes on a subquery,
Carl Rapson
Re: Using a Max Statement in Criteria,
John Spencer
Re: SQL Query?,
John Spencer
Help on syntax error (comma) in Query Expression,
Vandy
Find 'last' non-empty value for a field,
deekaye
Re: search between to field’s Low range & high range,
Marshall Barton
Re: Delete Query,
Allen Browne
Inserted Records not found in Linked table,
Vandy
Re: Date when user turns 70 1/2?,
John Spencer
Re: Similar Data - fmr,
John Spencer
Re: Large rowset