Hi, I am working on a Time Clock. I need some help to create two rouding functions. PUNCH IN TO between 8:00:01 to 8:14:59 ...

I've set up a database of stock market intraday data going back two years, showing Open/High/Low/Close data for every one minute bar of the day. I'm trying...

I have a query that assembles the data that I would like to routinely export as an Excel file to a specific file location. I would like it such that various...

I have the following three queries - qry 1 & 2 are called by qry 3 and joined. If I combine them into one query it takes forever. Can someone please suggest...

I’m new to access and I’m trying to make a query to look up rejected items. I’m doing this by date so in the criteria I have “Between And � it...

I am having trouble setting a date/time data type field to accept text values. For example, Currently the date/time can only put dates (5-29-2005) But, I...

Afternoon All, After reading on the Access Web about lookup tables and their evils I have removed them. Now I have a table for Titles (IE Mr, Mrs etc) and...

I have about 500 records capturing pilot data: flight time, day landings, night landings, instrument approaches, ... The logbook report I created shows 20...

I created a Form with about a 175 Fields. Some of the Fields are linked to various tables where I get information such as customer, or employee. But it won't...

I have a couple of issues. The first is I need to know the record count of a record set. I looked in the help and found this "RecordCount Property Returns...

I have been requested to design a data base for our local church to include Householder names, Occupations, Area of Help, Children's details including name of...

I am just learning Access and have set up a database which works fine except that the field I have set up to keep notes in keeps truncating the data. I set it...

My second question today on comapring averages, but..... I have a database of assessment scores for two year groups (9 and 10) of students. For year 9: I...

I have a quick quesiton on how to pass variables. I have 2 combo boxes. One named "cboBox1" and the 2nd is named "cboBox2". "cboBox2" contains all the field...

Thanks for you previous help. I have created a form and manually linked my first table to this form using the recordsource of the form. I now have a second...

Can someone point me in the direction of a web site or news group that might contain usefull information for someone who has several Access97 projects that are...

I have been trying to use one combobox to select a project and then have the next combobox display only the chanrge codes for that project. I have been to the...

In VBA code, I'm using a series of "Print #" commands to write to a text file. Somewhere I remembered that putting a semicolon on the end of a command would...

I have a .csv file that looks like this with 309 rows that has a single day's data. |----------------------- 103 Columns...

Recently moved my Access97 mdb applications from a Win98 system to a new XP Pro system with 1GB of memory. Both Access97 and Access2K are installed on the new...