I want to use an IF statement to extract some digits from cell data. A cell has a number like 90115 which represents 01/15/2009. I want to extract 9 from...

How can I add a record or edit a record on a data entry sub-form?

I am using an MS 2007 database linked to DB2 tables. I am trying to use an append query to add new records to a link DB2 table (with a single field used a...

Hello! I'm using the Access 2003 Events template and am trying to append data to one of the tables in the template - the Attendees table. However, in...

Hello, I created this db in MS ACCESS 2003 and recently our office upgraded to MS ACCESS 2007. Everything was working fine, until a User noticed that after...

How do I write the query to return any records entered today where the date field is in general format? I've tried now() which of course returns null. I know...

I am trying to get a list of entries that are between two dates that I input on a form. However, the date in the query that it is looking at is a calculated...

How can I create a query that prompts a user for the fields they want to display. I want to create this query which will link many fields but I want my...

I have a field where i want to write a query which shows only those records where particular word is not in that field.

I have a Query that lists anyone enrolled that is a senior... it is querying from the college's SIS database. Then I have a table called "Withdrawals"......

I maintain a database of shipping records which I update weekly. The database is largely used for simple queries about our shipping activity, and is not...

I have setup a query to look for inappropriate data. I then setup another query to count the number of records in the first query which are then reported on...

I am trying to make a query where I have one table "call it products sold " that has the price, lbs, QTY of the sku's.... I have a second table "call it...

Wondering if whether you can use an OR in a join. currently I have a table (principal_data_export) with variable cdscode & altcdscode I want the table to...

Greetings, I have a simple pivot chart that are reporting 30 rows of records with 15 field headers where the chart opens however not all the data will be...

In Access 2007, I am building a db to help manage a homeowners association. The task is to create a record of association meetings. In this task, I need to...

Hello all. I am creating a database to track repair costs on products. I want to use a form to select between 2 dates entered in the 'DATE SERVICE CLAIM...

I have IIF stament in the query criteria and would like return a text like following "CURRENT", "PAST", "CURRENT" or "PAST" It works for single criteria like...

Thanks for any help. I have a table and a query that I input into an Excel spreadsheet, match up a couple of fields, subtract account value if they match,...

Hi, I have an Access 03 query based on “Tbl Vol Hours Tracking�. In my query, one of the fields uses the following to calculate the total number of...