Using 2 tables I want to get the rows that match where the content of the field (string) is equal or is into other field (string) from other table.

Hello, Within my qry I would like to calculate the average daily production for the month. The data Im working with is: production volume, dates (which is a...

Hi, I doing a calculation in a query of the difference in times. I'm wondering if I can control the decimal precision to be just (2) places. The number I end...

I just installed Office 2010 (May 2010 version from Technet download) and many queries that worked in 2003 and 2007 now will not open and produce the error...

I have some sql queries involving the use of between clauses, similar to the following: select Colors1.*, sum(Colors2.freq) as TFreq from OldColors as...

Hello, I have the following Input tables Table1 Serial Item Date SerialandDate 123 Item1 01-04-2007 12339173 123 Item2 01-06-2010...

hello, this is my first post in this forum. I have the following problem and i really need some help because i am about to go crazy. I cannot understand why...

I am trying to develop a report where in the PartNum footer the average number of days between orders is calculated. I have created the...

How do you filter numbers? ex. 1 through 200 in order?

I have an inspection table to keep track of rooms in various buildings. These rooms are shared with different supervisors. One inspection of a location would...

Hi all, Kindly solve my problem. I have a mdb file. tables created t1,t2,t3,t4. fields are almost same in all tables, but the data is different in all...

Hello, I am fairly new to Access and Excel. I am trying to write a formula/expression, but I think my problem is as simple as having the parenthese in the...

I have tried to follow many of the suggestions in other posts, but have not been able to get this to work. I have a table called DailyCalls and another table...

Dear all, I have 2 fields, Eng and Math. I would like to set the parameter query for Eng and Math == Eng min, Eng max, Math min and Math max. The Eng query...

I have to loop through the data from one table (demand) and calculate total supply expected depending on the data from the other tables, here is example and...

I have a simple query that pulls data from a single table containing some basic client information. One field is a text field containing alpha-numeric data. ...

Hi all, Kindly solve my problem. I have 2 tables stock_received , stock_utilized. stock_received fields -- date,3pcs,4pcs,boxes. stock_utilized fields -- ...

I have a table (tblTerms) with 2 fields & . The typical terms in the table would be 2%10 Net 30 with having a value of 30. I then take the difference...

I am having a problem figuring the right way to pull specific data from within the text of the table's field and separating it into a unique...

Hi, I am getting duplicate results when I run a query. Here are the details. Bothe tables have the same data only dates have changed. what I am trying to do is...