I did this once but fogot how. I have an order table with an order entry time. I have several months worth of data. I built another table that has time...

I forgot how to do this. I have a table of orders with the order entry time and I want to count how many where entered each hour. I remember something...

Hello I want to use date variables in the criteria of a query. When I put Between #1-1-07# and #1-30-07# it works but if I try to use a date variable it...

I need a comparison within an iif statement to identify a time value of 00:00:00 and don't know what to enclose the time in, have...

I am trying figure out how to get access to do the following: Column 1 = Name Column 2 = Project1 Column 3 = Project2 Column 4 = Project3 Column 5 =...

Hi guys, I'm trying to created report called Intransit list, report would look at the each entry in table tblFileLoc and find out last entry for each case...

Hi I know this is simple but cant seem to get my head around it. I have two columns "Address Postcode 1" e.g. N3 and "Address Postcode 2" e.g. 4LL. I want...

I need to create a query based on two tables. The one table includes a 'Visited Date' field. It is based on these dates (of which there will be an...

I have an unmatched query (Using the wizard) that is returning only a portion of the results I need because there are two primary keys in the related tables....

Hi, I have a query, extracting some detail data. then. I have a second query, used to group and sum data from the previous one. If I have three Currency fields...

Hello: I'm trying to build a query that counts the number of students who registered for our classes between two dates, and I also need to count the number...

I am running a query from a table that limits the output of data to a specific time frame. I am working on the last month minus 12 months. So what I want to...

I have two tables: actual_job_data: job_id - long - fk to job table job_data_dt - date/time - time that event occured qty - long - running count from a...

Guys, I need to convert the following excel formula into...

I would like to create a form that allows the user to select a number of parameters that they could run a query (and eventually a report) on. They would...

Hey, I was would like my queries to only show those that date (in the field with the dates of my records) was in the last week. How would this be done in the...

I have a table that looks like this: ClientID RevisionNum --------------------------------- 10000 1 10000 2 10000 3 10000 4 20000 ...

Hi, I have this database where i could like to caculate the 14days average price of a stock closing prices. How can i write the expression: Fields that i...

I am helping a client replace yet another cumbersome excel spreadsheet with an access mdb, he is using the quotient function in excel which returns the...

Hi I am going to illustrate what i am trying to do in an example. I have the following results from a query: Payment# Account # Payment Date ...