Search results

I have 72 tables all the same structure. I want to put them all in one table. How can i do it without making 72 append queries? Thanx already, Denjuan

I work with access 97 (i know it is old) and i want some people who can only read in the whole database and some people who can write and read in the whole database. Is this possible? Greetz, Denjuan

I have a field with values like: 1234AB 1235JH 1239FF I only want the four first characters. Is this possible in a query? Already thanx Denjuan

I want to run a macro in one database from another. How can I do this?

I got the message: 'Too many fields defined' When i want to run a query from three tables. It will be around 400 columns. Does anybody know how much columns Access can handle? And is there a way (SQL Server??? Oracle???) or something else to have them all in one table? thanks already, Denjuan

I have a table with fields called: Categorization, % of sales. I want to cumulate this field. It must look like: Categorization %of sales cum: candy 5% 5% Gum 2% 7% Chips 4% 11%...