Microsoft Access Queries

J

Using Min() and Max() on column with both strings and numbers - can it work?

Jesper F
Mar 11, 2006

Replies: 2

Views: 376K

Mar 11, 2006

Jesper F

J

G

duplicate records

Guest
Mar 10, 2006

Replies: 3

Views: 267K

Mar 11, 2006

Tom Ellison

T

G

Comparing years

Guest
Nov 11, 2004

Replies: 6

Views: 35K

Mar 11, 2006

Vincent Johns

V

G

Summing Problem

Guest
Mar 9, 2006

Replies: 2

Views: 316K

Mar 11, 2006

Vincent Johns

V

B

Undefined Function - MS Query

Bill
Mar 9, 2006

Replies: 6

Views: 108K

Mar 11, 2006

Bob Barrows [MVP]

B

G

How do I return display portion of hyperlink in union query

Guest
Mar 10, 2006

Replies: 1

Views: 61K

Mar 11, 2006

Allen Browne

A

K

display dates between 2 dates

kirkland via AccessMonster.com
Mar 11, 2006

Replies: 1

Views: 208K

Mar 11, 2006

=?iso-8859-2?Q?Przemys=B3aw_Rachwa=B3?=

?

G

DUPLICATE QUERY results

Guest
Mar 10, 2006

Replies: 1

Views: 254K

Mar 11, 2006

Vincent Johns

V

G

Use query to change Text to Number

Guest
Mar 10, 2006

Replies: 2

Views: 40K

Mar 11, 2006

John Nurick

J

G

TWO iiF EXPRESSIONS

Guest
Mar 9, 2006

Replies: 11

Views: 155K

Mar 11, 2006

david epsom dot com dot au

D

G

Query to table

Guest
Mar 10, 2006

Replies: 1

Views: 163K

Mar 10, 2006

Guest

G

Join queries

Guest
Mar 10, 2006

Replies: 1

Views: 62K

Mar 10, 2006

Tom Ellison

T

G

Fuzzy Match on two tables

Guest
Mar 10, 2006

Replies: 7

Views: 142K

Mar 10, 2006

Marshall Barton

M

S

date

SJJ via AccessMonster.com
Mar 6, 2006

Replies: 13

Views: 215K

Mar 10, 2006

SJJ via AccessMonster.com

S

G

Why doesn't this work

Guest
Mar 10, 2006

Replies: 3

Views: 110K

Mar 10, 2006

Tom Ellison

T

G

error on IIF

Ghena
Mar 10, 2006

Replies: 3

Views: 99K

Mar 10, 2006

Ghena

G

creating field with blank data for append query

Guest
Mar 10, 2006

Replies: 3

Views: 14K

Mar 10, 2006

Guest

G

calculated field question

Guest
Mar 10, 2006

Replies: 5

Views: 413K

Mar 10, 2006

Tom Ellison

T

G

Create New Records in a Table by Copying Existing Records

Guest
Mar 10, 2006

Replies: 3

Views: 167K

Mar 10, 2006

Guest

G

Weighted Average - Access DB

Guest
Mar 10, 2006

Replies: 1

Views: 36K

Mar 10, 2006

Bob Barrows [MVP]

B

C

Formulas for Beginners

Chris Peikert
Mar 9, 2006

Replies: 6

Views: 107K

Mar 10, 2006

John Spencer

J

G

Running Total Error

Guest
Mar 10, 2006

Replies: 1

Views: 150K

Mar 10, 2006

Guest

G

A

Help with an IIF statement in a query

alanmorganjr via AccessMonster.com
Mar 10, 2006

Replies: 5

Views: 586K

Mar 10, 2006

alanmorganjr via AccessMonster.com

A

G

what is wrong with this text expression

Guest
Mar 10, 2006

Replies: 8

Views: 303K

Mar 10, 2006

Brian Bastl

B

G

Create a running Balance

Guest
Mar 10, 2006

Replies: 2

Views: 179K

Mar 10, 2006

Guest

G

Find the Maximum Value by Date

Guest
Mar 10, 2006

Replies: 3

Views: 237K

Mar 10, 2006

OfficeDev18 via AccessMonster.com

O

G

Case statement in MS Access

Guest
Mar 9, 2006

Replies: 5

Views: 332K

Mar 10, 2006

Guest

G

Resultsset order

Guest
Mar 10, 2006

Replies: 2

Views: 94K

Mar 10, 2006

Guest

G

Compound IF Statement?

Guest
Mar 10, 2006

Replies: 7

Views: 632K

Mar 10, 2006

Guest

G

duplicates in query

Guest
Mar 10, 2006

Replies: 1

Views: 131K

Mar 10, 2006

Tom Ellison

T

D

Changing Report Dependency

David G. Hoch
Mar 10, 2006

Replies: 2

Views: 64K

Mar 10, 2006

David G. Hoch

D

G

restrict field size in make table query

Guest
Mar 9, 2006

Replies: 2

Views: 27K

Mar 10, 2006

Guest

G

D

Creating a query that returns (one / multiple) records from two parameters

darobe
Mar 9, 2006

Replies: 2

Views: 101K

Mar 10, 2006

Dan

D

G

Make Table Query (Hide output)

Guest
Mar 10, 2006

Replies: 2

Views: 23K

Mar 10, 2006

John Spencer

J

F

Memo Field Data being truncated with agregate function

FA
Mar 9, 2006

Replies: 1

Views: 101K

Mar 10, 2006

Guest

G

S

Insert spaces into String

Sandybam
Mar 8, 2006

Replies: 5

Views: 48K

Mar 10, 2006

Sandybam via AccessMonster.com

S

G

How do I add a new industry to my database?

Guest
Mar 9, 2006

Replies: 12

Views: 16K

Mar 10, 2006

Guest

G

R

Duplicate Query

rblivewire
Mar 10, 2006

Replies: 1

Views: 56K

Mar 10, 2006

Darren

D

G

Dates, Quarters and counts

Guest
Mar 10, 2006

Replies: 1

Views: 231K

Mar 10, 2006

John Spencer

J

G

Append Query - Number to Text

Guest
Mar 10, 2006

Replies: 1

Views: 91K

Mar 10, 2006

John Spencer

J

B

getting name into 1 field from 2 fields

_Bigred
Mar 9, 2006

Replies: 4

Views: 288K

Mar 10, 2006

Tom Ellison

T

G

Combining rows

Guest
Dec 12, 2005

Replies: 14

Views: 866K

Mar 10, 2006

Guest

G

Return all data plus gaps in data

Guest
Mar 10, 2006

Replies: 1

Views: 94K

Mar 10, 2006

Guest

G

Access Crosstab Query Should Link To Forms

Guest
Mar 8, 2006

Replies: 3

Views: 246K

Mar 10, 2006

Duane Hookom

D

G

Can I "flatten" out a table

Guest
Mar 10, 2006

Replies: 2

Views: 191K

Mar 10, 2006

Marshall Barton

M

J

DDL query to add new fields to existing table

Julian
Mar 9, 2006

Replies: 1

Views: 286K

Mar 10, 2006

david epsom dot com dot au

D

J

insert increasing number with SQL

Jesper F
Mar 5, 2006

Replies: 6

Views: 234K

Mar 10, 2006

Bill (Unique as my name)

B

G

use query as field controlsource

Guest
Mar 9, 2006

Replies: 1

Views: 125K

Mar 9, 2006

Guest

G

opening report is askiing for parameter value of subreport ?

graeme34 via AccessMonster.com
Mar 9, 2006

Replies: 1

Views: 334K

Mar 9, 2006

graeme34 via AccessMonster.com

G

Need basic query help.

Guest
Mar 9, 2006

Replies: 1

Views: 60K

Mar 9, 2006

Guest

G