Help running 5 queries with same input criteria
Wed, 1 Oct 2008 22:24:40 +0100
I have 5 queries that I run every month into which I put a start date
and an end date. At the moment, I have to run each query separately &
must input the same start date and end date in each. I put them into a
macro, but it still prompts me for the start date and end date of each.
Is there a way that I can inpu ...
|
date range OR ALL parameter query
Wed, 1 Oct 2008 14:04:02 -0700
OK, I've spent enough time trying to get this query to work. Time to call in
the experts.
I want a parameter query inviting the user to select records by a date range
OR selcet ALL records by leaving the date dialogue box blank.
I thought this would work but it does not -
Between Nz([start date],0) And Nz ...
|
Please Help
Wed, 1 Oct 2008 14:02:58 -0700 (PDT)
I know I'm being a pain but. I still can't get my query to do what I
need it to. It pull the date that contain dates within this month but
if an employee has a date that expires in this month it pulls all
dates for him accross the board.
Lincense Safety Card
Crane Certi ...
|
Problem with DateSerial
Wed, 1 Oct 2008 12:41:02 -0700
I'm having trouble with a SQL Script I'm working with.
SELECT tblDetails.Fund, tblDetails.Budget, tblDetails.RstrCat,
tblDetails.RstrCatName, tblDetails.ObjectCode, tblDetails.CobjDesc,
tblDetails.FiscalYear, tblDetails.Amount, tblDetails.ReportMonth,
DateSerial(IIf([ReportMonth]>6,Left([FiscalYear],4),Righ ...
|
Need search within each value to check against a list
Wed, 1 Oct 2008 11:49:01 -0700
I've done a lot of searching and cannot find anything within the forums or
access itself that will do this (and my VB experience is limited to writing
macros for word and excel). Version used is 2003.
-Basically this is what I'm working with; it's only a small part of what I'm
actually out of a very large d ...
|
Date conversion
Wed, 1 Oct 2008 10:36:00 -0700
I have a date in a mm/dd/yyyy format and I want to convert it to a yyyy/mm
format that I can sort. I tried doing Year([Order Date]) & "/" &
Month([Order Date]), but that converts it to text. I am ok with leaving out
the / and using . if that would make it work better.
Thoughts?
Thanks! ...
|
create record with a query in the same table
Wed, 1 Oct 2008 10:17:01 -0700
Is it possible to create a record for a table with a query? I have a table
that has a moisture status (dry (1) and wet (2)) and color fields. The color
is ALWAYS the same for dry and moist. If I manually populate the dry color
and its associated color, can I query and make a new record for moisture
status ...
|
|
|
Minimum
Wed, 1 Oct 2008 10:11:01 -0700
Hello,
I have a query that works for me except I need to show just the first record
at each change in a record in a field.
Here is the SQL:
SELECT Import.Postcode, [FN Branches].Brand, [FN Branches].[Branch Name],
[FN Branches].Sortcode,
([Part1]-[Part2])*([Part3]-[Part4])+([Part1]-[Part2])*([Part3]-[ ...
|
Query returns 9 records with criteria that exists in one record
Wed, 1 Oct 2008 10:07:04 -0700
hello - my query has a field, Parcel Number. Criteria in this field is a
field from a form the person enters data into. that part works.
my query also has a field Type so when a person chooses record 01, which is
a weed type, they get a weed report.
problem - When I specify parcel number 01, the query retu ...
|
Dividends for stock report
Wed, 1 Oct 2008 09:41:01 -0700
I have two tables, one with a list of all of the stocks in an account. The
second table has dividends paid by stocks. I am trying to return a report
which will the list ALL of the stocks in an account in one column and in
another column list any dividends, if there were any. The problem is that
when I mak ...
|
