|
|
sql time formatting by
dp
hey guys,
trying very hard to format a time for an update query (without date part)
I have this so far:
Format$(strTime,"\#hh\:nn\:ss ampm\#")
Isnt there...
|
|
2 |
158 |
|
|
Missing records by
AdmSteck
I have a query in which I am trying to pull the total misset parts for each month for each part. Here is the query I have:
SELECT Parts.ID, Parts., Parts.,...
|
|
1 |
273 |
|
|
Multiple results in a querie by
Paula
I have an employee data base that has separate fields for
different eligibility dates for our various benefits. I
want to set up a querie/report that will...
|
|
1 |
142 |
|
|
todays date by
rml
I'm trying to run a query based on todays date. What is
the syntax for today in the criteria line.
Thanks.
|
|
1 |
139 |
|
|
Dates range within Date range by
Deanne
I am currently trying to write an expression that flags whether a specific date range occurs within a certain date range. This will enable me to calculate the...
|
|
3 |
526 |
|
|
|
|
3 |
199 |
|
|
Update query by 1/2 entered number by
Eb1mom
Two update queries. Number fields are being updated. Query
is simply + A popup comes
up and user enters number to be added. In second update
query the...
|
July 9th, 2004 02:07 AM
by eb1mom
|
2 |
778 |
|
|
|
|
5 |
686 |
|
|
Queries adding Zeroes by
Rob
hi,
i have a table which keeps track of lawyer membership in
different sections (i.e. criminal law, civil law, etc.)
by having their section dues (in a...
|
|
2 |
426 |
|
|
qry to show data from two tables by
jane
I am trying to build an appointments database which
includes a table of appointment times spaced at fifteen
minute intervals and a table to record...
|
|
7 |
291 |
|
|
Update query by
Ian Sweeney
What is the Access equivalent of
UPDATE table a
FROM table b
SET x = b.y
WHERE a.c = b.d
|
|
4 |
161 |
|
|
Query or queries by
Dan
I have a query based on two tables. One table has ID
number, point, and a Code field with either an X or a C.
the other table has ID, Name etc. I have created...
|
|
1 |
208 |
|
|
Query on a linked spreadsheet by
Michelle
In Access, I have linked an Excel spreadsheet, and then
have queries running off that linked spreasheet. The
queries are functioning correctly, but when I...
|
|
1 |
498 |
|
|
parameter query with multiple entries by
lynn.atkinson
Can I have a parameter query where the user just types the
various criteria in to one dialog box? eg I want to find
location 1, location 2 and location 3 from...
|
|
1 |
491 |
|
|
Replace blanks by text by
Seaman
How can I replace blank cells with the word "empty" in the
results from a query.
|
July 8th, 2004 04:28 PM
by Seaman
|
2 |
293 |
|
|
Unmatch query by
Amorfosis
Could somebody please tell me what an unmatch query is in English. The help menu in access isn't exactly crystal clear on what the query is and what it...
|
|
1 |
122 |
|
|
Pass Through Query Parameters by
Stacy
I'm using an SQL pass through query and would like to run
it based on criteria selected in a form. I've tried to
call the form fields in the SQL statement, but...
|
|
3 |
400 |
|
|
Appendquery to add display record, only by
an
Hello!
I have an Appendquery wich append all records to T_Values.
But I would like append present record only, because is
unique record with new data.
I need...
|
July 8th, 2004 02:55 PM
by an
|
4 |
199 |
|
|
append query overwrites all matching records by
NoSpamTakeSquareRootOfNumber
I have an append query in a database that must append records into
another database on a click() event. How can I make that append query
overwrite all records...
|
|
4 |
690 |
|
|
|
July 8th, 2004 02:38 PM
by PACS
|
2 |
236 |