Hi,
I have a few tables with the same row and column headings but contain different data in their cells. Is there a query whereby I can basically merge everything to give me one view with everything in it?
Thanks
Greg.
Hi,
Ive done a search for this and couldnt find any suitable answers. Is it possible to add a function to a query that auto numbers each row returned (so if your query has 10 results, it numbers the lrows 1 to 10)??
Thanks
Greg.
Hi,
I'm new to Access and was wondering if there is a function that can split/divide the contents of one field into seperate fields like you can do in Excel via the 'text to columns' function. I have people's names (surname christianname in one field in a table and want to have a query that...