Search results for query: *

I have an Access database in which I have created a select query. I now want to disply the results of the query in a form. How do I display the results of a query in a form?

I believe this is how we're going to receive the information and it's being left to myself to clean it up. I'm not sure what application it's coming from, but it is coming from another company.

I have a spreadsheet with two columns of information. The first column contains an account number which is fine. The second column contains an address, which is unformatted. Some of the addresses start with a comma, so for example it may start ", 25 Harlow Avenue, ". Other addresses may start as...

Ok I'll do that, thanks for your help.

Thanks for your replies, I didn't think it was going to be straightforward having spent some time trying to think of a solution!! This is going to be a file we will receive periodically, hence the need to automate it as much as possible. In the file I have at the moment there are just over 600...

I have a spreadsheet with two columns of information. The first column contains an account number which is fine. The second column contains an address, which is unformatted. Some of the addresses start with a comma, so for example it may start ", 25 Harlow Avenue, ". Other addresses may start as...

That's great, thanks for that. Is there any way of doing it the other way round - if I wanted to restrict the users to only entering alphabetical characters into a column and not numbers?

I have an Excel spreadsheet into which Users will enter data. I have a column which will be populated with phone numbers. I want to be able to restrict users to only entering numbers into this column and not allow alphabetical entries (a,b,c, etc.). Is there any way to do this?

I have tried importing the table into Excel. I get to the final step which is the SQL Server Login. I type in the password and get the following message:- Connection failed: SQLState: '08004' SQL Server Error: 4060 Server rejected the connection; Access to selected database has been denied...

I have created a new database with 5 tables. I now want to add a sixth table to the database. I am trying to import it as an ODBC data source. However, it gets part way through importing the table into Access before coming up with the error 'Invalid Argument - Error 3001'. I have tried...

I've now resolved this myself!!

I have now created a shared variable to produce the result, but now the only problem is that when I add this variable to the cross tab it only gives me the figure for the first load period (row 1 in my cross tab). Any ideas??

I can now see why it's giving me 2 or 3 rows. In the formula for the new row I am restricting it to 5 categories of the field used for the columns. It's giving me one row total for these five and then a seperate row for each of the other categories contained in this column field. So how do I...

I have a cross tab. This has the period in the row and a percentage formula as the column. This in itself works absolutely fine. However, when I add a second percentage field to the cross tab and put it in as a second row, rather than giving me one figure per period, it splits it into 2 or 3...

Thanks for that, but is there any way of avoiding copy and paste. Ideally what I want to happen is for the user to be able to drag and drop but for the values not to increment. I know that you can do this by holding the CTRL key and doing it but is there no way of, say, "turning it off" so the...

I have a spreadsheet where the user has a client code and a client name. He has filled in the first cell, for example client code 123 client name ABC. He then wants to have this client information in the next few rows. When he drags it down the client name remains ABC but the client code...

The report runs monthly, and will run at whatever time the database is up and running after being updated at month end. So there is only one datasource and the report wont actually run until this datasource is available.

I've checked the connection setups of both and they both appear to be the same. I have other deski reports I've created which use the same database connection and have worked absolutely fine on Enterprise when scheduled!

I have a report I've built in Desktop Inelligence which works absolutely fine when run in Desktop Intelligence. I exported it to the repository and scheduled it to run monthly on Enterprise. However, when it ran on Enterprise I found that most of the information on the report was missing. Is...

That's great thanks - that works when I put it in with my main block of data. In this main block of data I have a field called <Account Location>. If I wanted a seperate summary table to show the 4 values held in this field along with a total for the two variables I created above for each, how...