Parameter Query Problem

[Ian-W-]

Hi, i've just done an audit of all the hardware in the company.

I want to run querys to say for example find all PC's with cpus's over 1000MHz

I currently have like"*"&[Enter CPU Speed]&"*" this only displays records if you enter the exact figure.

I have tried >=[Enter CPU Speed] but that doesnt seem to do what i want either.

What criteria should I have?

 

[Len Boorman]

Have you checked the data type of the CPU speed in the relevant table.

Suggest it would be a Number , Long Integer but your succesful criteria looks to me set up for a Text search

L

 

[Mike375]

Hi, i've just done an audit of all the hardware in the company.

I want to run querys to say for example find all PC's with cpus's over 1000MHz

I currently have like"*"&[Enter CPU Speed]&"*" this only displays records if you enter the exact figure.

I have tried >=[Enter CPU Speed] but that doesnt seem to do what i want either.

What criteria should I have?

If all your entries are in the format of 1000Mhz, 650MHz, 1500MHz etc then your best bet might be to create a field that picks up the number part and then query that field as that would be a simple >=

Mike

 

[Ian-W-]

Thanks,

I just seperated the coloumns into two.

One for type i.e Pentium 4/AMD and one for speed which I made into a number.

Works great now

Thanks