Good morning, I have 3 fields , , & . Rotation and adn are True/False fields. The printtab is a number field. In stead of having 3 SQL statements, I'd like to...

Hello Access 2003. I have a query with the following parameters. Like !. & "*" ‘Data are in TAA Like !. & "*" ‘Data are in TBB Like !. & "*" ‘ Data are...

Hi Everyone, Access 2003. I have a query that I have set up so the user can type in in a txtbox (in a form) the year (string) and the query workks great. This...

There are no recorsd being returned when i run my parameter query. SELECT TrackingID, DocumentNumber,DocumentType, RequestDate,DueDate, ProgramID,...

I have a query that summarises sales data for a particular month and cost centre. The data comes from our accounting system and is held in a single table in...

I am using Mr. Hookums formula he gave me for concatenation in Access 2003 and it works fine. As soon as I copy it into 2007 I get error messages. I have...

Dear Access 2007 VBA Gurus, I have a "Worship Song" database. The tables...

Hi there, I was hoping that someone might be able to help me. My Access knowledge is at best, rather limited, and I am stuck now and cannot proceed further...

I have a database that tracks cadets that will commission into the military and they are broken into their year groups. My problem is that to generate a...

I have a field of names where there are multiple records of the same name. I want to run a query on this showing a field of the name and a field of the...

I have a query that calculates records between two dates as Between And Is there a way to show a default value for the beginning and ending dates in the...

I’m floundering about and need someone to point me in the right direction. I have two...

I have three fields in a table, and want to determine the total of the occurrences by a certain time period. The data I have looks like...

Access 2007 I have a table that contains (among other things) Start Date TimeDown End Date TimeUp All of these are Date/Time type Example data:

Hi, i need a form where we search for a detail and the result should be published in the bottom, based on the result the user will decide what to do next in...

I have a call database that includes a field for length of call. I have created a query that includes employee, date, and length of call. I need to calculate...

Hello, Access 2003. I have a single field called "Name" in a table called "Members". There is about 300 records in a Last Name First Name format,...

I have two tables - Employee_PunchTime table and Holidays Table. The PunchTime table contains three fields representing EmployeeID, Time-in and Time-out;...

I'm trying to convert "mm/dd/yyyy hh:nn:ss" date format to just time using DatePart function. I've used DatePart("hh:nn",) and it returns "Error". I've used...

I am rather much of a novice when it comes to developing Access databases, but have found myself in a situation at work where I have had to develop two...