Hi, I am creating a database that includes classroom information, such as: grades, attendance, etc. I have one table that is called Student information and...

hi, i need help. i have to write an if/then statement in access and it's for my query1 - the statement is to be written in the - advance_amount field - and i...

The following is a direct copy and paste from my intranet website. (I am printing the sql to the browser for testing purposes and the list of dummy tasks you...

Hi, I wrote a simple query in Access VBA that has been working for several months. Suddenly, it stopped working yesterday. It went something like...

I need to come up with a make Invoice table qry to export into excel in the Quickbooks IIF format. I have been goofing around with this for a week. I think I...

When I run the IRR function in Access, I get the error message: "Undefined function 'IRR' in expression." Presumably I need to load the relevant reference...

I have created a query which displays the results in a list box. Within this query there are a couple of fields which criteria is linked to combo boxes. When...

Help, What am I missing? I have a query that I am limiting by date - between 4/2002 and 9/2004. Unfortunately , I only have months and years to work with. When...

Hi I am currently using a pass-through query to run a SQL stored procedure - is there a way for me to create a 'make table' query to run the SQL stored...

table A carrier price year op 3333 2009 ot 233 2009 op 1200 2008 op1 1400 ...

Hi all, I'm getting to grips with SQL (within Access 2002) but am finding the SQL view to be a bit of a pain. Each time I quit and go back it, Access has...

Hi All, I'm hoping someone can explain this but first I'll give a little history. I was recently hired for a job and one task is to convert all Access...

Hi! I have an Access 2007 Table that I Have linked to a pivot inside of Excel 2007. I want to be able to pivot on a date field, and have identified the...

i have an update query that updates the database with new data. i want to run this update query every thursday at 12 noon EST. is there a macro that i can use...

Can any help - we have recently moved to XP incl Word 2002, since then I am unable to merge any Access Queries that i have set criterias in over to word - it...

I have a table that contains the following data. order number, narrative, line number I need to use a make table query to create a table that if the line...

Hello, Can someone tell me how to suppress the pop up (yes/no) messages that appear if you run a make table query? Jai

Greetings Access Users, I'm here to sell something. An idea. Some of you may have heard of a system called Dataphor from Alphora. I have been working with it...

Hello, I am trying to develop something, but I am running into some trouble. I need to do a search on a memo field based on a long string. Basically, I would...

I am using an Access query that includes calculated fields to merge into Word. When Word tries to pull the query in, it drops the data. Any experience or...