Microsoft Access Queries

Sort by: Views Descending

G

How do I create a time range criteria in an Access query?

Guest
Dec 27, 2005

Replies: 2

Views: 19K

Dec 27, 2005

MGFoster

M

S

return all after specific character. left, right, mid???

Scubadaisy
Apr 24, 2008

Replies: 5

Views: 19K

Apr 24, 2008

John Spencer

J

S

Access query based on number of characters

Susana C
Apr 24, 2006

Replies: 4

Views: 19K

Apr 24, 2006

Susana C

S

J

Re: Convert Number to Text and keep leading zeroes

Jeff Boyce
May 19, 2009

Replies: 1

Views: 19K

May 19, 2009

John Spencer MVP

J

G

Multiple "Not like" exclusionary query

Guest
Apr 5, 2006

Replies: 2

Views: 19K

Apr 6, 2006

Allen Browne

A

G

How to use a parameter query with multiple values?

Guest
Oct 27, 2004

Replies: 15

Views: 18K

Jan 13, 2009

Jacqueline

J

G

Guest
Dec 19, 2005

Replies: 8

Views: 18K

Jul 16, 2008

haikal Pribadi

H

G

How to convert Hex to Decimal in Access queries ?

Guest
Dec 20, 2005

Replies: 3

Views: 18K

Jun 6, 2011

tjeffryes

T

W

Calc no of working days in current month

Walter
Jul 14, 2003

Replies: 3

Views: 18K

Sep 30, 2007

mickeya7

M

G

Minus in Access

Guest
Feb 16, 2004

Replies: 4

Views: 18K

Feb 17, 2004

Guest

G

S

Blank Fields in NOT Null Query Criteria

Steve Stad
May 27, 2010

Replies: 5

Views: 18K

May 28, 2010

KARL DEWEY

K

B

SELECT DISTINCT only on some fields but display all fields (AC 200

Bill Nevin
Jan 17, 2009

Replies: 3

Views: 17K

Jan 19, 2009

John Spencer

J

G

Access function same as Excel's TEXT function???

Guest
Apr 15, 2005

Replies: 4

Views: 17K

Apr 15, 2005

Guest

G

A

Setting a field's default value as an value from another table

ashour.rehana
Sep 22, 2008

Replies: 7

Views: 17K

Oct 31, 2013

John W. Vinson

J

G

how split column by a delimiter in access?

Guest
May 9, 2007

Replies: 3

Views: 17K

May 10, 2007

John Spencer

J

D

I need to convert a decimal time to hours and minutes, is there a

Dave
Nov 6, 2008

Replies: 3

Views: 17K

Nov 6, 2008

John W. Vinson

J

H

How to query the blank date field?

hkgary33 via AccessMonster.com
Jul 19, 2006

Replies: 4

Views: 17K

Jul 19, 2006

Rick B

R

G

Access Subtotal in Query

Guest
Jun 6, 2007

Replies: 3

Views: 17K

May 12, 2010

Bob Barrows

B

N

Problem with Make Table Query - Resultant Table not allowed to have more than one AutoNumber field.

Neil Robbins
Apr 4, 2004

Replies: 5

Views: 16K

Dec 18, 2018

djdave238

D

M

What's the difference between VAR and VARP?

Michel Walsh
Nov 24, 2003

Replies: 2

Views: 16K

Nov 25, 2003

news.microsoft.com

N

G

how to split a column in MS Access

Guest
Oct 8, 2004

Replies: 5

Views: 16K

Mar 27, 2023

ophelie

O

G

Undefined function 'IFF' in expression

Guest
Apr 25, 2005

Replies: 2

Views: 16K

Apr 25, 2005

fredg

F

F

Append Query: SQL to add a new record?

Faraz Azhar
May 9, 2009

Replies: 7

Views: 16K

May 10, 2009

John W. Vinson

J

N

How do I execute multiple SQL statements in Access??

nickB
Mar 13, 2010

Replies: 3

Views: 16K

Mar 15, 2010

david

D

M

how kill query?

mykalc
Sep 15, 2006

Replies: 4

Views: 16K

Sep 15, 2006

Guest

G

F

Change format of date in query?

Flopbot
Apr 22, 2010

Replies: 3

Views: 15K

Apr 23, 2010

Flopbot

F

S

Inserting blank columns into query

Scott
Jun 18, 2008

Replies: 4

Views: 15K

Jun 18, 2008

John Spencer

J

G

Eliminate #Error from Query Results??

Guest
Oct 18, 2005

Replies: 3

Views: 15K

Oct 18, 2005

Ken Snell [MVP]

K

K

Calculate time difference

Kurt
Sep 26, 2010

Replies: 3

Views: 15K

Sep 30, 2010

Kurt

K

G

Pass thru query to SQL server with parameters

Guest
Jan 27, 2005

Replies: 3

Views: 15K

Jan 28, 2005

Guest

G

D

Undefined Function "Nz" in expression???

Darryn
Jul 18, 2005

Replies: 5

Views: 15K

Jul 18, 2005

John Spencer (MVP)

J

I

Irv Brand
Jul 15, 2003

Replies: 8

Views: 15K

Jul 19, 2003

Irv Brand

I

G

Can you calculate percentile/ quartiles in access?

Guest
Oct 31, 2006

Replies: 2

Views: 15K

Oct 31, 2006

Smartin

S

G

First occurrence returned by query

Guest
Feb 15, 2004

Replies: 3

Views: 15K

Feb 19, 2004

Guest

G

A

HAVING Count(DISTINCT ...

Ahlgren
Nov 18, 2005

Replies: 2

Views: 15K

Nov 18, 2005

Ahlgren

A

J

Query to find non numeric characters

Jerry
Dec 3, 2004

Replies: 3

Views: 14K

Dec 3, 2004

Jerry

J

R

Renaming Column Headers with IIf as a Result of a Crosstab Query

Ricco
Jun 1, 2009

Replies: 3

Views: 14K

Jun 1, 2009

Ricco

R

C

How can I get Access to calculate a percentage on two of my fields

Christinahoff924
Apr 27, 2009

Replies: 7

Views: 14K

Apr 29, 2009

Duane Hookom

D

S

CASE statement in UPDATE query

Steve
May 11, 2004

Replies: 2

Views: 14K

May 12, 2004

John Vinson

J

G

referring to a combo box column as criteria in a query

Guest
Dec 1, 2005

Replies: 5

Views: 14K

Dec 1, 2005

Guest

G

S

Append key violation error

sbaldwin
Jul 25, 2003

Replies: 3

Views: 14K

Jul 26, 2003

John Spencer (MVP)

J

R

Parameter Queries in Crosstab Query

Renee
Apr 15, 2010

Replies: 2

Views: 14K

Apr 15, 2010

Renee

R

P

using the results of a SQL SELECT(COUNT) statement in VBA

Paul James
Sep 23, 2004

Replies: 7

Views: 14K

Sep 24, 2004

Paul James

P

G

Short Date format conversion to Month name and two digit year

Guest
Jul 28, 2006

Replies: 3

Views: 14K

Jul 28, 2006

John Vinson

J

G

limit output of query to the last 7 days

Guest
Dec 19, 2004

Replies: 4

Views: 14K

Jan 24, 2005

fredg

F

T

Error 3021 - No current record -

Tiziana Venturini
Jul 14, 2003

Replies: 4

Views: 14K

Jul 15, 2003

Allen Browne

A

G

Change Query Field Name

Guest
Oct 17, 2007

Replies: 3

Views: 13K

Oct 17, 2007

Guest

G

A

using CASE in access

alecgreen
Aug 11, 2010

Replies: 5

Views: 13K

Aug 13, 2010

David W. Fenton

D

G

Need to export a pivot chart view of a query

Guest
Dec 8, 2004

2

Replies: 26

Views: 13K

Apr 19, 2010

Robin

R

M

inline sql comments in access 2007 ?

matrix8
Jan 11, 2009

Replies: 8

Views: 13K

Jan 12, 2009

David W. Fenton

D