Search results

I'm kinda new to this still, so I will explain the whole issue. So I have been given a list of information. This list outlines the people responsible for each program that we test, as well as version numbers, application numbers etc. and it contains about 1000 programs. I need to extract the...

Hey all, I have been given the task of organising a mail-merge with a sharepoint list, but the names and emails attached to each object are seperated by a delimiter. Furthermore each person is associated with many objects, and they want the merge programmed to only send 1 email to each person...

I think i probably need to explain a little better. The 200 tables are needed as each record contains a series of steps to complete, and there can be as many as 30 records. I floated the idea of having them altogether but management wanted it seperate, which to be fair makes the testing...

Hey all, Am currently planning the re-design of a database I made for work. It was buggy, over-complex and I am hoping that you might be give me some help about how to get around a few of the errors I encountered last time. Be warned I am very new at this. Firstly, is there a way of getting...

Hey all, I would love to ask for some help structuring my database but my table structure takes some explaining, is there an easier way of posting this information? Cheers, Greg

To be honest, I have NO doubts that the database is probably poorly structured, as it started as a way to show my boss that we could do things better, and then suddenly I was tasked with building one with no real databasing knowledge. I managed to find a work around, but this whole damn database...

Hey all, Wondering whether it is possible to use the 'Make Table' function in conjunction with a union query. My early attempts have failed and I am relatively new to Access. I am using Access 2010. Thanks in advance, Greg

After some fiddling I have come to the conclusion that if I could get an earlier query to output as a table it would reduce the complexity of the query above, solving the issue. However the earlier query is a Union query and I can't seem to easily combine the two. Does any know what the basic...

Hey All, Recently ran into the 'Query is too complex' error while entering data into my database when attempting to run the following query: TRANSFORM Count([Summary of Tests].Status) AS CountOfStatus SELECT [Application List].[TC or #], [Application List].[Test Object], IIf([Test Status...

Can you recommend a thread or place to start? That's about as complex as the database is gonna get thankfully, so if this issue is solved I should be just about done with it anyway. Edit: Ah thankyou, so if I just make sure the SQL structures match it should be ok? Edit: Edit: Worked like...

Hey guys, Getting a weird error where my union query is scrambling the data under different headings.... SQL is below. I know its absolutely terribly designed, but I'm kinda new to this stuff, and definitely open to advice! SELECT [Application List].[TC or #], [Application List].[Test...