Access Queries

Filters

G

Old queries / views

Gary Nelson
Dec 22, 2003

Replies: 1

Views: 164

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

Dec 23, 2003

Michel Walsh

M

B

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

Brandon
Dec 15, 2003

Replies: 3

Views: 466

Dec 23, 2003

John Spencer (MVP)

J

S

converting strings to ASCII

shank
Dec 23, 2003

Replies: 2

Views: 289

Dec 23, 2003

Gary Walter

G

I

Too many results

I Am
Dec 23, 2003

Replies: 1

Views: 179

Dec 23, 2003

ds

D

H

Data of Birth to Birthday

Harmannus
Dec 22, 2003

Replies: 1

Views: 159

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

Dec 23, 2003

Peter Kaufman

P

S

finding ASCII characters

shank
Dec 23, 2003

Replies: 1

Views: 267

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

Dec 23, 2003

Rick Brandt

R

C

Using a function to get a value from the database

Craig
Dec 22, 2003

Replies: 4

Views: 168

Dec 23, 2003

John Vinson

J

M

counting -.number of records.

Mickey
Dec 23, 2003

Replies: 3

Views: 205

Dec 23, 2003

Duane Hookom

D

S

Make Table with SQL Pass Through

SumApr
Dec 22, 2003

Replies: 1

Views: 365

Dec 23, 2003

Duane Hookom

D

N

concatenate field in all records

Nicholas R. Markham
Dec 22, 2003

Replies: 2

Views: 269

Dec 23, 2003

Duane Hookom

D

R

Select most recent date

Rick Dunmire
Dec 22, 2003

Replies: 2

Views: 378

Dec 23, 2003

Rick Dunmire

R

L

Append Query in Access

Lakshmana
Dec 22, 2003

Replies: 1

Views: 224

Dec 22, 2003

Cheryl Fischer

C

M

Cumulative sum of large table - DSum is unusable

Milan
Dec 22, 2003

Replies: 2

Views: 299

Dec 22, 2003

Otis B. Driftwood

O

A

fast queries became very slow

annie
Dec 13, 2003

Replies: 7

Views: 237

Dec 22, 2003

Van T. Dinh

V

D

Memo cut to 255 char in Grouped Query

Dan
Dec 22, 2003

Replies: 3

Views: 279

Dec 22, 2003

Van T. Dinh

V

H

Access 2000 Prompt to save?

Heather
Dec 22, 2003

Replies: 1

Views: 179

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

Dec 22, 2003

Mike H

M

S

Pulling together data

Scruff57
Dec 22, 2003

Replies: 1

Views: 195

Dec 22, 2003

John Vinson

J

B

Easier way to select most recent value...

Ben Moore
Dec 22, 2003

Replies: 5

Views: 321

Dec 22, 2003

John Vinson

J

A

cannot join on Memo, OLE or hyperlink

Andy Levy
Dec 22, 2003

Replies: 7

Views: 4K

Dec 22, 2003

Andy Levy

A

C

Query result to textbox

Carel Stoop
Dec 22, 2003

Replies: 1

Views: 214

Dec 22, 2003

Steve Schapel

S

J

Query records where artist name begins with a number

Jeremy
Dec 22, 2003

Replies: 2

Views: 210

Dec 22, 2003

Danny J. Lesandrini

D

K

field contains " "

Katia
Dec 22, 2003

Replies: 1

Views: 220

Dec 22, 2003

Tom Ellison

T

M

Need help defining parameters for an access query

Mike H
Dec 21, 2003

Replies: 4

Views: 208

Dec 22, 2003

Danny J. Lesandrini

D

N

Slow Query

Nick
Dec 21, 2003

Replies: 4

Views: 206

Dec 22, 2003

Nick

N

G

web-enabled database

Guest
Dec 21, 2003

Replies: 1

Views: 166

Dec 22, 2003

[MVP] S.Clark

M

B

Multiple Date Records

Bryan Hughes
Dec 17, 2003

Replies: 6

Views: 279

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

Dec 22, 2003

Allen Browne

A

F

2 steps query

Firman
Dec 22, 2003

Replies: 1

Views: 225

Dec 22, 2003

Danny J. Lesandrini

D

J

Looking Up a Field Value Based on Variable

John C.
Dec 22, 2003

Replies: 3

Views: 179

Dec 22, 2003

John C.

J

S

substraction

sharon
Dec 22, 2003

Replies: 1

Views: 149

Dec 22, 2003

Jeff Boyce

J

3

Return null / zero length / nothing

317342
Dec 21, 2003

Replies: 5

Views: 357

Dec 22, 2003

317342

3

G

uploading a query

Guest
Dec 21, 2003

Replies: 3

Views: 190

Dec 22, 2003

Guest

G

D

Replace data in memo field

Diederik Nieuwenhuis
Dec 22, 2003

Replies: 1

Views: 289

Dec 22, 2003

Allen Browne

A

A

Create Calendar in Query

Arvin Villodres
Dec 22, 2003

Replies: 2

Views: 200

Dec 22, 2003

Arvin

A

M

How to filter against records...

Mike Whalen
Dec 15, 2003

Replies: 8

Views: 313

Dec 22, 2003

Ken Snell

K

L

Sort By ID and then Year

Ling
Dec 22, 2003

Replies: 2

Views: 333

Dec 22, 2003

Wayne Morgan

W

Z

Help with error message

ZBC
Dec 22, 2003

Replies: 1

Views: 158

Dec 22, 2003

Steve Schapel

S

T

INSERT results of a SELECT statement and constants

Tim Zych
Dec 21, 2003

Replies: 3

Views: 230

Dec 22, 2003

Tim Zych

T

C

Error message in query for quotient calculation

chase
Dec 21, 2003

Replies: 3

Views: 342

Dec 22, 2003

Duane Hookom

D

S

Hours between dates

Steve
Dec 21, 2003

Replies: 2

Views: 198

Dec 21, 2003

Wayne Morgan

W

N

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

Neal
Dec 19, 2003

Replies: 1

Views: 316

Dec 21, 2003

Gary Walter

G

F

Math functions in a Query

Frank
Nov 25, 2003

Replies: 3

Views: 246

Dec 21, 2003

Douglas J. Steele

D

S

Where to put Update Query....

Sandra Grawunder
Dec 20, 2003

Replies: 6

Views: 218

Dec 21, 2003

John Vinson

J

G

crostab query with 0 values

Giannis Isaias
Dec 21, 2003

Replies: 1

Views: 386

Dec 21, 2003

Duane Hookom

D

D

return last month from query

desertdirk
Dec 12, 2003

Replies: 3

Views: 210

Dec 21, 2003

desertdirk

D

J

Query Multiple Tables

John C.
Dec 20, 2003

Replies: 12

Views: 316

Dec 21, 2003

Jeff Boyce

J

Top