I am trying to link 9 tables that have a common field titled Physician Name. Each table has 4 categories that have a yes or no option. I want to link all of...

I have an append query that requires the definition of two "parameters" as it executes. The problem is that each time I run it I have to manually enter the...

I have 62 queries is there a way to make a form or dialog box so i can change the 1 and only difference in the queries What i mean is ? the queries are for...

Hi All, I am trying to build a query that will allow me to show any records past there end date. Each record has a start date and an end date and i need to...

I am trying to select fields from two tables and Union them into a table, but it seems I cannot do a 'select into ...', but I can create a recordset of...

I'm trying to query a set of data and I'd like to use a form. I have 16 check boxes... three different shifts on 5 weekdays and an "any" box. I'd like the...

I created application for comunicating with Hitachi902 device for blood anylze. For each day database must be empty, and results from day before have to be...

Hello, I just used the startup feature for an access database file, and set the file to not display the database (the table does not show being opened) :...

I am using access 97 at work. I am using a form to enter report criteria. In the report I have specified field 1 or 2 or 3 to select the data. That all works...

Hello! I would like a query to field with next condition: Between And , please. Thanks in advance. an

Hello is it possible to use thin querie in Ms Access select test case champ = 1 then toto case champ = 2 then tata .... like we can in SQL server or what is...

In my table named tblSchedule I have the fields EID (Employee ID), Date and Assnmt (shift to be worked). A new aggreement between management and labor dictates...

I need a expression for a query thinger. The database has 4 possible values for a field called "Voltage", these values are 11, 33, 0 or NULL (NULL being...

Why I get "Type mismatch" with this code (VBA) The 'sale_Date' field is date/time field ----------------- Dim strSQL as String Dim dbs As Database Dim...

Hi everyone, would apprerciate some help with following i have a database of addresses, which also contains email address for establishment. We also have a...

I really need help with a formula to calculate the loan amount based on the mortgage payment, interest rate and term. How would you calculate this in Access...

Currently employee names are in the field empfirstname. Is there an easy way to move the employee last names into the field emplastname? thanks.

Hello, I have a Column called City State Zip that houses the info in this format. City, ST, Zip. I am trying to create a query that will seperate the...

Hi, I have two tables. One is called Attendees and the other is called MailingList. They both have a common field called ID. There is a check box on a form...

Hello. I hope someone can help me with this. I´m experiencing some problems trying to calculate stock. I make a query based on the items table, the order table...