Search results

Thanks, unfortunately it seems like the Concatenate function will only work for very simplistic data. most example cases are 1 company name - many order dates. my issue is that I have 1 property - many processes. but the processes are quite elaborate. I would have a 'type' field, a value...

would SELECT DISTINCT not solve our issue?

If you have a one - many relationship between data, normally in the table it is captured, you would find multiple rows for every 'thing', each row detailing different 'functions' performed on it. Is there a way that one can display these functions horizontally, instead of vertically, i.e, have...

I think I should just clarify, I want or need to filter or set a criteria for every 'year' field. not just OBJ year.

I didn't intend to send my complete DB, because it has thousands of tables and hundreds of queries, it would never be small enough to post to this site, due to their size restrictions on files.

ah, thanks, seemed to have worked. So now to explain what I want to do with it, there's one table in the ZIP file and one query, the query contains all the fields and all records (no filters or criteria) I want to maintain the above, but you will see that each record has a few date/year...

I used winzip, the file is named 'Database issues.zipx'

I am trying to add a zip file, yet I get an error, it says invalid file? why would this be?

Hi again just a quick and hopefully easily resolved question - does access have the ability to create a query where all records are present, all fields are present, yet some data within some fields aren't displayed?

Data(table): replaces (the ID) jobconf bankref buildingname municname erf deedtown portion farmname sectional_title unit size suburb yearstart firstname emailaddr surname accountnumber pptype:Dormant ppvalue:Dormant value pptype:78 ppvalue:78 value ppyear:78 year categories:78 categories...

Fair enough. Here's my situation, I have properties listed in a table named pmnproperties - I have the 'work' done on these properties in a table named newpropprocessinfo. - the relationship between these two tables = many records per property. Now as I briefly mentioned above, this created a...

maybe I should have provided more info. the query only contains one table. but the table is built from two 'make table' queries, and about 7 append queries that update these two created tables. - or something to that extent. the company has multiple 'types' of work, that can be done per...

I have a query that carries all the properties in our database, and data for when our company 'worked on' properties. Each property falls within a certain province and municipality (this is slightly irrelevant info) , we worked on properties in a period from 2009 - 2013/06/30 this period is...

Hi peeps, I manage the data of a small company in South Africa, the knowledge that I have of Access was acquired at my time at the company (the past 4-5 years), I don't really use extensive access functions all that often, I have a bunch of set queries in place and use those to extract lists...