Search results

Yep, the union query has sorted it! Thanks Pete!

Yeah, looks like you got the right idea now, thanks, will have a look at some union querys then! Cheers

Thanks for the response, I have tried adding the extra column to the query and this has compiled the records into a single field, however this is not quite what I wanted as one record now displays four account numbers. As i want the account number to be selected individually, this does not...

hi all, I have made a form to run reports on a database, however, I need to add a field where the end user can enter an account number and the report will find the relavent fields. The problem is that the account numbers are stored as four different fields within the database (add_char1...

Hello there, sorry for the delay in response, The data in the report is created via a pass through query so it is impossible to change the data type. Does anyone have any other ideas for a workaround? Cheers

Hi all, I'm trying to make a report which brings up a number of records depending on their renewal date. When the renewal dates were entered into the database they were not entered in standard date format (ie 01/01/2005), but were input as a mixture of full month names and abbreviations e.g...

Nice one dude, has worked a treat, cant believe how long i was looking for that! :D

?Anyone know how to Limit the number of characters in a field? Hi all, Does anybody out there know how to limit the amount of characters given in a field in a pass through query? I only want the first 5 characters of a field in a pass through query. For example some typical records would be...