Is there a way to take two sets of data that have a many to many relationship and create a one to many relationship using a query? For example: I have1...

i have written 2 separate queries to delete an individual record in 2 separate tables by employee name with a "like " arguement. the queries work as i need...

am trying to build a database and need a query build to count times example Hound Number 999 score 35 Time 11:00 Hound Number 999 score 30 ...

i am trying to build a database and need a query build to count times example Hound Number 999 score 35 Time 11:00 Hound Number 999 score 30 ...

Hello all, This is somewhat long, but please hang in there. I wasn't sure how much detail to include. I am trying to use a combo box column1 on the main...

I would like to know if it is possible to write a select query based upon the number of records within a group. I have a table with a primary key made up from...

Hi, I will do my very best to explain what I'm trying to do, but Microsoft Access isn't my first language so be kind! I am creating a database for a...

I have n access database which is split with the tables in one database and the queries etc in another, I have created a table called zztables and it is...

I have a table with the following columns: StudentName, DatePointGiven, PointValue, Comments, Archived. I also have a table with a single field: StudentName,...

I have a table of Potential customers which were the subject of a mailshot. I join this table to Current Customers to show how many potential customers...

Hello all, I have run this query with other tables (basically the same) and have not had a problem. Can anyone tell me if something looks wrong with this...

Hello, I am trying to truncate one field in a table, however the field size is variable (the character lengths of the records are 13, 14 and 15 characters...

I have table A, table B and table C table A contains contact information with a long integer primary key called contactID as the first field.. table b...

I have a table with 12 fields, 3 of which are named Keyword 1, Keyword 2 & Keyword 3 with each field and each record containing a keyword in the appropriate...

Hi there is a query joining two tables and im looking a way to say No to those records if some specific fields from the second table ( for example a date...

I am a newbie to MS Access and I am trying to convert a spreadsheet into an access database so perhaps I need to design things differently. Please forgive my...

Hi All, I have a button in a form with the following code: te Sub CmdGo_Click() On Error GoTo Err_CmdGo_Click Dim stDocName As String DoCmd.SetWarnings...

I have a database that has been running fine for years. When I change the dates on the queries to pull the data for February, it is coming up blank on one...

Can I use an update query to update select records by specifing a Macro in the Update To cell of the query? I need to populate other fields of many records...

I have two patient tables. One has patients with a certain condition, and the other has patients with a different codes. Some patients have both conditions...