Search results

  1. A

    Print Table Design View??

    Is it possible to print the design view of a table?? If so how do you do it?? When Im the in design view and go go to file the print button is greyed out. Thanks in advance. Andy
  2. A

    Label visible dependant on data

    After solving my last problem quickly, Ive decided to fire another one at you. Again I have a report that displays certain data and has labels saying what each bit of data is. Is it possible to set up the report so that if no data is displayed then the label for that data does not show up. For...
  3. A

    Date Display

    I have created a report that displays the Current Month and Current Year at the top using the following code -: =MonthName(Month(Date())) & " " & (Year(Date())) This works fine on my machine, and if I put it on the server and run the report it works fine, however if the other 2 users who need...
  4. A

    Updating Date using SQL

    I have a table which contains dates in the format (mm/dd/yyyy) as well as other information, I am trying to get an ASP website to update the date with values chosen by the user. The problem is that when using the UPDATE command it returns an error, saying the syntax is wrong. Here is my SQL...
  5. A

    String Searching

    I have a problem with an SQL query that is used to create a report, the query itself works fine, however I need to get it to do something extra. Basically we have a column that contains 1-3 letters. The letters are A, B and C. The query searches the database and returns result depending on which...
  6. A

    Data Request - Wrong Data Shown

    Hi, Following on from my previous post regarding reports I now have another problem with the report I am creating. the intial problem I had was that I could not order a report properly as the column was a text field not a number field. I solved this problem with help from your good selves by...
  7. A

    Report Data Grouping - Incorrect Order

    Could anybody help with this problem that I have been given by one of my colleagues. We have a report that groups contacts together depending on the code that we have given them, the problem is that they are not ordered correctly. They are ordered as 1,10,12,13....,2,20,21 and so on, where as...
Back
Top Bottom