microsoft.public.access.queries
- insert variables into Query,
stephenson22
- Problem with criteria,
scrye
- Message not available
- Message not available
- Re: Displaying the Difference Between a Date and Now(),
Duane Hookom
- Re: How do you calculate a null date?,
Duane Hookom
- URGENT - Need to match debits and credits,
toukey
- Re: Convert number to text,
John Vinson
- Deleting Duplicates in Access 2000,
Petep
- Currency to text,
Beagle1927
- Access 2003 Copy a record when a field contains two entries,
Céline Brien
- Re: calculate between two days if the second date is blank.,
pietlinden
- Re: Delete Query syntax in VBA querydef,
Granny Spitz via AccessMonster.com
- Re: Carriage Return in an Update Query,
John Vinson
- Re: Retrieve records based on 3 three periods, not using dates,
John Vinson
- Re: Previous Week Ending Date,
Jeff Boyce
- Can a SQL Pass Through query use a parameter from a Form Control?,
woody
- Re: Requery doesn't work,
kingston via AccessMonster.com
- Re: Undefined Function Replace and InStrRev,
fredg
- complex parameter query and report,
MES via AccessMonster.com
- SELECT query to show records for 2 parameter values,
MES via AccessMonster.com
- Re: Can I use a query to find and replace a word in a string?,
Duane Hookom
- Message not available
- Message not available
- Help on IIF Statement... please....,
bluefalcon904
- Storing data?,
blee via AccessMonster.com
- Re: How do I display non related queries on 1 Access page (Dashboard),
Jeff Boyce
- Re: Update - multiple tables,
Jeff Boyce
- OT: Klatuu name,
Gary Walter
- calculate difference between fields,
alecgreen
- Combo Box to Text Box Calculation,
Maurita
- Re: Unique records,
Duane Hookom
- Re: Query with specific months,
Duane Hookom
Re: Help with this query to pick only unique records.,
Neil Sunderland
Intermittent display problem with charts,
rdemyan via AccessMonster.com
Re: converting minutes,
Ken Snell \(MVP\)
returning a certain qualification,
Martin Hopkins
RE: Part of date,
Per
Re: Default Italics,
Douglas J. Steele
Re: Mulit. Sums,
Chris2
Re: top 2 records for groups in query?,
Allen Browne
Re: Count & Filter,
pietlinden
Re: Query to join two tables,
pietlinden
Re: Show all records *days after date entered in date field,
Van T. Dinh
Re: Multiple-Column Subquery In FROM Clause,
Granny Spitz via AccessMonster.com
Re: Missing records in cross tab query,
David F Cox
Re: Between statement ?,
kingston via AccessMonster.com
Only Return MAX AutoNum From relational Records,
Christopher Scott Rodgers
- Message not available
- Message not available
Re: Can I put a comment in SQL code of an Access Query, how?,
John Vinson
query all values equal to the nearest payday??,
tlyczko
To Crosstab or not to crosstab,
OMS
Re: trim,
fredg
- <Possible follow-ups>
- Re: trim,
kingston via AccessMonster.com
- Re: trim,
Jeff Boyce
RE: Query Records Showing Null AND Count = 1,
laknight
Re: Microsoft Access Problem,
Jeff Boyce
Re: Counting a yes/no field,
Duane Hookom
RE: most recent dates of duplicate records,
Paula
Clean numbers,
Rick5k via AccessMonster.com
Re: Parenthesis and periods in criteria,
Marshall Barton
Re: Complex query with non-standard return value,
David F Cox
Return Table Field,
shapper
beginners SQL question,
rich
Re: How do I "Group by" more than 1 field in a query?,
Rick Brandt
<Possible follow-ups>
Re: How do I "Group by" more than 1 field in a query?,
David F Cox
how to get count(col1), count(col2), count(sol3) with only one query,
Mario Krsnic
Re: Using a boolean return value from a function as criteria in query,
Allen Browne
Re: How do I get parameter queries to work with mail merge?,
Van T. Dinh
Re: date/time,
Van T. Dinh
Unicode character entry,
John Gough
Re: Next Issue - Setting the Order!!,
Allen Browne
Days excluding weekends,
Faio Eric
Need help calculating time query,
helpwithforms via AccessMonster.com
Re: Combo Box Query,
Granny Spitz via AccessMonster.com
How do I JOIN when 2 separate items reside in the same table?,
Barney the Rubble
Re: Convert string to number,
Douglas J. Steele
Finding previous business day.,
dodat via AccessMonster.com
Re: how do I commit changes in msaccess,
Van T. Dinh
Re: access query,
Marshall Barton
Re: decimals in an expression,
Marshall Barton
Which ARE NOT Duplicates!?!?,
Isaac Sanchez
Re: Help with syntax,
kingston via AccessMonster.com
Re: sorting,
kingston via AccessMonster.com
- Message not available
- Re: sorting,
kingston via AccessMonster.com
- Message not available
- Re: sorting,
kingston via AccessMonster.com
- Message not available
- Re: sorting,
kingston via AccessMonster.com
- Message not available
- Re: sorting,
kingston via AccessMonster.com
- Message not available
- Re: sorting,
kingston via AccessMonster.com
- Message not available
- Re: sorting,
Renetta
- Re: sorting,
kingston via AccessMonster.com
Split Query Result - How to combime them together?,
Vincent
Re: Report Selection from Po-Up Choice?,
kingston via AccessMonster.com
split field data,
Alex
Select Records,
shapper
double prompt in union query,
Amy Blankenship
Converting date to Week number,
Tom Tripicchio
Re: iIF statements in a query,
Jeff Boyce
Re: Multipal Entries,
Duane Hookom
Re: Can I create one query to run multiple update queries?,
Nikos Yannacopoulos
Clean Numbers/Text,
Rick5k via AccessMonster.com
split field,
Alex
Parameter Query,
Fie
Re: Delete query to clear records from one table with key linked to an,
Nikos Yannacopoulos
RE: Sql connections,
Rolf Rosenquist
Re: Query to filter data based on Text Box on a form,
MGFoster
Re: append table code question,
John Vinson
Re: Next available appointment,
MGFoster
Re: Query Based on an Input,
Duane Hookom
Re: let creditor know unable to satisfy loan?,
fredg
Re: Moving total result from query to report,
fredg
Re: Rolling YTD Query,
John Vinson
Select and updates records based on previous record selections,
pcslave via AccessMonster.com
Re: Append Query list of records not appended,
John Vinson
Re: Formatting,
fredg
Append Query key violations... Autonumber entries,
awkusmc
Re: Is there a formula?,
Brendan Reynolds
Re: Query pulls data from wrong table field,
Brendan Reynolds
RE: query that calculates the difference between two dates generat,
Bruce Meneghin
JOIN questions,
ksun via AccessMonster.com
Re: query with displaying data,
John Vinson
Insert Into SQL string from form,
a . t . brooks
Count and Count,
Brian
Re: Consecutive Date Query,
kingston via AccessMonster.com
Re: Handling Empty Strings in Query,
kingston via AccessMonster.com
Re: query that calculates the difference between two dates generated b,
kingston via AccessMonster.com
Query the date only and not the time portion of a column,
hansjhamm
remove hrs, minutes, secs from dateTime Fields,
harrykp via AccessMonster.com
Counting Duplicates,
Pam
Date Time Question,
ggonella
Re: Data Type mismatch Criteria Expression,
Ken Snell \(MVP\)
Re: Expression is too complex to be evaluated/data type mismatch,
Ken Snell \(MVP\)
Problem with finding minimum date value for query,
FrankieNap
Re: why does an update query ask for a paremeter?,
Duane Hookom
Append Override,
mattc66 via AccessMonster.com
Re: Deleting characters from cells in access,
John Vinson
Show dates,
Floyd Forbes
Trouble creating an Update Query,
Dos Equis
Re: Help with an update query??,
Jeff Boyce
Re: time criteria in query,
Marshall Barton
Re: Complicated Like Expression,
kingston via AccessMonster.com
Help with AppendQuery,
wesley.allen@xxxxxxxxx
Any Ideas!?! ;o),
Isaac Sanchez
Re: Criteria for requery,
philippe_b
Re: combo boxes on queries,
Jeff Boyce
Re: Combine Queries. Is it possible?,
kingston via AccessMonster.com
RE: learning to count with a query?,
KARL DEWEY
Query with parameter taken from a user-updated form control.,
Rayo K
add a table with vba to a query,
klwemu
Re: Include All Stores in Query,
Duane Hookom
Re: Need to export a pivot chart view of a query,
Bizarre
Re: Pass one parameter date?,
Jeff L
Pass a calculated value in a query?,
moorej2
Re: iIF statement in a query,
Duane Hookom
Re: No results in query,
Duane Hookom
RE: Help with criteria - counting based on text field,
Rayo K
Re: Not related table query,
Rick B
Re: How do I list the records from a table that DON'T appear in anothe,
Rick B
Sorting a Query Causes overflow,
Wesley Baker
Re: Saving Access Queries,
Allen Browne
Re: Updating an Access Form,
John Vinson
Re: HELP with Duplicate data,
Smartin
Re: help with count (maybe) in query,
Jeff Boyce
Count instaces of charcter in field,
Barkster
Permission to Query in User Level Security,
cdicob via AccessMonster.com
RE: Show all Cases,
Jerry Whittle
Re: How to enlarge the field viewing window inside of a query?,
Jeff L
Re: Find First Number,
Jeff Boyce
Re: Queries using a drop down field in a dialog box,
Jeff Boyce
ms query error 3078 cannot find input table,
lechu . 555
Re: add carriage return to end of text,
Duane Hookom
Re: Access 2007 distinct queries on unicode text - bug?,
Allen Browne
Re: Query using Checkbox State,
Marshall Barton
Re: finance date,
Douglas J. Steele
Re: What Does This Expression Do?,
David F Cox
Dlookup or similar to get the right values,
buddhagui
Return all values from Combo box form,
jake . friedman
Re: Please Help,
Marshall Barton
query with multiple primary keys,
Harlan
Calculate month ending date,
CAM
Re: Oracle criteria problem,
Douglas J. Steele
Re: Decimal part of a real number,
Rick Brandt
Re: Filtering table depending on criteria,
Jeff Boyce
dated range in Query,
organicpatti
Sort order?,
organicpatti
Re: Need help with Date range query,
Douglas J. Steele
Re: ALTER TABLE problems,
Granny Spitz via AccessMonster.com
Re: Calendar Drop down box,
Allen Browne
Query SQL assistance,
vbnetman via AccessMonster.com
Re: Ranking within Query,
Neil Sunderland
help with automatically updating a parameter query,
FrankieNap
Re: query not showing new records,
David F Cox
- Message not available
- Message not available
combine two fields problem with lookup field,
Faio Eric
Re: Parsing (Mid, InStr) Question,
pietlinden
Re: Using IIF in UPDATE,
John Vinson
Create Temporary Tables in a SQL Statement?,
WAstarita
Criteria,
lewy the fly via AccessMonster.com
Re: QUERY,
Phil Smith
Re: unblocking attachments,
John Vinson
RE: Union sort,
rachael
RE: Edit ODBC settings,
Bruce Meneghin
Re: How do I delete one entire table from another table in access?,
John Vinson
Re: Parenthesis as a criteria in a query.,
John Vinson
What's where,
garysibio
Re: permanently store a Criteria in query using a combo box,
kingston via AccessMonster.com
<Possible follow-ups>
RE: permanently store a Criteria in query using a combo box,
Hamid
Re: Change Table Format via Query,
S.Clark
Re: clearing a query,
Duane Hookom
RE: Value in Cross tab query,
KARL DEWEY
Re: Showing Data thats not there!?!,
kingston via AccessMonster.com
Re: Union Queries,
kingston via AccessMonster.com
DVD/CD Drives,
Harry Taylor
RE: Merge multiple records into one,
MISOfficer
Shared access errors with mdb's,
Johan Barkhuizen
Re: How to create an Running Sum Query?,
need help
Re: How to use query with aliases as source in a crosstab,
Duane Hookom
Report Error - when not all data fields of Cross-tab Query included.,
dmgoetz via AccessMonster.com
change name from "aliminium_X" to "Aluminium",
anil
Re: Query Criteria,
John Vinson
Optional record selection based on form's checkbox,
Kathy Webster
Query with a calculated field that uses multiple records,
dfeim
Re: Update table records,
Smartin
Re: How do I remove hyphens or periods in name using access 2000?,
kingston via AccessMonster.com
Re: Can you read a make table in a pass through query?,
Jeff L
Re: how do i or can i get either this colum or that colum...,
John Vinson
Re: How can I randomly select 20 records from my database?,
John Vinson
RE: Help with Crosstab query and report,
elena
RE: Query via LIst box choices,
Klatuu
Delete Query with Joins problem,
sweetlisa1217 via AccessMonster.com
transpose multiple record values into a single record,
Basil via AccessMonster.com
Re: Range Between A* and M*,
John Spencer
Including the Current Date in the File Import / Export Title,
dbain30
Re: help creating a querry,
Chris2
DateSerial Problem,
Juan Schwartz
Re: Trim Email Address,
Allen Browne
Re: Update,
Allen Browne
pulling data from different tables depending on criteria,
Basil via AccessMonster.com
Re: IF statement in a Query,
Jeff L
Re: filter data in Access,
Allen Browne
Re: how do I add an addition expression in query?,
Jeff L
Update query erroe 3144,
Jeffiec via AccessMonster.com
Statement too Complex,
HearSay
Re: Invalid Bracketing error,
Nikos Yannacopoulos
Crosstab Query/Report,
greatsky
Re: Query to return record at Nth physical location in table,
David F Cox
Re: Query to return record at Nth physical location in table,
Chris2
Re: Pull a value from previous record for query,
Douglas J. Steele
Re: Value will NOT calculate,
S.Clark
Sums in a Query,
Kathy Webster
Re: DateDiff with different formats,
Duane Hookom
Re: Query Expression that would find the Earliest Date in a Row of Dat,
John Spencer
Selecting desired value in totals query,
LGC
Re: decimals,
John Spencer
Re: Transpose with repeated data,
Duane Hookom
Reprise: Celko Nested BOMS,
kinsham@xxxxxxxxxxx
Re: Find a string,
kingston via AccessMonster.com
change table name in query,
guy
RE: Syntax error in FROM clause,
Pumpmerchant
RE: Combining Rows,
GMD
RE: Averages of data in a record source,
geebee
Re: If expression in Query -- is this possible?,
John Spencer
Re: Append query dropping a field,
Allen Browne
Re: How to specify the data type of a field in a make-table query?,
Allen Browne
Exit query without a question,
azekry via AccessMonster.com
Rename query results before emailing to helpdesk,
Rhaps
Re: Accessing form data from a query in 2003,
Marshall Barton
Query - counts per week?,
G Lykos
Re: how do I create a footbool league table in Access 2003,
John Vinson
Illustrations,
Joan 2
Re: Access should provide better query error feedback,
David F Cox
Query with multiple common points,
Jon
ASCII Help,
mattc66 via AccessMonster.com
Re: Supress Record in QUERY,
kingston via AccessMonster.com
Re: Crosstab By Month with only last 6 months data,
Duane Hookom
add/ subtraxct time with milleseconds,
Nena
25th of month to 25th of month,
Kathy Webster
Re: Action List,
Duane Hookom
Org Chart,
Brian
RE: Problem - can create an updatable query,
Jerry Whittle
Re: how can you find people who have an AA degree in a query?,
Rick B
Re: On my file button, there is no "send email"??????,
Rick B
Router Log file problem,
fred099 via AccessMonster.com
Re: Validation Rules Error,
Allen Browne
Re: field lengths ?,
Brendan Reynolds
Re: Passing Parameters betwen queries,
Allen Browne
Re: Need LOTS of help on a Query!!!,
John Spencer
Re: How do I output part of a string that has a non fixed length?,
Nikos Yannacopoulos
Re: delete duplicates,
Brendan Reynolds
Lookup question,
alecgreen
Query or SQL code needed?,
Mark
Help with Search Query,
lushh
Re: Microsoft Access date formulas,
John Vinson
Re: Cross Tab Queries,
John Vinson
Re: Trouble with "BETWEEN #time# AND #time#",
John Vinson
Re: Access Query Grid Column Width should save,
Smartin
Re: Group by and Sum in same query,
Chris2
Challenging Update Query needed,
Bikini Browser
Re: apply calculation to group of records and append into the same tab,
bmarland
Re: Distribution List: Names covert to email addresses,
bmarland
Re: union query,
bmarland
Update Query needed....,
Bikini Browser
- Re: Update Query needed....,
John Vinson
- Re: Update Query needed....,
Bikini Browser
- Re: Update Query needed....,
John Vinson
- Re: Update Query needed....,
Bikini Browser
- Re: Update Query needed....,
John Vinson
- Re: Update Query needed....,
Bikini Browser
- Re: Update Query needed....,
John Vinson
- Re: Update Query needed....,
Bikini Browser
- Re: Update Query needed....,
John Vinson
- Re: Update Query needed....,
Bikini Browser
- Re: Update Query needed....,
John Vinson
- Re: Update Query needed....,
Bikini Browser
- Re: Update Query needed....,
Chris2
- Re: Update Query needed....,
Bikini Browser
- Re: Update Query needed....,
Chris2
Re: too many merged records,
John Vinson
Re: Quick grouping question,
bmarland
Re: Too many records,
David F Cox
Uppercase to ProperCase Update Query needed,
Bikini Browser
Re: Count Students Who Attended Class?,
Gary Walter
update Query written,
Bikini Browser
CPU-friendly way to insert wildcards?,
Jaaz81
Cancel the 2nd input if the 1st input is empty,
Scott
Problems with (If no data then) with user input,
dennis . driscoll
Re: Help with Function,
John Spencer
Re: Function help please,
Rick Brandt
Splitting single field into 3 fields,
Pete Provencher
Re: Adding A Value To A Field Using Checkboxes,
John Spencer
Duplicate records in Query Result,
david . moore
Re: Calculating time over midnight,
Van T. Dinh
Re: Counting in queries,
Gary Walter
Slow Pivot Chart,
azekry
Re: How can I use DISTINCT with Case Sensitivity?,
Gary Walter
Re: Removing the blanks,
Neil Sunderland
Fixed Address Function,
sike11 via AccessMonster.com
Re: Update Statement,
Duane Hookom
Re: SQL Code to append multiple queries in an update query,
John Spencer
Re: Pass-Through Question,
Rick Brandt
Count IF,
Emlou85 via AccessMonster.com
Re: Multiply field value of one table with cell value of another table,
Rick Brandt