Microsoft Access Queries

Filters

J

Counting records

Jacques Latoison
Dec 17, 2003

Replies: 2

Views: 354

Dec 23, 2003

John Spencer (MVP)

J

J

criteria/expression wording

Jessica E
Dec 22, 2003

Replies: 6

Views: 365

Dec 23, 2003

Jessica

J

G

Old queries / views

Gary Nelson
Dec 22, 2003

Replies: 1

Views: 359

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: 368

Dec 23, 2003

Michel Walsh

M

B

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

Brandon
Dec 15, 2003

Replies: 3

Views: 476

Dec 23, 2003

John Spencer (MVP)

J

S

converting strings to ASCII

shank
Dec 23, 2003

Replies: 2

Views: 475

Dec 23, 2003

Gary Walter

G

I

Too many results

I Am
Dec 23, 2003

Replies: 1

Views: 447

Dec 23, 2003

ds

D

H

Data of Birth to Birthday

Harmannus
Dec 22, 2003

Replies: 1

Views: 358

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: 516

Dec 23, 2003

Peter Kaufman

P

S

finding ASCII characters

shank
Dec 23, 2003

Replies: 1

Views: 410

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: 3K

Dec 23, 2003

Rick Brandt

R

C

Using a function to get a value from the database

Craig
Dec 22, 2003

Replies: 4

Views: 285

Dec 23, 2003

John Vinson

J

M

counting -.number of records.

Mickey
Dec 23, 2003

Replies: 3

Views: 296

Dec 23, 2003

Duane Hookom

D

S

Updating split tables

Scruff57
Dec 22, 2003

Replies: 1

Views: 401

Dec 23, 2003

Duane Hookom

D

S

Make Table with SQL Pass Through

SumApr
Dec 22, 2003

Replies: 1

Views: 1K

Dec 23, 2003

Duane Hookom

D

N

concatenate field in all records

Nicholas R. Markham
Dec 22, 2003

Replies: 2

Views: 432

Dec 23, 2003

Duane Hookom

D

R

Select most recent date

Rick Dunmire
Dec 22, 2003

Replies: 2

Views: 419

Dec 23, 2003

Rick Dunmire

R

L

Append Query in Access

Lakshmana
Dec 22, 2003

Replies: 1

Views: 299

Dec 22, 2003

Cheryl Fischer

C

M

Cumulative sum of large table - DSum is unusable

Milan
Dec 22, 2003

Replies: 2

Views: 891

Dec 22, 2003

Otis B. Driftwood

O

A

fast queries became very slow

annie
Dec 13, 2003

Replies: 7

Views: 438

Dec 22, 2003

Van T. Dinh

V

G

Memo cut to 255 char in Grouped Query

Guest
Dec 22, 2003

Replies: 3

Views: 524

Dec 22, 2003

Van T. Dinh

V

H

Access 2000 Prompt to save?

Heather
Dec 22, 2003

Replies: 1

Views: 385

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: 1K

Dec 22, 2003

Mike H

M

S

Pulling together data

Scruff57
Dec 22, 2003

Replies: 1

Views: 404

Dec 22, 2003

John Vinson

J

B

Easier way to select most recent value...

Ben Moore
Dec 22, 2003

Replies: 5

Views: 402

Dec 22, 2003

John Vinson

J

A

cannot join on Memo, OLE or hyperlink

Andy Levy
Dec 22, 2003

Replies: 7

Views: 2K

Dec 22, 2003

Andy Levy

A

C

Query result to textbox

Carel Stoop
Dec 22, 2003

Replies: 1

Views: 501

Dec 22, 2003

Steve Schapel

S

J

Query records where artist name begins with a number

Jeremy
Dec 22, 2003

Replies: 2

Views: 1K

Dec 22, 2003

Danny J. Lesandrini

D

K

field contains " "

Katia
Dec 22, 2003

Replies: 1

Views: 383

Dec 22, 2003

Tom Ellison

T

M

Need help defining parameters for an access query

Mike H
Dec 21, 2003

Replies: 4

Views: 403

Dec 22, 2003

Danny J. Lesandrini

D

G

Guest
Dec 21, 2003

Replies: 4

Views: 430

Dec 22, 2003

Guest

G

G

web-enabled database

Guest
Dec 21, 2003

Replies: 1

Views: 310

Dec 22, 2003

[MVP] S.Clark

M

B

Multiple Date Records

Bryan Hughes
Dec 17, 2003

Replies: 6

Views: 328

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: 764

Dec 22, 2003

Allen Browne

A

F

Firman
Dec 22, 2003

Replies: 1

Views: 364

Dec 22, 2003

Danny J. Lesandrini

D

J

Looking Up a Field Value Based on Variable

John C.
Dec 22, 2003

Replies: 3

Views: 374

Dec 22, 2003

John C.

J

S

sharon
Dec 22, 2003

Replies: 1

Views: 369

Dec 22, 2003

Jeff Boyce

J

3

Return null / zero length / nothing

317342
Dec 21, 2003

Replies: 5

Views: 483

Dec 22, 2003

317342

3

G

uploading a query

Guest
Dec 21, 2003

Replies: 3

Views: 427

Dec 22, 2003

Guest

G

D

Replace data in memo field

Diederik Nieuwenhuis
Dec 22, 2003

Replies: 1

Views: 482

Dec 22, 2003

Allen Browne

A

A

Create Calendar in Query

Arvin Villodres
Dec 22, 2003

Replies: 2

Views: 357

Dec 22, 2003

Arvin

A

M

How to filter against records...

Mike Whalen
Dec 15, 2003

Replies: 8

Views: 396

Dec 22, 2003

Ken Snell

K

L

Sort By ID and then Year

Ling
Dec 22, 2003

Replies: 2

Views: 344

Dec 22, 2003

Wayne Morgan

W

Z

Help with error message

ZBC
Dec 22, 2003

Replies: 1

Views: 292

Dec 22, 2003

Steve Schapel

S

T

INSERT results of a SELECT statement and constants

Tim Zych
Dec 21, 2003

Replies: 3

Views: 489

Dec 22, 2003

Tim Zych

T

C

Error message in query for quotient calculation

chase
Dec 21, 2003

Replies: 3

Views: 606

Dec 22, 2003

Duane Hookom

D

S

Hours between dates

Steve
Dec 21, 2003

Replies: 2

Views: 360

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: 615

Dec 21, 2003

Gary Walter

G

F

Math functions in a Query

Frank
Nov 25, 2003

Replies: 3

Views: 2K

Dec 21, 2003

Douglas J. Steele

D

S

Where to put Update Query....

Sandra Grawunder
Dec 20, 2003

Replies: 6

Views: 430

Dec 21, 2003

John Vinson

J

Top