Microsoft Access Queries

Post thread
L
Nested If conversion to Select case
  • Lotto
Replies
5
Views
951
tina
T
J
Formatting date gives bad results in query
  • Jeff Beveridge
Replies
2
Views
1K
Jeff Beveridge
J
R
Select Top Query
  • Rob M
Replies
2
Views
843
Rob M
R
D
Splitting a large field up into six new fields
  • David
Replies
3
Views
1K
John Spencer
J
J
Using IIF statement in query criteria
  • jgeniti
Replies
11
Views
2K
jgeniti
J
D
Appending null data and moving!
  • Duncs
Replies
4
Views
848
Duncs
D
I
composite key unmatched query
  • inungh
Replies
1
Views
2K
Bob Barrows
B
U
HOW DO I USE COUNTIF FUNCTION ACCESS 2007 ?
  • Udaya
Replies
3
Views
25K
Paul Harth
P
E
Make Table Dynamic Table Name using INTO
  • excelCPA
Replies
2
Views
5K
John W. Vinson
J
D
Creating a "grid" of data
  • DawnTreader
Replies
3
Views
786
DawnTreader
D
S
Use a function in the "Criteria" of a query?
  • Six Lombardi's
Replies
3
Views
808
Six Lombardi's
S
P
Runs Ok, EXPORT fails with:Cannot define Field more than once
  • Phil Smith
Replies
8
Views
12K
DoncoMania
D
L
Listing all fields in a query
  • laeldo
Replies
0
Views
674
laeldo
L
C
Queries losing fieldnames when importing from external mdb
  • CompleteNewb
Replies
2
Views
1K
CompleteNewb
C
A
Custom Form Property, Parameter Query Access 2007 Problem
  • ascnd
Replies
2
Views
4K
Fred Parkinson
F
K
Serial No for Unique Value
  • K
Replies
1
Views
595
John Spencer
J
J
lookup table names
  • johnlute
Replies
1
Views
513
johnlute
J
J
Query field size quandry
  • James
Replies
2
Views
2K
John W. Vinson
J
K
Calculate time difference
  • Kurt
Replies
3
Views
15K
Kurt
K
Z
multiple users' simultaneous access to a MS Access database
  • zufie
Replies
4
Views
9K
zufie
Z
J
jeramie bellmay
  • jeramie francis
Replies
4
Views
1K
nonoe nonone
N
J
jeramie bellmay
  • jeramie francis
Replies
6
Views
1K
jeramie bellmay
J
G
Linking two tables using SQL with Mid function?
  • Guest
Replies
9
Views
2K
David W. Fenton
D
C
opposite of inner join; exclude rather than match
  • Christian Bahnsen
Replies
3
Views
8K
venkatesh s
V
Z
multiple users' simultaneous access to a MS Access database
  • zufie
Replies
0
Views
1K
zufie
Z
M
Using IN( ) function in a query
  • maki
Replies
7
Views
756
Bob Barrows
B
P
changing a number to text
  • pat67
Replies
1
Views
631
John W. Vinson
J
P
extract just month/year from table field??
  • PAkerly
Replies
2
Views
4K
Bob Barrows
B
K
Extract data from previous week, previous two weeks, etc.
  • Kurt
Replies
2
Views
10K
John Spencer
J
M
output to Excel
  • Michael Buscio
Replies
5
Views
691
Tony Toews
T
A
Data changes in append query
  • alecgreen
Replies
1
Views
843
John W. Vinson
J
L
query
  • lee
Replies
1
Views
585
John Spencer
J
G
When I open design view in a query I get "is not a valid name.
  • Guest
Replies
18
Views
1K
John W. Vinson
J
M
List box not displaying more than two columns
  • Mark
Replies
9
Views
2K
Mark
M
L
query
  • lee
Replies
1
Views
679
John Spencer
J
L
upc and pos
  • lee
Replies
3
Views
701
John Spencer
J
A
show the most recent payment
  • Andy79
Replies
5
Views
819
Andy79
A
P
can't open front end when back end in use
  • pat67
Replies
5
Views
1K
David W. Fenton
D
P
need to rank in a query
  • pat67
Replies
4
Views
949
John Spencer
J
K
Formula to give squense number
  • K
Replies
1
Views
714
Bob Barrows
B
K
Formula in Access Query to genrate numbers
  • K
Replies
1
Views
748
Bob Barrows
B
K
Effective date query
  • KD
Replies
3
Views
2K
KD
K
K
Help with a "like" query between two fields from two different tables...
  • KLZA
Replies
2
Views
10K
John W. Vinson
J
L
repeating a query
  • LUIS ANGEL
Replies
2
Views
516
KLZA
K
P
moving acces db to sharepoint
  • pat67
Replies
5
Views
1K
David W. Fenton
D
L
Can I do this with a query?
  • LAS
Replies
1
Views
599
John W. Vinson
J
C
How many dates this week?
  • Chris K
Replies
1
Views
568
John Spencer
J
Z
Report prob
  • zufie
Replies
3
Views
648
John W. Vinson
J
R
Missing attendance records (Wizard won't help)
  • Roger Ball
Replies
3
Views
727
John Spencer
J
C
Find Duplicate Record
  • clk
Replies
1
Views
567
John Spencer
J
Top