Parameter Query Not Working

[Switchwork]

Parameter query gone nuts AGAIN!!

Hello peeps. Please forgive me if this is a simple thing but trust me I have tried everything that sorted this similar problem last time.

Problem is: I have an invoice report generated from a parameter query. The parameters asked for are [Enter Customer ID]
Between [Enter Start Date]and[Enter End Date].
Right the other day I changed something on my report and then it started asking me for another parameter. Anyway I received help form this forum about what the problem was. Which was I had something different written in the control source.
I fixed that.
Now when i was going through my database to see if everything else was ok, I noticed that one of the field names in my JobDetails table had a space in it. I changed it to have no spaces as I have read that you are not supposed to have spaces in the titles of fields. The field was TOTAL COST which I changed to TOTALCOST. Not much difference. (This is not a CALCULATED FIELD, just a field that holds the price of each job we have done. WE run a Courier Company). So when I went to do an invoice I started getting the EXtra parameter again this time asking me for the TOTAL COST. Now I can't be entering the total cost into a parameter as all the job prices on each invoice will be the same and not what is stored in the JobDetails table..
I have checked the control source and there is nothing wrong with it. Someone suggested checking the Sorting and grouping but I didn't do any of that sorting and grouping when I designed the report with the design wizard. So what am I looking for in the grouping and sorting box if this is what I am supposed to be looking at??

Could someone let me know please as this is EXTREMELY URGENT!!! I have got to start invoicing again on FRIDAY. I have printed out plenty of invoice reports before I changed the title in my TOTAL COST field and they came out perfect so I can't see what is wrong with it.

Please let me know what I need to do to rectify this problem and if I have to go into the sorting and grouping what exactly am I looking for and doing in the sorting and grouping box????

Please help me
CLARE
A.K.A
THE SWITCH

 

[DJN]

The problem is that Access cannot find TotalCost. Change it back to Total Cost but enclose it in [] brackets. It is true that you shouldn't have spaces, but changing a fieldname without changing every other instance of the name can lead to problems.

 

[Switchwork]

Cheers.

I forgot bout this post till I got home and then I remembered so I logged on to see.
Thanx for the answer. I couldn't check it out until now (this morning) but it works. However it wouldn't let me put it in brackets. Each time I tried my Office Assistant Linx (the Cat) told me that I can't use anything like brackets, fullstops or anything like that.???? How comes?? I wasn't trying to use the normal brackets on the 9 and 0 keys. But the square ones ???

Anyway I just changed it back to the TOTAL COST with the spaces. This is only a first application design tho. I am just about to begin designing another application same as this one but with the things that I missed out and didn't think of on this database system.

Least now I know a lot more of what I can and can't do???
I am going to need alot more help as I am designing this new one. Specially with the complicated stuff like switchboards, macros and stuff.


Anyways Thanx and thanx again.
Clare
A.K.A
The Switch