Hi everyone, I'm not sure if this is do-able. I have a database where patients who have had particular tests are entered. Until recently I didn't have a...

I have a continous form that displays the results of a query. The criteria for this query is a part number. I would like to have on that form a text field...

I am trying to make a report baised of a query that just shows the data in the query. the problem i am having is the in the query the data shows up correctly...

The Left function from Espression building not returning proper value. When I tried to put character lenght = "3", or "5" or "7" they all return no value. ...

I have a table that includes a list of all payments (check number, amount, supplier, date). For each payment there is one of three different company numbers...

I'm trying to create a query in which Access will count the number of "Yes" or "No" answers based on a survey. Is there a way to do this?

I am having a problem with a query i thought would be easy. My table looks like this: Urban Suburban Rural 1 0 0 0 1 ...

Access 2003 database converted to Access 2007 Query will not now run, because error: undefined function 'chr' in expresssion worked fine...

Hello, everyone! � I’ve run into another dilemma…. We did a data dump from our system into a csv file and this file is over 120,000 rows. I cannot...

I am trying to perform an update query using 2 tables. The first table is a billing file with many records per employee id and there is also an employee...

I am trying to get just the last 6 months of data from todays date for the current year. SQL below works if your in the 7th month but, when I set my system...

I have more Burea Work Comp records which I want to match with records (1000+) on another table which doesn't have BWC policy numbers. I am trying to match...

I have a query that sums up several columns and gets a count from one column. Is it possilble to make anther column that takes the sum value of the the...

Ok, I have a table “tblEmployees�, with employees training data. Out of this table I created some queries: by training date, by employee manager, by...

Hi, I am working on a query and I was going to use UNION but I want to make sure it only pulls all the criteria requested in my search. I am doing a Vendor...

I have a table that contains: Project, Phase, StartDate, Month1, Month2, Month3,...Month48 Ecah Month column contains the number of hours spent in that month...

I'd like to use the values from rst (DeptQry) instead of the items selected. Here is my current code for the items selected. Please let me know how to change...

I'm new to this... hence the difficulties. I have two tables each with two fields. The first field is a date (mm/dd/yy) the second field is a number (single...

I have a make table query that looks great on the screen, but when I run it some of my number or currency fields get created as text fields in the new table....

I am trying to run a complet query and see ALL records I have product table and a sales table that I am joining. I have use the outer join getting all...