Search results

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...

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:)

sorted it john ....cheers

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

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...

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...

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...

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?

convereted i think!

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?!

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?

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...

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...

how do you output to snapshot??

Thanks tony will give it a go

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???