Search results

Hi I am trying to extract all numbers before a space, no problem with LN: Left([Custom label],InStr([Custom label]," ")-1) Except this will return #Func! where there are no spaces after the number Example 1234 yth will return 1234 but if the number has nothing after it i.e 2456 I get #Func...

Thank you for your answer can you give me an example please

Hi I am trying to copy a single record from one table to another Heres what I have I have a suppliers table, suppliers order table and suppliers orders detail table I use this to generate an order for the supplier, however the single order does not always arrive at the same time (the order is...

Hi I am trying to get the info for sales from last week (ending on Saturday and new week starting Sunday) and this week starting on Sunday case 4 and 5. For some reason I can easily go back 7 days from today but not last week that ends Saturday I am really struggling with this Heres what I...

I have been having problems trying to link access form field to a word form field. Word is opening as it should but the field is empty. I am trying this with a blank word document with only the 1 linking field txtTitle and the name of the db field is frmTitle I did notice that the word document...

Can someone please point me in the correct direction I am trying to change the button color on a subform if a related form data changes Main form is products with a continuous subform with serial numbers of products i.e, serial number, location, price and a button to add addtional issues if...

Sorry for not being a little more explicit. I have a report with callouts for the next week show date, time customer, address and phone number I would like to filter these using a combo box set for either todays callouts or tomorrows callouts or the next 3 days or this week call outs. I am...

Can someone point me in the right direction to filter reports by specific date types in a drop down or combo box I would like the dates to be Today Tomorrow The next 3 days and the next 7 days i don't want a date picker or between dates I have tried searching but cannot seem to find an answer...

Thank you very much, the corrected formula is Cost: IIf([CourierWeight]<=20,10.45,IIf([CourierWeight]>20 And [CourierWeight]<=30,([CourierWeight]-20)*0.35+10.45,([CourierWeight]-30)*1+(10*0.35)+10.45))*1.255 Works great

Thank you for your fast response. I have tried the corrected formula and it works great until the weight hits 32kg and then it doesn't calculate correctly It should 31kg = £18.76 32kg = £20.02 The formula at the moment is correct at 31kg £18.76 but at 32kg it shows £37.52 which is not correct...

Hi I am trying to use a formula that I am using in excel and cannot seem to translate it to access. The excel formula is =IF(A1<=20,10.45,IF(AND(A1>20,A1<=30),((A1-20)*0.35+10.45),(A1-30)*1+(10*0.35)+10.45))*1.255 Thank you Mr Excel for your help on that I am trying to use it like this Cost...

FANTASTIC.....worked a charm Thank you very much for your help Kim

Worked a treat on the first field, but on this field Picture: "http://www.domainname.com.com/" & [Picture.FileName] I am getting error Invalid bracketing of name [Picture.Filename] Thanks Kim

Thank you for your speedy reply. Can you guide me to an example of how this maybe done?

I would be grateful for some help on a default value in a table. I use an empty table with a couple of fields with default values in i.e. category: (default value is) Home, image url: (default value is) www.domainname.com/images/ I then append a query to this table which will then be exported...

Spot on, thank you.

I am trying to calculate the sales figures using the formula below which gives me the sales results for June 2009 but for some reason I cannot seem to get it right to give me the results for May 2009 and April 2008, can anyone give me a pointer please. =DSum("Total","AllSales","[OrderDate]...

Thanks for the reply. Sorry but thats not what I am looking for Is there a way I can just get last weeks sales so if its ran today oe tomorrow (Fri or Sat) it will show last weeks sales. I could do a between but I would have to change it every day when I want it to run. Basically there a re a...

I am slowly getting there This gives me the last 7 days sales but I am still looking to get last weeks sales =DSum("TotalSales","AuctionSales","[OrderDate] > DateAdd('ww',-1,Date())") Any more advice?

Thanks for the reply. There is data in the date range The table is comes from is a linked table to another db The query in the current db is based on OrderDate, TotalSales (per order id)