Recent content by PatrickB

n/m i see the error of my ways. INSERT INTO Application_Table ( XID, APPLICATION ) SELECT [User_app_assignment].[XID], [User_app_assignment].[Application1] FROM User_app_assignment WHERE ([User_app_assignment].[Application1] Is Not Null) GROUP BY [User_app_assignment].[Application1]...

INSERT INTO Application_Table (XID, APPLICATION) VALUES (SELECT b.XID, b.application1 from User_app_assignment B where b.application1 is not null group by b.xid);

I need help with something i want to accomplish in a report. I have a main table that all the info is based on. I need to write a huge if statement because i don't have time to normalize the data. The if statement is going to a create a record in a temp table if the field is not null. Then i...

what did you think about the temp table solution? go through each program field if not null create a record in a temp table then in the report display the temp table. kind of like a suedo list.

ps thanks ken for the help!

any tips on making it look like a list doing the concatenate? another thought i had... do a check through the database dump each answer that isn't null in that field into a temp table. just some ideas. create a row for each non null value. at the end delete tempfields. i dunno how exactly to...

its based on department no department has over 35 or so applications. tables are setup by department. in the table u have all the info for that department. i understand this isn't the best way. I just don't have time to fix it to be the best way. I can do cross table counts I do believe to get...

any faster way to get this done? there is over 400 applications. Any given user has at most 35.

just housing all kinds of data at the moment. but i am using it to pull reports for what programs each users have. i also use it to pull how many users total have program1 etc. what do you recommend to normalize the data. its pretty straight up. there is a X in the field if the user has that...

I am writing a report. I need a query that or any other method for this report. that can output without null values. I have not used access report builder much. example i need a list of programs for a user the data in the table looks like this program1 program2 program3...