Search results

Here's what i've been trying to do: strsql = "Select * FROM tblScrap WHERE (((tblScrap.[trans-date] between " & Format(Forms!frmMain!txtFrom.Value, "######") & " and " & Format(Forms!frmMain!txtTo.Value, "######") & ")) and ((tblScrap.[reason code]) ='scrp')) ORDER BY tblScrap.TransQty;"...

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

Thanks for the help, not 100% happy with what i've had to do but it seems to be doing the job nicely. I've make two union Queries, "Wk 1 - 26" and "Wk 27-53" I've had to use two as there was too much data to have wk 1 - 53. I've then had to make another union query to merge all the two into...

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, This is a simlified version of what I require, what i have is a report that is sent to me each week as .CSV. This contains different quantities each week i receive it. I am using "Stock" as a temp table to which i import the CSV, then using VBA / SQL I insert a new column in...

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...

Thanks for the reply, I have 52 fields named in this way. This is due to report I import, it is set out as below: Part Number | 07/04/2012 | 31/03/2012 | 24/03/2012 etc.. 12345 | 2 | 5 | 3 I can easily rename these fields if you think this is the...

I've found out this error is being caused as my database is swelling to over 2gb (from 3mb) Can anyone tell me why this is and how I can just simply import the above column? Cheers Chris

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...

Perfect! Thanks for your help! Just a final question, i've got the graph working perfect now and i can compare multiple part numbers on it. I would like to take this slightly further now, I want the axis of the graph to be in week numbers, then I want to input a part number, when I input the...

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 |...