Could you please tell me how to copy an MS Access database.
Actually, I need to have the same queries, the same reports the same forms. The data will be totally different. I make a copy of my old database and rename it. I opened the new table to check the rows, it is obvilously the same. I...
i am writing a cursor and I want to give certain information because, for example the budget year 2000 is from november 1 2000 to october 31 2001. If i am considering the budget year 2000, I want to say if order_1 is done between november 1 and december 31, the budget year is 2000 and if it...
I have to populate a new table from an old one: the problem is the new columns table do not have the same name than the old one. for example the new table is
iNSERT INTO BILL_TABLE (budget_no, VERSION, FISCAL_YEAR
BILL_SEQ_NO...
I had one user try to log in to the Production Database with
her username and password, however, we got this message:"ORA-01017: Invalid username/password; logon
denied." We were pretty sure that we had the correct account information,
but I figured that I would just delete her old...
I have to send a report by email. When I click save as I have 2 choices as n ezxport or by html, I chose the html choice and somehow I cant finalise the process.
I have a field USA, and 4 other North-east, south-east, north east and south east. I have to delete these 4 fields . they have data. I want to have the same info when I query the USA. so i WILL HaVE IN MY TBLE ONLY THE USA and not the regions. How can I do? Thanks
select customer.name, case.caseid, case.customerid, case.status, case.datecreated from case, customer where CASE.CUSTOMERID = CUSTOMERR= customerid, and case.status = 'open' and ((dateDiff("d", [case.datecreted], now())>15<br>(i have 2 tables : case and customer the...
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.