Hi, I'm battling here... I'm trying to write a simple querie that selects either an individual region or all regions. The source of the selection is a drop...

I have a table with 3 fields to be used in a crosstab query: PersonID GroupID ConCat RowHeader: Person ID ColumnHeader: GroupID Value: ConCat The problem is...

Hi I have one table (Detail) and one query (AGE), i need a query to combine the data of Detail and Age, as shown below. Detail table looks like below Name ...

I need to move data from Table 1 to Table 2 and can't figure out how to do it. Perhaps someone can help me. Table 1: has 3 fields DealerID Car ...

In Access, on a QBE Grid, what can i put in Critera in order to find a Question Mark in a text field. The question mark is not the only thing in the field....

Guys, just back to Access after some time away (and I wasn't much good the first time...) I am seeing bizarre problems with a subquery. 1) I am joining two...

Hello From a table with : P_Code P_Name Q_receved ID_1 A 3 ID_2 B ...

I need to move data from Table 1 to Table 2 and can't figure out how to do it. Perhaps someone can help me. Table 1: has 3 fields DealerID Car ...

Hi, We have product numbers that are about 12-13 digits long. I An example would be A45643-10243. There are a small handful that have an R in the seventh...

Our SKUs consist of a 2-3 digit pattern#, a dash ("-") delimeter, a 2-3 digit suffix and 1-2 alphabetical characters (A-Z) representing a color (if one...

My tblPeople table has a unique ID, people's names, and address. The tblContrib table has a unique ID for each contribution, the date of the contribution...

Hi, I have the follow query: SELECT Schools.SchoolName, BackupTracking.ServerName, SchoolServers.ServerID,...

Hello everyone, I have 4 tables : budget, sales, buyings and other expenses. They all have two fields in common : name of the restaurant and the type of...

I had several queries that worked fine. Somehow all the queries got changed by Access to have As Expr1... As Expr2 etc. for every column in every query. This...

Hello, I need to perform inserts and deletes in several tables of my MDB in a form. I'm using the command DoCmd.RunSQL = "..." But i have a problem: when a do...

I have two tables: taProperty fldPropertyID PK fldPropertyAddress fldParcelNumber fldPropertyZipCode taCONTACTS fldCONTACTSID PK

I am quite proficient with Excel, but relatively new to Access. I suspect there is an easy way to use an update query to get Access to delete an entire row...

I have a table of stores that have processed some templates of returns. The templates have the store number followed by numerous warehous locations. So,...

I have created a query. How can I send it to an email address? Excel or Word format is fine.

In Design View - I am building an Enter Perameter Value option for the user to pick in the value. Example . However, I want the user to be able to pick...