Search results for query: *

I'm trying to set up a simple Form which captures customer name and address - and date of entry. On the Form, I've created a new field called Entry Date which is =Now(). As I go through the Form I see the correct date, but it is not saving the date back into the database with the customer name...

When I run a report, then try to export the report into a snapshot (SNP) file, I get an error message that states: The report snapshot was not created because you don't have enough free disk space for temporary work files." However, when I clean out my recycle bin, I still get the message...

I have three fields: State, Total Sales, Sales Person. In a query, what is the formula/syntax for calculating the ranking (most to least sales) of sales persons in each state. I tried- New Ranking:Rank([Sales Person], [Total Sales], [State]) but I got an UNDEFIND FUNCTION error. Any ideas...

Heellllppp! Is it possible to increase Access' 2 gig limit? Does Microsoft sell an addin or something that will increase the file limit size? Or, is there anyother DESKTOP database program like Access that has a larger file size limit? I've tried many things to get around this issue like...

How can I use Access to calculate a regression between two fields? IE: Field 1 - y (Cost $) and Field 2 - x: (Month). I tried: Field 3: Slope([Field 2], [Field 1]) but Access didn't understand. Please advise.

In a report, I have inserted a page break after a grouping footer. However, I don't want the grouped data to show up with some on page 1 and then some on page 2. How do I have the report print a grouping on a new page if there's not enough room to keep the grouping on one page?

I'm trying to create a macro that will run a bunch of make table queries. But, when I run Make Table Query 1 it says 'do you want to delete current table' which I do, but how do I have the macro automatically do it rather than me having to click yes. Currently, the macro stops running to ask...

What is the limit of Access in terms of records and fields. What happens when the limit is reached (ie: does Access crash or will it give output but with errors)

I need to calculate a regression within MS Access but don't see how to do it. I also need to calculate a moving average (7days). Can Access do this or do I need another software program. Please tell me the commands.

I have data for the month of August and want to compare averages for 3 days prior an event and 3 days post. How do I program such that Access looks at a start date and uses 3 days prior than and then 3 days post. Thanks.

I have a dataset with a numeric field that is actually a date. The data is listed as 010828 and I need it to become a date field like 08/28/01. Any suggestions?