Hi, I can really use some help here... I am working on a database for the risk management department that tracks "Incident Reports" - including details of the...

Hi. I need to create a query that chooses me a column based on a criteria. Imagine. I have a form and in that form I a have a field with text. So, in my...

I have data table like following Emp No Activity Date A1Value A2Value A3Value A4Value 1 3/20/2008 10 15 10 ...

Hi , I am making a comparison with 3 numbers in many records Nr1 is a static number Nr 2 and 3 are variabel. I would like to get the number that is the...

I have a query which prompts for a date range. I would like to be able to save the user's response and use the range in the title of a report. Is this...

Hi Access Wizards, I have been using the Unique Values property in the query design window. The only problem is that it uses all the fields to create one...

HI. I trying to create a query with this criteria: !!!column(1) and it's not working. It also retrieves me the folowing information: Undefined...

Hi I have a database for rentals, with an arrival date field and a departure date field. It is easy to count the days between one and the other. The question...

I have several queries that have worked fine for years yet everyonce in a while they absolutely will not run. They are "make table" Queries and I will get...

I an appneding records to an Access table from an Excel file where the data in the Zip Code column is not consistent; some is numeric while others are text. ...

I would like my parameter query to provide all records if left blank or if the end user only knows the first 3 letters of a name then it should records with...

Hello, I am trying to create a update qry that if the value in tbl ITEM is null update from table SUB on Field Description. So far I have.. Field:...

Hi - I am not very proficient in Access so please bear with me. I have a table where very often I will have many identical records in a row (maybe 24 or...

I have a table with a field that has data that looks like the following: N0345, H4354, 48574, 48577 How can I create a query that would separate that data...

I need to create a number of duplicate records in a table (the records will be edited later). I have a form that has this table as the record source. The...

I've come across a query someone created and it has criteria pulling dates. Could someone explain to me this criteria: Like Get_Find Field : oDate:...

Hi, I am creating an append query so I can track all historical data because once the orders in WIP (orderWIP table) are completed, they will be removed...

I am using Access 2007. In a previous version I created a simple query that enabled a search on Company Name; Like "*" & & "*", which was written under...

please note that in order to get the date 6/28/1979 I am using average work days each month of 21.75 I have tried to Add just the total days to the date but...

Hi, I have reports set-up which run from queries- the user is asked to enter the month which in turn pulls all training records for the month entered. Is it...