Search results for query: *

I have a form which runs off an sql query. It has several subforms and controls. When the query retrieves no records it goes completely blank. Both the subforms and the controls disappear. I cannot find a way to stop this from happening. Is there a way? Is there an event or state which can...

There are indexes set up on both the despatchDate and the stockCode fields. However the I have linked the tables from another database set up on infomix so I cannot alter the design of the tables. I have overcome the problem by making the query perform a the calculation first(orderNo) on the...

I'm sorry that my syntax isn't great as I haven't been using databases for very long and I am trying to recall it from memory. Access has automatically but the group by clause into the statement, so I don't think that it is that which is causing the problem. Thanks anyway.

The query i am using is quite simple SELECT OrderLine.stockCode, Sum(ORderLine.orderQuantity) AS SumOfOrderQuantity FROM OrderLine WHERE OrderLine.despatchDate = Date() If I just run SELECT OrderLine.stockCode, OrderLine.orderQuantity FROM OrderLine WHERE OrderLine.despatchDate = Date()...

If you make sure there is a project Id in both of the queries {or another unique key}, you should easily be able to run a query off the query results. SELECT * FROM qryRevDiff, qryCurrPeriod INNER JOIN qryRevDiff ON qryRevDiff.projectID = qryCurrPeriod.projectId; Or something along those...

Craig0201, I can get the information without any problem it is just when i try to sum the quantity field on each stock code that it does this. So I don't think it is the size of the table which affects the speed of this particular query. But I'm not sure. How do you know if there is an...

I have a query which takes orders for today and sums the order quantity for each stock code. When this is put on the networked pc it takes 5 minutes. Why??? If I sum all of the orders it is immediate. If I choose the stock codes from an In() list it is immediate, even if I choose exactly the...

I’m using a Matsonic MS6383E motherboard with an AMD 500 K6-2 CPU and 192 Mbytes of RAM. I have a TNT2 graphics card and Hercules Fortissimo sound card attached to the two PCI expansion ports in the board. I’ve downloaded the relevant flash utility (AMIFL815.exe) and BIOS upgrade (63830930.rom)...

I'm a student on work placement and I'm having a few problems with Access. I need to decrement the fields in two tables by the amount entered into another table. The tables are Stock and Batches. Stock is for batches previously made and held in stock and batches is for batches being made that...