I am using Access 2007. I am trying to create a query that will select a particular cell at an intersection of a particular row and a particular field name. ...

Hi, I'm sorry if this is very basic but I haven't had much sleep lately. I have three tables: Machines Processes Process Instances Machines is a listing of...

I have a query based on phone numbers. My database distributes billing based on the number of hours each month an individual bills to a certain project. The...

the record I need to move from one table has different field names than the table I need to move it to how do I map which fields to copy all the data into...

Hello, I am trying to create an append query to append only records that were changed anytime when the query is ran. Another way of saying is append only...

am trying to write a query in Access, but I am having problems. If I write it like this: IIf(!!=True,!!, "") than it works just fine. However, as soon as...

I would like to set a query whereby I will locate data that will occur on a future date. That is, if I have a date field with 01/01/1999 and that data...

Ok, here is my situation. I have a table where you can enter deposits and withdrawals for an account involved in a specific investment. Then I do a query...

Im sure this has been asked before but i cant seem to find the right code. I have fields that are Start Time, Finish Time, Lunch In, Lunch Out and Hours...

A query can access values on a form, when the form is open. Is it possible for a query to access the values in: 1. A global variable? 2. A document...

my table is called employes. In this table I have fields called NAME JAN FEB MAR throu DEC and YTD I'm wanting a query that will update YTD with the total...

Hi, I have a table called "tblOrders", with has following field (example): Order_Num | Created_Date | Customer_ID ...

I have 2 tables 'DC Ship' and 'Receiving'. I need to compare the trailer numbers (in both tables the field name is 'Trailer#') from a user specified date in...

I am having a problem as to how to approch this. I have 8 tables with different structures serving different purposes. Each table has a field named "Region"....

I am current using a Union Query like this: SELECT Region, Count() AS Count, Sum() AS Sum, Avg(-) AS , "A" AS MyTable FROM GROUP BY Region UNION ALL SELECT...

I have a table with five columns the first three are text the last two are numeric. I have five rows of data in the table. I set the values in the first...

To start, I'm terrible at Access, but good at all forms of VBA. I have been trying to create a query for the last few days without success, and would...

Thanks in advance for any help. I have a query, with: BUCKET_VALUE: Sum(Round(,2)) and I would like to have a comma displayed in between the thousands and...

I have been asked to do some work on an existing very simple Access table of names and addresses plus some other info. Postcodes appear to be straightforward...

i copy a picture to my form and then when I go to my report the picture is gone. If I stay in forms and scroll thru the picture stay but as soon as i go to...