Hi I have a database where I have a number of transactions (numbered from 1 up) with a number of transaction lines in each. For example, transaction 1 might...

Hi all, This is my first attemp to do something serious with access, so pls bear with me. I have a table of events called tblRoutes. I have another table...

I want to run a query for the monthly data. The table only supplies me the date (no month). Our Accounting Month does not work along with the Calendar...

I've been working on a database containing patient information, information on the different studies, and sponsor information for the research people at a...

Im trying to set a checkbox value to a "true" or "checked" state when another field is equal to, or greater than another value in another field. What would...

Hello, I am using a form that you input search criteria. You then hit a button and it runs my query off of the information in the form. Problem is, when I...

Hey guys, I asked this question so many times that I'm tired of asking it now. I'm only posting again because this report is due very soon and I still...

I'm fairly new to Access (but have been in computer tech support, including database support, for over 20 years). I'm using Access 2002 SP3. I'm...

Hi Again being a newbie I feel compelled to ask yet more questions! In one of my tables I use it to store worked hours for personal. This composes of around...

I have main form with a combo box to search name and add form to add record. After adding record and close add form, newly added record does not show in...

I have a main form (Members) and a subform (CourseRegistration). A query computes a discount based on Income and PeopleNumber using tblDiscounts....

We have a small office of 2 computers. We have Access 07 on one computer with our customer list and reports. Do I need to buy another Office Business suite,...

I have the following code assigning a unique number based on the record type: Private Sub Combo4_AfterUpdate() Me.Type = Me.Combo4 Me.ID = Nz(DMax("",...

I'm new to Accesss (20 years in another 4GL db app), and am wondering where the actual save/commit is done in a simple Access db. I'm used to an environment...

I am trying to get the 60 day trial of powerpoint 2007, but i fill it all out and the phone number is wrong. I've tryed every thing. does anyone know what to...

Hi, now i have the crosstab query as below. I want, in my report, to show the following below the crosstab query table: ABC ...

I have 4 tables and each record is specific to a task with a start time, finish time, location, equipment number, and other various data specific to that...

I am trying to start a new project. I am asked for an SQL server but I hve no idea what that is or how to get on.

I am unable to edit my data or create a new entry in my form. I can only sort the data that I have already imported into tables. I am only able to edit the...

Ok. Let me try this again, this time, I'm going to try to be as clear as possible. I am not familiar with SQL queries. I just don't understand the...