microsoft.public.access.queries
- Re: Need help with query results,
John Spencer
- Re: Count Records By Emp,
John W . Vinson
- Re: View raw data behind crosstab query,
John W . Vinson
- Re: Update any Mcsmith to McSmith, etc . . .,
Jason Lepack
- Re: Current datab only query,
Jeff Boyce
- Retrieve The ID of the newly inserted Record,
Samuel
- Re: Conditional Count,
Jason Lepack
- query issues - need to change database structure,
MES via AccessMonster.com
- Re: Counting Objects not summing numbers,
Michel Walsh
- Re: Wild Card Doesn't Work ANymore,
Jeff Boyce
- Re: invalid operation,
Marshall Barton
- ListBox - MultiSelect VBA issue,
Trepalium
- Re: Trim after the first space,
John Spencer
- Re: Zip Code Query,
Marshall Barton
- Re: Rounding numbers,
Marshall Barton
- SQL Learning for novice,
Jay
- Re: query to return only unique records from 2 tables?,
Jason Lepack
- Re: Query from two tables duplicating data,
John W . Vinson
- Re: data,
John W . Vinson
- RE: top N values per group using VBA,
Kat
- Update query with greek characters,
greeknl via AccessMonster.com
- Search Text String For Exact Text,
Chuck
- NOW what! Need help with ANOTHER expression.,
Sue
- Create Multiple Tables based on Field Value,
dancnbr
- Grouping in a comparative query,
bg17067
- Re: Creating a Search Engine with Access 2007,
Allen Browne
- Re: Need Help Counting,
Jason Lepack
- Re: Problem with SQL statement,
Jason Lepack
- Re: Problem with SQL statement,
CP
- Re: Problem with SQL statement,
Jason Lepack
- Re: Problem with SQL statement,
CP
- Re: Problem with SQL statement,
Jason Lepack
- Re: Problem with SQL statement,
CP
- Re: Problem with SQL statement,
Jason Lepack
- Re: Problem with SQL statement,
CP
- Re: Problem with SQL statement,
Jason Lepack
- Re: Problem with SQL statement,
CP
- Re: Problem with SQL statement,
Jason Lepack
- Re: Problem with SQL statement,
CP
- Re: Problem with SQL statement,
Jason Lepack
- Re: Open form from an empty query,
Allen Browne
- Finding records with no entry within past year,
bg17067 via AccessMonster.com
- Help! I can't understand why this won't work!,
Sue
- Re: Queries Links Change,
Aaron Kempf
- Re: Microsoft Access - Accounts Receivable Solution,
Aaron Kempf
- remove space and chars. replace() does not work,
removeChars
- Re: How to Enter Same Text in 1000s of Fields,
MH
- Re: How to get Total form lookup fields,
Michel Walsh
- Re: Help Query.,
Michel Walsh
- RE: Query Help,
Dale Fye
- Re: excel functions in access queries,
Ed Metcalfe
- Re: Create a name from a table,
Carl Rapson
- Re: NEED A SINGLE RECORD RETURNED FROM ONE TO MANY QUERY,
Allen Browne
- Re: Counting in three dimentions,
Gary Walter
- Help with an expression, please.,
Sue
- Select Distinct II,
JensB
- Re: Pull year and month from date field using parameter query,
Allen Browne
- Message not available
- Message not available
- how to replace fields,
Mary
- Query doesn't always sort,
sam . alame
- Re: Parent Coming Up a Few Times,
Keith Wilby
- Please Help: Querying same field several times for a count in QBE,
pilch74@xxxxxxxxx
- Re: Query in preparation for tabbed form,
John W . Vinson
- Re: Help with query,
Allen Browne
- GURU NEEDED!!! Query memo field for user selection in report,
ausced
- Re: unable to delete record in corrupt 2003 database table,
John W . Vinson
- Re: How do I refer to existing field name that has an illegal characte,
John W . Vinson
- RE: "Enter Paramter Value" Prompt - how do I stop it?,
JohnG
- Re: Append or Update Query????,
John Spencer
- Join to get "exception" records,
john@xxxxxxxx
- Re: Strange error.,
Michel Walsh
- Re: count of records that meet criteria from two fields,
Michel Walsh
- Re: Between Dates,
Michel Walsh
- Query latest date,
Mack Neff
- criteria issue,
will via AccessMonster.com
Re: Is ther a like function RAT() in VBA for Access 2003 as in .net?,
Jason Lepack
Date Range Query Not Returning Correct Results,
sallen
Counting,
andy_42 via AccessMonster.com
Recursive Query or Iteration - Whats it to be ?,
Harry
Using subquery returns fewer records,
Pat
Re: Missing Index,
newsgroups
Re: Calculating two fields on based of the value of one field,
Carl Rapson
Personalize msgbox if criteria not found,
klumzyab
weekends and holidays!,
scubadiver
Re: Trim Data,
Allen Browne
Removing characters,
Alex
Passing a variable to a select query.,
Leo Hamal
Re: Filtering using form field value,
Allen Browne
RE: How to link tables via the field names themselves, not their conte,
Dale Fye
Re: how do i calculate values between two dates in access,
Stefan Hoffmann
Re: Null value in multi-parameter queries,
Will_Harris_ZA
Re: Calculate Null Date,
John W . Vinson
- Message not available
- Message not available
Parameter queries with multiple parameters and null values,
Amy Blankenship
Re: Adding up numbers in coloums,
Jeff Boyce
Re: Passing Variables to a query,
John Spencer
Re: TRIM function isn't working in my query,
John Spencer
Very slow query,
Bill Murphy
Searching Text String,
Chuck
Re: Comparing Tables to Find new items added ( is it possible?),
Jeff Boyce
Re: Replace a value with the one above it in a field,
Jeff Boyce
Re: Combining Fields that are Alike to get a Total Result,
Carl Rapson
Re: How do I sum 2 or 3 fields from a lookup fields in table?,
Michel Walsh
SQL Express query in MDB,
Tom Ellison
convert columns to rows,
lschultz
select specific historical records,
bukky_bu
another question on queries,
Doris
Strange Access SQL problem,
jliebman
Re: Limit to Max Number,
Marshall Barton
another query question,
Doris
Re: Simple Update Query returns Error Message,
Marshall Barton
Message not available
remove spaces between words. replace() not working,
mapsNoob
Re: Add / to data,
John Spencer
Unicode criteria not working,
Charax
Multiple Combo Boxes Limiting a Query,
Coral G via AccessMonster.com
Email DLookup to show all records,
Nick W
Simple DateDiff query,
Homer
roundup up in a query,
Anton
RE: Help Needed With Append Query?,
Holts Shoes
Re: Change number format in linked table,
John W . Vinson
Re: reserved error -1524 access 2007,
Allen Browne
Multi Selection List Box,
Tony
Message not available
Message not available
Re: Multi Selection List Box,
Tony
Re: query w/ sql View and access table,
Allen Browne
Re: Inserting query results into MESSAGE body of email,
Smartin
Re: Update Query won't accept "Update To" data,
John Spencer
Re: Update a field in a table based on two other fields,
John W . Vinson
RE: Expression Builder help.,
KARL DEWEY
Re: Slow make table query with multiple joins,
John W . Vinson
RE: Eliminating Duplicates from query,
Klatuu
RE: Criteria on a field, but also pull other data,
Klatuu
Re: Not prompting to save changes,
John Spencer
Make-table querie to a protected database,
Paulo Ferreira
Re: Expression not Sorting,
Marshall Barton
<Possible follow-ups>
Re: Expression not Sorting,
Marshall Barton
over my head with programming,
tmcavilee
DoCmd.OpenReport Error,
alvarjo9 via AccessMonster.com
Re: ceiling/floor worksheet function,
Allen Browne
Re: Number format in queries,
Allen Browne
RE: make age as a fraction,
Duane Hookom
find a duplicated name and sum de result,
pedro . j . manuel
Calculations involve different table,
EMILYTAN via AccessMonster.com
RE: Extracting Month and Year For a Given Date,
Charles Wang[MSFT]
Modify logical field,
Alan T
Need help with an Update query statement ...,
aellis2007
Re: If field is null....???,
fredg
Re: Parenthesis and comma status,
Jeff Boyce
Re: Transferring contents of 1 cell to another,
John Spencer
Re: change text field to a check box,
Marshall Barton
Re: Date Specific calculation,
Jeff Boyce
return number,
Jeff Klein
Re: How do I write a query for all those that have an odd value?,
Jason Lepack
Re: Message undesired @ query run,
John W . Vinson
- Message not available
- Message not available
Re: Querying memo fields.,
John W . Vinson
Re: find entry where id doesn't have a certain entry in another field,
Jason Lepack
Another simple query,
Homer
Re: Rounding Down of Age,
Allen Browne
Re: Count and sort queries - please help!,
John Spencer
Selecting distinct values,
JensB
Re: percentage once again,
Allen Browne
Frustrating Data Type Mismatch error,
Ivyleaf
query syntax,
Sandra Evans
Re: Select just one record,
Allen Browne
Re order level,
stevoo
Re: Tme Sensitive Date Calculation,
Marshall Barton
Re: help with number calculation,
John Spencer
Find record in a table using combo box.,
alvarjo9 via AccessMonster.com
help on running balance,
ai_enjoi via AccessMonster.com
This code is too slow. Can you come with faster one?,
Song Su
Return Top 10 Record,
rahmad
SELECT INTO Password protected db,
Amy Blankenship
Multiple ADD COLUMN in one shot?,
JR
Re: querying from 2 dynasets,
Jeff Boyce
Re: Simple query query,
Marshall Barton
Re: subtracting dates,
Allen Browne
<Possible follow-ups>
Re: subtracting dates,
raskew via AccessMonster.com
Use Aggregate functions in a update query,
Jose.M.Huerta@xxxxxxxxx
Re: Random Selection of Records for mailing,
John W . Vinson
Re: Find the top two children,
Allen Browne
Update data to match based on like datasets,
JR
Help with a query,
scottpconnors@xxxxxxxxx
Re: One more condition is needed,
Smartin
Help with query using multiple variables,
sallen
how do i? puzzled......!,
terryljsmith
Re: Query saves wrong,
John Spencer
Calculate MTD and YTD in a query,
equalizer
Re: Is there a replacement of Excell Vlookup function in Access?,
John W . Vinson
Re: Prevent Appending Certain Records,
John W . Vinson
Re: Year-To-Date Query with a lime Twist,
Jeff Boyce
Frustrating ORDER BY Problem,
OppThumb
Start & End of Year,
psowerby
FollowHyperLink and continue code,
Song Su
Re: **Please Help** Select Details.,
John Spencer
converting switch to lookup tbl?,
xz
Can Pivot Table views of a query be saved as a favorite?,
soarathorn
Re: wrong number of arguments,
Tom Ellison
Limit number of rows on query,
Ed Faulk
getting the latest 6 record information,
alvarjo9
Re: Crosstab Date Format,
John Spencer
Re: Ageing by Date to 30, 60,90 etc,
Stefan Hoffmann
Simple query,
Homer
help in Query F1...,
krisworld
format minutes to Hour:Min in crosstab,
Song Su
Re: Updating Blank Fields,
John W . Vinson
Re: find duplicates query,
Allen Browne
send query result to Excel and open it,
Song Su
Is an Instructor eligible for a salary increment?,
mauricioze via AccessMonster.com
Between . . .And problem,
Simon Jester
Date/Time Query,
Joe
Re: Deleting Digits from numbers,
John Spencer
Re: Trying to converting text field into numeric in a query,
John W . Vinson
<Possible follow-ups>
RE: Trying to converting text field into numeric in a query,
Jayneedshelp
create chart of subscribers per month?,
Geoff Cox
Re: Left Join Not working,
John W . Vinson
Re: Can dlookup (or anything else) do this?,
Michel Walsh
Re: Query to find potential duplicates within one table?,
John Spencer
Re: Separating Text In An Email Address,
Allen Browne
Globally rename a query?,
Jon
Union Query Problem,
DS
Re: Change one letter in line of text,
Stefan Hoffmann
Re: autonumber to number fields in a query,
Allen Browne
Help with query please!,
info
Re: creating an exe file,
John W . Vinson
Add sequential row numbers based on sorted field,
daffy333
Re: query not updatable,
Allen Browne
Re: # character as text,
fredg
Re: Query only runs in Design Mode,
John W . Vinson
Re: How to sum colums with access,
Marshall Barton
Union Crosstab Queries,
Claudette Hennessy
Re: combine a new primary key value as the fullname initial,
John W . Vinson
Re: access queries,
PatdeLux
Re: How do I Convert Columns empty cells to 0 in Update Table Query,
John Spencer
Re: How do I Convert Columns empty cells to 0 in Update Table Query,
PatdeLux
Re: conver text to number,
John Spencer
Re: How to Open linked form and close existing form?,
John Spencer
Re: Update query question,
Michel Walsh
query data,
jefferysf via AccessMonster.com
Re: count on days with open and closed status,
John Spencer
Re: How to prompt for duplicate on a form?,
John Spencer
Re: Compare fields to find missing records?,
mikesjLFG
Re: Displaying two unrealead query results under one query?Possible?,
mikesjLFG
Re: Find non-matching data,
mikesjLFG
Refer to a control in a subform,
Ivor Williams
Re: Time Calculations,
Allen Browne
Re: Find latest record,
Michel Walsh
Re: HELP! AND / OR criteria,
Michel Walsh
Access subquery using Like IN,
mikesjLFG
Re: Print Out Problems from query,
Rick B
A Simple Query problem?,
Ian Chappel
Re: Count from tables,
Stefan Hoffmann
RE: Queries?,
Melinda
Re: Weekly Rolling Total Query,
Allen Browne
No records with date criteria,
Linda \(RQ\)
Nested SQL,
Greg
Re: Trailing 3 month values,
John W . Vinson
Re: Parameters in queries,
Jeff Boyce
Re: Random nthing in access,
Michel Walsh
RE: Query,
KARL DEWEY
Re: Selecting Random Rows,
John W . Vinson
RE: Expression contains invalid syntax,
Jerry Whittle
Criteria prevents Query from running.,
Mike
data results error with union query?,
terryljsmith
Re: Round Up In Queries,
Allen Browne
Re: Step through each field in query,
John W . Vinson
Re: Query for random values multiple records,
John W . Vinson
Re: Query based on budget year.,
Jeff Boyce
- Message not available
- Message not available
Re: iif statement for calculations...,
Jeff Boyce
Re: Query to delete characters to the right of a decimal point,
Jeff Boyce
Reference multiple tables for a value,
dp724 via AccessMonster.com
Re: DefaultValue,
Michel Walsh
Re: MONTH HELP,
Stefan Hoffmann
Re: Union Query,
Douglas J. Steele
how to built calendar,
EMILYTAN via AccessMonster.com
Sum sum sum,
EMILYTAN via AccessMonster.com
Top 3 dates in calculation Function / Query?,
c8tz
Sales Summary Date Range Filter Question?,
niuginikiwi
Re: Delete Query Error,
John Spencer
Re: Using a Query to give me the 160th and 320th etc.,
Jeff Boyce
Re: Concatenation Limit in Calculated Query Field,
Marshall Barton
mktbl query question,
Joe Blow
Sum,
John
Best way to add a chart?,
Rick
Using a OR() like function in an IIF statement,
kkulakow via AccessMonster.com
need query to filter combobox row source list by table records,
Max Moor
Re: Distinct Count,
John Spencer
Re: Including all records from employees in a date range,
John W . Vinson
Output to macro to sharepoint,
Nick Monsour
Re: Enter Start Date and Auto Fill the End Date,
fredg
replacing quote marks,
Rcarman11 via AccessMonster.com
- Message not available
- Message not available
- Message not available
- Message not available
- Message not available
- Re: replacing quote marks,
Rcarman11 via AccessMonster.com
- Re: replacing quote marks,
John Spencer
- Re: replacing quote marks,
Rcarman11 via AccessMonster.com
- Re: replacing quote marks,
John Spencer
- Re: replacing quote marks,
John W . Vinson
- Re: replacing quote marks,
John Spencer
- Re: replacing quote marks,
Rcarman11 via AccessMonster.com
- Re: replacing quote marks,
John W . Vinson
- Re: replacing quote marks,
John W . Vinson
- Re: replacing quote marks,
Rcarman11 via AccessMonster.com
leave out certain data in a query..,
stephendeloach via AccessMonster.com
Re: PRO Needed for urgent help,
John W . Vinson
HOW TO CONVERT DD-MM-YY to YYYYMMDD IN ACCESS DATABASE?,
Potchtalon
Select dates in range,
Francisco
use current record to filter subquery,
Ghena
Re: Update query - sequence problem,
Allen Browne
Re: query error,
John W . Vinson
- Message not available
- Message not available
why my BeforeUpdate does not work?,
Song Su
Access97 on XP - Error 2287,
alainden@xxxxxxxxx
RE: Return records in one table, not in another,
Ofer Cohen
Re: Lookup a "Closest Match" value in a table,
Ed Metcalfe
RE: Column headings in Union Query,
Ofer Cohen
Re: Crosstab Query - Column Heading Dates,
Ed Metcalfe
Access 2007 capacity,
Richard H
Calculating Time Difference,
drmrinalini
Re: Making field a certain length,
Ofer Cohen
Re: Show all rows...Please help...,
Allen Browne
How to query with both JOIN and aliases in Access?,
Oscar
How do I select records were a field contains a key word??,
OldManEd
How to proceed using Allen Browne search interface,
Rick
Re: Time calculation,
John Spencer
Accounting Database Structure,
Gary B
Re: MIN and MAX for unique fields,
Jeff Boyce
Frond Production Count,
c8tz
Re: How to query one column in a multi column list box,
Carl Rapson
RE: Calculations based on counts in a crosstab,
Dale Fye
Help updating a table,
erick-flores
Re: Multiple copies of table in one query design view?,
Michel Walsh
Re: Creating a Global Connection Object to SQL,
Michel Walsh
Re: Help with the SQL,
Michel Walsh
Re: List all records but ...,
Rick Brandt
SAGE line 50 v 11 and VB.NET,
gurdeeptoor via AccessMonster.com
Design View Criteria question,
archico01
Re: Using like in an iif statement,
John W . Vinson
Pass 2 Values to Another Form - Including Combo Box Contents,
Maurita
Re: Delete query unable to delete records from table. Fix how?,
Allen Browne
Re: How do I create a calculated field in a query,
John W . Vinson
Re: date format - datediff - Not working,
fredg
help doing subtraction in a query,
Anja
Make table query where INTO {tablename} is actually a parameter; doesn't work,
dgmueller
Query expression using multiple records in same table,
Rick
Re: Criteria entered at run time,
Marshall Barton
Re: Find date closest to today,
Allen Browne
Re: Batch Query - 42 tables to one Master Table,
John W . Vinson
Re: Trimming a telephone number....Or replacing,
Bikini Browser
Linking ACT! 2007 database,
Bikini Browser
RE: How to Create a Query Using Multiple Groupings and Criteria,
jgraves
New Tables & Queries Force me to Save As,
wrldruler
URGENT !!!! PLZ HELP,
hafsa_aziz
Re: Monthly year to date average,
Michel Walsh
put query result to cbo control on the form,
Song Su
Re: Query takes 35 minutes to run with linked table.,
david
Re: Access 2003 modifies (corrupts) query when saved...,
david
Re: Wildcard search,
Allen Browne
Re: Append query hangs with multiple users,
John W . Vinson
query criteria between dates,
daniel
collected related records to populate table,
MM
query probelms,
Pkobo58 via AccessMonster.com
aggregate functions,
Sirocco
Re: Enhancement Request,
Sirocco
Re: group on year,
John W . Vinson
Crosstab query,
Sirocco
Insert dataset to another database,
JPM
Re: Make table truncates text concatenated using fnConcatenate,
John W . Vinson
Query Criteria question,