Search results

How do you use a Nz function?

Hi all, need some help. In my query I have 4 fields, a weekly labour cost, weekly material cost, weekly plant cost and a weekly summary. The problem I have is that my weekly summary shows a null value on some weeks as not all the weekly costs have a value assigned to them. I have been told...

HI all, I have recently created my own custom toolbar for my database which works fine on my computer, but when the database is transfered to another computer via a memory stick (needs to be done as it is going to be used on remote laptops away from the main network), the custom toolbar does not...

Sorry if this sounds stupid but how do i put in a foreign key?

I have a table which has a field titled equipment with various types of equipment listed in it and a field titled job number which contains the job numbers. Each job number needs to show multiple equipment types but when i add a new record to add the new equipment access says i can't have...

Hi all. I am new to the use of access and have been told that I need to create a one-to-many relationship to be able to have several records from a drop down list saved to one unique number (my primary key). Is this correct and if so how do I do this? If it is not correct what is the best way...

if the query holds the same fields then it may be possible to just change the record source to the query. To do this double click on the little square that joins the margin rulers go to the all tab and the first line says record source. From there use the drop down box to select the query. Give...

The reason for repeating the data is that I have one unique number but have many fields associated with it (rather then one unique field with different data) that are requested to be in seperate tables. Therefore I need to show this unique number in each table otherwise people won't know which...

Could someone please shed some light on any methods on a way to update fields automatically in different tables but with the same field name when data is entered into one of the fields in any table? Thanks

Could someone please shed some light on any methods of linking several reports? Is there also a way so that they can be printed all at once and all show the relevant data for one record (the multiple reports are based on data drawn from several tables for one record)? Also is it possible to...

The the tables contain different types of data mainly yes/no, numeric, text and memo.

Hi all i'm in desperate need of assistance. I am trying to construct a form but require data to be drawn from multiple tables (7 to be exact). I considered creating a new table but then i would be repeating data and i considered using a query but unusually the required number of fields would...