microsoft.public.access.queries
- Reverse Crosstab issue,
stephane
- Re: aggregate query,
Michel Walsh
- Query Problem - Obtain Client's Second Appointment,
Wendy Tate
- Count names issue,
Flemming
- How can I have the auto number field starts with 1?,
Grasshopper
- Re: Insert records in table based on number in another table,
Michel Walsh
- RE: many to many relationships,
KARL DEWEY
- Re: IF and mutliple selects,
kingston via AccessMonster.com
- Re: Access Function like Excel TRUNC function?,
Marshall Barton
- Re: Need Help Creating Database,
John W . Vinson
- Re: Searching mutiple fields with the same string,
John Spencer
- Re: syntax in long iif,
John Spencer
- Re: Finding a text field in a field,
John Spencer
- Distinct.... and count together,
Sonnich
- Re: Drop down list search,
John Spencer
- Help with parameter query,
Zeunasc
- Re: where statement,
kingston via AccessMonster.com
- Re: Select Query,
kingston via AccessMonster.com
- Re: Truncating a field in a table, need suggestions,
Allen Browne
- Can I create multiple queries using a script or command line?,
Ptrope
- Re: Form and Query,
John Spencer
- Re: Run-time Error 3188 Help,
Michel Walsh
- Re: Using a query to populate a search form,
Jeff Boyce
- Re: One-to-Many table quey,
Jeff Boyce
- Re: Office 2000 Access upgrade?,
Jeff Boyce
- Re: Help with duplicate query,
John Spencer
- Re: WHERE,
Jeff Boyce
- <Possible follow-ups>
- Re: WHERE,
John Spencer
- Re: How do I do reverse concatenation in an Access query?,
Albert D. Kallal
- update query? - Form Object?,
Fuzuy
- Re: iif function in query,
John Spencer
- Re: Today function with a Parameters Query,
Michel Walsh
- Re: How do I keep a correct sequence in an append query?,
John W . Vinson
- Re: Parameter Query,
Jason Lepack
- Re: paramter query,
fredg
- key violation in append query,
Helen Martin
- Sorting Numbers,
jasidebo
- Re: how do I convert a julian date(JDEdwards) into a calendar date,
John Spencer
- Re: Problems with "DateAdd",
Michel Walsh
- Re: IIF Statements nested,
Jason Lepack
Re: Isolating text in a field,
Michel Walsh
Re: Averages,
Michel Walsh
how to make "update"query?,
Fuzuy
Re: Need Help with Comparing Tables!!!,
Michel Walsh
Need help witha calculation query,
moschino_123
Re: How do I get values based on Field name?,
Michel Walsh
query with subquery does not take all rows it should i think,
pat12
Re: Advanced query,
Michel Walsh
MDA to MDW conversion,
Albert
expression to complex - switch & iff in Access 2007,
xz
Re: Sum based on date range,
Van T. Dinh
Re: WHERE help needed,
Rick Brandt
Re: Rolling query,
John W . Vinson
Re: Parameter query not working correct.,
Allen Browne
Re: newbie SQL question,
Jason Lepack
Sorting numbers in a text field,
mpfohl
Re: Running query from a Command button,
Van T. Dinh
Re: using less than in criteria in select query,
Michel Walsh
Re: Find data determined by date,
Carl Rapson
Re: Counting query,
John Spencer
Help modifying a "working days" query/function,
Zeunasc
Re: Date() Criteria,
Michel Walsh
Re: Query based on calendar year.,
John Spencer
Reconciling Two Tables With Similar Information,
FIECA
Re: Running total from query,
Jeff Boyce
Re: Conditional sum,
Michel Walsh
determine which time interval the date falls into,
Aivars
How Can We Have Access Accept Order By Input Param,
alee via AccessMonster.com
Re: Record to record calculations,
Allen Browne
RE: create a counter,
Ken Sheridan
Re: HELP! Error Message,
Gary Walter
Re: query not giving results but with no error?,
John W . Vinson
Date Search in Date & Time Field,
hobbit2612 via AccessMonster.com
Re: AS question,
John Spencer
Re: ORDER BY help needed,
John Spencer
Re: Subqueries,
John Spencer
Help updatecommand not updating,
Fendi Baba
Re: Need query to find employees who have not had required training,
Jeff Boyce
Re: Referring to a text field in SQL,
Jeff Boyce
Select Unique Rows,
alee via AccessMonster.com
Re: SQL UPDATE Query doesn't Update Table,
Gary Walter
Re: Text Export needs CR/LF at end - how to??,
Ken Snell \(MVP\)
Do I need to separate queries for this...,
Dave
Re: Query to update table fails,
Gary Walter
How to use a function in a query,
Zeunasc
Re: Pivot Query ??,
John Spencer
Two Out Of Three Ain't Bad...,
Bill Foley
Access 2000 Workgroup Administrator,
Albert
Re: Numbers in a query,
John W . Vinson
Re: Linked Tables in a query...,
John W . Vinson
Re: How do I update varying data into an existing column of a table?,
John W . Vinson
Re: Import xls data,
John W . Vinson
Complicated Query,
cableguy47905 via AccessMonster.com
RE: How do I update varying data into an existing column of a tabl,
KARL DEWEY
VB6/MSAccess Query Problem,
Ryan Prather
Re: Running Total in a query,
Michel Walsh
Re: Inventory table slow,
Michel Walsh
Re: Access Syntax Error,
Matthias Klaey
RE: Access Syntax Error,
Duane Hookom
RE: Increment Sequence Count Within a Query,
Cyhill
Hierarchy Sorting,
Steve
Filter by absence of subform record,
BruceM
Re: Merging data - no duplicates,
Michel Walsh
Re: query is perfect in immediate mode, doesn't work in combo box,
Amy Blankenship
Making a max query,
Enrique Rojas
Re: QBF Query by Form- more than 2 tables?,
Michel Walsh
Re: Automatically Adding Data from previous field under certain condit,
Michel Walsh
multiple conditions criteria iif?,
Starry
Query criteria,
Jim Pockmire
Building SQL statement in VBA. Getting 3131 Runtime Error in FROM clause :@,
russellhq
Re: One-to-many query,
Jason Lepack
Re: Select fields on a form and put this data into a specific table.,
Michel Walsh
Re: multiple statements updating a table with multiple values,
Michel Walsh
Re: Date as "month",
Allen Browne
Re: CONVERSION DATE PROBLEM,
John Spencer
random records are not generated in access 2000 !!!!!,
hardik
Re: Query Combobox Problems,
Gary Walter
Re: Please help with Comparing tables!!!,
Gary Walter
User interface via Net,
Matti Koski
Number of working days,
learning_codes@xxxxxxxxxxx
Re: Weighted Averages,
Smartin
How to populate sequential ID on an existing table?,
Grasshopper
RE: Calculating expressions between two dates,
Ken Sheridan
Re: Hide Duplicates,
Smartin
RE: Append Queries,
Ray
Re: How do I search for a specific year in a query?,
fredg
Re: parameter message,
Douglas J. Steele
Matching Table value to Query Expression,
fullera
Re: Excluding,
Jason Lepack
Re: Running Total in My Query,
John Spencer
Re: Format the query results,
fredg
RE: Query OVERFLOW Error,
Jerry Whittle
Re: Checking against input mask,
John Spencer
Re: Adding records,
Carl Rapson
iif statement in query,
Joel Allen
Re: Self-joins,
John Spencer
counting visits,
Jackie L Preston
Re: Parameter prompt and constant exclusions.,
John Spencer
Re: Selecting multiple "maxes"/latest actions?,
John Spencer
Adding Sequence number based on Date,
robertadamharper@xxxxxxxxxxxxxx
Re: Update Query Question Need Help,
Jason Lepack
crosstab query and main table,
doran_doran
Re: Subqueries and ranking,
RoyVidar
Re: Blank Form,
Van T. Dinh
Re: how do i make my criteria for a query where a field = x character.,
Van T. Dinh
Queries/Reports not showing records,
TracyM
Re: Annoying String Sorting Problem,
Rick Brandt
Re: Query using two different date values,
Van T. Dinh
Finding Overlapping Data from a Table,
FG
Re: Quering 2 unrelated (apparently) DBs,
Jeff Boyce
Re: decode,
John W . Vinson
Re: Calculating Date,
fredg
User function on report?,
Starry
Re: Basic query questions concerning a linked FoxPro table,
Albert D. Kallal
Re: Counting the number times a record appears within a date period,
John Spencer
Re: non-match query,
John Spencer
- Message not available
- Message not available
Re: Create 3 separate fields from one,
Ron2006
Rating system: Query to get a rate for each entry found.,
largie
Re: I need help working with parameters!!!!,
Carma
Convert Text to Number,
mattc66 via AccessMonster.com
Numeric Field Overflow Error for Macro,
DoveArrow
Re: Filter by date on a field that uses now(),
fredg
Re: Query sorting problem,
John Spencer
RE: Update records based on value of other records in same table,
Dale Fye
Re: STATE EMPLOYEE REQUESTS QUERY HELP!,
John Spencer
Re: Web Based Discussion Groups,
Jason Lepack
Re: Update Query Question,
John Spencer
Re: Trace records through a table,
Ron2006
Getting % As Total A97,
Kahuna
Modifying Import Specs and its Effect to Queries,
oldevilla
Re: Date Str into Date (Urgent),
tina
Re: DB read only - Access 2007,
John W . Vinson
Change date to set month,
John
Re: SEPARATING DIFFERENT DATA TYPES STACKED IN THE SAME FIELD,
Smartin
Lookup values from another table,
nubee
Re: Problem nesting one SQL in another,
Sylvain Lafontaine
Re: Searching mdbs for queries,
Jeff Boyce
Re: In query records returned multiple times,
Smartin
Re: Subtract Now() - 6 months,
John Spencer
Re: What queried should I use???,
John Spencer
RE: Error msg when convertint a select query in to an update query,
Steve S
data query,
Spring
Re: Tables with Lookup queries,
Ron2006
problem with inserting in two tables,
michel
Re: Recordset automatically updates,
Allen Browne
Re: Query output limiting field length - Access 2007,
Allen Browne
Add a running sum column in a query,
anees20148
Re: Add 1 when T/F fields are true,
Smartin
Re: Add to Data,
Smartin
Append duplicate invoice numbers,
T
Re: Querying memo fields.,
Douglas J. Steele
Re: Removing duplicate items within a category,
John Spencer
Re: calculating "how many" months,
fredg
Re: Figure months from a anchor date,
John W . Vinson
Re: Make Table query from a Linked Table,
John W . Vinson
Legth of all columns in db,
JR
Re: Repeated Data,
John W . Vinson
Re: Round 4 decimals up,
Marshall Barton
Re: ERROR: aggregate function?,
John Spencer
Re: Date not in list,
John Spencer
Re: searching for similar records,
John Spencer
Append Query,
Red via AccessMonster.com
Re: Query with Form problem,
Michael Gramelspacher
Forcing an expression to be a number, not a string,
John T Ingato
- Re: Forcing an expression to be a number, not a string,
Smartin
- Re: Forcing an expression to be a number, not a string,
Jamie Collins
- Re: Forcing an expression to be a number, not a string,
John T Ingato
- Re: Forcing an expression to be a number, not a string,
Smartin
- Re: Forcing an expression to be a number, not a string,
RoyVidar
- Re: Forcing an expression to be a number, not a string,
Jamie Collins
- Re: Forcing an expression to be a number, not a string,
RoyVidar
- Re: Forcing an expression to be a number, not a string,
Jamie Collins
- Re: Forcing an expression to be a number, not a string,
RoyVidar
- Re: Forcing an expression to be a number, not a string,
Jamie Collins
- Re: Forcing an expression to be a number, not a string,
Jamie Collins
Access 2003 : Numbering alarms by PermitNo so that after 365 days of the last number 1, the count returns to 1,
Céline Brien
- Message not available
- Message not available
- Message not available
Crosstab query totals,
Blair
Re: Ambiguous outer joins,
Douglas J. Steele
Re: Creating a due date but exclude Bank holidays and weekends,
Douglas J. Steele
Now it works... now it doesn't... What is up with this query,
John T Ingato
query for Max date and previous date for report,
DJTI via AccessMonster.com
RE: query for Max date and previous date for report,
DJTI via AccessMonster.com
Re: An IIF statement for a single character(s) Only,
Douglas J. Steele
Re: An IIF statement for a single character(s) Only,
John T Ingato
Re: Too few parameters. Expected 2,
Douglas J. Steele
Re: how to assign a sequential row numbers for each row in a query in,
Rick Brandt
Grouping Problem in Totals Query,
Connell Giacomini
Re: What is an "image shape"?,
John W . Vinson
Re: Business Days,
Michael Gramelspacher
Re: How does one "check the file permissions for the document"?,
Van T. Dinh
Crosstab query help,
Blair
Delimiting Field Containing - Character,
jeremy . reitman
Using "AND" in an IIF function statement,
AMFLMSC
Re: Finding the overall nearest match to a group of parameters (number,
Jeff Boyce
- Message not available
- Message not available
- Message not available
Re: Frustrated...Can somebody tell me how to turn on a feature?,
Joel Allen
Merging related records when there are multiple one-to-one relationships between two tables,
Marc Eckhert
week day query,
Joel Allen
Re: Remove Zeroes in front of a number - help!,
John Spencer
Re: Switch Function,
Marshall Barton
Re: Top 5 with grouping,
John Spencer
date field by month in query but want only one year,
Sue R via AccessMonster.com
Calculating total days minus overlapp,
jasonjrowe
Desperate for help,
drider629
Format Field in Make Table Query,
Claudette Hennessy
RE: summing a query,
SteveR
Re: Last Date when two tables involved,
John Spencer
Re: query issues - critera being ignored,
John Spencer
Re: Count IF Query,
Jason Lepack
- Message not available
- Message not available
- <Possible follow-ups>
- Re: Count IF Query,
John Spencer
Re: Find duplicate records in multiple tables.,
John Nurick
Reterving of top 5th value from the table,
damodarnarayana
Crosstab almost perfect,
Blair
cannot open file 'AptCashier.mdb' using access 97,
sunychu
Query error,
Doc Rock
Re: Running Total / Concatinate question,
John Spencer
Finding First salesperson,
Jordan_n22 via AccessMonster.com
Query last 7 days,
CraigADavisJr
Re: Merging two field together,
Rick B
Link AutoNumber to Text Field,
mattc66 via AccessMonster.com
Re: Expressions in queries that have an #error message come up in rec,
kingston via AccessMonster.com
Number Increments,
Chris
Re: Criteria on calculated field in parameter query,
Marshall Barton
doing an append and an update at the same time,
Helen Martin
Query Help for a report,
ttrig324
Re: How do I add 5 seperate number entries into a single line total?,
John Spencer
Re: Nz(null values in queries, 0),
John Spencer
Re: compariing and listing certain dates,
John Spencer
Re: Right Joins,
Jason Lepack
Re: IFF in Query??,
Jason Lepack
Re: Chart problem: At a loss :-(,
John Spencer
Re: Format text,
John Spencer
Subform parameter query,
drider629
Filter subform via different queries,
fapa via AccessMonster.com
Re: Combining Fields in a Query into Two Fields,
John W . Vinson
Adding a prefix number,
CAM
Ranking performance is slow,
matthewwhaley
SQL Command to List all Tables?,
Harry Whitehouse
Re: how to chek if a field is not null,
Paul B
Re: Reports due date,
Smartin
Re: Duplicate Query,
John W . Vinson
Re: flip this query,
John W . Vinson
Unmatched query,
henrik . johansson
show dups where all fields equal,
perryclisbee via AccessMonster.com
Help with criteria,
Paul B
Question about pass through queries,
Bongard
weekend query,
Joel Allen
Re: Simple Calculation Question,
Jason Lepack
Re: Association Difficulty,
Jason Lepack
Re: Duplicates in Union Query,
John Spencer
Re: Creating a query that tracks changes,
John Spencer
Re: Getting a total control to find totals for last 7 days via a query,
Marshall Barton
- Re: Getting a total control to find totals for last 7 days via a q,
efandango
- Re: Getting a total control to find totals for last 7 days via a q,
Marshall Barton
- Re: Getting a total control to find totals for last 7 days via a q,
efandango
- Re: Getting a total control to find totals for last 7 days via a q,
efandango
- Re: Getting a total control to find totals for last 7 days via a q,
Marshall Barton
- Re: Getting a total control to find totals for last 7 days via a q,
Marshall Barton
- Re: Getting a total control to find totals for last 7 days via a q,
efandango
- Re: Getting a total control to find totals for last 7 days via a q,
efandango
- Re: Getting a total control to find totals for last 7 days via a q,
Marshall Barton
- Re: Getting a total control to find totals for last 7 days via a q,
efandango
- Re: Getting a total control to find totals for last 7 days via a q,
Marshall Barton
- Re: Getting a total control to find totals for last 7 days via a q,
efandango
- Re: Getting a total control to find totals for last 7 days via a q,
Marshall Barton
- Re: Getting a total control to find totals for last 7 days via a q,
efandango
- Re: Getting a total control to find totals for last 7 days via a q,
Marshall Barton
- Re: Getting a total control to find totals for last 7 days via a q,
efandango
- Re: Getting a total control to find totals for last 7 days via a q,
Marshall Barton
Re: Queries with Parameters,
babyatx13 via AccessMonster.com
Re: How do I get the numeric data from a look-up to show as text?,
Jason Lepack
What am I missing?,
Amy Blankenship
Re: Case statement issue,
Jason Lepack
Re: Date expressions that can exclude weekends,
Jamie Collins
Year to Date Query Issue,
Steve
‘dashboard’ Form/Query to provide different data from the same fie,
efandango
Sum Values on weekends and total for Monday,
Bongard
Re: Something like a three-tiered JavaScript menu...,
John Spencer
Re: Multiple option query to calculate a value,
John Spencer
Re: Sums & Cross-Tab Query,
John Spencer
Re: DateSerial in Query,
Van T. Dinh
Re: Invalid Argument Error with Append Query,
dcichelli
Lookup table?,
ielmrani via AccessMonster.com
Re: Error Message 3075,
raskew via AccessMonster.com
Re: Query won't open in design view,
BBran
Re: Long iif statement not working,
John W . Vinson
Re: IIF Statement,
babyatx13 via AccessMonster.com
Crosstab more than a years data??,
Bill
Matching Queries,
Kevin . Gilnack
Re: Miles per Gallon Report,
babyatx13 via AccessMonster.com
Re: Special Character '#',
BruceM
Re: First|Last Function,
Jeff Boyce
Consolidate rows,
BruceM
Re: Query for retrieving week end date.,
babyatx13 via AccessMonster.com
Re: Clock In / Clock Out (Military Time) equals negative time??,
Tom Lake
Re: comparing two tables,
kingston via AccessMonster.com
UTC and Now() function,
techgeek1234
Re: Query modification,
Jason Lepack
Re: UTC Time zone and Now() function,
raskew via AccessMonster.com
Re: Insert Into syntax help,
John Spencer
querry - choosing selection,
Viktor via AccessMonster.com
Re: Series of action queries,
Jason Lepack
Access to access via Net,
Matti Koski
Re: How can I measure comparative progress across a range of dates?,
kingston via AccessMonster.com
Using Current System Time to Select Groups of Records,
Sighman
grouping,
Joel Allen
Sum on totals by date with 1's and 0's,
efandango
wildcard,
Joel Allen
Updating Fields with one charachter to another,
Craig
how to calculate the field delta between two records in the same table,
charlie
Created Replica now "operation must use an updateable query",
Farrel
Re: Update query using a sub select,
giorgio rancati
IsNull,
Mike Will via AccessMonster.com
Re: Adding the data of two columns together.,
kingston via AccessMonster.com
Re: Criteria of two field values being equal,
Carl Rapson
End If without block If,
ZIMMJE
subform query,
Spring
Re: Relationships,
Jason Lepack
Re: Nested IIF,
Jason Lepack