Search results

  1. P

    Trim Function

    I have generated a report which i based on a query. The problem im having is First name and last name fields.I want to trim blank space so for example Louise Wood looks as typed not Louise Wood. I know the trim function can do this but im not to sure where on the report to place it??! Any...
  2. P

    snap shot

    I have a report which is based on a parameter query.I have outputted the report to shapshot so i dont loose any formatting. the problem is when i open the document all i can see is the report header and everything else is blank? any ideas pls:)
  3. P

    multiple table qrys

    im trying to create a qry to extract information between two dates i have used between [enter start date] and [enter end date] which works fine based on one table. the problem im having is i need information from several different tables which i have tried but when i run the qry it returns...
  4. P

    qry between dates

    any advise on qry's between dates, i need to generate a report that pulls out info between two dates eg start 01/09/03 end 07/09/03 any suggestions?
  5. P

    relationship trouble!!!

    please help this is driving me mad!!! i am trying to set up a database dealing with customer complaints. I currently have tables as follows tblestablishment - name of place etc tblcustomers - firstname, last name, address etc tblcomplaint - there are several different complaints such as...
  6. P

    outputting a report to word

    Question?? When outputting a report from access to word the whole format changes.Does anyone know how to keep the format the same as in access???
Back
Top Bottom