|
|
Track a Value 15 yrs from todays date by
HelloWorld
I have field in a database that contains a date for a DUI conviction - i need
a criteria that compares that date and todays date and sees if it is more
than 15...
|
January 18th, 2006 02:06 AM
by tina
|
5 |
128 |
|
|
Weird Wildcard problem i Access by
Kristian
I'm working with an Access database and one of the fields contain codes like
this:
A03AA01
A03AB01
and so on
I would like to make a query where I select...
|
|
9 |
134 |
|
|
Help on Dsum by
Brotha Lee
Hi,
I have the following SQL statement which I use for calculation some figures:
SELECT , .Product, .Year, .Month, .Value,DSum("Value","TBL 1",. &" =") AS...
|
|
2 |
97 |
|
|
Converting data types by
Bob Wickham
Hi,
I am appending data from an Excel spreadsheet to an Access table.
The problem is:
A field (called Lender) in the spreadsheet is formatted as Text which...
|
|
6 |
193 |
|
|
Where string hangs up when using dates only by
Tony Girgenti
Hello.
When i use the following string in a "DoCmd.OpenReport stDocName,
acViewPreview, , strWhere", it gives me the report i want: " =
"A V H INTERIORS 4061"...
|
|
9 |
141 |
|
|
Negative selection by
Gregp
I am trying to produce a query so simple, I'm almost embarrassed to ask this
question! I have two tables: (i) Projects, which lists a number of projects
for...
|
|
1 |
104 |
|
|
Sum Query with 2 Sums on One Line by
BarryC
I'm trying to write a query something like this: "Sum(Pcs)as Pcs1 where
Date =, Sum(Pcs)as Pcs2 where Date=-1" so
that both Sums appear in One result...
|
|
2 |
104 |
|
|
Unmatch between 2 table by
MN
Hi,
I tried many unmatch query but not have result. Please help.
I have 2 tables: Score1 and Score2, 2 table have identical structure.
Score1: ScoreID, Name,...
|
January 17th, 2006 10:20 PM
by MN
|
7 |
115 |
|
|
Query Criteria by
LibbyB
I am trying to create a query but can't get the criteria set up correctly...
I'd like to run a query for our patients who have been charged code (X or Y)
AND...
|
January 17th, 2006 10:12 PM
by Ofer
|
5 |
110 |
|
|
Recursive query, or similar by
James Minns
I would like to know if it is possible to "explode" a table via a query;
here is a small example
Table fields
ID number
Type text (E or M)
Source_Ref...
|
|
5 |
117 |
|
|
Parsing Text Field In Access and using NZ by
Keith Leslein
Hello All,
I am parsing a text field from a table ( ex Data: A/ASEL)
I reviewed the MVPS.org/Access webpage to get a start.
Here is the function the parsed...
|
|
1 |
88 |
|
|
Date Calculation - SOS by
lalexander
Hi All,
I have a date conversion problem.
1. I've calculated the difference between dates from field#1 and field#2
2. I want to add 90 days to the...
|
|
3 |
65 |
|
|
STUCK, FRUSTRATED, PLEASE HELP!! by
frustrated1
I have designed the tables for the information that I need several times,
trying to find the right way to set up the data so I can get a Querie to do
what I...
|
|
2 |
119 |
|
|
YTD previous year by
[email protected]
Hello,
Im trying to get the prevous YTD to work. The current year to date
works fine.
Projects: Sum(IIf( Between
!.
And !.,1,0))
Here's the expression for the...
|
January 17th, 2006 09:28 PM
by Krizhek
|
1 |
94 |
|
|
How to close a query result? by
homer
After docmd.openQuery opens a select query, what is the syntax to close it?
Actually I don't need to see the result of it. Is there a way to make it...
|
|
2 |
79 |
|
|
Doing the math by
UT_Lab_Sup
I would like to be able to set a Column in one of my queries that will give
me the abs(max() of a series of columns within the query .. I am having
trouble.. I...
|
|
7 |
126 |
|
|
APPEND Data without duplicated data by
Santiago
Hey guys, maybe it is a silly question, but I don't know that much of ACCESS...
How can I append data to a Table checking if the new data is already in...
|
|
3 |
108 |
|
|
|
|
2 |
169 |
|
|
Nulls to Zeros for graphing by
Electricman
I've already spent a good 3 hours or more reading posts and help topics and
trying everything I can think of to solve this. What I am trying to
accomplish is...
|
|
5 |
112 |
|
|
|
|
5 |
126 |