I have a table imported from MS Excel which contains data in which I want to appear in if a value exists in and . How do I go about this?

Hello, I'm relatively new to Access development. I've got several fields in a database that are boolean, and I have buttons on a form corresponding to...

I am sure there is a simple solution to this I have a query that has "Week: Format(,"ww")" and then it groups by , ascending order. The problem is that it...

Can I do math in a query? I forgot to bind one of my text boxes to a field in a table and I need to be able to add these up. Kind of like a update query. I...

Can I store input to a query to use in subsequent queries? I'm trying to allow the user to enter one date that is setup in a subquery and then add to that date...

Hello, I have a pretty basic query efficiency question. I am wondering if it is more efficient to create a new query that includes a smaller set of fields that...

Hi I'm creating reports which show all of the information I have in my database for a person. Since I want to access just about every table in my database as...

hi, all! i have an append query and i would like to customize its message when it's about to append or cannot append bec. it violated some restrictions, so...

Our business uses the SQL based Sage business system. I have written a large number of queries on the Sage SQL database tables using the ODBC link to Access....

I have a query that looks to add fields from two separate spreadsheets. The query does add the figures together properly, however, when it writes the output...

Hello everyone. I have an access database for a auto dealership. One of the tables is called 'Features' Air Condition - Yes/No value option Power Steering -...

I need to automate a mail merge from a form in my access 2002 database. I've tried importing the code from a recommended...

Hi Newsgroup! I've got a litte problem with an sql statement, I'm sending to an access mdb by an C++-Application, to get "a newer value than the last...

hi all, I have a column with dates across several years. I want to get the week of the year corresponding to each date. However, I'm noticing that with each...

Hi, Hope you can help me! I am trying to use a crosstab query to chart works order, the fields I have are stockno, description, unit of measure, qty, job...

I inadvertently deleted Internet Explorer from one of my pc's (Windows '98). How do I reinstall it? I began to reinstall Windows, but I stopped in fear of...

I need an SQL statement to combine two fields into one - displaying that results in an SQL query. This is how my data looks: My Data: Record 1 FirstName =...

Hi I have a table of data that has been supplied to me where the date fields are in the format 1041231 - this would be 31st December 2004 i.e ignore the 1 at...

Hello everyone. I have an access database for a auto dealership. One of the tables is called 'Features' Air Condition - Yes/No value option Power Steering -...

Hello: I just need to know how to get any letters entered into one of my fields to default to upper case. For example, if a user enters 912795rn3 it needs...