Recent content by ignite

Thank you for the replies. This is SQL to build the query, I'm looking for SQL to export the structure and the data. Is this doable? :)

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.

Thank you for the reply, when I try and run the wizard it reports that: Object variable or With block variable not set Any ideas please?

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 <=...

Works well, thank you !

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 !

Ignore, fixed...thanks for the help.

Well this information is linked as a subform to a form which displays the OrderID, Customer Number etc. I would like the total value of this order to be under these values so like.. OrderID Customer Number Total When I tried what you stated it had an error as I'm guessing it didn't understand...

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...

Oh yes, it now works as expected, thank you for your help! Sorry for the simple error.

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...