I am trying to make a form, where I have 4 lookup boxes. I also have another table that it is looking at, I wish to make each of these four look at only...

Can anyone tell me how to count the number of times a yes is recorded in a yes/no field Thanks

Is there anyway I can attach an alpha number such as "A" to my auto number field? Thanks

I cannot see where my linked tables are linked to, and of course I have forgotten which database I used. I go to tools, db utilities and linked table manager...

I have a very simple problem, but can't get it. I have a date stored in text format, I want to take 7 days from it. I have tried -7 which works fine until we...

PERCENT: IIf(Now()DateAdd("yyyy",+1,),"4%",IIf(Now()DateAdd("yyyy",+2,),"5%",Null)) 2PERCENT:IIF(NOW()DATEADD("YYYY"+7, ),"7%",IIF(NOW()DATEADD("YYYY",+15,...

Can you explainto me how I can have multiple Like p* in a select query. I know I can do two rows for it but need more than two. Thanks

Help; can some one please tell me what dim means as in Dim ename, then code after it. I thought it was a diminutive of a name but I have tried making a code...

I have 2 databases BowlingLeague1.mdb and BowlingLeague2.mdb BowlingLeague1.mdb has info on teams 1,2,3 BowlingLeague2.mdb has info on teams 4,5,6 There are...

I have a simple example. A simple single table db. My table has 20 or so fields. I want to modify the Sub_Account field based on the Accout field. Something...

Hello, Hope someone can give advice on how to do this. I have inherited a database with a large table in it that has 5 fields; field 1 is text, fields 2,3,4...

Hi hope someone can help with an annoying crosstab problem. I have set up a crosstab query to show sales qty to each customer, by month, over a consecutive...

I want to have the same data in two different tables. (ex. user id).

I have an excel function that writes down a currency style number, and I want to incorporate this to a form in a A-2000 db. Objective.- To have this function...

as subject

What is the maximum number of TO's that can be used (in one shot) in conjunction with Outlook Express. I have an application that will need to send out 500 or...

I have Access 97 and Access 2000 installed on my XP Pro computer. I plan to install Access 2003 (Upgrade version). Of course, I'll be installing it to it's own...

Can anyone recommend a good Find and Replace product for Access 97. (I'm really more concerned with the FIND portion, with a good reporting/printout...

Installed Access 97 on my new XP system. Using the Custom install, I requested that the installation be placed in C:\Access97. When the installation was...

In a query, in a date field, I have the following parameter/criteria... Between And I'd like to offer the user the option of entering a date range...