Search results

Hi All, I'm really confused with this one. I have a report based on a dynamic crosstab query using the method I found here: http://support.microsoft.com/kb/328320 The report itself run perfect and all of the data is correct when I view in either Print Preview or Layout preview modes. The...

Hi All, I've spent the last two days trying to figure this out - searching all over the web! I'm fairly comfortable with vba / access but this one has got me stumped! I have chart (grpMaster) that is embedded in a form (frmMain), the chart is a line graph based on a query (qryDataFilter) with...

Morning, I have the following sql in vba to add up all the values of a column (tblscrap.transqty). I then want to sort on this criteria. I have put this into the query and the query works fine, so i've copied the sql into VBA but get the following error Run-time error '3061'. Too few...

Hi, I'm putting together a simple db report to list the top 10 items, in order, in the report. I've got the code i need to calulate the spacing and listing etc. but i'm stuck with actually getting the correct data I need. I have form with two boxes on it, txtFrom and txtTo, I want to...

Hi, Apologies i've searched all over the forum and cannot seem to find an answer to this. Is there a way in VBA I can control the filter of my pivottable based on the value in a text box or even based on an array of items in a list box? Any help would be much appreciated Cheers Chris

Hi, I have data which is set out as follows: PartNumber | Sales Wk52 | Sales Wk51 | Sales Wk50 etc.. 12345 | 122 | 150 | 179 I need the data in the following format so I can compare it: SalesWeek | Item Number | Usage Sales Wk52 | 12345 | 122 Sales Wk51 | 12345 | 150 Sales Wk50 | 12345 |...

Hi, Apologies i'm failry new to SQL and am really struggling with this UPDATE query. I have two Tables "Stock" and "Stock Master" They both have "ItemNo" fields and also "Quantity" fields. All I want to do is transfer the "Quantity" from "Stock to "StockMaster " where the "ItemNo" is the...

Hi, Really confused with this one and wondered if anyone could see where i'm going wrong. I have two tables tblHistory and tblTemp both table have the column "07/04/2012" set as number type All I am trying to do is append the data from tblTemp into tblHistory using the following command...

Hi All, I have a bit of a prob I can't seem to solve: I have a spreadsheet which lists sales for the past 52 weeks, and appears like this: Part no Description Wk1 Wk2 Wk3 ..... 05113 Door 15 20 17 I need to convert the above...

Good Morning! I’ve been browsing the forum and although its helped me alot I can’t seem to get the following right and wondered if anyone could help? I have two table tblHeader and tblData, the tblHeader contains the following field, Part number, Description, Price, Supplier Code, Supplier...

Afternoon! I've been searching the forum but can't seem to find what i'm looking for, hopefully someone will be able to help with my problem? I have a table that contains sales data from the past 24 months, the table is in the following format: Part number | Description | 21/11/11 |...