Hello All What's wrong with this: SELECT staffs.DOB, CDate(retirementdate(,)) AS retdate FROM staffs WHERE (((staffs.DOB)#1/1/1901#)...

I don't know how to implement a function, or refer to one formsa query. I have a table with Lat/Long coordinates for a number of locations and want to use...

I have a query with this function as the field: Outstanding Days: Date()-! The SentInDate field in the Customer's table is a date that represents when the...

I have 2 tables: TestTable: ID – Autonumber First Name – Text Last Name – Text Added 3 names to Table1 TestTable2: FullName – Uses Lookup to Table1

Hi, I'm new here. But this is driving me crazy! What is wrong with this IIF statement? Sometimes, if I try to use "|" because of errors with a "," and it...

Hi, yesterday I have installed the SP2 of my Access 2007 and now I have the version: Microsoft(R) Office Access (12.0.6423.1000) SP2 MSO...

I need to write two seperate statements. One returns the max value from a table and the other returns the 2nd highest value. Any help?

I am trying to develop a union query for my 2 inventory balances. the query comes back with the first 2 fields correctly but when it comes to the balances...

Hi all Is there a way to run a saved query like we can run a macro (docmd.runmacro)from within a VB sub? Thanks -- Alex

Hi there I need some help, to matching data! eg: out of 20 elements: eg (10,2,4 17,24,5,30, 40, 50, 100, 23, 35, 200, 3501, 201, 245, 323,2000, 33,...

A query I recently successfully completed gets mangled when I save it. No surprise yet. The mangling consists of replacing the parens around a subquery. The...

I used fields from three different tables to build a query. Table 1: Investor Name & Investor Category Table 2: General Information, Source, Date Table 3: ...

HOW DO I SET PARAMETERS FOR A BIRTHDAY QUERY. I NEED IT TO PULL OUT ALL STAFF THAT HAVE A BIRTHDAY IN JANUARY, FOR EXAMPLE. SOMETIMES I HAVE TO HAVE A TWO...

Hello. We have a database used just for reporting with status records that have a date and workstation fields as in: TempStatusRecNo TIMESTAMP ...

hi how can i make a query which will automatically run 2nd tuesday of every month. Can some one help me on this please. thanks in advance --

i've put a lot of work into my forms/reports and i want to protect & seperate them from the main data tables if i split the databse in two - should i leave...

Hi, I have created a query for the table with check mark. For some reason I can not check my checkmark in query, but I still able to change it in the table...

My db has 6 fields all populated with numbers from 01-55 and there are 1404 records. How can I write a query to tell me how many time each of the numbers (say...

I Have a form that has a button that when clicked it sends data from a query that i have to a excel spreadsheet. the problem that i am having is when i run it...

I want to create a formula that can test each vendor name field and return a 1 if they are all the same or a 2 if they are different. I tried a nested IIF...