Search results

As far as having a different table for historical data, that pretty much depends on how your table will be growing over time. If you feel like the extinguishers checked will be growing too fast, then it might be a good idea to have all records for extinguishers checked be entered into a...

The table tblExtinguisher looks ok. But you might wanna add a field to store the date the extinguisher is checked eg ExtinguisherCheckdate.

You may want to add a new column, set the field as text, then use an update query to populate the fields, setting NULL where the value is ZERO ie you already have a table with a column A. This column is the one that has the data to be updated. Now Create another column B, set the data type to...

I have these three tables A, B, C and D. IN table A, SSN is the primary key. Tables B, C, and D have other columns, but the also have SSN as one of the columns. Also SSN is NOT required in other tables. What I need to do is to be able to run an update querry that will update the value of the...

Resolved Thanks Smart!

Hey, I have a table with columns A,B and C. Column A may has a value that may be duplicated. eg A B c 1 2 3 1 5 8 7 5 4 5 6 8 I need a querry that will only return the 8 unique numbers, instead of 12, which is infact the total number of entries!

Thanks buddie.

Hello, I was wondering, is there a way to comment out some of your SQL codes in Access querries, like you do in Oracle or SQL Server or VB? I need to know how to write comments in my SQL codes when usingh access

It would be important to identify the market niche that you are targeting. I cant see you kids clothing in mind. However, you have to know thier goegraphical location ie, is it Indian Kids in India, or Kids in America , Uk etc. Here in the United states, this would be a big business, if you...

I have three columns TU, EFX, XPN a fourth column FICO which is based on the values in TU, EX and XPN. I need to update the FICO column so that it is either MEDIAN of TU, EFX, XPN or Minimum of TU, EFX Minimum of TU,XPN, Minimum of XPN, EFX I expected the SQL statement to be something like...

Hello A select statement i this line should help . I used it in a similar problem, and it worked just fine. SELECT CustomerName, date FROM tableName WHERE date >[Input start date] AND date <[Input End Date]; I assumned that the table is called tableName and that you need to view the...

Hello, Been wondering how I can update fields in my Access database table using data that lies in an excel spreadsheet. They have a common row ie say account number and other common fields that need to be updated. thanks

Probably this may help. on your Access table, go to Tool,=>Office Links => Analyze It with MS Excel Good luck

Hello, Is there anyway possible to restore a database to a former state? what happens is that I updated some information unknowingly, now I get into my database, and I cant find some data, which I suppose i updated probably the last time I worked on a the table. Any clues on how to handle this?

Hello Peeps, I'm trying to import an excel spreadsheet into an access table. The excell spreadsheet was created using the access table( by using the 'analyze using excel' feature) The problem is that I cannot import the updated excell spreadsheet. I get the error message.." An error occured...

Hello, This may sound too common a question, but I really need help on it. Prior querries in the same do not seem to solve it. I have two tables, table1 and table2 with the following fields table1 ( ACID, name, address, Salary, MStatus,Age) table2 ( ACID,salary, Age) ACID is the common field...

Thanks for the insight FoFa.

I have a table in access. The columns are State, FICO, LTV, DTO,LBI and Grade need to update the column (Grade) so that it gets the values A, B, C or D based on the following conditions If FICO >525 and LTV <100 AND DTI <50 then grade = D IF FICO >600 AND LTV BTWN 90 -100 AND DTI <50 Grade =c...