Search results

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...

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...

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...

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?