Search results

SELECT sites_users_and_role.PUID, sites_users_and_role.PUID_Name, sites_users_and_role.Create_Date, PUID_and_UINs.UINs, Authorised_Demanders.Authorised_Demander, UIN_TLB_MG.[TLB Code], TLBNames.[TLB Name] FROM ((sites_users_and_role LEFT JOIN (PUID_and_UINs LEFT JOIN Authorised_Demanders ON...

Hi all I have created an outer left join between tables. However the data is a bit messed up and the second table has multiple tuples that tally up with the tuples in the first table is it possible to only display the first set of values from the second table, ensuring that each tuple in table...

I am getting an error with a query. specifically when i try to do a date conversion. Access will throw up an exception when a field contains a null value or a value that can not be converted to a date. I need a way to bypass the conversion of null or other values (the text value of these fields...

Whoa guys no need to get so antsy I'm just looking for some reading on this subject and I was figuring you guys could help. e.g. information on how ensuring the accuracy of data has evolved from the days of flat files to 2009. I figured you guys might have read some interesting material on...

Hi all I am currently working on a project for University that requres me to examine data and how its accuracy can be maintained. Specifically I am examining where the responsiblity for the accuracy of Data should lie. Whether it is the DBMS, the database as designed by the administrator, the...

I have two tables. One of the tables has two foreign keys in it that are the primary key in the other table. How do i set up two seperate relationships between the tables as one table uses the primary key of the other table as a foreign key in two fields

I am currently trying to create a program using Microsoft Visual Basic 2005 in conjunction with Microsoft Access 2003 but I am having a few problems and I was hoping that you could help me out. I want to use some sort of DataGrid to present data to users I also want to be able to define the...

Hi guys, I have a huge problem with a table I'm currently making and I was hoping you could help. I have created a field in one of my tables using a Combobox lookup that only allows users to enter one of two options. What I want to do is restrict the other fields that a user can enter data...