Search results

  1. S

    Date query

    Can anyone help with this...? I have 3 queries all of which filter the results by date. I do this by setting the date field to WHERE and entering >[StartDate] AND <=[EndDate] as criteria StartDate and EndDate don't exist so when I run the query it pops up a box and which asks me for the...
  2. S

    Replace multiple parts of a string?

    Hi, can anyone help me do this... In my products table I have fields such as Bulletpoint1, Bulletpoint2, MainDescription etc. Each holds part of the product description In a seperate table I have my description templates with placeholders for the bulletpoints and maindescription. for...
  3. S

    Can this be done with a query?

    Whats the best way to arrange my data for the following, and can a query do it or do I need to use VBA with an "if" command? I have the following data in my products table.... Products Courier Weight (g) Guitar Case DHL 700 Guitar Strings Royal Mail...
  4. S

    Very basic question about pasting data

    Hi there, and sorry for such a stupid question.. I'm just making the change from excel to access for my business. Most things seem straightforward but I can't seem to paste a single value into multiple records. For instance, I have a couple of hundred records. I add a new field. The first 70...
Back
Top Bottom