Search results

I used form wizard to create a data entry form based on a table. The database user wants to print the form that only show the data fields that have information in them. For the data fields that have no information, they dont want them show up on the form at all. How do I set the condition...

I work on the database someone else created. Now I want to merge two data fields into one. How do that? Thanks for any help!

One of my data fileds in the database is called "number of items", so I set the data type as number (filed size - Long Integer). But the problem is that when the number exceeds 1000, my user would like to have a comma in between the number, so that it would be much easier for them to read larger...

I have a pull down list from tblType on my frmCPU that I'd like to set a default value. For example, if user want to add information about CPU, my equipment type should be set as "CPU". How to do that? Thanks! Nadalia

I was trying to use outer join to join 4 tables together, so that I can run a keyword search across these tables. The tables that I use to join are: tblMailing (main table), tblSPerson, tblAddress, tblContact. The relationship between tblMailing and tblAddress is one to many, and between...

I have tblAddress that contain over 4000 records. There are 70 more records in a seperate table that need to be added into tblAddress. Currently, these 70 records are in a seperate table called tblSAddress which has the same structure as tblAddress. I was trying to use Append query to append all...

help on mailing label, pls! My mailing label layout looks like this: MLabel JobTitle Company/Department Address1 Address2 Address3 =Trim([City] & " " & [State] & " " & [ZipCode] & " " & [Country]) There are several fields that could be blank. They are JobTitle, Company/Department, Address1...