Re: show the attributes of the selected records
Thu, 11 Dec 2008 11:15:40 -0600
Jenny wrote:
>I modified your codes to add another critirion for select on.
>ON (Ttable.QFINAL = XTABLE.MinQFINAL AND DateValue(Ttable.DateTime) =
>XTABLE.DayMin)
>One more question is that I want to include in the query that:
>if there is a record with QFINAL= zero beteew 2:00AM to 7AM for a day then I
> ...
|
Query is asking for a parameter that's not there.
Thu, 11 Dec 2008 08:31:02 -0800
Whenever I run my query, it is asking for a parameter that is not a part of
the parameters. Here is the SQL for the query:
SELECT tblProspectComplete.Destination,
Count(tblProspectComplete.Destination) AS CountOfDestination,
Sum(tblProspectComplete.[InitialR/OAmt]) AS [SumOfInitialR/OAmt]
FROM tblProspectCo ...
|
How to display only 3 letters of a last name in field
Thu, 11 Dec 2008 07:42:15 -0800
I have a muni court on Access 2003. Judge wants me to print out a list of all
"outstanding balances due" so that any of the other personnel can take a
payment from a defendant when I'm out of the office. I created a query that
works fine but with underage defendants, I have to protect their identities
and ma ...
|
Union Query
Thu, 11 Dec 2008 07:23:02 -0800
I have a table - Reportsdue
with multiple fields such as reportname, fiscialyear, towhom,
also with
reportduedate1
reportduedate2
reportduedate3
reportduedate4
I need to create a query/report that allows the user to input a month
requested
Example: Reports due in the month of May (5)
so I began with a ...
|
List all records that appear more than once
Thu, 11 Dec 2008 06:50:04 -0800
I have a query named readmit_2 that lists medical encounters. I need to build
another query that lists only those encounters that are a readmission. The
distinguishing characteristic is the Medical Record # (mr_num). If the mr_num
appears more than once, it is a readmission. However, I need all the records
t ...
|
SEARCH QUERIES VERY SLOW - HOW TO IMPROVE SPEED?
Thu, 11 Dec 2008 05:26:01 -0800
Hello,
MS ACCESS 2003 on XP PRO.
I wrote search panel for my database. I used to have it setup where it
would pull all the data together into one query and then run the criteria
searches on it. that took 2 seconds.
A buddy of mine with database training recommended writing steps of queries,
such that ...
|
Calculate difference in Sales by comparing month yearwise
Thu, 11 Dec 2008 00:50:14 -0800
Hi, I am having dataset like this, Period field Type is 'Text'
Product-Period-Sales
X-2007/01-10000
X-2007/02-5000
X-2008/01-15000
X-2008/02-3000
I would like generate final output that will show the difference of sales by
comparing current year month (2008) with last year month. Please suggest me
quer ...
|
|
|
IIF Statement in a Criteria In() statment...?
Wed, 10 Dec 2008 15:34:01 -0800
In the query in questions there is a field where I need to place a
"In(Select...)" statement in the criteria but the catch is that the "Select
statement within the In() string would have to reference one of two queries
within the same database based on the value on an open form as indicated in
the IFF statem ...
|
Iff Statment in a IN() string...
Wed, 10 Dec 2008 15:25:00 -0800
...
|
How can I make the name of a record an attribute in a table?
Wed, 10 Dec 2008 13:36:05 -0800
Hello,
I have several tables that look like this:
ProteinName Signal ProteinAmount
A 10 20
B 5 20
C 30 30
(about 1000 proteins)
I have about 50 of these tables.
I want to make a larger table suc ...
|
