I am creating a database table and query for billing that uses the date form month/year, or mm/yy. I want to be able to filter to "year-to-date" in order to...

i was to sort my database to find workers who started between 2 dates in the filter criteria i tried =#27/05/2009# and =#30/06/2009# (wanting starters...

I have a table with 2 fields, one is a primary key to join another table in a query, the other is a hyperlink field with a text display. For example, T04 is...

I need to look at specific records where the root cause is marked TBD to determine when the TBD changes to a valid root cause. However, when attempting to...

In the procedure below I keep getting error saying "Else without if" and the debug points to the "Else" statement I have underlined. If I remove the first...

Hi i have a table with just date of births, but do not show the ages. I designed a query to show the ages from the table with the expression...

Hello, I have a query set up which relies on the user entering a date. When it prompts the user to enter a date the message (Now) comes up to enter the...

I have a field that contains date and time information in the format dd/mm/yyyy hh:mm:ss AM. I want to find all date/times within the time range 7:00 AM and...

I have an Access 2007 table containing a number of columns including 1 multivalue field. I have a spreadsheet containing data that I wish to import into this...

Hello, I was working on a continuous form, filtering it using VBA according to different textboxes on the form. One of the filters is . There as no...

Hi from Barcelona, I've a Table with two fields: date (date format) and sales (currency). There are records for 5 years. I want a query to show date, sales and...

I was give an excel spread sheet of data that I want to normalize in Access. I placed it in a table, but want to change the data layout as follows. Current...

I am importing a table and I am trying to query the average price for an item, the issue is the items have been sold to a variety of customers and at various...

I have a qry called qryEPO built from table called 'Schd.' Each record has 71 fields, EPO1 through EPO23, Date1 through Date23, Med1 through 23. another...

I have an append query. When it is RUN it adds various fields of the record. One such field is DateOfQD. When the next record is added I need to change the...

Hi I have a Access database which store data from my weather station. I am struggling to write query which will give me the maximum temperature in the last...

I have two list boxes on a form that are sourced from queries. They work great. Now client wants this and other forms moved to a tabbed form, one original...

for your financial needs visit www.plicorp.name

I have a Access DB that two different colums should be the same match (Number). I need to create a Query that will give me the ones that do not match...

Hi Folks In a table I have 1 client that can have many funding applications and sub funding applications. I have created 2 tables for this. If a client has 1...