Search results for query: *

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

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

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

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

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

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

I am using BO 6.5. I have a crosstab showing the Customer Name and Usage Type on the left (1st Measures), and across the top are Months (2nd Measures). The months displayed are determined by the date range that the user selects. Is there a way of hiding all the rows where all of the date...

Hello all. I need to build a report that allows the user to input a date range and obtain stats for that range. The bit I am having difficulty with is that the display needs to break down the stats by month (and probably year - although the sponsor has not specified this, as yet), according to...

Is it possible to use a 'wild card' in a query prompt? For example, rather than select a Name from the Values list and get data just for that Name, enter a wild card to retrieve data for all Names.

I have included the LastPrintDate() function in a cell in a report, but rather than just showing the date, I want the cell to read; "Date of Print: dd/mm/yyyy" I have tried concatenation using the ToDate and FormatDate functions but keep getting #ERROR. Any ideas?

Does the RunningCount function count UNIQUE occurrences or ALL occurrences?

What's the difference between a field that has a null value and a field that is not initialised?

I have a report that displays 3 columns (at the momnent); * NAME - the name of the customer * CAPTION_ID - the unique number for the name * LISTING_ID - the unique number for each record belonging to the NAME/CAPTION_ID. Each NAME/CAPTION_ID can have several LISTING_ID's. I have a break on...