Search results for query: *

Calculation means the diff. between dates (# days). Doesn't work means it returns an error or incorrect #. I just used your tips and in this case kept the expressions in the header or footer and it worked. I think the real key to what I am asking has to do with where you can and cannot place...

As I said I have always found a bit of confusion, but the report I'm doing it kind of made me stop and ask the experts. I have a query which tallys the difference between two dates. In the report it inserts the resulting numbers in a column along side the other data. I want to create a...

In spite of all the Access reports, etc I've done, I still find the topic of where to place a formula to be confusing. I can't find a pattern or commonality to tell me. Do you put the formula for sum or count, etc in the header, footer,or detail or in the group header or group footer you have...

Sorry but I don't have Northwind available. Staff names are random (non-alpha within their division, but each division has a portion of the alphabet A short sample of a report extracted from say, a table called customer DB: StaffName Beginning Customer Ending Customer John Lopez Petula...

I have a DB which includes customer names. One report runs an alphabetical list from A on page 1 to Z on the last page of ALL customers. It also counts in 2 ways for the customers. For example for the last name Adams it will list all of the Adams then all Arsten's. It will give a running count...

It still pulls in only the second column of data-for example Col 1 Col2 Col 3 John smith 293 234 1234 it pulls in smith and thats it

We are trying to importing data from an Access 2000 table into the contacts in Outlook-why reinvent the wheel when we have the info we need. The problem: it imports only the data from one (the 2nd) column into contacts and not the other fields ??

We are trying to impoting data from an Access 200 table into the contacts in Outlook-why reinvent the wheel when we have the info we need. The problem: it imports only the data from one (the 2nd) column into contacts and not the other fields ??

In the process of reading your responces, trying them, researching Microsoft and experimenting, I ran across the solution to my problem, although I have not yet tryed implementing it in a form. Refer to "http://support.microsoft.com/kb/210530/en-us" and specifically the following expression...

Happy Holidays to u also!! OK that was a little clearer- sorry to belabor this- I'm visual so I just have to do it once and I will then be ok. So one more ?- if I use the form to fill in the table, I'm trying to picture what the query will look like- in other words in a simple query if I used...

IGPCS- I don't quite understand this part: "use where the form is marked with a check or something like this"

OK. I agree it's clunky (good choice of words!) A form would seem to be good idea. I haven't done it that way before so 2 ?'s : 1--- does the form have all the fields from the query (so u can use any one or more field? OR does it just have the fields u want to prompt for? (ie, if u put in say...

More specifically-more than one prompt can be used in a single column of the query, but what if you want to narrow down the reults by ALSO using another column? For example If you use the ? "what is your favorite fruit?" The answer might be apple, but it may be apples and oranges or apples...

We commonly use queries (and the same ones in reports) that prompt for user input and return the results based on the answer. The problem is when there may be more than one answer desired. An example- The query prompts for "What is your favorite fruit?" The answer might be apple, but it may be...

thanks but it didn't make any difference. It complied, ran correctly and I still get an error

Just did-you are right.

I have a rather simple A2000 database-one table (not linked), a couple of queries, a couple of forms, no reports and a couple of macros After finishing I tried to create an MDE file so no one could moify the orig. file. The utility runs for a while and then generates an error which I checked...

I have a rather simple A2000 database-one table (not linked), a couple of queries, a couple of forms, no reports and a couple of macros After finishing I tried to create an MDE file so no one could moify the orig. file. The utility runs for a while and then generates an error which I checked...