Search results

Can I insert records into a query that joins 3 tables? I need to do an insert statement into 3 different tables at the same time. Is it possible?

Can someone tell me how I can properly email a form so it looks like it does in access. I tried email a form by clicking on the menu. I can send it fine but it looks very sloppy. It looks like a query with numbers running off the page. I know it prompts you for a template option? Can...

Do you know if I can add more queries after a Union? New select statements that are not part of the union? I want to make this form but I need more records pulled that are not part of the union? Can I combine multiple queries in a form? thanks

I have this Union Query that works great. I want to run a select statement right after it. Can someone tell me if my syntx is wrong or the sub query is wrong. The Union works great on its own. SELECT TOP 1 Inventory.Inventory_ID, Location.Location_Name, Product.Product_Name...

Thanks Alot Man, That worked great.

Thanks for your help. I have attached the table and results Its still not working quite right. Please help

The Statment gives me the correct bottom record for the first statement but gives the correct top record for the second statement when I need the bottom record.

Can someone tell me if there is anything wrong with this statement. It pulls the right data in the first statement but always the wrong data in the second. I want it to pull the last record in the table that meets the where clause? The first statement pulls the last record (which is correct)...

Can someone tell me if there is a function to select the Bottom records in the table? I know there is a select top 1 fieldname from table etc.

Thank for your response. I have a table that Product, Client, Job, Delivery. I was just wondering if it is possible to add new records through a form rather than getting people to go to the actual table itself. The Job Table stores the ProductID, Client ID but all the info about the...

Can someone please explain what this message means. I am trying to add a record to table with a form. I am guess it has something to do with multiple tables the queries data comes from. Cannot Add Record(s) Join Key of Table 'Delivery' not in Recordset Is there another way to add a record...

Nope that does not work, That returns all records. I should have between 10-12 records returned See attachment

That is progress, but it is just returning records for the most current date entered which is today. I need it to do that plus return records for the other locations for the most current date entered, which is not today. thanks for helping. I am sure there is a way to do this.

I need the most current record. For ex. Location 1 Mon 45 1 Tue 10 Location 2 Tue 10 location 3 today 55 A date range won;t work because I don't want it to select duplicate records

The between Date thing won't work. I want the most current Inventory level regardless if it was today. So I want 1 reading per location. some might have Mon levels, some might have wed for example.

I have this query which is selecting the current days inventory. Can somoene tell me how I can write an SQL statement so it selects not just the current day but also the most recent days inventory for fields which are not entered on that date. I have inventory locations but one might be from...

Ok, I fixed the query by remving the Sum and the Group by Clause and the Query stiill works. However it is still not updatable. Am I to assume that queries that perform calculations are not updatable? I am not trying to edit the totals, just the other fields. Is it possible? thanks for...

Can someone tell me why my query is not updatable. I have created a form with this query and would like to update data when need be. All this query does is make a few calculations. thanks SELECT Client.Company_Name, Product.Product_Name, Delivery.FC_Number, Delivery.Bill_of_Lading_No...

thank you, It worked

Can someone tell mw how I can set this calculated field to currency. I can't get it to work somehow. Total_Price*[delivery].[Act_Volume] AS Total_Priced_Volume