Recent content by ddskorupski

Thank you for the posts. but I am not looking for help with nested iifs. I am looking for help in create a select case or switch function. This is why I gave a description of what I am trying to achieve. Again, I do not want a nested iif to work so I will not be posting my statements. I am...

As I said in my first post, I did not bother to type in the exact, proper code because I just don't have time. My nested iif statements are typed in properly. As I said, I believe that Access 2007 believes this to be too complex. This is the reason I am looking for a select case or switch...

That is what I did. only one iif will work

thanks for the quick response. I did that. A query will not work, even one by one. It looks like a select case or switch could work but I have no clue how to build them. Any ideas?

ok. I need serious help here. I use Access 2007. I have what I thought should not be a complex query but I cannot get the query right. I have searched this forum for answers on select case and switch and honestly have no clue how to do this. here is what I need to happen:(not correct...

Hello. I am designing a new database (Access 2003). The objective of the database is to integrate data from separate data sources. The primary data source will be where I want to pull the correct data elements. The secondary source will the be data that needs to integrate into the primary. I...

Hello all. I finally figured out (at least I think) all I need to really begin using my database to it's fullest. Now I am trying to decide how to design a form that will display a multitude of information from more than three tables. Here is what I need your opinion on. I want to display...

Thanks HITechCoach. However, I am not duplicting any data. The data in the transformation table has the same application name and id but different dates. That is why I need to compare the two tables and record history change.

Hello. I have three tables: tblMaster; tblTransformation and tblhistory. The tblMaster table has all of the master records that we report off of. The date fields in the master table contain our baseline dates. The tblTransformation table has the same fields and records but the date fields...

Hello. Can you help me figure out how to get this append query to show data that is null? I have three tables: tblbasetable, tbltransformationtable and tblhistory. The query looks at tblbasetable joined to the tbltransformationtable. It appends to the tblhistory table. The criteria is...

Got it. file size was to big. Had to compress.

oh, sorry. try this one...

Hello Everyone! I am in desperate need of assistance. I am trying to create a database to track date changes to 8 fields. I think I am making this harder than it needs to be. I am attaching a spreadsheet with the fields that I need to track. BAsically, I will receive a spreadsheet that...

Oh, is that all? ;) you make it sound so easy. I actually came across a history db I found on this site under database samples. I am trying to use it as a basis. I'm not having much luck though.

Thanks docman. I agree about the changes which is why I want to create a version copy of the records before I upload or query the changes. Any idea how the table structures should look and how the relationships should be?