Hi there,

hope anyone will explain to me the meaning of pet peeves.

From the context there is one thing that really drives me crazy. I receive spam mails and mails with...

I think you can set this on a databse level.

Most of the time it works. However, sometimes EM thinks it's better to use another view option

quote:

---

Many companies put unreasonable demands on accountants, especially the big accounting firms that prey upon, excuse me, hire kids right out of...

oh my,....I'm really dumb today!

Can you explain very slowly what the rationale behind this query is?

Cheers,

Frank

quote:

---

i need something like the following:

SELECT

student

FROM

TableA

WHERE

...

Hey, I think we should give billk the chance to say what he tries to achieve

Cheers,

Frank

Hi billk,

quote:

---

i have the following Table

Table A

Student-NumberOfTests-Percent

1-5-5

1-5-10

1-3-20

1-3-30

1-3-40

1-1-50

2-5-5

2-5-10

2-4-20

2-2-30

2-1-40

3-5-5

3-4-10

3-3-20

3-3-30

3-1-40

3-1-50

i need a SELECT statement that returns students with at least

2 number of tests >=...

Hi Andrew,

quote:

---

The command works on existing tables but not on new ones..all permissions are the same and all data types seem to...

Hi sonashish,

quote:

---

Is there any tool for migrating an Access front end to an SQL back end? That is, unbinding forms, creating...

Hi Gregory,

quote:

---

How can I create *.xls file in DTS package (VBScript) on server where Excel Application is not installed ? I must...

Hi Lee,

quote:

---

In other words, Hollywood raises the expectations of everyone who is not a techie, about what techies can accomplish. ......

quote:

---

And add the date to that solution to yield

SELECT item_no, date, sum(qty)

FROM table

GROUP BY item_no, date

---

Hi Paul,

quote:

---

I have a table with three columns, Item_no, Date, Qty.

what I want to do is, select on this table but if...

Hi mkadambari,

quote:

---

I am getting the following error while creating a recordset with the field name "Price" whereas price field is existed, but...

Hi steinie,

I don't think, that there is a direct way to call API functions.

So you need to write a wrapper round it. Either COM or small exe.

What function are you...