Hi, can anyone tell me how to sum two table by using a query Table A Table B 1 2 2 3 3 ...

Hi, Im encountering Numeric field overflow error whenever I run Append Queries on the fourth times. Could you help me resolve the problem?I've already...

Hello I want to return records containing the Name, Address and Location fields only, from Table1 where the combined fields Name, Address and Location are are...

Hello All I have a query which is apparently "typed incorrectly or is too complex ....". The sql is: SELECT A1.absencedate AS thisabsencedate, A1.SorN,...

I have a field which has a date and time stamped in. I use a query to retrieve record based on date range. The criteria under the date/time field is as...

I have a query that prompts the user for a date, but because the date field itself is a "general date" which includes the time, every time they type in a...

I have a problem with a query that I have been working on for a couple of days now. My problem is that in my query there is a date constraint and when I...

I have this code. It is a conversion code from data in my table that has numerous types of measurements, i.e. lbs, oz, fz, ea, etc. The most common outside of...

I create a table that have a column name "CommissionPaid", and three options selection from a form: 1-Yes, 2-No, and 3-NA. When the data is enter, it...

My database contains an "inventory" of controlled documents and all their past and current versions. I have a query that searches for all the archived...

I am having trouble getting accurate results with a cross-tab query. In my cross tab query I am trying to get a list of unique doc ids with a count of...

I have a single table with 5 fields containing numerical data between 0 and 3. I would like to sum the 5 fields. For example, field one has a data value of...

I have the following crosstab that gives me the desired results: TRANSFORM Max(qry_Reports_Meeting_Schedule_1.Time) AS MaxOfTime SELECT tbl_ScheduleTimes.ID,...

I now know how to update a field, with text such as "record found", based on the contents of another field. I use something like this: update tableb,tablea...

I have 3 queries: query 1 has date, agent and # of calls fields, query 2 has date, agent and # of accounts worked fields, query 3 has date, agent and # of...

Hi All, Can I combine 2 or more records become 1 records using Access query? Here is my data: Client ID Info-1 Info-2 Info-3 AAAA ...

Greetings, I have two tables of about 10 columns each, which share 5 common columns. Is there a way to join the tables together, and join then on those...

Sorry, but I have read many postings on this subject and just don't get it. I am getting the following error: "This expression is typed incorrectly, or it is...

I have query with a field and a field. I am trying to work on a Status field which will return a result. The query is that if the completed stage is null...

Hello, I am trying to create a query to capture the total count in each WC where the operation corresponding to the WC vary and can be multiple operation per...