I have created a number of queries which calculate the volume sold per
account for specific products; I am now trying to collate these into one
summary table with a row for each account and the products as column headings.
When I add the first column the output is correct, however ...

Simple question - Is there an equivalent formula in Access that will
duplicate the DAYS360 function in Excel?  The DAYS360 function is used to
calculate the number of days between two dates based on 30 day months.

I have a field in a query using dlookup to find a minimum date in a table but
it does not sort by date.  I have tried formating it but it still sorts by
text.
delivery: Dmin("MyDate","Mytable","MyID = ID")

My subject is a mess, i apologize...
I have a dataset which I am searching by two fields, season and week...
Season is an endless number increasing once every 16 weeks. Weeks loops
from 1-16 for each season. My goal is to write a query which will

i am trying to get the formula to change decimal degrees to degrees, minutes,
hundreds  or to degrees minutes, thousands.
Any help would be appreciated.

Hi, i need to create a query that calculates the percentage usage of certain
feilds
Im creating a booking management system.
i need to work out the percentage that certain booking slots are used eg

I have a table called tb1.  There is a field called Per_Num  in a Query which
is based on the table tb1.
I have a second Query which generates values for the field called Per_Num.
How do I write a DCount function for a variable??

hey all,
I have an un-normalized table named Products which can have several
categories associated with it. Four to be exact.
So I have in this table four different fields that store the same type of

My autolookup query works fine until I add a third linked table.  Is there a
way around this?  I need to add additional tables to this query to perform
lookup functions.
Thanks

This should be simple, but I am not getting the results I want, so I'm
asking for help with a formula to give me the lowest value from 3 fields, as
long as there is a value in the field and it is greater than 0.
The fields are Test1, Test2, and Test3 and the default for all the ...

I need a query that will delete spaces after the text in the field.  I have
code that pulls the 10 chars that populate this field from a very long
string.  The problem is I don't know if my actual data is 6, 8, or in fact 10
chars.  

I am having a problem with a query. I am trying to make an equipment list
and  I have 5 tables (Category, Sub Category, Component, Subcomponent and
Maintenance) linked linear except for the last two which are linked to the
same table. My goal is to make an equipment list that ...

I have the following query:
SELECT tableBackup.BackupDate, tableBackup.Type, tableTape.Serial
FROM tableTape INNER JOIN (tableBackup INNER JOIN tableJoinBackupTape
ON tableBackup.ID = tableJoinBackupTape.BackupID) ON tableTape.ID =

In a table, when a field is defined to be Date/Time, the date and time is
part of the field.  In my case, the time is always 00:00:00 because it is not
used by me.  On the date part.
Is there a way to note have the time part appear on a table???  I would just

I have 3 tables containing the following information:
1) Job Categories & Descriptions
2) Pay rates for the job categories at specified time intervals - e.g.
- 6 mo, 1 yr, 2 yr - with a date field that marks when that pay rate