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

    relationship trouble!!!

    sorted it john ....cheers
  4. P

    relationship trouble!!!

    thankx a million, it works!! but why do i have to enter start and end date twice?:D
  5. P

    relationship trouble!!!

    great stuff, thank you seems to working for me ok now...one minor question! how do i get thedate range i.e 02/09/03 - 09-09/03 to show on the report automatically also is there a way to get customer first name and customer surname to show with a only a small space inbetween instead of a huge gap...
  6. 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...
  7. P

    relationship trouble!!!

    Hi Jon, the information which is required on this weekley report is bits from different tables eg customer first name and srname from tbl customers shopid from tbl shops area manager id from tbl area managers...etc....i have placed the criteria under date of incident but still no records...
  8. P

    relationship trouble!!!

    JON, In tblshops, the am field im asked to enter paramter value it then lists am surnames how do i iget both first name and surname?
  9. P

    relationship trouble!!!

    convereted i think!
  10. P

    qry between dates

    date qrys will always be from the previous week ie rpt next week 07/09/03 - 14/09/03.... probably a stupid question but this is all new to me where do i type this criteria?!
  11. 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?
  12. P

    relationship trouble!!!

    here we go Jon Hi Jon, Thankx for all your help so far, Please find attached what i have structured so far, i also need to add a resoloutions table but im not sure how to establish a correct relationship and with what table.Im still fairly baffled by 1-1 1 - many etc and im not sure of the...
  13. 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...
  14. P

    outputting a report to word

    how do you output to snapshot??
  15. P

    outputting a report to word

    Thanks tony will give it a go
  16. 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