I have a table named X that contains person's blood pressure reading dates and sys/dia results. Many may have up to 3 BP readings. I would convert the data...

Hi in the form, a command button executes a query when clicked. I want to close the result window with ESC key press in the keyboard. i dont want to click...

I have a database which I created for schoool registration. I am wanting to make it more simple so parents only go to one location for registration. For...

Hello SQL experts! I thought my SQL was working, but it actually only works when I click the ‘And’ radio button. Here is my design: DateFrom (ComboBox)...

On Feb 1, 12:19*pm, Dan wrote: Hi all - I am wanting to use Access to run a SQL Stored Procedure. *I've set up ODBC connections...

I know this has to come up a lot, and I am wondering the best way to handle it. I have two tables in a one to many relationship. Say an Product table, and...

I want to be able to list the most current date an item is checked out. As I was working through the query I used max as an aggregate function but I still...

tblItem Item Code | Desc | tblTran Tran_ID | Date | Item Code | Qty | I need a query to show the following: tblItem.Item Code | tblTran.Date | tblTran.Qty

I'm opening a query and the datasheet window has the 'x' grayed out so the user cannot close the window without exiting the database. query is opened...

I have a macro that I want to transfer text from the query I posted below. I need to create a specification for the transfer. When I open the query and...

I’m kind of stuck on a query! This works fine, when I just filter for Customers and Traders. Then, I went ahead and added in a couple of ComboBoxes, to...

HI, this is second time iam posting this ,,kindly help me a form contains button which runs a query like select count(field1) from table t1 ... then normally...

I have 2 tables in a database. Each table has 1 data field, "Slot", in common with the other. How do I create a new table or query that combines data in one...

Hi I wonder whether someone may be able to help me please. I am trying to create a query that shows updated fields within a given time period. I have set up...

Hi all please help me table t1 fields f1,f2,f3 are name, mob,date I have a form with a command button, when clicked it executes a query and result will...

Hi, I have a table where I import data to a table. This data contains a list of Services (some which are valid, and some which can be ignored). I have...

Hi All, not sure if anyone can help with this. I have a column called VNTR24 which has 10+ digit numbers - these are not unique and we want to be able to...

Hi, I have a table which has three fields Type, Server and Service (table and sample data below): Type Server Service DEV ...

I have 10 fields f1,f2......f10 and I want to give all fiields with condition of group by f1 and last data of f2 (integer). I try to create query by using...

I am trying to generate a master dates table that holds a number of groups that a date may belong to. Amongst them are some that I can create using date...