Recent content by Jembo

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