Search results for query: *

I am in SQL view on a MS Accesss query.

So even though I am in SQL view, I can't write SQL?

I am getting Undefined function 'Trunc' in expression when working in SQL view in Access 2000. I have the following library objects checked; Visual Basic for Applications Microsoft Access 9.0 Object Library Ole Automation Microsoft Access DAO 3.6 Object Library Microsoft ActiveX Data...

Brilliant - just what I wanted. Thanks for the swift response.

I have created a report on the results of a (Make) Table (Query) for which a user prompt is used to select the data for the company concerned. I want to know if it is possible to include the User Prompt data in the report so I can include it in the header to identify who the data is for. For...

Thanks. Got that. I sort of figured it and am just now running a query and testing the data to make sure it gives me what it should. Cheers.

First of all I must confess to little (if any) knowlwdge of VBA so i apologise in advance for my ignorance. I have built a little utility using Access 2000, and all the automated functionality is controlled by macro's. However, I need to create a report that macro's alone will not build, and I...

Brilliant!!!

I have user data in a table. In one of the fields there is a text field containing a number. Some users have input the nuber as "1", some have input it as "001". I want to write a query that will pad out the single numbers to 3 characters i.e. turn "1" top "001". I am in SQL view but LPAD...

Thanks Roy. The SQL view worked a treat.

Thanks for that..........but I'm not quite sure what you are saying. I'm sure there is a simple syntax solution but I have been searching various forums and tutorials for a few hours now and got nowhere. I'm sure it's a case of a colon/parentheses/quotes or a combination of these (or something...

I have 4 table that hold counts of various data. The field holding the count is CountOfRef_Number. I have created another query to combine all of the totals into one table so I can output a report, but all of the column headings show as CountOfRef_Number. In the query Design View I want to...

I have just done a similar exercise and had to create a separate variable in the universe for each word in my string. The process I used sounds similar to what you are doing, but if you are only after the text after the 8th ':' then why 16 UDO's? Not sure if this helps but the syntax I used...

No Steve. Concatenating the data will just put it back into one string. From the example above I want to end up with; Chrtd Acctnt Internet Security & Web etc...

I thought I would have to do it this way. I have decided to take into account only the first 7 words so have created 7 variables. Is it now possible to combine the data in these variables into a single variable (so I have a long list of words)? I have a feeling this is not possible (which...

I have a field (Bus Desc) that can contains more than one word. e.g. Bus Desc Bldr Chrtd Acctnt Internet Security & Web Design Consultancy & Training Is it possible to create a Universe variable that contains each individual word?

Thanks Steve - but the POS function wasn't covered on the courses I attended, but I did eventually find it in BO documentation. Anyway, I have another issue now whereby the Initials field can contain more than one space, full stop, or comma, or a combination of multiples. So I guess I need to...

SubStr won't work because I don't know where the space character will occur. I think I have found it - the POS function. I need to find the position of the space character first, then use the SubStr function using this value. I will have a play and if successful post the conclusion (to help...

I have been asked to query data in a spreadsheet and get the number of occurrences of each Initials field. I have done this but now have to break this down further. The problem is that there are a number of Initials fields that contain a space character, and then a second initial. For example...

In 6.1, with the Universe open you can simply go File/Save As, and when the dialogue box opens just select Portable Document Format (*.pdf) from the 'Save as type' drop down list. Is this not available in 5.1?