I am having difficulties building a rolling average, and hoping that somebody out there knows how to do it............ I've tried building a query that will...

I'm trying to set up a database to allow us to record What software is on which computer. I've set up a table list ing the software information, and one with...

I am just learning access. I need help with query. I need to count the number of records in a query with a certain field that is empty. Once i get a total, I...

Hello, I have a table named "A". Table "A" has 3 fields, the first field is Autonumber. I have 2 queries, first one is the query that delete data in table...

I'm having a strange problem. Before importing my excel spreadsheet, I ensured all the fields were properly typed, Date, Text, etc… I am having a problem...

i use a query which is based on another query. i get "system resource exceeded". 2003 version. -- Message posted via...

Hello, I have the following scenerio: An Engagement is made up of 5 Assignments to be completed sequentially by different staff members. When the...

NeoFax wrote: I have a table that contains part numbers, allowed ship duration and date of change. So, there are multiple instances of the same...

JimP wrote: I have an append query that uses a pass through query (to a SQL Server db). When the db that is referenced is small, the query opens up in...

I have a parent table (tblPt_Gen_Info) linked on one to many relation to another table called Schd. The parent table has a field called . It is the primary...

I have one query that pulls records from a table and sums the quantities from several fields (transaction quantities). It is an inventory table with...

Hello, I have the following scenerio: An Engagement is made up of 5 Assignments to be completed sequentially by different staff members. When the...

Hi, I am bit new to the access world, I created a table with ID as default primary key assigned by Access. Now I want to update fields in ID for every row so...

My production is in Access 2003 with tables in Access 2000 format. When I deploy the program what they will be using is Access 2000. Will there be any...

Hi, when I run the following query , I get the following error : compile error. in query question 'nz(dmax("iteration","tbl_rndnumstore"),0)+1' INSERT INTO...

http://www.photonews-fotovideo.it/videos/24/salvataggio-acrobatico-di-un-operaio-a-torino

I want to get last five entries in a table using query builder.

http://www.photonews-fotovideo.it/videos/24/salvataggio-acrobatico-di-un-operaio-a-torino

If the form for my criteria is closed how do I write the criteria to look for the same field name in another form that is open? I placed the 1st option in...