I have been given the dubious task of developing reports from a db that someone else did. Unfortunately, there is very little (if any) table structure to...

Hi, i have got a query which is filtered, then i have a macro to output the query to a text file (to import into another programme) it needs to be comma...

Hello, I'm using A2003 to create an application that, in part, projects financial results over a flexible time period. The following are either input...

How can I write a criteria as follow: 100, and between 101 to 199 and between 251 to 999 and between 1000 to 5000 Cheers, John

i have an insert into SQL issue where a user may be using an apostrophe and it's messing with the SQL. here's the code: strSQL = "insert into tblNewoptions...

Hello I have an apped queryI have several fieds in my query and a total field (which total s all the fields. When I run the append query all of the fields...

Hi everyone! Hope you are all having a wonderful week! I'm using A02 on XP. I've been asked to extract a list of the most recent statements for each...

I have an update query which needs to be run on a certain day of the month each and every month. The problem I have is that access is not continually open...

How do I go about updating a new value in a table using a query I want to update the table - and not the Form. I have 2 tables 1. CLIENT - Field :...

I feel stupid for resorting to this but here goes... I can't figure out what's wrong with my form based parameter query. It won't accept the criteria...

I have a database that contains dates, names, and other things that relate to the attendance. What I am trying to do is dynamically count the number of...

I'm having a problem I can't see the trees from the forest. In the following SQL I added on the Job Sheet and Me. The SQL was working fine before the...

Hi, I am working on Pass-through queries with SQL, My query need date filter so I want to set date paramenter on that query but from Access97 (in...

Hi I would like to set the default of the 'Find' Dialog to 'Match any part of field' Is that possible and how? Thank you, Samuel

What criteria should be placed on the textbox "qty" on Form1 so that the quantity that is going to be purchased should not exceed the quantity on hand, which...

Hi, I have a fairly simple database that looks like the attached. It is the beginnings of a school database. Unfortunately, the MS template doesn't quite...

Hopefully someone can help me with this. I'm trying to create an Access database that will pull a list of people based on the first two letters of their last...

Good morning, I am having a problem where I have designed a query and I have it looking up certain criteria in 3 fields. Date - Between And Position -...

Hi, I am trying to import Excel sheet into Access but I encounter with a problem in ZIP code field. Even through I set ZIP code column with ZIP format in...