Search results

Thanks! Easier than I thought it would be. :)

Hello! I need to create a report that compares 2002, 2003 and 2004 data by month by week (defined as groupings of 7 days). I've created a cross-tab query with the data I need but am having trouble with the report... can someone help? See attached what I mean. The cross_tab_report.jpg is the...

Yeah! The partition function seems to be my savior. thanks a lot :) daniel

Humm... it seems that the Partition() Function is what I'm looking for. What would the syntax look like? My table looks like this: Invoice Date Amount Customer ..etc.. The [Date] field has the date I want to compare while the [Amount] has the $ value for comparison. Partition([Date].... )...

Hi, I've searched the forum but couldn't find an answer for this one... if it has already been answered I apologize. I have a table with data for 2002, 2003 and 2004. I need to compare weekly data but we know that week1 in 2002 will not have the same number of days as week1 in 2003 or 2004. I...

Hi, I've searched the forum but couldn't find an answer to this one... I have a form based on a query that summarizes a table showing only ID, Name, etc... and a button to open a second form where I show the details of the selected record. I'd like that when I click the button, the form...

OK, was able to find the info myself by going to Microsoft's Knowledge Base. Here's what they say about this if anyone else needs to know: *********** To recover an AutoFormat style, follow these steps: 1. Start the copy of Access that contains the AutoFormat style that you want to...

How to recover an autoformat option I accidentally deleted one of my autoformat options... is there a way of bringing them all back to the original settings? thanks! daniel

Thanks! Works great!!!! Thanks a lot :) daniel

Hi there, I'm running Access 2000 and have the following problem: In my form, I have a text box (F_Path) with the file path to a word document. The code I'm using to open it works great, but when there's no path or an invalid path, it brings up an unfriendly error message with the options to...

I have a Dsum function in an event on a subform that reads: Totals = DSum("[Paid_Amt]", "tblPayments", "[Custcode] = " & Me.CUSTCODE) The problem is that when executed, I get the following error message: Run-Time error '2471': 'The object doesn't contain the Automation object 'ABC." (where...

Word gives you more flexibility when formatting your text and playing with pages.... and also because the person that will run and modify the letter is not familiar with Access.

Simple question: how do you do a word mail merge when you have the following table structure: table: Customers customerID customername customeraddress table: Invoices customerID invoice_no invoice_total It's a one-to-many relationship between those two tables and my letter in word needs to...

Humm... does DSUM work if the data type is currency?

Hi, I tried what you suggested but it shows #Error in the field where I have the Dsum expression. The expression I'm using is: =DSum("paid_amt","TblPayments","Custcode = " & [Forms]![frmCustomer_Main]![Custcode]) Maybe I'm doing something wrong?

I have a main form with two subforms: - Tracking - Payments The main form contains customer info (ID, Name, address) while the payments subform is a datasheet with fields "payment_amount" and "payment_date"; the tracking subform has "total_due" and "total_paid". I want to calculate the...

Thanks Paul, I'll try that. :)

I'm using a DB in Access 2000 to perform a mail merge. I've created a report (the letter that will be sent out to customers) successfully and have each customer on a separate page. The problem is that some customers will receive a one-page letter and others will receive 2 or 3 page letters...

I have a report that is based on a table with information like: Customer_ID Customer_Name Customer_Address Invoice_No Invoice_Total The report is grouping customers and showing each invoice related to a customer. Each page has a different customer with his/her invoices listed. I also added a...

Hi, No, I'm still stuck! Any help is greatly appreciated :) daniel