microsoft.public.access.queries
- Re: crosstab column field size,
Duane Hookom
- RE: When I put in 1,2,3,4, or 5 all items beginning with that numb,
Leslie
- Re: Update query/Delete Query,
John Spencer
- Work Around,
Mark A. Sam
- Re: I need to change all data in two fields,
fredg
- Re: select from a combo box to display a report,
fredg
- Re: How do u build a Query that merge the two table together?,
MGFoster
- Re: Executing a query in the Query Designer via keyboard shortcut,
MGFoster
- Re: Calling "Format" function in an expression of a query,
fredg
- Re: Specific Date Criteria,
fredg
- Re: In a query, create an average field when another field is a match,
MGFoster
- expressions to omit info,
jwrnana
- SELECT query to match on 5 out of 7 fields,
Kristen
- RE: Find Duplicates in one field AND where another field is unmatc,
Ofer
- Re: Find Duplicates in one field AND where another field is unmatched,
John Spencer
- Re: seperate data in a field into two fields,
tina
- Re: Filter a text field for only numeric values,
John Spencer
- Show last records by date?,
Rose H.
- Prompted for Values while Running a Query.,
comish4lif
- Re: How to make Access ignore missing data (-999),
Phil
- Calculated controls,
bbrazeau via AccessMonster.com
- RE: Joining results of two queries,
peter kappes
- Percentile Aggregate Function,
ajay . kalyan
- Re: Query based on the value of a calculated field,
Jeff Boyce
- Re: Delete and INNER JOIN,
John Spencer
- New Services?,
Mark Stephenson
- Re: SQL erases after the query is ran,
Paul B
- query outout formating,
SF
- Set Query Criteria when opening a form,
Chas Large
- Null value question - simple.. should be anyway,
Mischa
- Calculated Fields in Access 2002 queries,
Wellcome
- Help figuring out query,
Jdougal via AccessMonster.com
- Re: weekly reports,
Duane Hookom
- Re: Searching,
Duane Hookom
- Re: Parameter query: how to display all if nothing is entered,
Rick Brandt
- Link excel to a query?,
LMB
- Calculate until End of Financial year,
NoRegrets_jackhammer2485
- Re: Expression Total Not working,
MGFoster
- Need VBA Codes for Update or Insert statement in MS Access,
FA
- Re: How Create Sum for Sort?,
MGFoster
- Re: Problem with Querty,
MGFoster
- Re: Increase and Decrease of an Amount Field,
MGFoster
- Is it possible??,
rblivewire
- Re: reset query value,
John Spencer
- Re: Combining start and end dates to create a date range,
Michel Walsh
- Need help in MS Access Query,
FA
- Re: "Create a new query" option has disappeared, where is it?,
Duane Hookom
- Re: Query to select first record of changes between records,
Amy Blankenship
- Random,
Brian
- Re: date extraction,
tina
- Re: Recoding Yes/No Data Type in a Query,
fredg
- Re: Merge two or more tables into new table,
robink
- Re: Cannot insert record,
Duane Hookom
- query with date limitations and expressions,
cporter
- Access 2000 to 2002 Selection to Union Query Conversion,
samsoldman
- Re: Crosstab based on date range,
Allen Browne
- Re: Calculating percentage,
Allen Browne
- Re: Add "ALL" to combo box?,
Brian Bastl
- Register Help!!!!!,
darkguyver_2002
- Datediff function,
Amazing
- query for random records,
_Bigred
- Re: How do I run a query and exempt certain numerical values?,
Duane Hookom
- Counting the days sequentially in a month on a date field.,
BFish via AccessMonster.com
- Re: Calculation Sum to appear at the bottom of one column of numbers,
Duane Hookom
- Re: Queries with no records,
strive4peace
- Re: Eliminate duplicate records,
Dr. Brad
- Re: Duplicate Amounts don't show up in Union Query,
Tom Ellison
- Re: duplicate data,
Tom Ellison
- Re: labeling a value,
fredg
- Bulk DELETE or TRUNCATE query,
ricky
- Re: if then,
Duane Hookom
- Re: date field question,
Rick Brandt
- Taking Last Value from range before query starts.,
Mike Abbott
- Re: Storing and Querying MS Word Docs in a mdb,
John Nurick
- Re: Generating passwords automatically,
Peter R . Fletcher
- How do you subtract two dates in an expression?,
Paul Ponzelli
- Re: how do I extract the date between two date fields in Access,
strive4peace
- Re: I grouped the data but don't see sum appear when I run the query,
Duane Hookom
- Re: Overflow Message,
Ken Snell \(MVP\)
- Re: Combo box show values based on value in Option group?,
Pat Hartman\(MVP\)
- Re: how to use GROUP BY,
Marshall Barton
- Using string variable in Query,
BudMan
- NUMBERING GROUP OF RECORDS IN QUERY,
ClaudioGuru
- Active X Calander Controle,
Ian Potter
- Re: Queries with no records -- change Join type,
Crystal
- Re: merge update queries?,
tina
Re: Create new fields from duplicate records,
tina
Re: outer join with multiple fields,
Marshall Barton
Re: Only last record,
Jeff Boyce
Append Query: Invalid Argument after Compact and Repair,
Appleton
Merge two tables together with same fields.,
Miranhat
Find and replace,
Jacques
Re: Excluding related records in a query,
Jeff Boyce
Re: Trim function in a query,
Tom Ellison
Re: Qry Criteria too Complex,
MGFoster
Re: Sorting Data into Groups,
Duane Hookom
Entering Decimals in a Table,
Ian Potter
String data, right truncation (#0) - Strange,
martin1b
Re: The Microsoft Jet database engine does not recognize <name> as a,
John Spencer
programming complex query/report,
Carl Porter
Re: Last Years Sales Data based on Fiscal Week,
Crystal
Re: Invalid Expression - Repost,
Crystal
Re: Connection to another Server,
Jeff Boyce
Re: Top 3 query gives 4 records,
Roger Carlson
Re: Duplicate query,
Tom Ellison
Re: compare two memo fields,
John Nurick
Re: iif with sum function please ! urgent!,
Crystal
RE: need table to update when a linked dropdown has information chosen,
Peter Yang [MSFT]
Re: Two table query not allowing entry.,
Duane Hookom
output to a formated excel sheet,
SF
help with query,
Jack Shelp
Re: Error message instead of parameter box appearing,
John Spencer
Re: How do I query two tables of a mdb file for unmatched records?,
Rob Oldfield
Re: Querie for inexisting records,
Rob Oldfield
Re: Default Value for Combo Box,
MGFoster
Re: Connection string for pass-through query,
MGFoster
Re: Need Help,
MGFoster
test for empty date,
mcnewsxp
Re: Crosstab Query Column Headings,
Duane Hookom
Re: Find Unmatched,
John Spencer
Need to create a query,
rblivewire
Re: No mention of MS-Access in Office 2007,
Marshall Barton
Re: Date format in query,
Marshall Barton
Re: count alphabetically within a sort,
OfficeDev18 via AccessMonster.com
My query is broken and I cant fix it :<(,
red skelton via AccessMonster.com
Invalid Operation,
Mark A. Sam
Query disappears after adding table to design view,
Darrin Ezell
Problem with totaling,
RJS76 via AccessMonster.com
Get count of product with special feature at each store,
robert d via AccessMonster.com
Re: access ??,
Rick B
Re: access date finction,
Rick B
Re: Running Total,
John Spencer
Missing Data in Multipart Query,
die_laffin
Re: Delete query is not working,
John Spencer
Re: Matching records within one table on multiple fields,
John Spencer
Report is adding too many numbers,
Jacques
Re: sub-Assemblys,
Tom Ellison
Re: character limit to updating memo field from form,
Tom Ellison
Re: Query - accumulated,
Allen Browne
Matching accents,
tony h
Devide a colum into multiple columns in an access query,
Jeronimo
Re: Geting result set to print only Checked records,
Crystal
choping up data,
ryan . clair
Re: Retrieving records where yes/no data type is checked,
Duane Hookom
Re: Add queries to new crosstab every month,
Duane Hookom
Re: combining groups in a query for a report,
Duane Hookom
Re: How do I set a between criteria in a query in Access,
Duane Hookom
Re: combo box incorrectly looking up the primary key records,
Brian Bastl
IIF Statements,
mb
have query grab 2 different method,
_Bigred
Books covering Access SQL peculiarities,
_DS
Decimal fields's precision is too small to accept the numeric you attempted to add,
Phil
Re: Find changes between two tables,
[MVP] S.Clark
Re: Current Date,
John Spencer
Re: Recordset cannot be updated,
[MVP] S.Clark
Calculating Days,
learning_codes
Re: add zeros to number,
MGFoster
Re: Export Query to multiple files,
MGFoster
Re: EXPORT TEXT FIXED LENGTH FILE FROM QUERY,
MGFoster
Re: Change name of column queried "on the fly",
MGFoster
Re: Criteria for records between two dates,
fredg
Re: how to change numeric field to text,
Phil
How do I query a Date field (mm/dd/yyyy) by a Year (yyyy) value.,
Wayne
Re: Output Access Query to Excel Spreadsheeet,
Ken Snell \(MVP\)
Re: If criteria is null return all,
Rick B
Re: Incorrect Record Count in Union,
Tom Ellison
Re: Unwanted messages appearing in MSN Messenger,
Rick B
Re: Select which record to draw data from.,
Jeff Boyce
Re: Current month,
Jeff Boyce
Re: Need unique customer number,
OfficeDev18 via AccessMonster.com
Re: Like Query Question,
fredg
Re: remove text after pound sign in Access query,
Rick B
Query/Form Question,
Andy
Re: Make Table Query - Sorting Errors,
Duane Hookom
- Message not available
- Re: Make Table Query - Sorting Errors,
Duane Hookom
- Re: Make Table Query - Sorting Errors,
Fred
- Re: Make Table Query - Sorting Errors,
Duane Hookom
- Re: Make Table Query - Sorting Errors,
Phil
- Re: Make Table Query - Sorting Errors,
John Spencer
- Re: Make Table Query - Sorting Errors,
Tom Ellison
- Re: Make Table Query - Sorting Errors,
Fred
- Re: Make Table Query - Sorting Errors,
Tom Ellison
- Re: Make Table Query - Sorting Errors,
Fred
- Re: Make Table Query - Sorting Errors,
Duane Hookom
- Re: Make Table Query - Sorting Errors,
Duane Hookom
- Re: Make Table Query - Sorting Errors,
Fred
- Re: Make Table Query - Sorting Errors,
Tom Ellison
- Re: Make Table Query - Sorting Errors,
Fred
- Re: Make Table Query - Sorting Errors,
Tom Ellison
- Re: Make Table Query - Sorting Errors,
KARL DEWEY
Re: Query Field Formula,
Duane Hookom
Can't aggregate...,
mike via AccessMonster.com
help with matching data required,
Norman Fritag
Re: Where can I download a German Spellchecker for Office XP?,
Rick B
Re: Show Records From Table1 That Aren't in Table2...,
Graham R Seach
Re: Incorrect calculations in a query.,
John Spencer
Re: Select Query,
John Spencer
Re: Extract a part of a date or time value,
John Spencer
Re: Maybe Dumb question ...,
david epsom dot com dot au
Re: Return Records with Values,
Duane Hookom
Re: Query Statement for negative values = 0 but keep the whole values,
Duane Hookom
Help Subtracting Now() - Minutes,
joeserrone
Re: Selecting only 1 record from a group of 6,
Jeff Boyce
One-to-many question,
Ann Scharpf via AccessMonster.com
A query based on form action,
Olden
Re: VB Query shown in Sub Report,
Brian Bastl
Concat different rows column into single row field,
troppfigo
RE: Combine fields into a text,
KARL DEWEY
Re: Delete Records in One Table from Another,
Lynn Trapp
Re: A query is 23 lines, click sort and then only 11 lines are shown?,
Marshall Barton
Re: 2nd post - Crosstab query column headings,
Duane Hookom
Re: Getting count of field occurances (trying again),
Crystal
Re: Find Duplicates with Different Yes/No values,
Crystal
Why is this query unupdateable??,
tlyczko
Re: Date Comparison,
Tom Ellison
DAVG in Query,
Scooter
Re: multi yes query,
John Spencer
Re: Module,
John Spencer
Re: Removing a certain word from a field,
John Spencer
Re: Updating Query,
John Spencer
Re: Make Table Query - Formatting Percentages,
John Spencer
Re: Unmatched records for multiple field match,
John Spencer
Re: number records in a group, within access query,
aemAndy
Re: A query is 23 lines, click sort and then only 11 lines are sho,
John Spencer
Re: query yes for two fields,
Rick B
Re: How to get data from 2nd row,
Duane Hookom
Re: combo box calculations,
Michel Walsh
Re: How do I create a weekly rolling average in access?,
John Spencer
How to get record ID of just inserted record,
wazza_c12
Re: Set criteria in a query to always find current month data,
Ricky Hicks [MVP]
Query Using List Boxes,
Ganz
Re: Copy Information Within a Table,
Rick Brandt
Re: pass through query,
Rick Brandt
Best way to do this query,
Mick
Re: Combining 2 queries into 1 query with same data field,
tina
Re: inputting criteria from a form,
tina
- Message not available
- Message not available
Re: Eliminate spases in number,
Douglas J. Steele
Re: CombineChildRecords with concatenated fields,
Douglas J. Steele
Re: duplicate data in column in union query,
Rob Oldfield
Re: Problem using ALL/ANY in a subquery,
Tom Ellison
Re: division in access query from separate tables,
Tom Ellison
Re: Matching records,
OfficeDev18 via AccessMonster.com
Re: Update a number field incrementally,
OfficeDev18 via AccessMonster.com
Re: Replace "wildcard" string in a query,
John Spencer
Need Help on AVG Query,
scottyp1967
Re: How to manipulate data based on the results in a query,
OfficeDev18 via AccessMonster.com
Extract just the date from Date Time,
Neal
Re: How do i make a table using todays date as the name?,
tina
Re: Counting until change in field,
John Spencer
Re: SUPER, DUPER SLOW QUERY!,
OfficeDev18 via AccessMonster.com
Re: IIF function based on Check box,
John Spencer
help me plzzzzz... (urgent),
marco
Re: Storing the result of a calculated field,
Nikos Yannacopoulos
best way to do a parameter query for selecting a month,
Neal
Suppressing Parameter Query Prompt,
Jimbo
Re: Sum of fields,
tina
Re: Sums in query,
tina
Re: error message 3121 cannot group on fields selected with '*',
John Vinson
Time in seconds to mins and seconds,
Neal
- Message not available
- Message not available
Need help with delete query...,
Joe
Re: the append query do not transfer decimal digits why?,
Rick Brandt
Newbie question - Querying Yes/No fields using form,
Hulo
Query not updated,
Lasse T
Re: A big Thank you,
Tom Ellison
Re: Linked SQL Field being cut off,
Tom Ellison
Re: two queries in same table,
John Vinson
Re: Running Sum,
Marshall Barton
Re: Convert Text to Date,
Marshall Barton
Re: No Data,
Douglas J. Steele
Re: Update a reference field incrementally,
John Vinson
Re: Summing two fields from one table and dividing them in a pivot,
John Spencer
Re: sorting a Dcount field,
Duane Hookom
Re: between statement issue,
Michel Walsh
Re: using the keyword "LIKE" with SELECT not working,
RoyVidar
Ignoring Layout Save Dialog box,
Jimbo
Query question??,
Christos via AccessMonster.com
Re: Problem comes while updating,
Brendan Reynolds
Re: access: correcting time formats,
John Vinson
12 month rolling average,
jar
Re: input query prompting twice,
Ken Snell \(MVP\)
sales between hour1 and hour2,
fabrice
Re: question marks in values,
John Nurick
Re: Order by Alias Field Name?,
Ken Snell \(MVP\)
- Message not available
- Message not available
Re: Correct syntax using a numeric variable in the WHERE clause,
fredg
Re: select count(distinct(column name)) from table name,
John Vinson
Re: Top Value,
John Vinson
Re: How do i get a query to give me a 15 min sum from 5 m intervals,
John Vinson
Re: Help with Query Calculation,
Jeff Boyce
Re: Ranking Top 3 Results,
Ken Snell \(MVP\)
Re: query results shown on mutiple spreadsheets,
Rick B
Create queries based on form selections,
dreamsoul620
Re: MS Access Pass through to 2 SQL Server DBs within one SQL Statemen,
Tom Ellison
Re: ActiveX error when try to run a Query,
Douglas J. Steele
Re: DateAdd Funtion Nightmare,
Douglas J. Steele
Re: Message box,
BruceM
Re: Access query: prompt input with a droplist?,
Duane Hookom
Restart numbering,
CJ
Two tables, different structures, can Access 2003 update or append?,
Brian Goodheim
Re: Combining text and currency fields with possible nulls,
John Spencer
Re: #Error in Query,
Duane Hookom
Re: Return Last,
Roger Carlson
crosstab query with parameters,
Lindsay
RE: Not in query,
Pete
Re: aggregate text in group query,
Brian Bastl
Creating a temporary table/query for subform,
LeMay
Re: if then statement not working,
Brendan Reynolds
Re: if then statement not working in .asp file,
Brendan Reynolds
Combining City and State Errors,
jwrnana
Update Records from Another Database,
damiankinsella
Finding unmatched/missed dates within same table,
Alp Bekisoglu
Re: Select first three records,
Allen Browne
Re: Yes/No Query,
tina
Dynamic query using no, some, or 2 CRITERIA fields,
Tom
Creating an automated manual,
jorel
Re: If expressions,
Rob Oldfield
Re: UNION and Unique ID,
Rob Oldfield
Re: fields,
Rob Oldfield
Export to HTML & update Question....,
JNariss@xxxxxxxxx
Re: Adding a Autonumbering Field,
Michel Walsh
Re: Query to Count Number of Times a Value appears for certain criteri,
John Spencer
Delete query date field pulling more than one month,
Bill Fischer via AccessMonster.com
Re: Help with this IIF statement,
Wayne Morgan
how to break the bounds of 59 in data/time data type,
x
inner join and remove leading and trailling letters,
zwasdl
Returning unique results only is control is Null,
pi3832@xxxxxxxxxxx
Re: query by day, week, month, year,
Jeff Boyce
Querying all jobs between two dates,
PaulHilgeman
Re: Append Query Error,
OfficeDev18 via AccessMonster.com
Re: Data in table (Memo field) not getting into Queries,
John Spencer
ODBC Call Failed - Queries timeout sometimes but not others... Help,
Joe
Moving Relationships Between Databases,
kh
Re: SQL,
Brian Bastl
Re: How do queries work?,
Allen Browne
Re: How do I add CR and LF to an expression to create a vertical list,
John Spencer
How do I compute yesterday's business date if today is Monday,
Dave
Mangled, with a difference,
Tom Ellison
- Re: Mangled, with a difference,
John Spencer
- Message not available
- Re: Mangled, with a difference,
Marshall Barton
- Re: Mangled, with a difference,
Tom Ellison
- Re: Mangled, with a difference,
Marshall Barton
- Re: Mangled, with a difference,
Tom Ellison
- Re: Mangled, with a difference,
Marshall Barton
- Re: Mangled, with a difference,
Ken Snell \(MVP\)
- Re: Mangled, with a difference,
Tom Ellison
- Re: Mangled, with a difference,
Ken Snell \(MVP\)
- Re: Mangled, with a difference,
Tom Ellison
- Re: Mangled, with a difference,
Ken Snell \(MVP\)
- Re: Mangled, with a difference,
Wayne Morgan
Dates,
Fie
Best method Please,
Tom
Re: Products with multiple price levels,
Allen Browne
Appending a table from a download,
Alex Martinez
Re: Parameter Query-how to do you return to re-enter the parameter?,
MGFoster
Function that relates to multiple fields,
rpboll
Re: Queries from two queries,
Crystal
Re: unable to filter records,
John Vinson
Query on 2 other queries,
Bob Groger
RE: I am receiving an #Error in my query even after using Nz funct,
Georgia girl
Re: Combine 12 seperate queries into 1,
Duane Hookom
Re: combine prompt with Like operator?,
John Vinson
Run Crosstab Query without a Paramater Prompt,
jrmfzf
Julian Date,
Chris
Re: Help With Expressions Within Expressions,
Marshall Barton
Re: HyperLinkPart fails in Access Query,
John Nurick
Re: Counting help.,
John Spencer
Re: Grouping,
John Spencer
Re: Microsoft Jet Engine Does Not Recognise......,
John Spencer
Re: Expression for multi-purpose field,
Rick Brandt
Re: Union query,
Marshall Barton
Re: SQL ambiguous outer joins (I think the solution is easy),
OfficeDev18 via AccessMonster.com
Re: Linking Queries from same table,
OfficeDev18 via AccessMonster.com
RE: DSum subtotaling,
Robert_DubYa
SQL PrimaryKey,
Anna Kubiak
RE: Unable to edit records in Query due to Relations with Linked .,
Vadimbar
Re: No Update After Specific Date,
John Spencer
copying field headers when exporting data to Excel,
andrea . bruner
Name from Textbox into query ?,
SpookiePower
SQL Statement Syntax Error,
JNariss@xxxxxxxxx
Re: Simply Query,
John Spencer
Re: Renamed table in query,
John Spencer
Re: Compare values in separate tables,
John Spencer
How to remove FIRST leading zero in a string,
Kermit Piper
Filltering results in a querie,
Yiannis
Re: counting values,
Gary Walter
Let user choose to see distances in miles or km,
James Minns
Want to count number of organisations with date range in crosstab query,
philip . au
RE: Parameters to OpenReport,
Peter Yang [MSFT]
Re: Passing a between statement to a query,
Wayne Morgan
Re: DSUM Function Criteria,
Duane Hookom<