Microsoft Access Queries

W

DATEDIFF function problem

WB
Apr 27, 2005

Replies: 2

Views: 22K

Apr 27, 2005

WB

W

A

case sensitive LIKE search

Abhishek Madas via AccessMonster.com
Apr 27, 2005

Replies: 2

Views: 17K

Apr 27, 2005

Ken Snell [MVP]

K

M

Append query

Michael Stengel via AccessMonster.com
Apr 27, 2005

Replies: 1

Views: 123K

Apr 27, 2005

John Vinson

J

G

How i select the hours only in date feild of yyyymmddhhmmss

Guest
Apr 27, 2005

Replies: 3

Views: 118K

Apr 27, 2005

John Vinson

J

G

List box to set q parameter

Guest
Apr 27, 2005

Replies: 1

Views: 357K

Apr 27, 2005

Van T. Dinh

V

G

calc a field based on values for example if [acnt_nbr] in 300999,.

Guest
Apr 26, 2005

Replies: 2

Views: 68K

Apr 27, 2005

Guest

G

Storing Values

Guest
Mar 14, 2005

Replies: 4

Views: 65K

Apr 27, 2005

Guest

G

Multiple rows in query

Guest
Apr 27, 2005

Replies: 2

Views: 237K

Apr 27, 2005

Guest

G

Need help on Numeric field overflow error

Guest
Apr 27, 2005

Replies: 1

Views: 130K

Apr 27, 2005

Gary Walter

G

Which identity?

Guest
Apr 27, 2005

Replies: 1

Views: 201K

Apr 27, 2005

Gary Walter

G

M

Update Query using same criteria for multiple Tables

Manuel Indacochea via AccessMonster.com
Apr 26, 2005

Replies: 2

Views: 356K

Apr 27, 2005

Manuel Indacochea via AccessMonster.com

M

G

help with Elseif or IIF

Guest
Apr 26, 2005

Replies: 2

Views: 256K

Apr 27, 2005

Guest

G

Esay way to turn rows into columns

Guest
Apr 27, 2005

Replies: 2

Views: 379K

Apr 27, 2005

Guest

G

if you use Access 2000

Guest
Apr 27, 2005

Replies: 1

Views: 14K

Apr 27, 2005

Duane Hookom

D

K

Time/Billing Calculation

Kirsty via AccessMonster.com
Apr 27, 2005

Replies: 1

Views: 69K

Apr 27, 2005

Duane Hookom

D

G

TRANSPOSE FIELDS IN ACCESS DATABASE

Guest
Apr 26, 2005

Replies: 1

Views: 25K

Apr 27, 2005

Jeff Boyce

J

G

multiple make table queries to increase performance

Guest
Apr 27, 2005

Replies: 1

Views: 59K

Apr 27, 2005

Jeff Boyce

J

G

counting matches between multiple tables

Guest
Apr 21, 2005

Replies: 2

Views: 54K

Apr 27, 2005

Guest

G

T

Problems with dates in query

Tony Williams
Apr 26, 2005

Replies: 2

Views: 408K

Apr 27, 2005

Tony Williams

T

G

Crosstab Query

Guest
Apr 26, 2005

Replies: 1

Views: 20K

Apr 27, 2005

Duane Hookom

D

B

Append Same Data To Table N Times

ButchyBoy via AccessMonster.com
Apr 27, 2005

Replies: 1

Views: 22K

Apr 27, 2005

John Vinson

J

G

Add data on double-click

Gina Whipp
Apr 27, 2005

Replies: 1

Views: 19K

Apr 27, 2005

Gina Whipp

G

select and where

Guest
Apr 26, 2005

Replies: 7

Views: 72K

Apr 27, 2005

John Vinson

J

G

passing records from a multilist box to parameter setting in a uer

Guest
Apr 26, 2005

Replies: 3

Views: 52K

Apr 27, 2005

Marshall Barton

M

G

Concatenate one-to-many into one row

Guest
Apr 26, 2005

Replies: 1

Views: 142K

Apr 26, 2005

Guest

G

Query w/ 8 "WHERE" Values

Guest
Apr 26, 2005

Replies: 8

Views: 130K

Apr 26, 2005

Guest

G

Multiselect list to unbound box to query Parameter

Guest
Apr 25, 2005

Replies: 5

Views: 112K

Apr 26, 2005

Van T. Dinh

V

G

many to many then one to many

Guest
Apr 26, 2005

Replies: 1

Views: 33K

Apr 26, 2005

MGFoster

M

G

Wildcard in IFF Expression

Guest
Apr 26, 2005

Replies: 3

Views: 4K

Apr 26, 2005

Van T. Dinh

V

G

Odd Street Addresses

Guest
Apr 26, 2005

Replies: 1

Views: 154K

Apr 26, 2005

MGFoster

M

Delete Query based in a table (different scenario) and fields combination.

Manuel Indacochea via AccessMonster.com
Apr 25, 2005

Replies: 5

Views: 515K

Apr 26, 2005

Michel Walsh

M

G

Query Message: Scaling of Decimal Value resulted in data Truncatio

Guest
Apr 25, 2005

Replies: 3

Views: 356K

Apr 26, 2005

MGFoster

M

G

Query Counting Number of Items Using Custom Dialogue Box ?? Help!

Guest
Apr 26, 2005

Replies: 1

Views: 41K

Apr 26, 2005

Guest

G

R

All records show up instead of filtered one's by name

RWalther
Apr 21, 2005

Replies: 1

Views: 16K

Apr 26, 2005

Guest

G

Before, current, and ending units based on dates

Guest
Apr 24, 2005

Replies: 2

Views: 425K

Apr 26, 2005

Guest

G

Time stored as varchar

Guest
Apr 26, 2005

Replies: 3

Views: 120K

Apr 26, 2005

Guest

G

Invalid procedure call!?

Guest
Apr 24, 2005

Replies: 5

Views: 385K

Apr 26, 2005

Duane Hookom

D

G

Getting a Count for a range of values

Guest
Apr 25, 2005

Replies: 6

Views: 110K

Apr 26, 2005

Duane Hookom

D

M

pivot table and weekly view

Mario Krsnic
Apr 26, 2005

Replies: 1

Views: 59K

Apr 26, 2005

Duane Hookom

D

G

Calculating Fields

Guest
Apr 26, 2005

Replies: 1

Views: 13K

Apr 26, 2005

John Vinson

J

C

take entries of a table as criteria for a query

Claus Haslauer
Apr 26, 2005

Replies: 1

Views: 163K

Apr 26, 2005

Claus Haslauer

C

G

ODBC Call failed

Guest
Feb 22, 2005

Replies: 12

Views: 616K

Apr 26, 2005

Guest

G

N

UPDATE Statement

Nadine Sinclair via AccessMonster.com
Apr 26, 2005

Replies: 2

Views: 180K

Apr 26, 2005

Nadine Sinclair via AccessMonster.com

N

G

Multiple field query

Guest
Apr 26, 2005

Replies: 4

Views: 17K

Apr 26, 2005

Guest

G

IIF (Expr, "*", ,[Forms]![TestForm]![TextA])

Guest
Apr 25, 2005

Replies: 7

Views: 15K

Apr 26, 2005

Lynn Trapp

L

G

Latest of several dates

Guest
Apr 25, 2005

Replies: 6

Views: 191K

Apr 26, 2005

Guest

G

V

Query used to produce report based on combobox selection

van
Apr 26, 2005

Replies: 1

Views: 160K

Apr 26, 2005

Michel Walsh

M

G

Unmatched qry, 2 fields

Guest
Apr 26, 2005

Replies: 1

Views: 38K

Apr 26, 2005

Michel Walsh

M

C

VB6 ADO Connection does not run a query

Cloe
Apr 26, 2005

Replies: 1

Views: 252K

Apr 26, 2005

Michel Walsh

M

G

Combo Box Query??

Guest
Apr 26, 2005

Replies: 5

Views: 193K

Apr 26, 2005

Michel Walsh

M