update queries

So I am not sure if this is better to do in Excel some way or Access. So I have a Excel file with Open orders. I update it every week. Right now I do it manually. Basically I have notes on some of the open orders of why they are still open etc. So when I pull the new open order report I need...

I am trying to update from one table with a short text field that has dates, blanks and "N/A" values to a table with a date type field . Using the following in the update query: Update To: DateValue(IIf([Table1DateText]![DateText]="N/A",#12/31/2100#,[Table1DateText]![DateText])). Works fine...

Hi all, Hoping someone can guide me or help me? I have an excel work book which has multiple MSSQL queries which pulls data and puts it in to tables for reports. The issue I have is I have created an update button (refreash all basicly) however I have to keep entering the password. I know I...

I have been building a Sub in a standalone database and have run into an issue with running a query native to the same database. I have in the same sub as part of an If function, another CurrentDb.Execute and it works fine; however, when it gets to the next part of the Sub, the secondary...

Hello, I'm attempting to perform an update query to a table for the field "periodyear" and "period" using a text box and a list box that live on a form in front of the database. The text box's name is Year_Label and the list boxs name is Quarter_Label. I've had this working at one point where...

Currently, my skill set is average in Access. I leverage the tool for my own analytics (ie. pulling in tables and using queries to slice and dice the data). I'd like to learn how to use update queries and also how to build a database "front end" intended for other people to use. Any good...