What I have: Three tables for a many:many. Roster with ID, LFName... TngPer with PerID, PerName (four training periods per month for the next 4 years,...

I need to delete the last 12 characters (phone number) from a field that contains names and phone numbers.

I'm racking my brain on the best way to do this and it's time I ask the experts. I am trying to copy a report currently used in Excel and need to create a...

Hi I only have some experience of IIF statements so please bare with me. I am trying to get the value of three fields into One field. The Problem I have...

How do I test a text field for numeric data? How do I test a text field for alpha data?

hi there. this is the situation, i'm trying to split one date in several dates, for example: 01/03/2010 ----- split in 60 dates with the interval of 1...

Hi all, Is it possible to create a query that DELETES column in a table in ACCESS 2007? the reason is, because I receive a very big database from my...

Could anyone can help?! I have 2 tables : Table 1 : tbl_customer master Cust_code Customer Address AA001 ABC Ltd 1000, BB Road..

I have a table with ID, Description, Intake, Sold, Remaining, Intake Date, & Total Inventory. I would like to have the Total Inventory column populate with a...

Primary Key is ID and data is extracted by ClubID. Fields are ID, ClubID, StpMail, FNm, LNm, MI, AD1, CO, Cty, ST, ZP. Prompt asks for up to 5 ClubID's, but...

I have two tables that you see below. The first table called CompletesAndNonCompletes holds information on who completed a course in the company. If the field...

Is all I want to do is combine two records from a query. I have data from a query from a lunch account and from a dinner account. All I need to do is combine...

Hello! I'm working on a query that I think may have to be done in SQL but would rather do in Access if possible. I have a table similar to the one...

I have a database which I want to calculate vehicle monthly usage. I also need to be able to show daily which vehicles should be used based on that usage...

I need help on structuring a query. I have an existing query that gives me as as output the following information: Region-Id (coded number with...

I have an Access database of all of my CD's that has all of the tracks. I want to have a query that will show which songs I have that are done by multiple...

I have a union query showing the results from pool matches GameID Player Opponent Result 1 Joe Bob Won 2 Jim ...

Our contract requires me to post a job for 10 calendar days and it must remain active until 8:00 am the date of the deadline. After that it must be removed...

i have a club where players earn points. they can redeem those points for "food dollars". One food dollar equals 114 points. you can only redeem food dollars...

Hi I have built 2 tables: tblMain and tblPartNo. They are linked by Drawing numbers. I want to find all Part numbers that are also drawing numbers and later...