Search results

Hi, I have an access database which has a date field. I've entered all of the dates in valid UK format (dd/mm/yyyy). An example of the table looks like this: Id| SeminarName | SeminarDate 1 | Introduction | 18/02/2006 2 | Other stuff | 19/02/2006 When I do: SELECT * FROM tblSeminar WHERE...

Thanks RuralGuy, Like most things, I'm sure it's the easiest thing in the world if you know how to do it. I've just opened up querybuilder and I can't do it. Rather than ask you to explain to me how querybuilder works, I'll probably just try to do more Googling for multiple inner joins. Will...

I had this quite recently, where someone tried to point me in the direction of querybuilder (which which I'm totally unfamiliar). Thanks for suggesting this, but I really just need a SQL select statement which I can use in my ASP page to select the data from the Access tables. I honestly don't...

Having just read http://www.w3schools.com/sql/sql_union.asp it seems that UNION is to select values from different tables. This isn't what I want. I need to select a value from the tblProduct table where the product belongs only to a particular group (I will pass Group_Id into the select...

Hmm... so I don't need to JOIN the tables? I've never used UNION before.

Hi, I have the following four tables: tblGroup: Group_Id (PK) | Group_Name tblSubGroup: SubGroup_Id (PK) | Group_Id (FK) | SubGroup_Name tblProductType: ProductType_Id (PK) | SubGroup_Id (FK) | ProductType_Name tblProduct: Product_Id (PK) | ProductType_Id (FK) | Product_Name I...

Actually, this works perfectly: update products set product_quantity = product_quantity - 1 where product_id = 937 How simple!

Can anyone help with this, I'm really stuck? I'm sure this can be done quite easily with ADO??

Okay, thanks jibbadiah. How do I call this from a web page and pass in the product_id, so that it only decrements one single record (I don't just want to subtract 1 from all product quantities).

Hmm, actually, I'm stuck at the first hurdle. I'm using Access 2003 - how do I create an update query? Is it possible to pass values into the query? ADO might be simpler for me you know...

Okay, I'll give it a go. I need to pass in a value for product_id from the website, and have this query then subtract 1 from the corresponding product_quantity field. How do I call this update query from my web page? How do I pass the product_id value into the query? How do I construct the...

Thanks, I'm not familiar with update queries, and don't really have the time to learn on this project to be honest. Is there a way to do this using ADO?

Hi, I have a product table in Access, like this: product_id | product_name | product_quantity I need to be able to do an SQL update on this table to subtract 1 from the product_quantity field. I could do this with two SQL queries (SELECT product_quantity, then subtract 1, then UPDATE...

Hi, I've got three tables: tblEvent -------- Id (PK) | Event_Name tblDelegate -------- Id (PK) | Delegate_Name tblBooking -------- Id (PK) | Event_Id (FK) | Delegate_Id (FK) I need to retrieve a recordset with the following information: Booking Id | Event_Name | Delegate_Name Can...

Hmm, I'm not too sure this covers my problem. All of the entries in the table show up as dd/mm/yyyy, but when I add a new one it goes in as mm/dd/yyyy - even when I set the default value as date() (so this proves it's not to do with the format of the SQL insert statement which is the problem)...

Hi, An Access database table I'm looking at has a date column, where date is entered in UK format (dd/mm/yyyy). However, upon entering the database, the date is somehow converted into US format, despite me passing the date into the table as dd/mm/yyyy. The trouble started when someone else...

Perfect, thanks very much!

Thanks Gromit, that very nearly does the job. The trouble is, I need to group the events by the Event Id, rather than Event Title, since different events may have the same title. I tried altering the SELECT string to: SELECT tblEvent.Id, tblEvent.Event_Title, tblEvent.Event_Price...

Hi, I've got a database containing three tables: ===================== tblEvent: --------------------------- Id (PK) | Event_Title | Event_Price ===================== ===================== tblDelegate: --------------------------- Id (PK) | Delegate_Name =====================...

Hi, here's the scenario... I'm building an ASP based email application which is to send emails to different user groups. The email addresses in the database need to be able to be assigned to more than one user-group, and an administrator needs to be able to add user-groups to the database. So...