Hi. I developing an Access DB for registration of historical info (1880 - present) on sail boats (boat type, owner, year of purchase, participation in...

I am using a text field in a table for an address number, ie 4 Brown Street, 8 Brown Street, 10/12 Brown Street and so on up to 40 Brown Street. When I try to...

Hi, I am building a Rating system for a local tennis league, and have hit a problem. I can calculate the points gain/loss (e.g +/-15) from the result, but when...

I compare billing data with a mdb using queries that someone helped me create. I'm trying to understand this expression - Not Like...

Folks What is the best way to build an editable query when using aggregate functions ? I have a typical father / child (1: - :n) design and have a query...

I have a column with a mix of numbers and words. I want to create a column with only the numbers from that column. What is the Query-command for that? (And...

Hello all, The string below does not work in its current state. However, if I remove the final line "ORDER BY e.EVENT_DESC;" and dress up the line before it...

I need to determine total duration for a select assignment in a specified record. The record incorporates 4 requirements necessary to get an...

I hope someone can help me out here. I am using Access 2002. I have created a make table query that is also a summary query. One particular field is giving me...

Hello, I am using Access 2002 and I need some help. I am using 3 tables in my query. Table one call Inventory contains the following fields: "Insured Name",...

I am currently writing a piece of software that allows an administrator to remove 'n' amount of software licenses from a database. Let's say that they want to...

I get Syntax error (missing operator) in query expression 'vpVendorID='. Please explain, as both are Long Integers, what I am doing wrong. SELECT IIf(=2,...

How do I put in the criteria to only look at the first 5 characters?

Hello: I have a query Q1 which returns one column of 700 records. I need a query to this query to extract any number of records of Q1. For example records...

How do I adjust my code to give the dates that I am looking for between 9/1/96 and 1/1/05 +Where contid CONTAINS 'B -' and 94 + cndtlet between...

Your assistance will be greatly appreciated: In a field named "Comments" I need to extract a error code that begins with E and a four digit number. (i.e E2301...

Hi guys. I have many duplicate records in a database and I need to get the record with the highest date and not show the rest of the duplicate records. I have...

OK I got a query for a date period but now I need to set the criteria to only ask what day to search on and searches for a two given time...

I am still new to Access and querying, so please be gentle. I am creating a form in Access where I am using a series of combo boxes to create a product...

HI, I have conducted a "find duplicates" query in order to find records where entries in some, but not all, of the fields duplicate. For example, for records...