I am trying to link two tables using a field but the po # in one of the tables includes leading 0s and the other does not. As a result, Access doesn't see...

Good day. I really need some help! Someone here at our offices deleted a Access database file. I retrieved the file, but now it doesn't want to open!!!!!! It...

I have this SQL SELECT QryHisacctable.CORP, QryHisacctable.DIVISION, QryHisacctable.FACILITY, QryHisacctable.DST_CNTR, QryHisacctable.PCC_SMIC,...

HI, I have a singe table and 2 queries based on the same table. One query is a Select query with some criteria. The second query is one which uses the...

Iam trying to create a table from a query that has 10 columns of data (real numbers) I would like to extract the data in the 10 columns row by...

It has come to my attention that sometimes, when I open a Query in SQL View, the SQL that I see is not exactly the same as the SQL in the Query's Querydef. The...

Have 2 queries the names are "CustomersNoSales" and the other "CustomerSales", both have a field named "CID"(CustomerID) and another field named...

Hello Is there a way to group the fields in a select SELECT DISTINCT statement so that the distinct part works only with the first three fields and...

I have a fairly simple table that I am trying to query and am having problems with one of the parameters. There is a field that simply holds a Yes or No. I am...

Is there any way in a query to do a running total like records? the output that I am trying to acheive is this: teacher class period student stu_no Mr....

Is there a way to do an append query and set a particual field to a value in all records appended? I am currently using for exmaple: INSERT INTO SELECT *...

I create an append query on Access as follow: Parameters p_field1 decimal; insert into table1 (field1) values (); The field1 is a decimal field with 2...

Hi, This is not so much a question as a sharing of something I've come across. It won't be earthshattering nor epiphanous, but it might prove helpful. I...

Hi, I have as saved access update query called 'qupdEnvironmentActivate'. The SQL for the query is as follows: PARAMETERS Text ( 5 ); UPDATE...

I currently have the computer inventory at work in one table. I have created new tables with relationships and I want to append the data in the existing table...

I want to join two tables A and B. Both have multiple columns. The field that is exactly the same for two tables is "Phone Number". I want to put all fields of...

Hello, I have a database in which I have two fields; called "1st Notice" amd "2nd Notice". Both are date fields and are formatted as medium date. I have a...

The select query sometime does not return all the records with in clause for ex. select * from modelmaster where model in ('a','b','c') will sometimes return...

Hi, I am building queries for duplicate payments reports. I have the query working but when I go to run it in the report I get an error message (error 3079) in...

I have the following tables: Address, LState, Country, Contact Every Contact has one or more Addresses. Each Address may or may not have a State or Country. ...