Search results

I have a relatively simple query where I would like to export its structure and data to SQL. This SQL will hopefully later be used in phpMyAdmin. Is this possible in Access (my version is part of Office XP)? Any help is greatly appreciated.

Hello, Is it possible please to extract a tables structure and data into SQL in Access. I know how to do this in phpmyadmin (an internet based DBMS) but not so sure in Access. What I want to do is to create an identical version of the table in SQL Server, so therefore require the structure and...

Is there anyway I can add a sort of count field to my query, for example what I require is the result of my query to include a column which counts the rows in the queries. For example: PositionID NumOfVotes Count 5 5 1 6 2...

Is there anyway I can add a sort of count field to my query, for example what I require is the result of my query to include a column which counts the rows in the queries. For example: PositionID NumOfVotes Count 5 5 1 6 2...

Hello, I am having difficulties with working out how to create a correct query from my database. :confused: These are the two results I require: What strength of whisky sells the best at Christmas (How do I do an 'In-Between' date condition regardless of the year? i.e. >= #01/12/____# AND <=...

Hoi, Is there any way I can add the date to come up automatically (i.e. today's date) on a field called 'order date' on my orders form. I currently have an input mask on this table field (i.e. dd/mm/yyyy) if this is any help/hiderance? Thanks for any advice !

Hello, I have a small query problem, how would I determine the total amount of the products which make up an order please? I have the following fields in my query... OrderID, ProductCode, UnitPrice, Quantity, Amount: [UnitPrice]*[Quantity], Total Now, I require the total to equal the value...

Hello, I have an order form where I want when you type in the Customers number their details (i.e. address) are then displayed on the right hand side of the form. I have basically two tables linked, an order table (OrderID, CustomerNumber) and a customer table (CustomerNumber...and their...

Hello, I've got a small form with one field called 'Price', this is set as a Currency type in the table design. How would I go about ensuring that the field (in form view) always starts with the '£' symbol...would this be an input mask or would it be something on the form? Thank you for any...

Hello, For my Student Record System that I have created I would like to customise the toolbars shown at the top. I understand this can be achived as I have seen other programs do this like so: http://www.ingserv.com/desktop.jpg So in this instance I would like to remove all of the Formatting...

Cancel button ruins program! Please help Hello, I'm making a Student Record System and one of the options I currently have is the ability to search through records (in this case students). When selected the user is allowed to enter a desired Surname and Forename to search as shown...

Hello, I'm trying to make it so that my Student Forename field only allows text (from a-z i.e. no numbers etc) to be written inside the box, would I use a certain validation rule and if so how would I do this please? Thanks in advance.

Hiya, I'm new here so please forgive me if this is the wrong forum :-) I am currently making a student record database system for a college project. I designed it in Access XP (Microsoft Office XP) consisting of tables, queries, forms and macros. The basic principle of the project is to have a...

Hiya, I'm new here so please forgive me if this is the wrong forum :-) I am currently making a student record database system for a college project. I designed it in Access XP (Microsoft Office XP) consisting of tables, queries, forms and macros. The basic principle of the project is to have a...