I have a report that shows summary information received monthy by locations from policy holders. I would like the information to start with the month of the...

This should be simple but I am having a problem. I have a table which I have set up in a left join query against a much larger table. The common field is the...

Hello. There are a lot of duplicate records in a table. I used the duplicate wizard to find them. I also have a checkbox named "dupli". What I need is to...

Hi all! I think I may be experiencing a glitch. I've successfully created a cumulative total function using DSum in a query, which is fed by a table from a...

I need a query criterion that returns records in which a text field (255 max characters) contains any character(s) other than alpha (upper and lower case),...

I have some queries on an Access database which use Date() as a criterion. Up until this afternoon they worked fine, but now when I try to run them I get a...

I have an access database for our parts inventory. My "inv" table holds information such as part number, mfg, qty, cost, list, etc. Another table "alt"...

I'm builiding a crew scheduling database. I need to be able to build a reoccuring event like the reoccuring appointment function of Outlook. How can I do...

hello, ive created an access database and i want to retrieve records between a start and 90days.

I'm trying to join two tables via SQL and am getting errors. Any help is appreciated. The tables: taDEFENDANTS DefendantsID PK PropertyID...

I am having some issues with selecting the TOP value in an UPDATE query. I am not an expert and I am looking for advice on the best way to proceed. Here is a...

Hi Everyone, Something went wrong with this db, and I'm getting the "VBA file corrupted" message, and "Id is not a valid index" when I attempt to open. I ran...

I'm lost. I would like an unbound text box to pull up a value from another field. so, SELECT FROM WHERE (in the fasting table) = (from this table) AND ...

I have the following query (see below). My primary field is TECH_Id (alias CAPId) - and I want to return just one row per CAPId value. However, I have...

If I say 'SELECT TOP 5' and the result set returns less than 5 rows, do I get an error? I looked in Access SQL help and it did not say.

I've entered the following expression in a query: TotalPay: (*)++ The query doesn't return the resulting calculation. What am I doing wrong? -- Chris

MASTER Table: ClaimsPrimaryKey DETAIL Table: AutoNumberPrimaryKey Date ClaimsPrimaryKey ClaimsStatus This represents, of course, a one-to-many...

Table Account, Field customerid, AccountNo (PK), AccountType(for example: Saving account; Current account, Qdii, etc ) Rule: One customerid may open several...

Hello, I am having some problems with my search panel in Access 03 on XP Pro. I have five fields to allow the user to search for any number (up to )...

I have a table with a memo field. I have used it in queries previously and it was returned just fine. Occasionally, though, it returns characters that I...