Days of the Week Query
Tue, 30 Sep 2008 10:00:03 -0700
Is there an easy way to get all the dates for all the Mondays, Tuesdays, etc.
for a given year? Thanks. ...
|
Need Help on getting the query to come back with a blank value if the
value is equal to the criteria
Tue, 30 Sep 2008 09:22:47 -0700 (PDT)
Okay guys this is the last one.
My query will pull everything that has this months date in it. When
the query finds a date that falls in this month it also prints the
dates by the person's name that does not fall in this month. How can
I get it to return a blank value If it does not match the criteria.
Th ...
|
Help with more than on expiration Date
Tue, 30 Sep 2008 09:07:16 -0700 (PDT)
SQL:
SELECT Test.[ID], Test.[First Name], Test.[Last Name], Test.[Crane
Certification], Test.[Physical], Test.[Lincense], Test.[Safety Card]
FROM Test
WHERE ((Year([Physical])=Year(Now()) And
Month([Physical])=Month(Now()))) OR ((Year([Crane
Certification])=Year(Now()) And Month([Crane
Certification])=Month ...
|
Transferring Data from one query to the next
Tue, 30 Sep 2008 08:57:02 -0700
I have two forms based on the same table, one is view closed inventory and
the other is view open inventory. Recently I put a command button on the
closed inventory form that will allow the closed inventory record to be
reopened. I need to put a condition in closed inventory query that when the
checkbox is ...
|
Using Yes/No data type
Tue, 30 Sep 2008 08:35:01 -0700
This is the query I've created to capture clients who have requested repairs
and have received them and also requested repairs and not received them. I
used a yes/no data type as the indicator. When I run the query all of the
entries in the DB show up. 1. How do I display only the entries where either
situat ...
|
Update Query based on Difference in time
Tue, 30 Sep 2008 07:00:01 -0700
I have a table keeping track of attendance for employees. We use a point
system, so that if an employee is absent or late, points are deducted. How
can i add the points field to each record?? There is a 15 minute grace period
in this as well, i would want it to look something like below, where late
employees ...
|
Use of "Where" in Query Total line
Tue, 30 Sep 2008 06:31:00 -0700
I have a Trips form and a Visit sub form, the Visit sub form has a sub form
called â??Tripsâ? in the trips form.
In the Sub Sub Form â??Visitsâ? I want to filter the pets to only show the pets
from the customer selected in the primary form.
Should I be putting â??Whereâ? in the â??Total:â? line. When I pu ...
|
|
|
Query searching multiple fields
Tue, 30 Sep 2008 05:52:02 -0700
I'm a complete novice so bear with me. I have been asked to set up an
enquiries database that includes an Enquiry field, Keyword1, Keyword2,
Keyword3 and Keyowrd4 fields (among others). I would have preferred one
keyword field with free text but the boss, you know ...
How do I set up a query across all thos ...
|
Using 3 criteria to filter a report?????
Tue, 30 Sep 2008 03:16:01 -0700
Hi guys,
I am trying to sort out a form (linked to a query) for a database which will
allow the user to enter 3 criteria to filter records and view a report. The
criteria are;
1. Journal Name
2. Start Date (beginning of records the user is interested in, eg 01/01/08)
3. End Date (end of the records user ...
|
what does this VB program mean
Mon, 29 Sep 2008 19:16:30 -0700 (PDT)
Public Sub AddTitles(strFile As String, intRows As Integer,
astrTitles() As
String)
On Error GoTo Err_AddTitles
Dim appExcel As Excel.Application
Dim bksBooks As Excel.Workbooks
Dim wkbBook As Excel.Workbook
Dim wksSheet As Excel.Worksheet
Dim intArrRow As Integer
'Initiate a ...
|
