I have a pass-thru query that's pulling a date from a table. The actual date in the source table is 4/2/2009 11:59PM, but it shows in my pass-thru query as...

I have this query: ___________________________________ SELECT TAa1_AllAccts.OrgID TAa1_AllAccts. AS 06_NonEntNet, TAa1_AllAccts. AS 05_NonEntNet,...

I have a query in which I calculate the difference between two measurements, Left and Right. My formula reads Diff: - This should be simple enough, but I...

Some help please. I have a query that subtracts date/time (b) from date/time(a), let's say that the result (formatted hh:nn:ss) is (c). I then created a...

Here's the gist of a situation I have: I have 2 tables A and B. In one query (call it Q1) I find all record common to both tables, in a second query (Q2) I...

Hopefully this isn't a duplicate. It's similar to (but not quite the same as) the question posed by aybs10 on 2/7. I have a table X with 500,000 rows. The...

I created a form (Form A) for running queries. The form requests a start date and end date and one can then select from a list of queries. The form works...

Hello, I am trying to group data in a query (Access 2007). The scenario is this: I have a database that keeps track of monetary gifts. Part of the query is...

In a query I use the following expr1 for calculating text fields round(val(field1)*val(field2);3) Issue is that in not all cases does it round correctly I...

Is there a limit of the number of sort items one can have within a query. We are using MS Access 2002. I am using the following query but getting...

Im am trying to create the following: If Qual=A, an dif (Transaction Amount/100) is less than highest CEM then “Eligible� If Qual=L, and if Transaction...

I have a table that has a long date field. I want to calculate values off of that field. In order for my to get the values that I need I have to change the...

I am trying to create a query with 4 tables to report sales out quantities and I am getting incorrect quantities whenever I add the 4th table to the query. ...

Access 2000 (Yes, I know. Old.) I am designing a database to help me manage a research study. Subjects will be baselined, that date will be entered into...

If possible pl give me the detail i am working on a transport project i have a invoice bearing 15 card board (consignment 1-15) i have a invoice bearing 35...

Hi, I have a table where we key-in Delivery notes for customers; in my form I use the following : =Nz(DMax("","delivery note table"),0)+1 to have continuous...

I am attempting to run a query and it runs forever and never appends records. The CLMPRDFIL files are linked through an ODBC driver to a AS400 database. The...

Hi all Masters, I have a integer field containing numbers ranging from 2 to 60. I am looking to increase these numbers by 40. Please, how do I attain this...

Hello, I've got a large database where I want to delete duplicate records using a delete query. I've set up a totals query to determine which duplicate record...

Increment a Counter and reset it at some stage when the group change: I wrote a powerlifting system but have run into some problems and it all boils down to...