Browse by Tags

Export Access Report(S) to Section(S) in Word

Hi, I have never done exporting a report to a bookmarked section in Word before and I really do need help on this. I have seen from other posts that it can be done for (1) report and a section in word.. however.. My question is: 1) Is it possible to Export different Report(S) to different Section(S)...

Posted to Access (Forum) by microsoft on 01-18-2010
Conditional Sum in a Query, Similar to sumif

I have a set of invoices that have different expenditures. I want to combine these expenditures into a larger class of expenditures. Example: Regular Contractor and Health & Saftey Contractor: ContractorTotal Regular Materials and Health & saftey Materials: AgencyTotal Is there any way I can...

Posted to Access (Forum) by microsoft on 09-19-2009
Make subform invisible ormodify query to accomadate

I am in the process of normalizing our database. Our old system was primarily based on one large 78 field table. There are some aspects that make that simpler to work with but much more rigid and way less expandable. Anyways, we have a financial form that has a number of fields in it. Most of these fields...

Posted to Access (Forum) by microsoft on 08-31-2009
iF AND THEN STATEMENT

Piece of cake in excel but I can't seem to figure out in access Here it is in excel: If(and(1lue out of range") I keep on getting syntax error messages, I have done If then statements successfully...If and doesn't seem to translate. Any help would be greatly appreciated.

Posted to Access (Forum) by microsoft on 08-11-2009
Print report on one page

Hey Guys, Is there a way to print a Access report on one page? similar to the fit to x pages by y pages in Excel?? I have a report that occassionally goes to two pages and I tried selecting the Can Shrink option to a Yes, but it didnt help (I also have a sub-report as the report footer and I set that...

Posted to Access (Forum) by microsoft on 07-20-2009
Specified Expression not part of an aggregate function

I have a query where I want to take two different classes of expense and total them for each invoice and have those totals in one 'record'. So if PO number 2 has a $3.00 & $ 5.00 Regular Material items and a $9.00 Health & Safety Material item. The total in the query would be PO Regular...

Posted to Queries (SQL) (Forum) by microsoft on 06-24-2009
Update subforms rowsource based off of combobox

Is there a way to change the rowsource of a subform? I have an In/Out board subform whose rowsource is contingent upon a combobox in the parent form. The records in the combo box are people and groups. cboBox source: Jim Office Field Phil James Supervisor The Many to many table associating these people...

Posted to Access Forms (Forum) by microsoft on 06-24-2009
Problem: Microsoft Access-Grouping records and getting stats (percentile rankings, averages, etc)

I have let's say 1,000 records with the following fields - portfolio name, date, peer group, and number of stocks. I want to create a query that groups the data set by peer group and report the 95th, 75th, 50th, 25th and 5th percentile of the number of stocks by peer group and date. I know this is...

Posted to Access (Forum) by microsoft on 06-05-2009
Problem: Enumerate Results in SQL Query?

Is there any clean way to enumerate the results of an SQL query in a listbox? The main reason for asking this is that I need a way to count the row/results so if I sort them, the row number is consistent. Thanks in advance^ Code Snippet: 1: 2: 3: strlist2 = "SELECT (SELECT Count(ID) FROM Assignments...

Posted to Other (Forum) by microsoft on 05-31-2009
Problem: Transfer Records from SQL Server to MS Access

BACKGROUND 1) I have the following tables in SQL Server DB: SQL_TABLE1 with fields: F1A, F1B, F1C SQL_TABLE2 with fields: F2A, F2B, F2C 2) I have the following table in MS Access DB: MDB_Table1 with fields: M1A, M1B, M1C 3) I need to query the records in Table1 and Table2. The record filter is based...

Posted to Access (Forum) by microsoft on 05-30-2009

Page 1 of 2 (17 items) 1 2 Next >