Sorry if this is a duplicate, but I tried lots of searches here. I can't seem to find my answer anywhere. I have 2 tables that I need to join by date and...

Hi I am creating a Vehicle Bookings database and have created a query which identifies any clashes for bookings of vehicles to eliminate double bookings. When...

Hello all, First off I want to say I read a lot of the previous posts about this issue and none seem to be similar to mine. I am working on a database...

Hi (Access 2007) I have the following union query (full sql at bottom of question) where the fields Seven, Eight, Nine etc are derived from check boxes in a...

I have a query that when run opens into a form, however when there is no matching record in the database the form opens as a grayed out box. This is fine for...

I am taking 4 fields from a linked AS 400 database, the 4 fields are IDAREA = T IDAISL = RA IDBAY = IL1 IDLEVL = 9 I need the word "TRAIL19" to be my parameter...

I’m trying to calculate the percent return for different stocks. I need to get the (-)/. Here is my (non-working) query: SELECT SharePrices.StockSymbol,...

I am looking for where "MR#", "Name", "Sex", match yet ONLY "Ans" not matching. The data in other fields are to be listed regardless if they match or...

I have to make a calculated field in the query where the value from one table is deducted from the value in another table. Is that possible ? Here is the...

I have three list boxes. Depending on what is selected in the first list box, the second will display different data. Whatever is selected in the second will...

I have a Seminar table and an Attendance table, seminars and Attendance joint by Seminar Number (Attendance table also has attendees Social Security Number)....

HI, I have a database that list publications and articles in the publications. I use two tables. Table 1 is the one containing publication names. Table 2...

Is there a way to search for a space and break a name that is in one field into 3 separate fields? For example: Field 1: John S. Doe becomes Field 2:...

Hi, I have tried explaining this problem before without success, so I'll try again. TblTransactions From Suburb To Suburb Service Items Kilos

This should be easy, but I've got "brainfreeze".... What's the correct syntax to get records with a date Between today and 7 days ago??

Hi I am an Access Novice but used to get on with the very basic points up to and including Access 2000 but in Access 2003 - Oh my God - what has happened?? I...

To obtain records between two exact dates I use, in Date column: = AND = And if I need to obtain records only with First date, or Last date, please? Thanks...

I have one table, Customers and one table called Emails. Each customer can have several emails, and these two tables are linked with the field CustomerID. For...

Hi I am trying to create a query that can be updated 'on the fly'. What I want to happen is for the user to select an option from a pop-up box and then the...

tblInventory + tblInvoiceDetail I would like to collect sales history for analysys. I'd like sales for various periods (based on tbleInvoiceDetail.date) for...