Search results

I am having trouble with using a #symbol in a field name. When i export the table to excel the # symbol is substituted with a . I know that the # symbol is a wildcard.... can it be used as a field name?

All, I am struggling hear novice "coder". I have pulled together some code that helps export many tables into one workbook in excel. see below. I would like to have it set up so that the user can select the path and file name for the export but do not know how to do it. Also for some reason...

I am trying to import an excel sheet into Access. The data that is in the excel table is going to go into 3 different tables. Two of the tables are a one to many relationship to the 3rd table. They are joined by primary keys and lookup tables. My question is how can i import the data into...

I am trying to export data from a query that will export the data into multipal tables.......... so i want all information from variable a to be on its own table and then all information from variable b to be on its on table........ I was thinking that this could be done throught a macro.... but...

All, I am trying to increase the number of possible groupings that you can do in a report. Does anyone know how to do this?

Ok..... next issue i am buiding a form that has a field that the data in the field is always associated with data from another field. ex.... A B XYZ XXXXX ABC AAAAA XYZ XXXXX ABC AAAAA My question is how do i make them dependent of each other. So...

I am trying to add three different fileds to create a unique ID. Two of them are formated as text and the third is date. The issue that i am dealing with is that the date is formated as ex. 8/12/2008. What i would like is 8122008 so i want to remove the "/s". Does anyone know how to do this?

Hi all. I am trying to build a query that combines several fields. The situation is as follows.... 1. If a is > b then i need a 2. If b is > a then i need b 3. If a is null then b is not null 4. If b is null then a if a is not null 5. If a and b are null then '999999' I have everything taken...

Hi all, I am trying to create a field that has a combination of two things in it. The first is a field that contains values the second is that if the field is null i wish to add the number 999,999. This is not a problem i can combine the function however it will not keep the formatting as a...

Can you do an SQL IIF Statement for formating? I am trying to Bold a value only if the value is greater than a value in another column.

I am trying to conduct a query that is based on two separate queries. Is there a way to that the queries can be related based on multiple fields?

This may sound I guess you could say stupid but...... Is there a way to add a less than symbol in a colum and still keep the value a number rather then text?