I have a field in a table that is a memo field that is used in a report. What method, if any, can I use to extract all of the data in this field instead of...

Hello all. This should be a pretty easy question. The following date function I'm using gives me the date one year from the current date. However, it only...

hello, can anybody help me out with this one: here is what i do: i filter a form and retrieve the resulting filter via me.filter: here the resulting filter

I have a report who's source is a query. The query is based on a number of nested queries. When the report is run the results of each of the queries runs and...

Hi Everyone, Using Access 2003 and I use the query grid to make my queries. I have a query that I have 5 tables joined. The main tables for the data I am...

I have report based upon a query that uses criteria selected from a combo box drop-down of an unbound form. This works great but know I have a need to...

When I'm sending query from Access to Excel, in Excel I get a message "File error. Some number formats may be lost." when I open the .xls file. All the data...

Original table ocity year price frankfort 2008 1200 frankfort 2009 500 hopkinsville2008 200 hopkinsville2009 120 indiana 2009 12 pa 2008 8

I need help in creating a query that will find all unmatched records in a table. I have two tables: The first table T1 has just has a record number The...

I wonder why the 'like" function does not work perperly. In my query i have want use like to filter out the result. I used like "lightnin" on the criteria to...

I know it is not the best practice to use parameter query for user input(a form is better) but I have inhereted this database and just want to make a few...

This is giving me a syntax error Update Set Hyperlinkpart(,,0)=Replace(Hyperlinkpart(,,0),"tempest","trinity")

I am have to find out a %, based on total(# of records)- corrections/total(# of records) The fields i have would be QCP_id, date, batch_id, and...

I have a table called "Students - Enrolled" and I need to create an update query that will put a "90%" in the column/field for the records that have an...

Hello, I have a table with 3 fields - Name, Lap1, Lap2. I want to create a query that will shows the result with 2 fields. The 2 fields are Name and...

Hi, I have a simple database to track each sales person's contacts and 6 different steps in the sales procress. Its not about contact management, rather its...

What is wrong with this slq statemnt. When I hit my cmd button in my form i get a pop up box that says "Enter Paramater Value" GCriteria = Forms!!.value & "...

Access 2007 Table1: Field: ABC (AutoNumber) PrimaryKey: ABC Field: Data (Text) Values: ABC Data 1 abc 2 def

I have a database which details holidays, and I have had to construct it specifically to include all dates. I want to make a field that specifies whether...

I have a table of staff effort data, containing the following fields: FY WBS Period Hours I want a query to return a complete set of records for every period...