|
|
help in calculation by
sheela
Hi
I need help in some calculation. It is easy in Excel, which I used to do.
I have a table with multiple fields including stimulation (text),
replication...
|
January 19th, 2006 09:47 PM
by sheela
|
4 |
347 |
|
|
Update Query changing text to number by
shark1966
I am running an update query that is updating text to CLng. I receive a
message that all the records weren't updated due to a type conversion
failure. All of...
|
|
4 |
88 |
|
|
|
|
4 |
100 |
|
|
Multiple parameters by
LizJ
Can someone help. I need to retrieve peolple's addresses from a table. The
only criteria I can use to identify these people is their ID number (an auto
number...
|
|
4 |
116 |
|
|
Altering fields in a query by
Mark Olsen
Hi,
I have a question that I really have no idea how to resolve. I am working
on a database that I have read-only access to. The problem is is that I...
|
|
4 |
112 |
|
|
Table or Query information by
James McDowell
I would like to know of a query that will tell me the type of each query
within a database, AND what tables/fileds it updates/makes.
OR
query each table within...
|
January 19th, 2006 08:49 AM
by Mike
|
4 |
157 |
|
|
Exporting Delimited Files by
Stryker22150
When exporting a query in delimited format with null values the data is
pushed to the left. I need to be able to maintain consistency. I have
discovered I can...
|
|
4 |
136 |
|
|
How To Write Query by
Martin
FieldX in some records in TblData contains a value while in other records it
is null. How can the query be written which gets the criteria for FieldX...
|
January 19th, 2006 03:09 AM
by Martin
|
4 |
124 |
|
|
Help with time difference query by
red skelton via AccessMonster.com
Hi everyone,
Can anyone help me? I have a query that is giving me a problem and I cant
figure out why. I am using the same DateDiff format three times in the...
|
|
4 |
207 |
|
|
|
January 17th, 2006 10:00 AM
by Arno R
|
4 |
105 |
|
|
QUERY DATE RANGE by
hotrod1952
I AM A NEWBIE: I am writing a query in Access97 to pull data in between two
dates. The expression I am using is: Between
And in the critera field. The...
|
|
4 |
109 |
|
|
Querying by Primary Key SSN with Count by
Wendy Lee
I have created a form keeping track of "Clients", primary keyed by SSN.
Another form was created to keep track of "Client Cases" each time a
client comes in...
|
|
4 |
169 |
|
|
Ranking by
DDR
How do you write an expression or SQL statement that will rank data. I have
employees that make calls that I log in your database. I have a rank number
that...
|
|
4 |
92 |
|
|
|
January 13th, 2006 04:00 PM
by LeAnne
|
4 |
147 |
|
|
Multiple IIF Statements by
Susan
I have several checkbox fields in a query. I want the checkboxes, "if= -1"
to show in another field on the query, the checkbox fields will not show. I
have...
|
|
4 |
126 |
|
|
Group By, Count, and Like by
LFNFan
Hi
I have a table containing a Voucher_Number field and a Status field. The
Status field data type is text, and records contain values: Used, Expired,
Void,...
|
|
4 |
71 |
|
|
Date Querry by
jb ellis
My db has a birthday field in short date format (mm/dd/yyyy).
How do I querry for all birthdays in say Jan, regardless of day or year?
|
|
4 |
140 |
|
|
|
|
4 |
134 |
|
|
Append Query by
Chey
I have three tables
Provider info
Provider Monthly Info
Months
I need to take all 12 months and append them to every provider in provider
info, but I need the...
|
|
4 |
101 |
|
|
Select Case in Query? by
Sandra Grawunder
I have a rather complex series of calculations I have to do on a field in a
query for a silent auction. For instance:
To calc the new field StartBid:
If is 0...
|
|
4 |
178 |