|
|
Date criteria problem by
PayeDoc
Hello All
What's wrong with this:
SELECT staffs.DOB, CDate(retirementdate(,)) AS retdate
FROM staffs
WHERE (((staffs.DOB)#1/1/1901#)...
( 1 2)
|
|
19 |
423 |
|
|
|
|
19 |
137 |
|
|
DateFunction in Query by
Curtis Stevens
I have a query with this function as the field:
Outstanding Days: Date()-!
The SentInDate field in the Customer's table is a date that represents when
the...
( 1 2)
|
|
19 |
277 |
|
|
|
|
19 |
209 |
|
|
Iif not working by
Noreen
Hi, I'm new here. But this is driving me crazy! What is wrong with this IIF
statement? Sometimes, if I try to use "|" because of errors with a "," and
it...
( 1 2)
|
|
19 |
177 |
|
|
|
August 14th, 2009 07:20 PM
by Jim
|
19 |
303 |
|
|
|
|
19 |
348 |
|
|
union query by
lmiller
I am trying to develop a union query for my 2 inventory balances. the query
comes back with the first 2 fields correctly but when it comes to the
balances...
( 1 2)
|
February 11th, 2010 05:34 PM
by lmiller
|
19 |
244 |
|
|
Automating a query by
Alex
Hi all
Is there a way to run a saved query like we can run a macro
(docmd.runmacro)from within a VB sub?
Thanks
--
Alex
( 1 2)
|
March 23rd, 2006 10:20 AM
by alex
|
18 |
215 |
|
|
help with matching data required by
Norman Fritag
Hi there
I need some help, to matching data!
eg: out of 20 elements: eg (10,2,4 17,24,5,30, 40, 50, 100, 23, 35, 200,
3501, 201, 245, 323,2000, 33,...
( 1 2)
|
|
18 |
288 |
|
|
Mangled, with a difference by
Tom Ellison
A query I recently successfully completed gets mangled when I save it.
No surprise yet.
The mangling consists of replacing the parens around a subquery. The...
( 1 2)
|
|
18 |
179 |
|
|
Query is not reflecting all records. by
Jill76
I used fields from three different tables to build a query.
Table 1: Investor Name & Investor Category
Table 2: General Information, Source, Date
Table 3: ...
( 1 2)
|
|
18 |
292 |
|
|
PARAMETER by
Debbie
HOW DO I SET PARAMETERS FOR A BIRTHDAY QUERY. I NEED IT TO PULL OUT
ALL STAFF THAT HAVE A BIRTHDAY IN JANUARY, FOR EXAMPLE. SOMETIMES I
HAVE TO HAVE A TWO...
( 1 2)
|
December 22nd, 2005 12:41 AM
by Debbie
|
18 |
164 |
|
|
How to get needed records for report by
Tony Girgenti
Hello.
We have a database used just for reporting with status records that have a
date and workstation fields as in:
TempStatusRecNo TIMESTAMP ...
( 1 2)
|
|
18 |
135 |
|
|
Date Query by
SJJ via AccessMonster.com
hi
how can i make a query which will automatically run 2nd tuesday of every
month.
Can some one help me on this please.
thanks in advance
--
( 1 2)
|
|
18 |
196 |
|
|
Front End vs Back End by
JethroUK©
i've put a lot of work into my forms/reports and i want to protect &
seperate them from the main data tables
if i split the databse in two - should i leave...
( 1 2)
|
|
18 |
162 |
|
|
check mark in query by
alexasha
Hi, I have created a query for the table with check mark. For some reason I
can not check my checkmark in query, but I still able to change it in the
table...
( 1 2)
|
|
18 |
226 |
|
|
How to by
tamxwell
My db has 6 fields all populated with numbers from 01-55 and there are 1404
records. How can I write a query to tell me how many time each of the numbers
(say...
( 1 2)
|
|
18 |
165 |
|
|
Access to Excel by
[email protected]
I Have a form that has a button that when clicked it sends data from a
query that i have to a excel spreadsheet. the problem that i am having
is when i run it...
( 1 2)
|
|
18 |
360 |
|
|
|
January 30th, 2005 05:30 AM
by YYZ
|
18 |
338 |