Search results

It works now, thank you very much for your help!!!

not working For some reason, when I enter in that formula, it only gives me the entries for the last two days, nothing from 8/2/2002. I put the exact thing in the critiria part of the query, under the dateval feild. Am I doing something wrong? Thank you for your help!

I have a database that I want to only pull the entries from the current month up, I can't remember how to do this. could someone please help me.

I have a table that lists user act# billing_element timeOnSystem Cost The billing element is either one of four choices, each choice is discounted a different amount. so it looks like this billing_element cost choice one $$$$ choice two $$$$ choice three...

I am now having a problem, b/c I need to have these numbers multipled by another field. What i mean is, when I asked for them to be multipled by .30 or.17, I need the database to take out say dialup from the field billing element, and if it is dialup then multiply .30 by another field like...

Question to sohaila Sohaila, I tried it your way and when I saved it, it told me that the function had the wrong number of arguments. Could you help?

I am trying to build a query that will take a large amount of data that is sent to me so I can be able to allocate charges to users of a particular thing. The only problem is it is a phone line and for each different way of connecting, 800 number, dial up, VPN, there is a different discount...

Thanks I will try that right away!

I am building a database that calculates totals on users in a system. I have a generic list of all possible users, and every month I get a list of each time a user went into the system and how long they stayed there. My question is, I can't seem to get the reports to just show a user once...

Thank you so much, it worked great!!

I need to build a query that allows me to show all form entries in the past 7 days. I have a date entered feild already. I also have an ID # that is a primary key, and I would like to build a query that allows me to pull from a particular ID number foward. Any Ideas?