microsoft.public.access.queries
Re: Linked Table in a Query,
G. Vaught
DataGrid Cotrol IN Access 2003,
BJ
Re: Please Help...Using the column function within a query field,
John Vinson
Re: Why won't my query to show only 2005 data work?,
Duane Hookom
Re: Explicitly declare the variable,
Tom Ellison
Empty Table?,
Marc Meltzer
Re: Complex Autonumber Problem in a query,
Tom Ellison
Re: shorten an SQL statement to work in VB.net,
John Spencer
Re: Query Problem - Two or More Records,
John Spencer
Re: Prompting several different criteria from a form (Query by Form),
Rick B
Strange Problem Reading MS Access Memo field.,
colindaly
Combo boxes with queries,
Maxine via AccessMonster.com
Re: query usung datedif function,
tina
RE: Left Join Not Properly,
"privatenews"
Re: I want to select either specific records or all in same query,
Marshall Barton
Re: How do I used wildcard characters in Query by Form?,
Duane Hookom
Re: why is my expression being truncated?,
Vincent Johns
Re: update select fields,
Tom Ellison
Re: Reverse Cross-Tab (Union Query) - Size Limits??,
Tom Ellison
Re: help with if statement,
Tom Ellison
Re: Query for ComboBox - Show each entry only once,
Tom Ellison
How to use SQL variables in VBA,
schoultzy
Re: DateAdd,
John Spencer
Re: Parameter query, null value in (table) field,
Tom Ellison
Re: Add a range of dates to a table,
[MVP] S.Clark
Re: New Parameter values (from Form) not being picked up by Query,
[MVP] S.Clark
queries with combo boxes!!,
dara
Formula/table assistance,
Dechienne
If statement,
dale@xxxxxxxxxxxxxxxx
Re: Problem with memo field in query,
Rick B
Re: Date query criteria,
Allen Browne
Re: expression,
John Spencer
Re: Concatenating fields,
John Spencer
help with getting to end report,
catherine2255
Query Help - PLEASE,
Robby
Re: Discrepancy between query results, rounding error?,
Tom Ellison
Re: Variable Question,
Tom Ellison
Can this be done.,
Woodies_46
Re: How do I show query results in color,
Duane Hookom
Re: Using aggregate functions in a query. When I click run I get the,
Duane Hookom
Re: Results from Query using IsSelectVar to a Table,
Duane Hookom
Re: query that pulls specific names out of a number of fields,
Jeff Boyce
Re: Showing No Duplicates,
Jeff Boyce
Re: how do I create a database using post code,
Jeff Boyce
Equilevant of Oracle for optional records,
Maurice W. Darr
Re: How to write query for sorting data in table using VBA?,
Vincent Johns
Re: Calcuate Elapse Time,
Tom Ellison
Query run again,
cmichaud@xxxxxxx
Email Query,
cmichaud@xxxxxxx
Help with query,
graeme34 via AccessMonster.com
four columnes into one,
asc4john
Re: IFF Statement,
Rick B
Re: database for c.v's,
[MVP] S.Clark
Limiting a Ccur() function to 2 decimal places,
graeme34 via AccessMonster.com
Re: can an iif function have more than two results?,
Duane Hookom
Re: Access Query - Don't know what type to use - Inner Join? Update?,
[MVP] S.Clark
Exclude Query,
Tamika via AccessMonster.com
Re: Entering Parameter in DateSerial expression,
Tom Ellison
Re: Return 20 Rows from Query,
John Spencer
Message not available
Re: Convert Text to Numbers - Leading 0s,
John Spencer
Add two fields of a query together?,
Andibevan
Re: Count in a query,
Duane Hookom
Re: How can I, in an IIF statement, create the true statement in red?,
Rick B
iif Function in Query,
mattc66 via AccessMonster.com
Re: Dates in a query,
Jeff Boyce
Re: UPDATE query creation for SQL,
Roger Carlson
please help am having a nightmare with running totals arghhh,
catherine2255
RE: hide repeat values in a join,
K Dales
Re: FUNCTION,
John Spencer
Re: Unmatch Query result,
Allen Browne
input date in query,
Kay
Help Not getting proper result from simply query,
Alex Martinez
Re: Stupid Query Question...Column Display,
Vincent Johns
Re: datedif function,
Wayne Morgan
Re: First 200 Query,
Tom Ellison
Stock Price History Criteria,
Justin Tyme
Re: Access: Query criteria for uniqueness, only non duplicate records,
John Spencer
MS Access SQL database Query,
Dave
update query confusion,
cporter
Re: Select All but only Select some Distinct,
John Spencer
Re: What Access formula is usee to retrieve data from 6 mo. ago?,
Phil
Re: Time Conversion Question,
Jeff Boyce
RE: Linking Records between Tables: Compensation Offered,
Chris Burnette
Another 'buckets' question,
elsenorjose
Append Query clarification,
Mark M S
Re: Can I Use a function in a queries criteria.,
Tom Ellison
How do I re-write my query so that it will decode the masked files.,
petejk
Re: query to tell number of months between two dates,
Tom Ellison
Last date value from records,
Zack Barresse
Calculating hourly total,
biswajit . tamu
Re: how to import all lines from table even if identical,
Rick Brandt
Re: Criteria = Like "*this*" With Prompted Entry,
Michel Walsh
- Message not available
- Message not available
Re: grouping,
[MVP] S.Clark
- <Possible follow-ups>
- Re: grouping,
jahoobob via AccessMonster.com
Re: Time Conversion,
[MVP] S.Clark
- Message not available
- Message not available
Re: Parameters for query with Option group on form,
[MVP] S.Clark
Re: Limit # of Records by one field,
[MVP] S.Clark
Multiple expression, in Query,
Woos
Re: split address into 2 fields,
Marshall Barton
Query for Email Address Then send to Outlook,
cmichaud@xxxxxxx
Query Query,
Paul Richards
extract only the numeric element of a text string.,
Garry
Counter Reset Weekly,
Kay
Transform Vertical Lines to horizontal please help,
catherine2255
Re: Multiple Rows in a query,
Tom Ellison
Re: How to make null = 0 in expression query ms access?,
Tom Ellison
Re: select case statement,
Tom Ellison
Re: Information from a query,
Tom Ellison
Re: To enter date range once only for main- and sub forms,
Tom Ellison
Re: Linking Records between two tables using queries,
Tom Ellison
string two columns together and use the string in another qry,
Crystal via AccessMonster.com
Re: Delete records containing certain info,
Duane Hookom
NOT criteria in query not working,
jwr
Re: Hourly volume calculation,
Tom Ellison
Re: Need Formula,
Tom Ellison
Re: help with nestled query,
John Spencer
Re: Using Between...And Criteria with Ages,
Phil
Open Table results:Decimal's precision is too small...,
Phil
Open Table results:Deciaml's precision is too small...,
Phil
Re: Multiply Selection Update Query,
Wolfgang Kais
Create report with 2 queries,
sumana
Re: Problem with outer join in query,
Tom Ellison
Re: compare empty form text block,
Tom Ellison
Re: Need some VBA code help I think....,
John Spencer
Using between dates,
stevenphillips63 via AccessMonster.com
Re: Multiple Updates on one query,
fredg
Re: Time Format,
fredg
Re: Multiple Criteria,
Ken Snell \(MVP\)
Hardship with localized version of access,
pdarisse
Re: "Not Updateable query" error..,
Duane Hookom
Re: Update all in one query...,
John Spencer
Re: Help Build Query,
Allen Browne
How to limit Query return to first 10 that satisfy criteria,
kennedyr4 via AccessMonster.com
Struggling with query,
LHEMA
- Re: Struggling with query,
Tom Ellison
- Re: Struggling with query,
LHEMA
- Re: Struggling with query,
Tom Ellison
- Re: Struggling with query,
LHEMA
- Re: Struggling with query,
LHEMA
- Re: Struggling with query,
Tom Ellison
- Re: Struggling with query,
LHEMA
- Re: Struggling with query,
Tom Ellison
- Re: Struggling with query,
LHEMA
- Re: Struggling with query,
Tom Ellison
- Re: Struggling with query,
LHEMA
- Re: Struggling with query,
Tom Ellison
- Re: Struggling with query,
LHEMA
- Re: Struggling with query,
Tom Ellison
- Re: Struggling with query,
LHEMA
- Re: Struggling with query,
Tom Ellison
- Re: Struggling with query,
LHEMA
- Re: Struggling with query,
Tom Ellison
- Re: Struggling with query,
LHEMA
- Re: Struggling with query,
Tom Ellison
- Re: Struggling with query,
LHEMA
- Re: Struggling with query,
Tom Ellison
Re: Query on Memo Field,
John Spencer
Re: Where clause on a Look-up field,
Jeff Boyce
Subtotal query,
Malcolm Miles
Adding query results to a table field,
Leslie Isaacs
Error message invalid bracketing,
catherine2255
Re: Change data arrangement,
Duane Hookom
Re: Calculated Field,
Tom Ellison
Re: calulate backwards,
Tom Ellison
Re: deleting records - in a duplicate query,
Tom Ellison
Re: why don't I have "search" option in TOOLS,
Tom Ellison
Re: data out of range,
Tom Ellison
Counts and averages,
rascal
Re: Date In Query,
Tom Ellison
RE: Select last two records entered,
SteveS
Query Totals,
prince1142003
Re: query to count number of records for each letter of alphabet,
Tom Ellison
RE: using numbers as characters,
LAF
RE: How can I give a user options when using a parameterquery?,
Tom Wickerath
RE: Select query - only one-to-many records?,
Tom Wickerath
Re: Using Query to Find and Replace,
Tom Ellison
Help with query!,
graeme34 via AccessMonster.com
record with doubled value,
fgerard via AccessMonster.com
Combine 3 queries for report,
dreamsoul620 via AccessMonster.com
Group Query,
lito via AccessMonster.com
RE: How do I calculate % in a PP data sheet?,
Jerry Whittle
Query not updatable.....,
graeme34 via AccessMonster.com
Linking a SQL database to an Access database.,
Frank
Pass a Value to a CrossTab Query,
Claudette Hennessy
Possibe to use "NewField: CDbl([ExistingField])" in a CROSS-TAB Query ??,
kev100 via AccessMonster.com
Another Date Query,
Tony Williams
Pulling queriy criteria from a text box,
Ant
Date Field plus X days,
FJB
Create a field to calcualate a date.,
Craig Ferrier
Re: Calculating # of Shifts Between 2 Date/Times,
Tom Ellison
Re: Want Duplicate Information,
Tom Ellison
RE: Error in query,
Jerry Whittle
Repeating records based on a number in a field,
Confusled
Query of what isn't linked to a certain table...,
office drone
Creating a unique customer code with a function,
mattc66 via AccessMonster.com
- Re: Creating a unique customer code with a function,
Tom Ellison
- Re: Creating a unique customer code with a function,
Tom Ellison
- Re: Creating a unique customer code with a function,
mattc66 via AccessMonster.com
- Re: Creating a unique customer code with a function,
Tom Ellison
- Re: Creating a unique customer code with a function,
mattc66 via AccessMonster.com
- Re: Creating a unique customer code with a function,
Tom Ellison
- Re: Creating a unique customer code with a function,
mattc66 via AccessMonster.com
- Re: Creating a unique customer code with a function,
Tom Ellison
- Re: Creating a unique customer code with a function,
mattc66 via AccessMonster.com
- Re: Creating a unique customer code with a function,
Tom Ellison
- Re: Creating a unique customer code with a function,
mattc66 via AccessMonster.com
- Re: Creating a unique customer code with a function,
Tom Ellison
- Re: Creating a unique customer code with a function,
mattc66 via AccessMonster.com
- Re: Creating a unique customer code with a function,
Tom Ellison
- Re: Creating a unique customer code with a function,
mattc66 via AccessMonster.com
- Re: Creating a unique customer code with a function,
Tom Ellison
- Re: Creating a unique customer code with a function,
mattc66 via AccessMonster.com
- Re: Creating a unique customer code with a function,
Tom Ellison
- Re: Creating a unique customer code with a function,
mattc66 via AccessMonster.com
- Re: Creating a unique customer code with a function,
Tom Ellison
- Re: Creating a unique customer code with a function,
mattc66 via AccessMonster.com
- Re: Creating a unique customer code with a function,
Tom Ellison
- Re: Creating a unique customer code with a function,
mattc66 via AccessMonster.com
- Re: Creating a unique customer code with a function,
Tom Ellison
- Re: Creating a unique customer code with a function,
mattc66 via AccessMonster.com
Query that displays what isn't connected to records in a certain table,
office drone
update query help,
fieroguy
Re: Append / Delete Query Question,
John Spencer
Re: populate blank fields,
John Spencer
RE: The query-expression deletes some of the fields,
shannieboat
VBA filter on unbound forms,
mobrun@xxxxxxxxx
MIN,
Ghena
Re: How can I round to the next month,
Duane Hookom
Re: How do I check the date I istalled SP2,
Wayne Morgan
Re: Reference a local table in a passthrough query,
Rick Brandt
Re: Return every nth record? - newbie,
Allen Browne
Deleting and Recreating Access Tables,
BarryC
Case statement equivalent,
ricky
Cannot tranfer Database with Date Function query,
Ian Potter
Subtract 2 dateTime stamps,
Dave
Re: Ranking scores,
Duane Hookom
RE: More fun with subqueries,
Dirk
Finding the first LOCAL minimum in a time series,
LStegman
Parse one field into multiple columns,
mattc66 via AccessMonster.com
Updating Multiple Pass-Through Queries through a Form,
ryan05 via AccessMonster.com
Making Append Query generate 3 record and not running into key violations,
fjbuch
Re: NULL is design view criteria,
Tom Ellison
Re: PLEASE HELP! CRISIS!,
Tom Ellison
Default Value in Query,
jwr
Filter subform data from main form combo box(s),
serviceman via AccessMonster.com
Re: Alias amnesia after subqueries in Access?,
Marshall Barton
Re: Mark a query checkbox,
Rick B
Adding field in query design view to enter 207 blanks.,
mscomdex
Query Confusion!!!!!,
Pattyt
Query is too complex,
Bev
Re: Query is too complex,
John Spencer
Import Data - Column names in one column in Excel,
Major via AccessMonster.com
Scheduler,
Chris
Re: QUERY: Output Data from multiple records,
John Spencer
Crosstab Columns in Datasheet Subform,
David
Select in Query causes cartesian results,
Al
RE: Reference form controls in query,
KARL DEWEY
RE: Sum of 2 lines of Count query,
Klatuu
Query to get report to show specific criteria,
RealGomer
RE: Count(*) Syntax,
klam
Simple Select Query not updateable???????,
graeme34 via AccessMonster.com
calculated field in query,
cporter
Re: Single result from multiple records each month,
Tom Ellison
Multi join on same table,
cedric
Parsing text string (1 field) to number and date (2 fields),
kennedyr4
Re: Concatonating in a query,
Tom Ellison
Re: Export to Excel,
[MVP] S.Clark
Re: Gen Record Number within Primary Key,
[MVP] S.Clark
Re: Date parameter,
[MVP] S.Clark
Re: Record Locking,
[MVP] S.Clark
Re: Build on query expressions deleting closing ),
[MVP] S.Clark
Re: How do I move a query to another computer in the office?,
MH
Inventory Query Question,
babyatx13 via AccessMonster.com
Re: Help with date formula in query,
Allen Browne
How to get data that's NOT in another Table?,
ashanthenuka
Append Key Violation,
Geezer via AccessMonster.com
Re: how do I pull information for the same month but different years?,
Allen Browne
Re: changing the date format,
Allen Browne
RE: Update Table Statement - Time Out Problem,
Jerry Whittle
Help with passing ASP variables to saved queries,
tranceport185
Append/copy calling a module switches data,
dl
Determining which vaccine was given in a date range,
Mark S
Re: Text in a Number Field,
RoyVidar
jet sql access subquery in from clause left outer join does not work ... help!!,
media . opslag
Re: User to select different fields,
Allen Browne
update (remove last 4 characters),
_Bigred
how do I only pull 5 records (random)?,
_Bigred
Minimum function problem,
marwan
Get data that I want problem?,
JPP
Re: Create a query that will allow users to enter data in Access,
Tom Ellison
Re: OpenForm Criteria,
Allen Browne
Summary of Donations,
Craig Ferrier
nz not working in A200?,
Jesper F
Please read before posting: guidelines for microsoft.public.access.queries,
Tom Ellison
Re: Wild card in parameter,
Tom Ellison
Re: Column Parameters,
Tom Ellison
Re: OLAP CUBE ERROR,
Michel Walsh
Re: tracking log times ...,
Tom Ellison
Help! Trying to set a maximum value on a query result.,
scipio
Re: Functions - YTM,
Tom Ellison
Problem with an ASP update query,
Brave
Done with one query?,
JOE
Re: Elapsed Time,
Tom Ellison
Re: Not Operator,
Tom Ellison
Re: Truncated memo fields from queries within queries,
John Spencer
Re: Aggregate Function Error,
Tom Ellison
Re: Secondary Sort for Union Query?,
Tom Ellison
HELP WITH DELETE QUERY IN ACCESS,
harish
Re: Using IIf null statement in a query,
Tom Ellison
Query coding with variable criterea entered from a form,
JohnG via AccessMonster.com
Re: Matching rows to columns,
Vincent Johns
Re: case age,
Lynn Trapp
- Message not available
- <Possible follow-ups>
- Re: case age,
John Vinson
Result of subquery sum based on fields of same record,
Olaf Richter
Union Query,
michaeljfrey
Display Counts of records per day,
Kay
Re: Date/Time conversion,
Vincent Johns
Re: Why can I not format a calculated field in a query to Currency?,
Allen Browne
subform based on crosstab query,
sigava77 via AccessMonster.com
- Re: subform based on crosstab query,
Duane Hookom
- Re: subform based on crosstab query,
sigava77 via AccessMonster.com
- Re: subform based on crosstab query,
Duane Hookom
- Re: subform based on crosstab query,
sigava77 via AccessMonster.com
- Re: subform based on crosstab query,
Duane Hookom
- Re: subform based on crosstab query,
sigava77 via AccessMonster.com
- Re: subform based on crosstab query,
Duane Hookom
- Re: subform based on crosstab query,
sigava77 via AccessMonster.com
- Re: subform based on crosstab query,
sigava77 via AccessMonster.com
- Re: subform based on crosstab query,
Duane Hookom
- Re: subform based on crosstab query,
sigava77 via AccessMonster.com
- Re: subform based on crosstab query,
Duane Hookom
- Re: subform based on crosstab query,
sigava77 via AccessMonster.com
Re: Subtract Workdays,
[MVP] S.Clark
Re: Seperating parts of data,
John Spencer
Re: Criteria question,
Jeff Boyce
Query Issue,
vbnetdev
Re: creating a report from a query,
Vincent Johns
Need help with following SQL... anyone?,
Papachumba
Re: Error Received When Appending,
Allen Browne
Re: help with referencing second database please,
Vincent Johns
Matching results in query based on periodically updated field,
keliie
Re: Ole DB Connections to SQL server,
Tom Ellison
Calculating days between dates,
KevinE
Re: combining fields,
John Vinson
Re: converts secs to nn:ss,
John Spencer
SQL Inner/Outter Multi-Join,
sbatschelet
Re: Pull Field name from a form,
Tom Ellison
Re: Creating Query from many to many relationship,
Tom Ellison
Re: Read-only data,
John Vinson
Re: division is zero error in query,
Tom Ellison
Re: Problem with date parameters in union query,
Tom Ellison
Re: Generating an ID,
John Vinson
Re: Unique Records,
Tom Ellison
Re: Query 1 Field from specific lines.,
Tom Ellison
Problem editing a query based on another query and table,
Emlou85 via AccessMonster.com
make-table query,
SP
Display count by day,
Kay
Re: Combining two fields in an update query,
Duane Hookom
sql aggregate product,
Jean
Re: Aggregate smalldatetime fields in stored procedures,
John Spencer
Re: Counting Date entries,
John Vinson
Re: criteria parameters,
Duane Hookom
expired data,
fapa via AccessMonster.com
Re: Max of Date with/without grouping?,
Allen Browne
Re: Parameter Queries - duplicating parameters,
BruceM
Re: Incorrect query result????,
Allen Browne
Re: Subquery & Text,
Michel Walsh
Re: ODBC--call failed,
John Spencer
Re: Batch Queries in a Pass-Through,
John Spencer
Calculating Rolling Usage,
Andi Lee Davis
Editing Query Data Problems,
davepidgeon
Display report for nominated client,
mandyric
Re: Deleting rows from a table based on a concatenated (composite) key,
Allen Browne
Using a parameter query with date and time,
Alex Martinez
Re: Type mismatch even though types are the same,
[MVP] S.Clark
Re: In MS Access how do a only show the 19999 of 0~19999 in a column?,
Tom Ellison
Re: Need help with a query displaying a "No" in one or more fields,
Jeff Boyce
Re: Nested IIFs,
John Vinson
RE: "Incremental Values from a Table",
Len at BV
Count in an Update Query,
Max Yaffe
Re: date criteria does not work,
Tom Ellison
Rolling Time Periods,
dreamsoul620 via AccessMonster.com