Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Hierarchy of calculations in access
Name: jerrycreedon Date: May 17, 2007 at 03:01:22 Pacific OS: windows NT CPU/Ram: pentium 4 Product: dell
Comment:
I have been trying to manipulate data from a fairly complex database. I am creating a report that is counting a specified field once it has gone through a query and a couple of filters. The SQL statement became too long for the complete calculation. I have now decided the break up the operation and then calculate the final result from these smaller operations. I am however nervous as to the hierarchy between the first set of operations and the final operation which brings them all together. How can i be sure that the initial operations will be completed before the subsequent operation calculates the final answer?
Summary: Im trying to implement a function in Access 2003 to allow the application to find a given field from a give another field in the same record. e.g. I have a table of Assets called tblAssets, im trying ...
Summary: Is there a shortcut key in MS Access 2000 for adding a new record? I haven't found one, and when I want to add new record in form view, I have to click the >* -button or scroll to the end of the recor...
Summary: Sorry, I was'nt very clear. I have set up a macro with an import specification for a text file which has records for 4 fields, into a table. For example the file which has: Product Date Quantity Co...
