Search results

  1. M

    An easy one i think ?

    Hi - I think this can be quickly sorted. I use the following code in my query to merge together my customers details to 1 field: LeadName: [Title] & Space(1) & [FirstName] & Space(1) & [LastName] I want to do it for their address, what do i use instead if SPACE so that i get a NEW LINE each...
  2. M

    Too many records in my golf query !!

    My query is a multiple table query across customer details, golf courses, hotels. As i build the query say with just customer details, then it is fine in that the customer details, name,address etc appear only once. The trouble starts when i want to know what courses they are playing at. If...
  3. M

    Formatting an email sent via access

    Hi, I wonder if anyone can help? My email code is working fine in that it pulls certain info from my data base into an email. It also then merges it with a mailbody word doc template which has other text in it such as the ending of the message, my name, contact no and disclaimer text. The...
  4. M

    Compile errors in queries

    All of a sudden none of my queries work properly- all the criteria and calcs i had in them have been deleted?! Basic codes do not work any more e.g >now() ;between 1 and 30 etc If i try and write a new query using the same expressions and code they just don't like it - YET they were working...
Back
Top Bottom