Hi. I have got a table with around 20,000 records in. I need to be able to bring back a 10% random sample of the records 'actioned' by user. e.g. User A...

I have a create table query where I would like to add an addditional column that is an autonumber column. How can I reference autonumber within the SELECT...

I need to match up records in two tables based on PART of a field, which could be variable in length. For instance: Table1 has a field with data "Project1",...

Ok, thanks to Allen Browne and his great website, I've gotten a good bit done on this db I'm working on. I've got 2 main data entry forms and 1 data...

Is it possible to export a report instead of a query into excel? Thanks, Jasper

Hello all, Let's assume i have the next query: SELECT * FROM CUSTOMERS WHERE CUST_NUM= in the querys tab, and named QUERY_CUST Now, in a form in a click...

Good morning, I have the following query: SELECT dbo_Clients.Cltnum, dbo_Clients.Cltname, dbo_Clients.Cltsort, dbo_MM_Fixed_Fee_Payment_Info.,...

Hi All Need a little help in calculating the maximum concurrent connected calls in a half hour based on a dump of start time and end time of 4000000 call...

Sometimes I need move records from one table to another table. I always need to insert into and delete from 2 queries to complete the task. Are there any...

I have a query, and when I run it I want the user to input criteria for one field by selecting an option from a drop down menu. I am currently typing in the ...

I recently upgraded my OS from Win 3.0 to 3.1 on DOS 5 and can't figure out why IE8 will not run correctly - any advice welcome .... -- Steve

Hello, I need some help setting a criteria for a query based on the selection made on a form. Background: When my database opens, I have a form that...

I've created a temporary database to do some quick calculations. It hasn't turned out too quick, however. The sum and count functions are taking the...

I have a passthrough query where I have to manually edit the dates for the information I need. I would like to utilze a form & enter the start & end dates...

I’ll try and simplify this by only including fields from the tables in question which are relevant to the query I want to perform. First of all, I’ll...

Hi I have a Access 2003 PivotTable query where I need to insert a calculated item to calculate the difference between 'Actuals' and 'Forecast'. Sample table...

Hi I have table called Product listing. Product listing A B C and my total overhead to produce all product above = $10

ocity ost ozip dcity dstate dzip consignee shipdate a b c d e f catsur 1/1/2008 h f g d e f catsurd 1/2/2008 p k l o z t cat 1/2/2008 l st mn d e...

I need to append all records, from several tables (several fields) to an empty table, programmatically. The entire process takes about 12 seconds. I am using...

Hi All Hope someone can help with this one. I want to set up a query to run from a bunch of combo boxes. If the user selects none, then all records should be...