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

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.

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

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

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

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