|
|
Selecting the top 1/3 of a table by
ASP.Confused
I have a table with 306 records. If I select the top 33.333333333 percent,
it's returning 101 rows. It should return 102 rows.
Thinking that this was...
|
|
4 |
135 |
|
|
Correct Profit Margin (%) by
LJG
Hi Guys,
This might be a really dumb question, but can anyone advise the correct way
to calculate profit margin %
I have /
i.e £4.19/6.98 = 60% (no...
|
July 17th, 2006 01:12 PM
by LJG
|
2 |
104 |
|
|
Query Code and Form by
Russ
I created a simple database that will be used to track company purchases. I
created three tables (main, list of departments, list of vendors). I created
a...
|
July 17th, 2006 01:12 PM
by Russ
|
6 |
198 |
|
|
|
|
3 |
135 |
|
|
Borders disappeared by
Shely
Hi
My webpages no longer show their borders!
Last week, for no apparent reason, the web extensions "turned themselves
off". This has just been fixed at the...
|
July 17th, 2006 03:12 PM
by Rick B
|
1 |
88 |
|
|
|
|
2 |
108 |
|
|
Export to Excel?? by
Ket
Hello,
I am using Office 2003. I have an access db that contains a number of
tables.
I have been asked to export two of these tables to Excel. The issue...
|
July 17th, 2006 05:15 PM
by Ket
|
0 |
97 |
|
|
Access 2003 Query by form by
Nightfall
Hi! I hope I have this in the right discussion group. Here is my problem: I
have a form which is to be used to enter query criteria for up to 14 fields.
I...
|
|
2 |
153 |
|
|
DateDiff Calculation Off By One Year??? by
Ronster
I'm running a query that requires that I convert a YYYYMMDD text
formated field to a valid date, then use the converted date to
determine the person's current...
|
|
5 |
153 |
|
|
Update query only works the first time by
Jacine
I am having a problem with an update query for an inventory control form.
There are several bin locations with a numeric field for how many there are
in each...
|
|
4 |
126 |
|
|
Using Totals w/ an Updateable Recordset by
Jamie McD
I have two tables with a one to many relationship, well call them A and B.
I have a continuous recordset form based upon this relationship.
The issue I'm...
|
|
3 |
85 |
|
|
|
|
2 |
101 |
|
|
Multiple Query Parameters by
Sheenalis
I have a query that pulls project numbers, task numbers, and cost types. I
want the parameters to ask for two project numbers, and task number and a
cost...
|
|
4 |
163 |
|
|
Global Var in queries by
Scott Burke
I have a global var "G_NAME"
I would like to use it in a query.
Is it posible?????????????????
Scott Burke
|
|
2 |
103 |
|
|
SQL Syntax Bug by
In need of assistance
I'm writing a query and I'm getting a syntax error but I'm not seeing it
when I look at it and the error message isn't telling me where it is at. For...
|
|
2 |
104 |
|
|
Column Order in Output by
[email protected]
I am using an Access query with fields in a specific order to create an
Excal file which will later be used as data to import elsewhere.
I am finding that the...
|
|
1 |
67 |
|
|
|
July 18th, 2006 12:27 AM
by
|
3 |
113 |
|
|
|
|
1 |
81 |
|
|
ad post and related fields by
Maria
This seems like such a simple thing to do but I just can't seem to get
started. I want to create a query that allows me to enter the Name and
despription in...
|
July 18th, 2006 08:45 AM
by Maria
|
4 |
98 |
|
|
simple Update statement by
x-rays
Hello all,
I have a simple Update statement,
Update INNER JOIN ON .Make =
.Make SET .Make =
.MappMake
Where .Type = "G";
is the table I want to update...
|
|
3 |
96 |