I have a database that is used to log employee compliants. A query (Details Qry) is used to summarize all of the compliants within a specified date range...

Order ID Order Date Ship Date Ship City Shipping Fee 1 11/14/2005 11/15/2005 Jakarta $55.00 2 11/14/2005 ...

Hi, I have been working on this little query for the last week and I just can't get the solution. I just hope you guys are smarter than I... Anyway the...

I have a field "0002222 Catheter". I need to create a table that just pulls out the 2222. I thought I could truncate somehow?

In MS Access i have a field that i have broken down into 6 constituent parts, 2 of the parts are in kilometers and i want to convert them to Miles and...

Please Help. :-) I have two tables that have two fields of addresses. I want to create a query that can campare the first 5 charecters of these fields only. ...

hello there. i am just learning ms access and have the following situation that i run into day after day: 1. i download weekly csv files of google adwords,...

I've been reading other posts and I'm still confused. Here is my problem. I have records that have 6 different test scores. I want to find the total of the...

I have many too many queries, which I use to gather data for a report. I hope someone can suggest how to consolidate them. For example, 8 of my queries are...

Hello, I don't really know if this is possible! I was instructed to create a database and one of the requirements is as follows, bare with me. Table...

Is there a way to display column total in a query? I have a query that gives me Prior year sales and current year sales but I would like to include column...

I want characters 15 & 16 of a 16-character field.

I'm working on a query that counts how often certain types of contacts happened between staff and clients, how many hours were spent on those contacts, and...

I am developing training material to teach how to use crosstab query wizard. My example is to show how many employees were hired each year for each...

(To start, I hate the way our database managers setup this database.) One of our databases is setup such that when a price adjustment is created, the row of...

I have a crosstab query I am using on a form with a subform. For some reason I can not get the columns to change when the dates change in query. Please...

Can someone help me with a query. I have a table like below ItemNo CostType 12345 a 12345 b 54321 a 54321 c 09876 b

can anyone see what i am not see...the sql bellow give me a syntax error on join operation, but i dont see where. is it because there are too many...

I have a query where in one column I have a calculation that is suppose to return a "G", "Y", or "R". However, due to non-existing values for some instances...

I currently have a crosstab query that I used to count the number of each type of employee compliant and summarize by quarter. For example: ...