HI. I have used an SQL union query to join 2 tables and created a table from this query. Then i've used a totals query to identify duplicate records based on...

Hello All, Using Access 2003. I have a strange situation when I create an append query. One of the tables is not available from the list of tables that is...

I have a large database of patients that I have set up a query to only select patients in a specific floor. I want to create a table/form in Access OR...

In Access XP I was able to create shortcuts for various database objects to the desktop so a user could immediately bring up a form or report. I upgraded a...

I have tblAgency with frmAgencyDetails for viewing the details. Most of the fields are locked for editing as people were overwriting certain fields. I have a...

Hi there I am starting to write VB for my databases. Good so far but in some databases for example when I am in the VB Editor and write "DoCmd." I get a list...

I have a field named cost and I need to increase it by 15%, how do I enter that expression in a query?

The following code is in a query, written in a New Blank Query, not using the Grid. The code when run yields "Invalid SQL statement Expected "DELETE",...

Good Day, I have a form that is linked to a query. THere is a search combo box that the user can use to select a specific record and view the details of...

Hi. I was wondering how Access ( 2000 an onworth) are handling concurrency issues when performing transactions. ( If I am in the wrong newsgroup please point...

I'm using Access 2007. I have a query that I print from datasheet view. I need to draw attention to a specific column. When I try to change the background...

I have two tables: Customer Orders: fields are Customer Number-autonumber, First Name-text, Last Name-text, Price-currency, SKU-Number. The other table is...

I have a field in my table that is text and has any of these combinations. AM PM AM/PM I want to run an update query dumping certain fields (Including the...

I hope I can explain this clearly. I have a table that shows budget, current month cost, and year-to-date cost for certain cost categories. The budgets and...

I am creating a database to compare about 5 different tables (we will name them Table1, Table2, etc). I created a query to compare via Building Number (Each...

Hi folks, I'm using Access 2003. I have a table that includes foreign keys to several other tables. I'm trying to write a query that will pull data from the...

I have a query that counts on a field. There are no matches in my critera so it results in a empty output. How do I show a 0 in the result if no records...

I am trying to create a query that appends records to a table based on the remaining percent to 100%. I have records that have the percent build complete on...

sigh ive inherited a database that is a little broken with my new job. =] it is relational but its not. i could go into depth and detail but wont unless...

Hello, I'd like to write some javascript with a query. I'd like to generate some script that looks like this: var myDoc =...