Search results

  1. I

    Count Query for newbie

    Hi I know this should be simple But I just can't get my head round it!. I have a table which stores information on files: [ID] [Files] [Boxes] [Count] ID FileNo BoxNo Count 2 123456 Box1 10 3 654321 Box1 15 4 258852 Box1 25 5 654456 Box2 20 6 753357 Box2 10 7 951159 Box2 10 I want a...
  2. I

    newbie query from access to SQL

    Hi I have a simple query that I use in access which works great! UPDATE dbo_MT_Document SET dbo_MT_Document.Text_Field_8 = [Text_Field_1] & "-" & [Text_Field_2] WHERE (((dbo_MT_Document.ID_Job)="0000000004E") AND ((dbo_MT_Document.Is_Batch)=0)); I can't get it to work in SQL Server, I have...
  3. I

    ColumnHistory problem

    Hi I am having problems with the ColumnHistory contol on a form! =ColumnHistory([RecordSource],"Comments","[contact_ID]=" & Nz([contact_ID],0)) which just gives me "#error" anybody had any experience with ColumnHistory; has there does not seem to be much info on the web about it thanks...
  4. I

    Newbie query help

    Hi I Have two table.... Table 1 (index) Auto id box file_number surname first name done Table 2 ( archive) Id archive file_number surname first name Question 1 How can i query the table to give me a list of all box's that have ALL THE RECORDS IN THAT BOX in the archive table and an...
  5. I

    Autodate table design

    I am designing a table and I need one of my columns to automaticlly enter the date in when a record is created. In MSSQL i Simply add (getdate()) into the default Value Thanks for any help Regards....stephen
  6. I

    sql take two

    Hope this makes sense If anyone can help with my ms sql 2000 I have this question:- I am designing two tables : Batch Documnets In both tables i have two fields called "page" and "name" all the names in the name field are unique How can I design the page field in the batch table to be...
  7. I

    newbie table design sql

    If anyone can help with my ms sql 2000 I have this question:- I am designing two tables : Batch Documnets In both tables i have two fields called "page" and "name" all the names in the name field are unique How can I design the page field in the batch table to be updated with the...
  8. I

    newbie sql database deisgn

    Thanks to everone in forums for help with my access frontend If anyone can help with my ms sql 2000 backend I have this question:- I am designing two tables : Batch Documnets In both tables i have a field called "page" How can I design the page field in the batch table to be updated with...
  9. I

    saving login details

    In my database i have a linked table through ODBC to my sql2000 server. when i first open that table or form linked to that table it asks me for login details for the sql server Is there away to save these detail so it never asks again ? sounds simple !! regards....stephen
  10. I

    Newbie query count help

    Hi I have a column with data displayed as below ;00;0000000000M;00;0000000000N;00;0000000000O;00 Each ;00;0000000000M stands for the name of a linked image file so ;00;0000000000M;00;0000000000N;00;0000000000O;00 would stand for 3 linked images to that file. I Need some help in writing a...
  11. I

    report startup filter

    Hi can anyone help a access newbie I have a table which has 2 colums Name & Box and i have a report linked to this what i want to be able to do is when i open the report a box will come up asking box number when i enter the box number i require it will then just show records relating to...
Back
Top Bottom