Hi All, Is it possible to create a Make Table query in access (2.0 and 2003) that creates the table into a SQL Server database? Following the steps: 1-...

I have a field titled Decision. There are serveral options writting under decision. How do I run a query where everything but "TBD" , "In-Progress", and...

In an Excel spreadsheet there is 'conditional formating' for individual cells. So fo any given cell in one column you can for example add days in...

I am using a form to supply date for report query. I want to use the same date in three different places. as you see in the SQL the three places for dates....

How do you count the number of days in a month without giving the start date and end date. As everyone knows jan has 31 days, how do u get this info as...

Je me trouve dans la situation suivante après avoir installé une imprimante LEXMARK 1180 : Impossible d'imprimer plus d'une page des courriel reçus...

I'm trying to create a query in Access and want it to include everywhere where it says "TBD" as well as the blank fields. I got it run all the "TBD"s not the...

When nesting IIf statements, it seems to me that subsequent IIf's always end the previous IIf. In other words, there cannot be another IIf statement in both...

Hello all! I'm trying to write a make table query using the table "Portfolio" to pull out only the end of month data. For example, the Portfolio table is...

ocity ost ozip dcity dstate dzip consignee shipdate a b c d e f cat 1/1/2008 h f g d e f cat 1/2/2008 p k l o z t cat 1/2/2008 l st mn d e...

I have two tables: tbl_Audits and tbl_AAL_Items. I need a Yes/No field "Design" is Yes when is "Design" . Also, in some cases, I need to keep is already true...

Hi, I have a query which returns selected fields into a report in a schools database. At the moment, the report shows all the entries as one list (which is...

In a database I have 2 name fields 1 for last name and 1 for first name. FOr each field I have the following criteria: Like !! & "*" Like "*" & !! & "*" Like...

Hello, I have a Transaction history table that records transactions and the information that goes along with them line by line. The records I have are as...

I would like to query an Excel spreadsheet using code behind an Access form to check a value in the spreadsheet before importing it. This is what I am...

Hello, I created an "Equipment Calibration" table, including the following fields: l_ ID _l_ Description _l_ Serial Number _l_ Next Calibration...

I have a database with around 4,400 records. The main form I use to manage the data combines all these records into 360 "pages". I have the main form and...

I have query set up that counts the number of entries in each category ("died" "sold" "euthanized" "born") in a specified field from a table. I would like...

I have upsized access to sql2005 server. Access front end. I have an open form for user to type in data to update the table link to sql2005 server. I have to...

I'm doing a select query on linked tables where the source data is in an AS400 database. It's a left outer join query (tableA left outer join tableB on...