I need some help writing this query. This should be simple, yet I can't get it to work as I want. I have a simple database to keep track of incidents. I...

Ok, apparently I have lost a good chunk of my brain in the last 6 months. I am trying to merge 4 tables together that have at least one field that should...

i have a query with ten different fields. all fields contain vehicles, e.g. alfa romeo,fiat,chrysler,etc. i have created a form with check boxes for each...

I have a sql database that access is using to do some queries on, in the queries there is a date/time field. I've used the datevalue() function to remove...

words I have seen way too much of today! And if it is not "too compex" then I get a message saying "insufficient resources". I have spent the day trying to...

using A2k; seen LOTS of posts about this topic, but none seem to address the heart of my question. Let's break this into 2 parts: queries (stand-alone); and...

Can somebody please help me with this expression. The table is tblClassification, and the field name is "Class". The records in the table in the Class...

Can anyone tell me what is wrong with this SQL for a UNION ALL. What I end up with is a query that only shows the fields from the very First table in the...

When I run this query I get one nember for cases shipped. SELECT tblInvoiceHistALL., tblInvoiceHistALL. FROM tblInvoiceHistALL WHERE (((tblInvoiceHistALL.)...

I have a form which allows a user to add a new category to table . After update I then want to be able to add an additional record of that category to a table...

I have two tables in a select query, tblRoot and tblParts. In the tblparts there is over 100k part numbers. The tblroot only has about 200 but will change...

I wrote an append query that successfully gets new Unique ID's, loads them as the append query runs, and appends to the Oracle tables just as expected (OBDC...

Tbl is as follows; name, dodate, team. I must first select the single name that matches a specific dodate, then select all the names that match the team of...

Hello, I'm transferring a very complex file from excel into Access, but am having trouble with one of my formulas. It works in excel, but when I type it in...

I thought I had solved this problem earlier but apperently not. I'm getting the following error: The changes you requested to the table were not successful...

Due to the year changing I now have a crosstab query that returns a Null. When the query was built I did not account for the new year. I would like the...

I want to request annual payments for membership. I have a query that pulls payments by month, but I need only the most recent payments. For example: ...

I need help.. When I add the Nz to the below cell in my query it changes it from currency to text. What can I do to resolve this issue. I am adding Nz because...

Hello all, Is it possible to time long running select queries? I was looking at creating some code to do this....something like: 1. Store current time in a...

I have a table with a field that contains the component ID number for 800+ items. The ID numbers are as follows: 1.1-1 1.1-2 1.1-3 1.1-4 1.1-5 1.1-6 1.1-7