Microsoft Access Queries

Filters

J

Counting records

Jacques Latoison
Dec 17, 2003

Replies: 2

Views: 39K

Dec 23, 2003

John Spencer (MVP)

J

J

criteria/expression wording

Jessica E
Dec 22, 2003

Replies: 6

Views: 88K

Dec 23, 2003

Jessica

J

G

Old queries / views

Gary Nelson
Dec 22, 2003

Replies: 1

Views: 33K

Dec 23, 2003

[MVP] S.Clark

M

M

Ceating reports from query from a table with multiple choices

Max
Dec 23, 2003

Replies: 1

Views: 182K

Dec 23, 2003

Michel Walsh

M

B

Removing rows with duplicate values in a field (distinct?)

Brandon
Dec 15, 2003

Replies: 3

Views: 142K

Dec 23, 2003

John Spencer (MVP)

J

S

converting strings to ASCII

shank
Dec 23, 2003

Replies: 2

Views: 105K

Dec 23, 2003

Gary Walter

G

I

Too many results

I Am
Dec 23, 2003

Replies: 1

Views: 71K

Dec 23, 2003

ds

D

H

Data of Birth to Birthday

Harmannus
Dec 22, 2003

Replies: 1

Views: 62K

Dec 23, 2003

Allen Browne

A

M

Creating a field that is one of four answers depending on other values in each query

Mike H
Dec 22, 2003

Replies: 2

Views: 31K

Dec 23, 2003

Peter Kaufman

P

S

finding ASCII characters

shank
Dec 23, 2003

Replies: 1

Views: 44K

Dec 23, 2003

RobFMS

R

G

query to check if a certain field contains certain value, and return "yes" or "no"

Guest
Dec 21, 2003

Replies: 3

Views: 188K

Dec 23, 2003

Rick Brandt

R

C

Using a function to get a value from the database

Craig
Dec 22, 2003

Replies: 4

Views: 66K

Dec 23, 2003

John Vinson

J

M

counting -.number of records.

Mickey
Dec 23, 2003

Replies: 3

Views: 113K

Dec 23, 2003

Duane Hookom

D

S

Updating split tables

Scruff57
Dec 22, 2003

Replies: 1

Views: 58K

Dec 23, 2003

Duane Hookom

D

S

Make Table with SQL Pass Through

SumApr
Dec 22, 2003

Replies: 1

Views: 152K

Dec 23, 2003

Duane Hookom

D

N

concatenate field in all records

Nicholas R. Markham
Dec 22, 2003

Replies: 2

Views: 96K

Dec 23, 2003

Duane Hookom

D

R

Select most recent date

Rick Dunmire
Dec 22, 2003

Replies: 2

Views: 351K

Dec 23, 2003

Rick Dunmire

R

L

Append Query in Access

Lakshmana
Dec 22, 2003

Replies: 1

Views: 66K

Dec 22, 2003

Cheryl Fischer

C

M

Cumulative sum of large table - DSum is unusable

Milan
Dec 22, 2003

Replies: 2

Views: 53K

Dec 22, 2003

Otis B. Driftwood

O

A

fast queries became very slow

annie
Dec 13, 2003

Replies: 7

Views: 45K

Dec 22, 2003

Van T. Dinh

V

G

Memo cut to 255 char in Grouped Query

Guest
Dec 22, 2003

Replies: 3

Views: 69K

Dec 22, 2003

Van T. Dinh

V

H

Access 2000 Prompt to save?

Heather
Dec 22, 2003

Replies: 1

Views: 12K

Dec 22, 2003

Kelvin

K

M

Query that asks for dates x number of days away from today's date / comparing two fields in a query

Mike H
Dec 22, 2003

Replies: 2

Views: 139K

Dec 22, 2003

Mike H

M

S

Pulling together data

Scruff57
Dec 22, 2003

Replies: 1

Views: 62K

Dec 22, 2003

John Vinson

J

B

Easier way to select most recent value...

Ben Moore
Dec 22, 2003

Replies: 5

Views: 49K

Dec 22, 2003

John Vinson

J

A

cannot join on Memo, OLE or hyperlink

Andy Levy
Dec 22, 2003

Replies: 7

Views: 576K

Dec 22, 2003

Andy Levy

A

C

Query result to textbox

Carel Stoop
Dec 22, 2003

Replies: 1

Views: 49K

Dec 22, 2003

Steve Schapel

S

J

Query records where artist name begins with a number

Jeremy
Dec 22, 2003

Replies: 2

Views: 177K

Dec 22, 2003

Danny J. Lesandrini

D

K

field contains " "

Katia
Dec 22, 2003

Replies: 1

Views: 49K

Dec 22, 2003

Tom Ellison

T

M

Need help defining parameters for an access query

Mike H
Dec 21, 2003

Replies: 4

Views: 84K

Dec 22, 2003

Danny J. Lesandrini

D

G

Guest
Dec 21, 2003

Replies: 4

Views: 12K

Dec 22, 2003

Guest

G

G

web-enabled database

Guest
Dec 21, 2003

Replies: 1

Views: 30K

Dec 22, 2003

[MVP] S.Clark

M

B

Multiple Date Records

Bryan Hughes
Dec 17, 2003

Replies: 6

Views: 142K

Dec 22, 2003

[MVP] S.Clark

M

P

"Make table" query missing records returned by simple query - why?

Paul Danaher
Dec 22, 2003

Replies: 1

Views: 139K

Dec 22, 2003

Allen Browne

A

F

Firman
Dec 22, 2003

Replies: 1

Views: 30K

Dec 22, 2003

Danny J. Lesandrini

D

J

Looking Up a Field Value Based on Variable

John C.
Dec 22, 2003

Replies: 3

Views: 73K

Dec 22, 2003

John C.

J

S

sharon
Dec 22, 2003

Replies: 1

Views: 127K

Dec 22, 2003

Jeff Boyce

J

3

Return null / zero length / nothing

317342
Dec 21, 2003

Replies: 5

Views: 313K

Dec 22, 2003

317342

3

G

uploading a query

Guest
Dec 21, 2003

Replies: 3

Views: 32K

Dec 22, 2003

Guest

G

D

Replace data in memo field

Diederik Nieuwenhuis
Dec 22, 2003

Replies: 1

Views: 32K

Dec 22, 2003

Allen Browne

A

A

Create Calendar in Query

Arvin Villodres
Dec 22, 2003

Replies: 2

Views: 66K

Dec 22, 2003

Arvin

A

M

How to filter against records...

Mike Whalen
Dec 15, 2003

Replies: 8

Views: 35K

Dec 22, 2003

Ken Snell

K

L

Sort By ID and then Year

Ling
Dec 22, 2003

Replies: 2

Views: 30K

Dec 22, 2003

Wayne Morgan

W

Z

Help with error message

ZBC
Dec 22, 2003

Replies: 1

Views: 110K

Dec 22, 2003

Steve Schapel

S

T

INSERT results of a SELECT statement and constants

Tim Zych
Dec 21, 2003

Replies: 3

Views: 144K

Dec 22, 2003

Tim Zych

T

C

Error message in query for quotient calculation

chase
Dec 21, 2003

Replies: 3

Views: 12K

Dec 22, 2003

Duane Hookom

D

S

Hours between dates

Steve
Dec 21, 2003

Replies: 2

Views: 53K

Dec 21, 2003

Wayne Morgan

W

G

Update Query to add an value from an expression to an existing field

Guest
Dec 19, 2003

Replies: 1

Views: 135K

Dec 21, 2003

Gary Walter

G

F

Math functions in a Query

Frank
Nov 25, 2003

Replies: 3

Views: 31K

Dec 21, 2003

Douglas J. Steele

D

S

Where to put Update Query....

Sandra Grawunder
Dec 20, 2003

Replies: 6

Views: 204K

Dec 21, 2003

John Vinson

J

You must log in or register to post here.

Top