I have a table (tbl1) that has Invoice # and Item Desc as Fields (the info i used is fictitious) : Inv # Item Desc 50014 ...

I have a macro set up that runs a MsgBox that I need to run on some specific dates at the end of the month. I would like to run the macro on the 24th, 25th,...

Hello, I have a table with field Year, Month, date, model, value. What would be the formula to calculate the current quarter average for the different...

I was hoping that someone could give me some possible reason as to why I’d get a missing operator error when my SQL is correct. It’s an IIf-DateSerial...

I have several update queries that I would like to automate the Date field to today's date and the "UpdatedBy" field to the person who's logged in...

I have an imported flat data file that has extended ASCII characters (i.e. 189, 239 and 191) in a Customer Name field. The extended characters are not always...

I have a query which has a parent and child link tables and would like to have all the records in the parent even no child for this parent. It seems MS Access...

I'm trying to create a query such that when the user runs it, the proper columns (fields appear). We have 12 columns, one for each month of our fiscal year...

I am getting 'undefined function' w/this expression in my qry. Expr1: IIf(today(),"cur","exp") How do I insert or use todays date in a Query.

I have a table that contains dollar amounts in random cells throughout the table with the remainder of the cells containing nulls. I need to replace every...

Not sure if queries is the right place for this. Please redirect me if not. I have three tables that interact on this process: ...

I have a column that is in general date format, 6/19/2007 5:34:23 PM. In another column I have a value between 10 and around 50. What I have to do is get the...

I have a large table that I want to query 2 things from. Please be patient because I am pretty new at this. I need to count the number of times that...

Hi I need to create a formula/sql that brings the previous record forward. I have a phone number which needs to be populated into the next record where the...

I’m fairly new to Access so this may be an inane question to all those experienced people out there. My question is about the use of aggregates in a...

Hi - I need to run a query to find out in a tableA field gender has some other value than 1,2,3. But this will product all records ! It was included...

I have data to report on by area, priority and days past due (positive and negative) eg 0-6 7-14 15-28 etc Newbee to Access, trying to create query by the...

Is there an SQL code or command in MS Access that allows me to export query results into an table. I'm not worried about the redundancy part as it's a small...

In Access 2003 After running the duplicate query finding all the duplicates how would I go about deleting them leaving one record.

Can I insert multiple records into a table using "INSERT INTO"., it seems it can insert only one record at one time. INSERT INTO Table1 (F1, F2, F3, F4)...