| Thread | Last Post | Replies |
|
| How do I get a spreadsheet to print fullsize? | 15 Nov 2006 17:48 GMT | 1 |
When I print a works spreadsheet it downsizes the document instead of printing it full size on my paper. What do I do to get it tio print full size?
|
| Truncate phone extension | 15 Nov 2006 17:43 GMT | 7 |
I run a query for exporting purposes. I do NOT wish to alter my existing table. That said, how do I truncate the "ext: ..." from the query results? As usual, help is greatly appreciated.
|
| Take out SumOFMyFieldName from Query | 15 Nov 2006 17:31 GMT | 3 |
I have a few queries I am exporting to Excel. Is there a way I can automate or perminatly change the the field name to only show the field name and not the SUMOF portion that is at the beginning of my calculated fields? If so how would I go about this?
|
| add records to a table from a recordset | 15 Nov 2006 17:12 GMT | 1 |
i am creating a recordset in code that I want to dump into a table so I can pull from it in a query. is this possible? how? here is the code i have to create the recordset... Set qd = con.CreateQueryDef("", sql8)
|
| Pass one parameter date? | 15 Nov 2006 15:59 GMT | 4 |
I am exporting two reports from one button on my form. I have two queries running 2 seprate reports. How do I go about passing the parameter to the other report? In other words I want the user to type in the first and second date only once to open the report, not twice. This ...
|
| Searching Data Base | 15 Nov 2006 15:43 GMT | 2 |
I have Access DB, I have tables, one of the tables is cust_details. The table has fields like: cust_id cust_name cust_address
|
| Query in Multiple Fields | 15 Nov 2006 15:13 GMT | 1 |
I have two tables with mostly the same fields. Specifically, they both contain a field called "Author." I would like to design a query that allows me to search in both "Author" fields, while only having to use one parameter/search term, and so the resulting table contains the ...
|
| Calculating Material Usage | 15 Nov 2006 14:56 GMT | 7 |
I need to summarise the amount of inventory used over a specified period, I have a query that gathers this data but I need to calculate totals for each inventory item not the summary used in each BOM. The problem is that each inventory item is used in many Bill of Materials and ...
|
| adding product qty fields from multiple records to transaction record | 15 Nov 2006 14:49 GMT | 3 |
I need to take a field value from multiple records in one table and append those values to the end of an associated single record in another table. (Or, create a third table.) I am an Access newbie -- having gotten by fine with Excel until now. I have Access 2000.
|
| Query to combine records based on matching criteria. PLEASE help. | 15 Nov 2006 14:12 GMT | 10 |
Hello all, I'm new to access and having some difficulities. Any help I could get I would really appricate. I have two tables from which im trying to combine records. I have 4 fields in each table.
|
| Query or Form for criteria between . . . | 15 Nov 2006 13:16 GMT | 2 |
I need to I need to set up a mailing list with criteria such as: 541101 - 541105. Is it possible to do this? I've been working on this for a while! If it is not possible I'll have to filter each criteria # individually and I have many.
|
| Select Query | 15 Nov 2006 13:15 GMT | 3 |
I am new at the use of access. I am using Access 2000 on a Windows 2000 system. My question is (if possible). Select records with the greatest date field. Example:
|
| Concatenate text | 15 Nov 2006 12:55 GMT | 3 |
Here are my fields. [Figured] This field is sometimes blank. [Cut] [Veneer]
|
| Consumption during time window | 15 Nov 2006 12:32 GMT | 3 |
As part of a safety stock - reorder point analysis, I want to compute the historical consumption during specified time windows. As a start point, I have a list of all net consumptions per day (Material|Plant|Date|Consumption). Till now, I used a not-so-quick-but-dirty method by ...
|
| Change field type from VB | 15 Nov 2006 11:00 GMT | 2 |
I have an Access database with a table containing a decimal field wich has these properties: precision: 18 scale: 5
|