Recent content by Xina5280

Thank you so much Pat! I just read up on 'normilization' (why couldnt they put that in Access for Dummies ;)) and I think my problem may be design flaw but before I go changing things around I would like your opinion. So I want to keep my main [Projects] table the same with colums that...

Yes it was and I deleated all the junk out. I was hoping that there was a way to not have it show up like that....if not I can live with deleting it out:p Thank you so much though!

Haha! Genius!

Ok looking at it again isnt code per se but its the "summary for 'date by month'= april 08" etc... I attempted to do a screenshot but i have no idea how to get it down to the necessary 100 kb.

I was wondering if I can use an update query for these tables -tbl cornerstar tickets- columns are: phase, date, ticket, employee, equipment, rate, description, hours, loads, price -tbl cornerstar invoices-columns are: phase, date, company, invoice #, item description, loads, tons, price...

Now why didnt I think of that? :D That worked beautifuly! Except for the fact that the SQL code is showing up in random sections on the report. Is there any way to run the report without having that show up?

Im very novice at SQL and Access in general and I am having difficulty doing a subquery from a union query. Here is the code I have so far in my union query: select Phase, [Date], Price from [Corner Star Tickets] UNION select Phase, [Date], Price from [Corner Star Invoices]; *The reason I...

Re They are located in the QUERY WIZARD because I dont know code. If I have too ill learn it. As for what I am trying to do, Ill go as detailed as possible: Table1 HEADINGS: Phase, Date, ticket, employee, equipment, rate, description, hours, total Table2 HEADINGS Phase, date, company...

Hi, I am trying to combine 2 tables with the same headings selected in the query wizard. The headings im using are Phase, Date, Total. What I would like to happen is the phases combine to match, sort by month and then calculate the totals from both tables into one column. Everytime I try to...

Re Im building a database for coworkers to use so I am hiding the navigation pane from them. The format im working on is click a button and it will go here, click another button and you will end up here. So what I would like to see happen is if you want to see detail for PROJECTX and you...

Hello, Im new at this and I am trying to create a hyperlink to open another table in the same database. When I go to edit the hyperlink the only option it gives me is for other seperate databases. Is there a way I can do this?