I am importing a table from another app. It is passed as an excel spreadsheet. I have a routine that "cleans up" the sheet, then imports it into a temp...

Clifford helped me out yesterday with an SQL for selecting all the STATION_ID records for which there are zero values OR non zero values in the VOC field. I...

Hi, I am trying to create a query that uses 13 different tables to be a recordsource for a form. When the query runs , I can see all the data but cannot...

I have a table that is created by an append query from 4 other tables. When I use the append query, it creates duplicate records. For a record to be...

Hi, In Access 2007, in a query, Design view, the status bar, botton left, has "Form View" listed. Can you tell me why? Thanks, Gene:)

SELECT X.* FROM PPG AS X INNER JOIN PPG AS Y ON (X.BLY.BL) AND (X.Ship_Date=Y.Ship_Date) AND (X.Consignee=Y.Consignee) AND (X.Ozip=Y.Ozip) AND...

Hi I have a query that lists records from three tables. The query lists all patient visits to a doctor’s office. Each record has a diagnosis code (i.e....

In my query I am asking it to pick the min or first date associated with an Sales Doc # and a material. There is also a field called LDB. On the line with...

I am importing a table from another app. It is passed as an excel spreadsheet. I have a routine that "cleans up" the sheet, then imports it into a temp...

Access 2003: I have a table with two columns. The first column has the same information repeated over and over to match up with the unique information in...

Hi, I am trying to create a query that uses 13 different tables to be a recordsource for a form. When the query runs , I can see all the data but cannot...

I have 2 tables with data that includes "Part Numbers" in both. I want to create a Query to list all of the data in the first table, but not for the "Part...

Access 2003: I have a table with two columns. The first column has the same information repeated over and over to match up with the unique information in...

hi, i am using access 2003 and have a .csv that i imported into a table. i need to extract a list of computer names that do NOT have our custom service...

I have 2 tables with data that includes "Part Numbers" in both. I want to create a Query to list all of the data in the first table, but not for the "Part...

I have recently name a query and it is working how it should. However one thing that I would like to add to it is a dropdown list of things to choose from...

I have 2 tables 1. Clients 2. Orders In the orders we enter an order id (ie: 2100, 2101, 2102). For instance we have tbl_Orders C_ID O_ID

Hi Can anyone please help me add to my statement? Currently it returns text based on data in a string field on our database. What I need to add is that if...

I'm trying to Make a criteria in a query. Pull today's date and the past 6 months of data. What i have so far is.. =Date()-180 But this is not working.. ...

I'm trying to Make a criteria in a query. Pull today's date and the past 6 months of data. What i have so far is.. =Date()-180 But this is not working.. ...