Can you explain how I would do it? I found this on the internet but I'm unsure about the values (9,0) what does the 9 and 0 refer to?
alter table stores
modify record_id numberic(9,0)
I have a two tables one with 4265 records and another with 670 records that are setup identically but with different data. The first table has a primary key. So when I try to copy the data from one table to the other I get a duplicate key error.
So I'm trying to do an insert statement that...
I have a form with a subform. In the subform is a work order number. I would like to use the work order number in the criteria for a query. That way I can tell it to print a report in the form and it will print the report that goes with the form currently being viewed. I can get the report...
Well I looked around the forum and found some info on my problem. I know now that I have to create a report. But how do I get the report to show the info that I selected. This is how my database works. I have the following tables. Post inv, sign inv, work order. there is one post for...
I have a main form with pulls information about signs. Then I have a sub form that contains the work order information for those signs. I want to be able to print the form but only the current record. I tried print current record but what it does is it prints the current record of the main...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.