microsoft.public.access.queries
- dlookup problems,
b . bomgren
- Re: Append Query with Duplicate Primary Key Records,
pietlinden
- Re: LookUp columns!,
Jeff L
- Re: adding queries together but not imposing their criteria on each ot,
Duane Hookom
- Re: It was working perfect,
John Vinson
- last row per account,
Knox
- Re: Ranking records,
Marshall Barton
- Re: average time between two date ranges,
Duane Hookom
- Re: IF, Then, else,
Nick 'The database Guy'
- Re: Calculating/Storing Elapsed Time for Future Averaging,
Lynn Trapp
- Re: Update query gives wrong results,
John Spencer
- Re: Format Date to financial year,
Gary Walter
- Re: Except operator in Access 2003,
bjartnes
- Re: Percentage of total,
Marshall Barton
- "Numeric Field Overflow",
Don
- Re: wildcard date search,
Allen Browne
- Help with Case Statement,
lurch279
- Re: I need to generate a 8 digit Random Number in a Query,
Jeff Boyce
- DAO - Column rather than row,
Dan
- Re: Query parameter not working when expression points to form field,
pietlinden
- Re: TOP 1 in INNER JOIN,
Jeff L
- Re: how to call unique records DISTINCT?COUNT?,
Jeff L
- Re: track query usage,
Brendan Reynolds
- Can't find stored procedure,
j_sobecki
- Outer Join on Two Fields?,
scottchampion
- Re: The "count" function,
Marshall Barton
- Re: Auto Num,
David Cox
- Re: Re-naming during concatenation,
Roger Carlson
- Re: Counting null in totals query,
Marshall Barton
- Query returning unwanted results,
Phil
- Re: repeating parameter query,
Duane Hookom
- Re: Problem with "and" & "or",
Roger Carlson
- RE: Percent Utilization Based on a Date Range,
J Rhymes
- sql query where search criteria contains a single quote e.g O'Neill,
Gerard . Clynch
select only those rows that have more than 2 entries based on key field,
Jess
Convert Number to Time format,
Krish
Help with getting newest record,
jln
Using more than one join in a query,
Bert
Using AND in Queries,
greg . kylelangley
select non-dup records,
xg
Re: get a combo box to show specific list depending on data eneterd,
Steve Schapel
Re: Duplicate queries,
Steve Schapel
passing range values into query criteria problems...,
james
Re: Auto-populate one table from another,
Jeff Boyce
Re: Subtracting Dates in a Query,
John Spencer
Re: Max fields in make table query? Error message "Invalid Argument",
Rick B
Re: concatenate distinct data,
Duane Hookom
RE: Update Table,
KARL DEWEY
Re: Comparing data in Access,
Jeff Boyce
Help with format amount (dollars),
Mike B
Re: Multiple Value Filtered Query,
John Spencer
Re: Splitting a data field,
John Spencer
Re: Dsum slow,
John Spencer
basic query help for two linked tables,
shadowsong
Re: iif & like,
John Spencer
Re: Like in a paramater query,
Jeff L
RE: Need help to create code,
FrankM
Appointment system help,
mortisha_i_am
Sum working hours,
thomas
Summing working hours,
thomas
Updating Blank Records,
HearSay
Re: Print Current record,
Allen Browne
Updating Blank Field,
isons via AccessMonster.com
Re: show count,
Michel Walsh
Payment Vs Total Order Value,
isons via AccessMonster.com
a Report Spanning 2 days,
dn
Re: comparing rows in a query,
Allen Browne
Cut record from a table instead of appending,
CAM
Re: Update record in code,
Nikos Yannacopoulos
Re: filtering dates in a query,
John Vinson
Re: Query: Datasheet View,
Duane Hookom
Re: Calculate between two expressions,
Duane Hookom
passing values into query criteria,
james
Re: Operation must use an updateable query,
david
Re Post - Problem With Same-table Join,
yunno_who
need append query SQL help,
Slez via AccessMonster.com
complex select query,
MES via AccessMonster.com
Create an input box for update queries macro,
jesZee
Re: IIF question,
John Spencer
RE: Count Query,
WMorsberger
- RE: Count Query,
Klatuu
- RE: Count Query,
WMorsberger
- RE: Count Query,
Klatuu
- RE: Count Query,
WMorsberger
- RE: Count Query,
Klatuu
- RE: Count Query,
WMorsberger
- RE: Count Query,
Klatuu
- RE: Count Query,
WMorsberger
- RE: Count Query,
Klatuu
- RE: Count Query,
WMorsberger
- RE: Count Query,
Klatuu
- RE: Count Query,
WMorsberger
- Re: Count Query,
John Spencer
DELETE QUERY,
guaro555 via AccessMonster.com
Filling a Container,
DRPJL
Re: Can't sort by expression,
John Vinson
Re: A paramater based on another paramater's results??,
Duane Hookom
Deleting records,
Viktor via AccessMonster.com
Re: Sum top 3 query,
Michel Walsh
Re: how to find lowest of two numbers in access 2000,
Duane Hookom
Re: how can i convert stored procedures in sql to stored queries in ac,
Michel Walsh
Re: SQL Insert Value,
Allen Browne
Conditional INSERT Query,
Warrio
Re: Formulas,
Jeff Boyce
nested SQL asking for value,
conradtruscott
Re: Qty Query applied to tables listed in another table?,
Allen Browne
Query Madness,
mask2xxx
Re: Unable to save pictures from Inbox to My Pictures folder,
John Vinson
Query not updateable in Access 2000,
daniel
Combo box parameter report,
allie357
Complex Access 2003 Query,
Ward
Delete query refuses to run (looks good in select mode),
Jan
Re: identifying inactive entities,
Allen Browne
Cannot get same-table join to work,
yunno_who
QUERY 3/5 fields TRUE, then TRUE, otherwise FALSE.,
slagg7575
Re: divide records equally among multiple employees,
Allen Browne
Re: Query surprise!,
John Vinson
Re: Query - Choosing Scores to Average,
Ken Snell \(MVP\)
Re: Query gives incorrect count of records,
Douglas J. Steele
Null date field,
swtrader
Re: Transpose rows and columns,
tina
email addresses in a database,
David Robinson
Top 10 Invoice Values Per Customer & Site - ??,
Dave Gibson
Re: Criteria Script for a Query,
Ken Snell \(MVP\)
Re: Select top n records (randomized),
Allen Browne
Help with Crosstab Query to transpose data,
Mark
Re: Remove text from field,
fredg
IF Query critera <120 "true" >120 "false",
slagg7575
SQL Pass Thru from normal qry,
perryclisbee via AccessMonster.com
Re: Monday-Sunday Date Range,
[MVP] S.Clark
Re: Evaluating Strings in Query Builder,
Jeff Boyce
Re: Conv. 0 and 1 to Yes, No,
Jeff Boyce
Re: Add null value to date field.,
Michel Walsh
Re: Query not doing anything.,
[MVP] S.Clark
Query Avg / Ignore Null Values and Zeros,
gumby
Re: how to find records in one table which are not in another,
Jeff L
Re: query 2 years of data from same table,
Allen Browne
Re: NotIn Function? Need a query based on 2 tables.,
JK
Date conversion,
Dave
Re: Crosstab Query - Show date range????,
Duane Hookom
Date Difference - Weekends & Holidays,
Tcs
Re: macro in a query?,
Duane Hookom
Re: How do I write an SQL statement to return the 2nd highest valu,
Nero
Re: Comparing date field values and deleting the earlier date record,
Michel Walsh
Re: Between and Query,
John Spencer
Re: VBA with a variable in a query using a dsum funtion,
Dale Fye
Re: Average data for previous month,
Gary Walter
Re: Queries and functions,
theblackghost
Problem writing query to get latest date and action from table,
conradtruscott
Re: Merging 2 tables,
pietlinden
Query to transpose date,
Mark
Re: Access 2003 has a bug. It renames my field caption like number,
Allen Browne
Re: unmatched query not working,
pietlinden
Re: Help Please!! Putting together a Challenging Query,
pietlinden
Re: large amounts of criteria,
pietlinden
Re: Merging two tables,
pietlinden
Message not available
Please, What is wrong with this Query?,
CEV
Re: Counting yes/no selection in a query.,
Duane Hookom
pictures in reports,
shank
DB search,
trawets
How can I create an empty date field?,
Tcs
Re: Run a query in a query.,
pietlinden
Re: date difference in days,
Jeff Boyce
Re: Set key field in Make Table query,
Jeff Boyce
Re: How do I force exact match in text inner join,
John Vinson
Re: Duplicate names in column A different dates in column b,
John Vinson
Re: Court Case for a Specific Individual,
John Vinson
Re: Password Protect Query,
jahoobob via AccessMonster.com
Re: Append query not working due to Validation Rule Violations,
John Vinson
- Message not available
- Re: Append query not working due to Validation Rule Violations,
Gary Walter
- Re: Append query not working due to Validation Rule Violations,
faxylady
- Re: Append query not working due to Validation Rule Violations,
Gary Walter
- Re: Append query not working due to Validation Rule Violations,
faxylady
- Re: Append query not working due to Validation Rule Violations,
Gary Walter
- Re: Append query not working due to Validation Rule Violations,
faxylady
- Re: Append query not working due to Validation Rule Violations,
faxylady
- Re: Append query not working due to Validation Rule Violations,
Gary Walter
- Re: Append query not working due to Validation Rule Violations,
faxylady
- Re: Append query not working due to Validation Rule Violations,
faxylady
- Re: Append query not working due to Validation Rule Violations,
Gary Walter
- Re: Append query not working due to Validation Rule Violations,
faxylady
Re: Make a Field the Name of the Table,
John Vinson
Convert table with separate checkbox columns into multiple rows by an index,
Holly
Re: Add the monthly range in each row using the actual start and end d,
Jeff Boyce
Re: Losing Records,
Allen Browne
CrossTab Sum and divide by 60,
gumby
Select Range of Records,
Michael
show values not listed in a table,
perryclisbee via AccessMonster.com
How do I create an Intersect Query similar to Oracle's?,
pjdavila
Re: Advanced Query Coding.....,
jahoobob via AccessMonster.com
Re: Updateable query,
Rick Brandt
Re: Overflow when add criteria,
Allen Browne
Re: Creating :Null field in Make Table Query,
Allen Browne
Re: Date Recurrence 2,
Allen Browne
RE: condition,
geebee
Calculating Dates,
brfender@xxxxxxxxx
Re: Make Table Query Question,
Allen Browne
How to convert text field to integer in query criteria,
mjbruesch
Re: Type mismatch problem,
Brendan Reynolds
Re: date gaps,
John Spencer
RE: trying to link tables in query, only works for 1st record,
Ofer Cohen
Relation division,
Lukas via AccessMonster.com
Total SUM in crosstab query,
Santa-D
Leading Zeros,
mattc66 via AccessMonster.com
Re: days between 2 dates w/o weekends,
Douglas J. Steele
Return records based on a certain value being reached.,
Mike D via AccessMonster.com
Re: counting "yes" answers in a query,
Jeff Boyce
Memo Truncation in Queries,
gamer2k4
need help with append query,
Slez via AccessMonster.com
Re: If, then, Insert date, else.,
Jeff L
Re: restricting 0.00% in AVG,
John Spencer
Re: using lookup fields in queries,
Jeff L
RE: How do I group a text field in Microsoft Access query?,
rmoore
Re: change underlying query,
pietlinden
Re: DESPERATELY NEED HELP,
pietlinden
Re: create query dynamically,
pietlinden
Re: criteria mismatch,
pietlinden
Re: sum duplicate records in query,
pietlinden
Re: Removing dashes in phone numbers,
pietlinden
Re: Making a cross tab in an Access Project View,
[MVP] S.Clark
How to avoid duplicate records in two queries,
hkgary33 via AccessMonster.com
Randomize records,
RRKEM
Re: SQL,
Duane Hookom
Re: creating a count query from a union query,
John Spencer
Re: Displaying # records around 1 record (alphabetically),
John Spencer
Re: search and group results,
pietlinden
Re: select data field and update another field in the same record?,
John Spencer
Re: Generating Records of all date,
John Spencer
Replacing Field,
isons via AccessMonster.com
Re: how i can calculate the total hours for overtime,
Allen Browne
Re: date field - filtering,
Allen Browne
Re: how to get month in queries,
Allen Browne
syntax error (missing operator),
Pamela Creighton
Re: Query building Copy and Paste not working,
Gina Whipp
- Message not available
- Re: Query building Copy and Paste not working,
Gina Whipp
- Message not available
- Re: Query building Copy and Paste not working,
Gina Whipp
- Re: Query building Copy and Paste not working,
CurtainMary
- Re: Query building Copy and Paste not working,
CurtainMary
- Re: Query building Copy and Paste not working,
Gina Whipp
- Re: Query building Copy and Paste not working,
CurtainMary
- Re: Query building Copy and Paste not working,
Gina Whipp
- Re: Query building Copy and Paste not working,
CurtainMary
- Re: Query building Copy and Paste not working,
Gina Whipp
- Re: Query building Copy and Paste not working,
CurtainMary
- Re: Query building Copy and Paste not working,
CurtainMary
- Re: Query building Copy and Paste not working,
Gina Whipp
Re: Query and Report "enter parameter",
pietlinden
Re: Query Access 2007 "Disbled Mode",
Lord Madrid
Re: Duplicate entries,
pietlinden
iif #Error then,
mattc66 via AccessMonster.com
Re: Way to query both ProperCase & Upper Case,
Ken Snell \(MVP\)
- Message not available
- Message not available
Re: Creating a query with multiple items from a single field,
[MVP] S.Clark
suppress warning when export from query to excel,
xg
RE: DSUM criteria,
Dale Fye
Re: Query for combo box,
John Spencer
Re: Query / Join Problem,
Jeff L
Re: create a query to delete all records in a table,
Jeff L
Re: Query AND vs. Or,
Allen Browne
Re: Formulas in Access Queries,
John Vinson
Re: Defaulting a Query to the Current Fiscal Year's Start and End Date,
[MVP] S.Clark
Re: Subquery Help,
Jeff L
Re: help...new to queries,
Jeff L
RE: append query errors,
Dave F
Excluding a field in query in a one-to-many relationship,
eclypse66
Update query not working Please help,
allie357
Data is deleted from Query but not in Tables..,
Newf via AccessMonster.com
Re: total multiple fileds into one,
John Spencer
Update table with SQL,
Roger Svensson
Rounding to nearest 1000,
Darrell
Inserting text containing a vertical bar by code,
Per Larsen
Re: Finding Unique entries & Deleting Them....,
Michel Walsh
Re: Merging multiple fields on one row into a single field in a 2nd ta,
Michel Walsh
Re: if statement in query criteria,
Jeff Boyce
Re: How do I express more than 2 SELECT FIELDS within the same table?,
jinsungy
Re: Why does this query work, but not the other example?,
jinsungy
Hoping You Can Help Me to Save a Little Time.,
krystle h. via AccessMonster.com
SQL Code Error,
ielmrani via AccessMonster.com
Re: Aligning and sizing subforms on a form,
John Spencer
Rounding/Remainder help,
Lord Madrid
Queries involving subforms,
Phil
Re: Union 2 fields where values are counted?,
Amy Blankenship
Re: query from form,
Allen Browne
Re: Using all tables,
chris . nebinger
RE: Unique values & Record count,
Ofer Cohen
Re: Formatting when working with phone numbers in queries,
John Spencer
Re: Query - Calculating field,
John Spencer
Using a table to fill an other table,
jvdn
Re: Operation must use an updateable query.,
John Spencer
Re: same column name from multiple tables,
Jeff Boyce
Re: Returning records with fewer than 10 digits,
John Spencer
RE: Query for various servers,
Angus
Average certain records?,
Jay
Join expression not supported with outer joins,
corybradshaw
Re: Query not retrieving data that is definitely there,
Allen Browne
Re: Query Parameter Prompt for >=,
pietlinden
Re: help with append query...,
tina
Re: Simple between and query,
Ken Snell \(MVP\)
Query with dates help,
Carlos
Re: hide duplicates in related records,
Michel Walsh
Re: Problem with Query and Outer Joins,
Gary Walter
Re: How to give users a list box when running a query,
Gary Walter
Re: Restock Query needs help!,
Gary Walter
Need SubQuery Help - Table with Multi-Field PK,
bkimbrell@xxxxxx
Re: Update query using Left function,
tina
hide duplicate fields in related records,
geexcess
Form control reference in crosstab query,
tina
Re: how do i select the most current record using effective date in ac,
Ken Snell \(MVP\)
Re: Finding Duplicates - Query & Macro problem,
Steve Schapel
fail to link textbox control to query,
hkgary33 via AccessMonster.com
Re: Suppress duplicate CompanyName,
Duane Hookom
Xtab criteria problem?,
Pete
Sounds like it should be easy, but is it? - date calculation question,
JM
Re: Union Assistance Requested,
John Vinson
Filtering.,
Austin Powers
Simple Rows to column Not so simple for me,
Carlos
Re: Combine two tables with a query - How to?,
Duane Hookom
Re: Append query locks application,
Dale Fye
Re: Calculating totals and % change,
Bob Miller
Re: Updating records,
Jeff Boyce
Percent calculation based on cross-tab query,
Jon
Form Based on Query Update Labels,
mattc66 via AccessMonster.com
Re: Multiple Column Sorting...,
Allen Browne
Cross tab heading update issue,
mattc66 via AccessMonster.com
- Message not available
- Message not available
Re: Counting days question,
giorgio rancati
Re: Using MultiSelect Listbox & Combo Box as Parameters,
celticfairy
Parameterized query,
seans
Query Performance.,
Warrio
Re: Close a query on error,
Allen Browne
Re: how do i extract using mid criteria?,
pietlinden
Free SMS Messaging From Computer to Cell Phone,
dbarr8
Re: allocation function within a query,
pietlinden
Chikka Software,
dbarr8
Re: Time Weighted Average,
Dale Fye
Re: Query records that expire (date) in XX days,
fredg
combing three queries to create a report,
wanglede
Creating a combined query,
Klips
Query date errors,
kurt . baker
Re: using LIKE inside an IIF,
Rick Brandt
Re: Filter out records from one query by removing records in other que,
guido via AccessMonster.com
Combining three queries into one,
wanglede
Re: Delete records containing certain info,
aMack
Re: Query help...PLEASE,
John Vinson
Re: Two Criteria Questions - Need to be able to leave one blank,
John Vinson
Query trouble...summing count...suggestions?,
allie357
Rank Values inside Query,
JohnR
Why is my Top Value query not working right?,
hotplate74
Aggregate Function in a query based on a query,
JK
Re: Can I update a select query using an update query?,
Allen Browne
Re: Updating from Many records to one table,
Jeff Boyce
Re: conditions in the select clause?,
Jeff L
Re: Null values in date range, multiple criteria,
Jeff L
Re: Updating area codes and exchanges,
Rick B
Re: How do I compare 2 tables for mismatched data?,
Rick Brandt
Querying multiple initials fields for report,
Don
Re: Formula help,
Brendan Reynolds
Order and UnitsInStock,
Syphonics
Re: I have a "delete query" query!,
John Spencer
Re: Count and record query records,
Steve Schapel
Re: Problem with Date Query,
Baz
Re: if access query has no records, output "no records found",
Duane Hookom
Correlated SubQueries in Access,
News.Microsoft.com
Adding Rows,
Floyd Forbes
Re: Replace characters in a table,
fredg
How to Join 3 Tables,
MT
Re: Avg() in passthrough query returns string,
giorgio rancati
Changing Date/Time Property on Linked Table?,
Xavier
Re: How do I rename a folder? (not a file),
Ken Snell \(MVP\)
Re: Trying to write a query that finds unique records,
Jeff L
Count in a query problem,
Mike B
Re: how do I show the last 4 digits of a SSN in Access 2000,
Brian . M . Waters1
Delete Query with Requirements,
soberman
Re: Run Update Query Using the Where Clause,
John Vinson
Re: Query - String Fields NOT Empty Condition,
fredg
how to do this query,
coedxiao via AccessMonster.com
Crosstab Date Column Heading,
mattc66 via AccessMonster.com
Trouble Querying Database,
Brian . M . Waters1
How to pass parameter between parameter queries,
Carl Colijn
Calculations,
trawets
help with calculated field expression,
Slez via AccessMonster.com
Count contacts who are associated with campaigns,
VLee . KHer