I have a table (Table1) that has a field referred to as 'Type'. For some of the records, 'Type' is null and for others there is data in that field. I would...

Good day, I am seeking help to resolve a query that I want to run from a class Module in access 2003. I first designed the query by linking the two tables...

I have a table in the below format- For example Customer A and Dzip 678 is being served from ozip 099 twice and 011 once ozip dzip customer 099 678 ...

I have a text field (up to 200 characters) and I need to extract a specific word. The text field name is "MEDICATIONS" and the word I need to extract which...

Hi I will import some data from a texte file.(see below) Some data are duplicate or more == by doing a duplicate query, Il will retrieve all duplicate. They...

Hi, I have 2 forms and query. The query contain fields and 2 field have criteria(Forms!Form1!NameControl). I want to use with this query by the second form...

hello to all I have a Report that is based on two crosstab queries, qryA and qryB (shown below). Because these both have exactly the same Row Headings and...

Hi, I have a form that edits a table. What I am trying to do is when a certain filed is filled, two other fileds are fillled based on the first field. What it...

Hi, I need to figure out how many total minutes employee worked during the IVR Timing. Each employee works different shift and it can run overnight into...

Hey guys! First off, thanks for you help, I've been a long time reader of Accessmonster. com and I've learned so much from you guys. I've ran into a problem...

Hi, I have a table to which I am trying to manually add a record. When I add a record directly to the table using query, I receive the error message "You...

We developed modules using MS Access 97 in a server. A query using Dsum works fine in this server but when we ran it in another PC, it gave me #error. I...

Good day I have a query that reads from a single table with two criteria. I would like to extract from 1 or more districts at the same time choosing one or...

Does Access have a like function?

I need help with querying a field (called AddedDate) I want to see all records prior to a given date. The field's data type is Datetime and the format is...

I WANT TO RUN SEVERAL QUERYS SIMUTAENOUSLY FROM ONE CONTROL BUTTON ON A FORM IS THIS POSSIBLE

Hi guys, I have a query in which i want to use a dlookup which i have embedded in a function. Strange thing is that the first record returns the correct...

I run a query for distribution via macro. I could use the 'between dates' criteria, but is there a better way? I have code 'Between...

I have a query that worked fine for a while until now. Error #:3205 Too many crosstab column headers (300). How can I fix this error? Thank you! TRANSFORM...

I have a query that I'd set up a while back for a user on an Access 2003 db. The main table has keys that point to other tables (schools and departments). She...