Search results

No, I meant inverted commas. They are required around each section where a space may occur, such as in "Microsoft Office". Not sure why you can't see them. Here is the string again with X substituting for inverted commas (") XC:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXEX...

Not happy with my summary query. Here is another example, but it is still not good. Best bet I think would be to append the results of the first three to a new table, then produce the final result from there. Regards Chris B

I would suspect that the ones which are working have only one entry, and the ones which don't have more than one. The total shown would be the last detail entry for that organization. Resolve this by using a running sum in the detail section (hidden) then you should get the correct total of the...

Don't know how many you can have, I have done 10 or so, but there are many ways of assembling data like this in (I think) an easier way before trying to organize a report. I would be looking at a series of queries which appended their results to a new "reports" table, then I would pull the...

OK. I am still not quite convinced that this outcome is what you seek. Note that the outcome if the stated conditions are met will change day by day. I wonder for example if the first condition should be 10 days OR MORE or 10 days OR LESS than the search date rather than exactly 10 days before...

I think your main problem is that your setup is incorrect. It seems that you have created records for each order "in advance". I would not do this. Creating a new record for each new order seems to resolve the issue you are facing. Avoid using an autonumber primary key as your PO number as these...

Are they really AND/OR remembering that if they are all AND you will get results which only fulfill ALL of the conditions. OR willl give those which fulfill ANY of the conditions. It is not difficult, you need a query for each condition then one which draws its result set from all three. Just...

It certainly can be done. I do it all the time. The user doesn't join the workgroup, he/she can stay in the default workgroup. If you create a new shortcut - desktop - right click - new - shortcut, and put my line in it with the appropriate info, it will open access, attach it to the specified...

Simplistically (is that a word?) in the query criteria of the date field, - Between [Enter From Date] And [Enter To Date] - will provide prompts where you can enter from and to dates which will limit the result to that date period. If your form is based on that query, you will see only the...

Here is the whole string for Office 2003, the Office directory will be different for other versions. Note the inverted commas - "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:\SomeDirectory\SomeDatabase.mdb" /WRKGRP "C:\SomeDirectory\SomeWorkgroupFile.mdw" Chris B

Odd, new controls should reflect the data the same as the originals. Can you copy your db remove the records and attach it here? Use the Go Advanced button to attach a file. Chris B

Is the form based on a query or directly on the table? If a query, have you added the new columns to it? Chris B

<<do I have the split the database or do they have to do it - if I have to do it (which I've never done before) is it easy enough to do?>> This was a private message. No prob with that, but better I think that everyone can see the response as we all want to explore the possibilities don't you...

You seem to be on the right track. The join would be employee_id (a number which never changes). All employees would be referenced in all tables by this number. Name and details appear only in the Employee details table. That way if a name or address changes, there is only one dataset to alter...

This usually occurs if you are trying to have multiple users open a single db and they are not all using the same workgroup file and or the same version of Access. Also the name is inappropriate, something like DdsV2Sep.mdb perhaps. Split it into a backend containing the tables, and provide each...

Use a make table query which you can fire with a macro if necessary. Chris B

or like "cashpayer" & * Result is probably the same, but I am not sure without testing if the * works inside inverted commas. Chris B

OK. If you wrap your whole calculation in an IF as I did in comment #8, you can push it to Monday if the result would otherwise be Sat or Sun. If you can't get it to work, post the whole calculation so I can see exactly what you are up to. Chris B

Have a look at this - http://www.lebans.com/loadjpeggif.htm Chris B

Am I still missing something I wonder? Date()+7 adds a week, eg Monday +7 is next Monday. Will this be used at weekends which means a different outcome is required. I don't understand Chris B